- ABAP Snippets
- Top SAP Courses
- Top SAP Books
SAP and ABAP Free Tutorials
SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
In this post, you will find the main SAP Purchase Order Tables for header, item, and historical.
As well as, all relevant SAP tables related to Purchasing process.
First, we will explain the main Purchase Order SAP Tables, then we will list the main SAP Table for Purchase Document in SAP MM (Material Management).
Table of Contents
SAP Purchase Order Tables
The main SAP Purchase Order Tables or SAP PO Tables as commonly called are:
Check also this post for more detail about SAP Purchase Order Overview
EKKO Table in SAP
EKKO Table in SAP is the Purchasing Document Header.
The most important SAP Purchase Order Tables is EKKO. Each Purchase order is identified by EBELN (PO Number)
The main EKKO fields are:
- SAP Purchase Order Process & Doc. Flow SAP SD / MM (Tcodes & Tables)
- Complete list of SAP Purchase Document ME21N Exit and BADI
- EDI 870: Order Status Report SAP ORDERS05 IDoc Explained
SAP PO EKPO Table in SAP
The lines of SAP PO (Purchase Order) can be found in EKPO table.
The main fields at EKPO are:
EKBE Table is SAP
The Historical data for a SAP Purchase Order Tables is set on EKBE . The details are saved by items.
The main fields for EKBE are:
Check this book Materials Management with SAP ERP: Functionality and Technical Configuration (SAP MM) (4th Edition) (SAP PRESS) 4th Edition
SAP Purchase Order Reference Tables
Purchasing document category bstyp.
The purchasing document category allows differentiation between the various kinds of purchasing documents (e.g. purchase order, scheduling agreement, contract).
The purchasing document category determines the applicable number range, for example, and the fields that are offered to you for maintenance.
The relevant document category is suggested by the system when you create a purchasing document.
Purchasing document categories can be further subdivided into Purchasing Document Types.
List of Purchasing Document Category Value
The Document Category (EKKO-BSTYP) values are set on Value Range for Domain EBSTYP.
The different Values of SAP Purchasing Document Category are:
Purchasing Document Type BSART
The Document Type EKKO-BSART  differentiates between the different kinds of requisition and purchases order in the SAP system.
The order type controls the number assignment for a purchase order, for example, and determines which fields you must maintain.
The reference table for Document Type is T161
The Document Type are a subdivision of Document Category. The keys for T161 are BSTYP and BSART .
Vendor Account Number
The vendor Master Data table in SAP is LFA1 for general information.
Full list of SAP MM Purchasing Tables
Sap tables for po (purchase order tables in sap).
The first list contains only PO Data Tables. The next part will list the customizing tables for purchase orders in SAP MM Purchasing.
SAP Purchase Order Tables are:
SAP Table for Purchase order history
The Purchase Order History can be found in the standard Table EKBE .
The Key fields for PO History Table are :
There is also SAP Tables for Purchase Order Further History such as:
- EKBEH, Removed PO History Records
- EKBZ, History per Purchasing Document: Delivery Costs
- EKBZH, History per Purchasing Document: Delivery Costs
SAP Customizing Tables for PO
The main customizing for PO or Purchase Order can be found in the following Table.
SAP PO Customizing Table Part 1
(Note that some following SAP tables contain SAP PO related Master)
Read also List of Important SAP Material Types in SAP MM
T161* PO Customizing Table Part 2
The next list of Purchase Document SAP Customizing Tables starting with T161* are:
T162* PO Customizing Table Part 3
Here the list of SAP Purchase Order Customizing Tables starting with T162*
T163* PO Customizing Table Part 4
Here the list of SAP Purchase Order Customizing Tables starting with T163*
T165/T166* PO Customizing Table Part 5
Here the list of SAP Purchase Order Customizing Tables starting with T165/T166*
Sap Purchase Order Tables: T16F* PO Customizing Table Part 6
Here the list of SAP Purchase Order Customizing Tables starting with T16F*
Related Posts
The Most Important SAP Payment Terms Tables (ZTERM, Text…)
October 21, 2018 March 24, 2021
SAP Batch Management: User-exits and BAdIs
June 17, 2017 January 21, 2022
SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)
June 16, 2017 January 21, 2022
- ABAP CDS Views
- HANA XS OData
- SAP HANA Modeling
- ABAP In Cloud
- S/4HANA Guide
SAP FI Bank Accounting Tables
Sap fi account receivable tables, sap fi down payment chain tables, sap fi asset accounting tables (2023).
There are thousands of different transaction codes available in SAP, and each one serves a specific purpose. With the right knowledge and understanding, you can use transaction codes to carry out any task imaginable in SAP. The complete list of SAP TCodes
- SAP ABAP TCodes
- SAP ABAP Language TCodes
- SAP Batch Input TCodes
- SAP Selection Screen & Variants TCodes
- SAP Transaction Variant TCodes
- SAP ABAP XML Processing TCodes
- SAP Business Workflow TCodes
- SAP Flexible Workflow TCodes
- SAP Workflow Error Analysis TCodes
- SAP CCMS Archive TCodes
- SAP CCMS Background Processing TCodes
- SAP CCMS Data Aging TCodes
- SAP CCMS Monitoring TCodes
- SAP CCMS Configuration TCodes
- S/4 HANA tables
20 SAP Purchase Order Tables – Most Important
SAP S/4HANA Materials Management (MM) module has several key tables that store master data and transactional data. These core tables capture the critical information needed for materials planning, procurement, inventory management, and invoice verification. In this post, we will look at some of the major SAP purchase order tables along with other important SAP S/4HANA MM tables organized by sub-module.
SAP Purchase Order Tables
EKKO and EKPO the important table which stores purchase order header data and line item data respectively. Here are the key SAP purchase order tables in SAP S/4HANA:
The key tables store purchasing info records, purchase orders, account assignments, partners, document types, purchasing groups, organizations, number ranges, screen controls, pricing conditions etc. These core tables capture the key purchasing data in SAP S/4HANA Sourcing and Procurement .
Below are the SAP Industry Specific (IS) purchasing related tables
SAP Oil & Gas Downstream Purchasing Tables
Sap recycling administration purchasing tables.
Below are the SAP Logistics purchasing related tables
SAP Logistics Purchasing Tables
Congrats!! now you have the most important list of SAP purchase order tables.
RELATED ARTICLES MORE FROM AUTHOR
SAP Tables for Cost Center: Helpful List (2023)
Important SAP Financial Accounting Tables
Editor picks, popular posts.
MOVE CORRESPONDING for Internal Tables in ABAP 7.4
Function Import in SAP OData Service
$filter query in SAP OData Service
Popular category.
- Basic Functions 152
- Application Interface Framework 132
- ALE Integration Technology 112
- Analyzer 96
- Profit Center Accounting 86
- Financials Israel 72
- Asset Accounting 51
- Basic Settings 51
Account assignment purchase order Table in SAP
- JKSDPORDERFLOW Table for IS-M: Assignment of Purchase Order Book to Purchase Order Table Type : TRANSP Package : JSDI Module : IS-M
- DPR_OBJLINK_SCPO Table for Purchase Order and Purchase Order Item for SRM Shopping Cart Table Type : TRANSP Package : DEVELOPMENT_PROJECTS_SRM Module : PPM-PRO-EXT
- T460C Table for Order/Purchase order types for planned order Table Type : TRANSP Package : MD Module : CRM
- T460D Table for Order/Purchase order types for planned order Table Type : POOL Package : MD Module : CRM
- BBPD_OR_PCO Table for Object Link: Purchase Order/Order Confirmation Table Type : TRANSP Package : BBP_PRODOC Module : SRM-EBP
- BBPD_OR_SUSPCO Table for Object Link: SUS Purchase Order/Order Confirmation Table Type : TRANSP Package : BBP_PRODOC Module : SRM-EBP
- FRE_OP_PO_KEY Table for Key-Completion F&R Order Proposal R/3 Purchase Order Table Type : TRANSP Package : WFRE_PI Module : CA
- EBKN Table for Purchase Requisition Account Assignment Table Type : TRANSP Package : ME Module : SRM-EBP
- TOIAE Table for Purchase Fee Account Assignment Table Type : TRANSP Package : OIA Module : CRM
- VSEBKN_CN Table for Version: Purchase requisition account assignment Table Type : TRANSP Package : CNVS Module : SRM-EBP
- /XNFE/NFEASSIGN Table for NFe-E Assignment: Purchase Order / Delivery Table Type : TRANSP Package : /XNFE/APPB2B Module : SLL-NFE-MGM
- CRMC_ACC_MAP Table for Assignment of Account Assignment Group to Account Table Type : TRANSP Package : CRM_LEASING_SRM Module : CRM-LAM-BTX
- BBP_PDCON Table for Purchase Order Item Confirmation Table Type : TRANSP Package : BBP_PRODOC Module : SRM-EBP
- BLK_REASON Table for Blocking Reason in Purchase Order Table Type : TRANSP Package : ME Module : SRM-EBP
- BLK_REASON_TX Table for Text Table for Blocking Reason in Purchase Order Table Type : TRANSP Package : ME Module : SRM-EBP
- CDBD_PO_H Table for Purchase Order header - CDB table Table Type : TRANSP Package : CDB Module : CRM-MSA
- CDBD_PO_I Table for Purchase Order item - CDB table Table Type : TRANSP Package : CDB Module : CRM-MSA
- CFIORPURITM0C Table for FIN Objects for Purchase Order Items Table Type : TRANSP Package : CON_ACC Module : FIN-BAC-INV
- CONT03_EKPO Table for Container Table for Purchase Order Item Table Type : TRANSP Package : CBZID Module : PS
- CRMC_PODCACTIV Table for Purchase Order Number Check: Activation Table Type : TRANSP Package : CRM_ORDER Module : CRM-BTX-BF
- CRMC_PODCGROUP Table for Purchase Order Number Check: BP Group Table Type : TRANSP Package : CRM_BUPA_MD Module : CRM-BTX-BF-CU
- CRMC_PODCGROUP_T Table for Purchase Order Number Check: BP Group (Texts) Table Type : TRANSP Package : CRM_BUPA_MD Module : CRM-BTX-BF-CU
- FINORDPUR01 Table for Data Storage for Purchase Order Information - Items Table Type : TRANSP Package : FIN_INTERFACE_MODEL Module : FIN
- FINORDPUR0C Table for Data Storage for Purchase Order Information - Header Table Type : TRANSP Package : FIN_INTERFACE_MODEL Module : FIN
- FIP_D_STAT_POQ Table for Table containing the Past Purchase Order Quantity stat. data Table Type : TRANSP Package : FIP_DDIC Module : MM-PUR-FIP
- FMRE_MM_CATASS Table for Permitted Types of Earmarked Funds in Purchase Order Docs Table Type : TRANSP Package : FMRE Module : FI-FM-PO
- FRE_PO_POINTER Table for Change Pointers Changed Purchase Order Documents Table Type : TRANSP Package : WFRE_PI Module : CA
- GLS_CNT_REDEL Table for Control of Document Sequence for Purchase Order Change Table Type : TRANSP Package : RS_BCT_SRM Module : BW-BCT-BBP
- L2TC_SETTINGS_PO Table for Raw-Exposure Update for Purchase Order: General Settings Table Type : TRANSP Package : LOG_TRM_INTEGRATION Module : LO-INT-TRM
- LIPSPO Table for LIPS Reference Data Purchase Order Table Type : TRANSP Package : VL Module : CRM
- MLBEKEPH Table for ML: Cost Comp. Split (Elements) for Purchase Order History Table Type : TRANSP Package : CKMLCCS Module : CO-PC-ACT
- OTBPARAM2 Table for Parameters for OTB Purchase Order Warning Table Type : TRANSP Package : MCP2 Module : CRM
- POEXT Table for Enhancement Fields for Purchase Order Table Type : TRANSP Package : ME Module : SRM-EBP
- PUROB Table for Original Batch for Purchase Order Table Type : TRANSP Package : VBOB Module : LO-BM
- RSBCT_XSA_PO_TT Table for Purchase order text (Training) Table Type : TRANSP Package : RS_BCT_XSA_ABAP Module : BW-BCT-EPM
- RSBCT_XSA_PO_TXT Table for Purchase order text Table Type : TRANSP Package : RS_BCT_XSA_ABAP Module : BW-BCT-EPM
- SDEMO_PO Table for Purchase Order Header Table Type : TRANSP Package : S_NWDEMO_MODEL_PURCHASE_ORDER Module : BC-SRV-NWD
- SDEMO_PO_I Table for Purchase Order Item Table Type : TRANSP Package : S_NWDEMO_MODEL_PURCHASE_ORDER Module : BC-SRV-NWD
- SDEMO_PO_SL Table for Purchase Order Item Schedule Line Table Type : TRANSP Package : S_NWDEMO_MODEL_PURCHASE_ORDER Module : BC-SRV-NWD
- SDEMO_PO_ST Table for Purchase Order Header Status Table Type : TRANSP Package : S_NWDEMO_MODEL_PURCHASE_ORDER Module : BC-SRV-NWD
- SER08 Table for Document Header for Purchase Order Item Serial Numbers Table Type : TRANSP Package : IQSM Module : CRM
- SNWD_PO Table for EPM: Purchase Order Header Table Table Type : TRANSP Package : S_NWDEMO_MODEL_DDIC Module : BC-SRV-NWD
- SNWD_PO_I Table for EPM: Purchase Order Item Table Table Type : TRANSP Package : S_NWDEMO_MODEL_DDIC Module : BC-SRV-NWD
- SNWD_PO_INV_HEAD Table for EPM: Purchase Order Invoice Header Table Table Type : TRANSP Package : S_NWDEMO_MODEL_DDIC Module : BC-SRV-NWD
- SNWD_PO_INV_ITEM Table for EPM: Purchase Order Invoice Items Table Table Type : TRANSP Package : S_NWDEMO_MODEL_DDIC Module : BC-SRV-NWD
- SNWD_PO_SL Table for EPM: Purchase Order Schedule Line Table Table Type : TRANSP Package : S_NWDEMO_MODEL_DDIC Module : BC-SRV-NWD
- T160D Table for Function Authorizations: Purchase Order Table Type : POOL Package : ME Module : SRM-EBP
- T163B Table for Purchase Order History Categories Table Type : TRANSP Package : ME Module : SRM-EBP
- T163C Table for Texts for Purchase Order History Categories Table Type : TRANSP Package : ME Module : SRM-EBP
- T175DP_STATE Table for Update Down Payment Requests in Purchase Order History Table Type : TRANSP Package : ME Module : SRM-EBP
- TEE003 Table for Customizing Purchase Order from Easy Execution Table Type : TRANSP Package : CKEXECUTION Module : CO-PC-PCP
- FM_CIACC Table Data element for Assignment of FM account assignment to account is binding
- KNTBU Table Data element for Account assignment category: unknown account assignment
- J_CO_AUFNR Table Data element for Order number of internal CO order for account assignment
- J_RK_AUFNR Table Data element for Order Number of RK Order for Account Assignment
- JHCO_AUFNR Table Data element for IS-M: Order No.of Internal CO Order for Account Assignment
- BBP_ACC_NO Table Data element for Sequential Account Assignment No. in EBP Purchase Document
- FM_BEKNT Table Data element for Account assignment type for unassigned purchase orders
- ORVTP Table Data element for Value type of purchase order/sales order values
- MSR_REP_REPL_PO_BSART Table Data element for Order Type for Purchase Order with Replacement From Vendor
- BPBMG Table Data element for Purchase order quantity in order price unit
- MCBW_DMBE Table Data element for BW: Delta Purchase Order/GR in Order Unit
- CO_PROF_DI Table Data element for Profile purchase order operation order info system
Account assignment purchase order related terms
Definitions.
SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
Popular Table Searches
Latest table searches.
IMAGES
VIDEO
COMMENTS
08-27-2008 10:07 AM. hi, use EKKN table for account assignment in Purchasing Document. 08-27-2008 12:46 PM. Thanks a lot. Solved: Hi all, i'm looking for the table for Account assignment in purchase order. In fact i'm looking for the Asset assignment to my purchase order. Thanks a lot.
The Document Type EKKO-BSART  differentiates between the different kinds of requisition and purchases order in the SAP system. The order type controls the number assignment for a purchase order, for example, and determines which fields you must maintain. The reference table for Document Type is T161.
Purchase Orders (MM-PUR-PO) Account Assignment; Purchasing (MM-PUR) 6.0 EHP3 SP24. Available Versions: 6.0 EHP8 SP20 ; 6.0 EHP8 SP19 ; ... If you do not have an SAP ID, you can create one for free from the login page. ... Create Custom PDF Share. Table of Contents ...
Here are the key SAP purchase order tables in SAP S/4HANA: The key tables store purchasing info records, purchase orders, account assignments, partners, document types, purchasing groups, organizations, number ranges, screen controls, pricing conditions etc. These core tables capture the key purchasing data in SAP S/4HANA Sourcing and Procurement.
PURCHASE_ORDER_ACCOUNTING Fields, Structure, and DDIC. PURCHASE_ORDER_ACCOUNTING is a standard Purchasing Structure in SAP MM application. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
account ing Document Segment FI - Financial Accounting: Cluster Table 7 : AUFK: order master data CO - Overhead Cost Orders: Transparent Table 8 : CDHDR: Change document header Basis - Change Documents: Transparent Table 9 : EKBE: History per Purchasing Document MM - Purchasing: Transparent Table 10 : VBFA: Sales Document Flow SD - Basic ...
Flexible Workflow for Purchase Orders. Manage Purchase Orders. Optimizing the Order Quantity. Output Management in Purchase Orders. Dunning and Order Acknowledment Reminders. CDS Views for Purchase Orders. Account Assignment in Purchase Order. Compliance Status of Dangerous Goods. Compliance Status of Dangerous Goods by Item.
List of Account assignment purchase order tables in SAP. JKSDPORDERFLOW for IS-M: Assignment of Purchase Order Book to Purchase Order. DPR_OBJLINK_SCPO for Purchase Order and Purchase Order Item for SRM Shopping Cart. T460C for Order/Purchase order types for planned order. T460D for Order/Purchase order types for planned order.
T163K. account assignment Categories in Purchasing Document. MM - Purchasing. Transparent Table. 30. TFKCOD. FI-CA: CO account assignment Key/Allocation. FI - Contract Accounts Receivable and Payable. Transparent Table.
the header data of a purchasing document, such as vendor, purchasing organization, order currency, and so on. the item data. such as material, purchase order quantity, order unit, net price, and so on. the account assignment, such as account type, cost center, controlling area, quantities, values, percentage rates, and so on.
You can limit the item categories that can be used for a document type via configuration: Materials Management > Purchasing > Purchase Order > Define Document Types. Within this transaction you can define which item categories are valid for a specific document type. You can then define which account assignment categories are valid for each item ...
Learn how to use the account assignment category in SAP ERP to control the cost object, stock, and account assignment details for different items. Find out how it relates to requirements class, requirement type, and item category.
Dear all, I would like to add PERNR field to account assignment K in PO. As i see in OXK1, in screen 1101 the field is there. Moreover, the field exists in RBCO and BSEG, so i would like to add it to the screen of the account assignment and append EKKN to save the value. Does anybody knows how to change the coding block of the account ...
Po Account Assignment Category Database Tables in SAP (30 Tables) 6 : CDHDR: Change document header Basis - Change Documents: Transparent Table
Account Assignment PO. Message no. ME045. DIAGNOSIS: Comparison of the field selection strings from G/L account 400000 and the account assignment category K revels that there is an incompatible combination of field selection for the field selection group EARMARKED FUNDS . The G/L account field selection is stored in table T004F; that for the ...
Account assignment is used when ever you are purchasing Directly to them, That means we are not going to stock the Material , the Material will be deemed to consumed for Account Assignment. you are using in PO, Ex: Cost Centre, Project etc.. The Accounting will be always Consumption Account During MIGO & MIRO.
Dear Experts, A direct consumption PO with Account Assignment category K was created. A GR was posted in January (closed period now). The user wants to cancel this GRN document for to post two GRNs according to the two vendor invoices. Cancelling the January GRN isn't possible because the period is ...
What factors we need to consider while deciding the Account Assignment Category for Third-Party Schedule line Category CS in SAP? ... A direct consumption PO with Account Assignment category K in Enterprise Resource Planning Q&A 7 hours ago; ... SAP Standard Table - PO Number, Invoice Number... Re: Is it possible to group all open items into a
Account Assignment is the specification of the objects ( for example cost center, sales order, project) that are charged in the case of a purchase order for a material that is intended for direct usage or consumption. A purchase order item can be assigned to a single account or to several accounts. Costs can be distributed on a percentage basis.
Enhanced RISE with SAP Methodology with clean core quality checks in Enterprise Resource Planning Blogs by SAP 9 hours ago; Jumpstart your cloud ERP journey with guided enablement in RISE with SAP Methodology in Enterprise Resource Planning Blogs by SAP 9 hours ago
hello good afternoon! I have a problem with a purchase requisition and would like some advice on where to start. Purchase requisition flow. I have a document where it followed the Standard approval flow and was fully approved. Purchase requisition release code with status 2 (RFQ / Order) But in pu...