purchase order account assignment table sap

• 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

Purchase order account assignment 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

Purchase order account assignment 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.

• MEPOACCOUNTING - Account Assignment Fields for Purchase Order

SAP Table MEPOACCOUNTING

Account assignment fields for purchase order.

MEPOACCOUNTING (Account Assignment Fields for Purchase Order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MEPOACCOUNTING to other SAP tables.

MEPOACCOUNTING table fields

Mepoaccounting foreign key relationships.

• 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

3452285 - Order type not visible in Purchase Requisitions for Account assignment F

While creating purchase requisition with Account Assignment Category F, the Order type maintenance order( example YA01 to YA05 ) are not visible in Fiori app "Manage purchase requisitions-professional" or "My Purchase Requisition -New" 

Environment

SAP S/4HANA Cloud 

Reproducing the Issue

1.Open Fiori app "Manage purchase requisitions-professional" or "My Purchase Requisition -New" 

2.create purchase requisition and enter all mandatory details and choose account assignment category as F

3.Click on Account assignment tab and get in to the details of  it 

4.Click on value help of  field 'Order type' and search for YA01

5.You will not get  any results.

6. follow same steps in  GUI App "Create purchase requisitions-Advanced"

7. You will see many  order types

System is behaving as per current development, kindly note that all features available in GUI apps may not be available in Fiori apps in general.

Currently we  see that all order types  (including YA01 to YA05 ) not visible in Fiori apps that are existing in GUI app.

I would suggest you reach out to your Customer Success Partner (CSP) who will help to coordinate your request in case your request is critical for your Go Live.

In case your request represents valuable feedback for the solution but has no direct impact on your Go Live, SAP offers an opportunity for SAP S/4HANA Cloud customers to submit improvement requests using this link: Homepage - Customer Influence (sap.com) . Customer Influence (CIS) is a platform where customers can suggest features that they would like to see in future SAP HANA releases.

Please refer to the SAP KBA ##2963059 - How to Submit Feature Requests for SAP S/4HANA Cloud Product for more details.

Follow the below steps to open an Influence request:

• Get started by opening  SAP Customer Influence .
• Register and accept the Terms of Use.
• Choose a session of your interest.
• Create and submit your improvement request.
• Take a look at existing improvement requests and start voting and commenting.

2963059 - How to Submit Feature Requests for SAP S/4HANA Cloud Product

maintenance order type not visible;Account assignment purchase requisition fiori;Purchase requisition account assignment F; purchase requisition  maintenance order Account assignment; S4HC, S4_1C, X4BC, S4_PC   , KBA , MM-FIO-PUR-REQ-SSP , Fiori UI for Self Service Procurement , MM-FIO-PUR-REQ-PRF , Manage Purchase Requisitions – Professional , Problem

Privacy | Terms of use | Legal Disclosure | Copyright | Trademark