- 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
2897186 - Account Assignment Tab is missing in Purchase Order and in Supplier Invoice.
You are creating a new supplier invoice (SIV) with a purchase order (PO) and you can see that the Account Assignment is missing in both the SIV and PO.
Environment
SAP Business ByDesign.
Reproducing the Issue
- Go to Supplier Invoicing work center.
- Select the Invoice Entry view.
- Select a PO line and click New Invoice.
- From the new invoice, go to Items tab and Coat Distribution sub-tab.
- You can see that the Account Assignment information does not display bellow Cost Distribution Details.
- Also, if you open the PO used to create this SIV, under Items tab, you will also see that the Account Assignment sub-tab does not display.
The product used in your PO is under the process type To-Stock.
- When you create a supplier invoice for a To-Stock Purchase Order, the system will fetch the account assignment details from the product master data.
- It is the same for purchase order as well as you do not see the Account Assignment tab in To-Stock orders.
- In this case, system will fetch the costs from respective account determination groups which are mapped in product master data and these accounts are mapped to general ledger accounts in financials.
- Hence you do not see the Account Assignment tab for an invoice which has To-Stock items.
- This is the standard system behavior.
Account Assignment tab missing, Purchase Order, Supplier Invoice, To-Stock Process Type. , KBA , SRD-SRM-SI , Supplier Invoicing , How To
Privacy | Terms of use | Legal Disclosure | Copyright | Trademark
IMAGES
VIDEO
COMMENTS
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.
Solution: The indicator determines which account assignment screen is used by default for maintaining the account assign. for a purchase orde r item. For the EnjoySAP transactions, this value is simply a proposal that you can change in the purchasing document. For the old transactions, this value is the only one that you can use.
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.
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_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.
Go to Supplier Invoicing work center. Select the Invoice Entry view. Select a PO line and click New Invoice. From the new invoice, go to Items tab and Coat Distribution sub-tab. You can see that the Account Assignment information does not display bellow Cost Distribution Details. Also, if you open the PO used to create this SIV, under Items tab ...
SAP Community is moving in January 2024! Hereâ s what you need to know to prepare. ... account assignment tab fields on the PO. 77 Views. Follow RSS Feed hi gurus, Is there a transaction like ME2N which can show me the fields like G/L account, cost center and order fields in the output like ME2N, ME2M show some fields like net price, quantity ...
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.
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.
This new field would be carried over to the Invoice Document in the SAP 4.7 C system. In the SPRO Setting> Materials Management > Purchasing > Account Assignment there is a setting for maintaining Account Assignment Categories & Set Subscreen for Account Assignment (Coding) Block. I have created a new field and added the same to the Maintain ...