• 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

List of SAP Purchase Order 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

SAP Payment Terms Table

The Most Important SAP Payment Terms Tables (ZTERM, Text…)

October 21, 2018 March 24, 2021

SAP Batch Management 1

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 category 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
  • T163A Table for Check Item Category/Account Assignment Category Table Type : POOL Package : ME Module : SRM-EBP
  • 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
  • KNTBU Table Data element for Account assignment category: unknown account assignment
  • FM_CIACC Table Data element for Assignment of FM account assignment to account is binding
  • 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
  • KTYP_KAUF Table Data element for Account assignment category for sales order stock
  • NET_KAUF Table Data element for Third-Party Req. for Sales Order Account Assignment Category
  • 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

Purchase order account assignment category Table in SAP

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

SAP Logo

3459521 - Creation of purchase document possible against blocked WBS Element

The user has enabled block function for a WBS Element for purchasing but is still able to create purchasing documents when the account assignment category is "Q"(Proj. make-to-order) in purchase document, and the account is assigned to this WBS Element.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

  • Set the blocked flag for Purchasing against a WBS Element in Project Control - Enterprise Projects -> Project Planning -> WBS Element.
  • Purchase Requisition or Purchase Order creation is allowed with account assignment containing the above WBS Element where account assignment category is “Q”.

The following BAdIs can be implemented to incorporate block function check in case of account assignment 'Q':

Purchase Order: https://api.sap.com/badi/BD_MMPUR_FINAL_CHECK_PO

PURCHASEORDERACCOUNTING    Purchase Order Account Assignments    Importing   IF_EX_MMPUR_FINAL_CHECK_PO=>B_MMPUR_T_PURORDACCASSIGNMT

Purchase Requistion: https://api.sap.com/badi/MM_PUR_S4_PR_CHECK

PURCHASEREQACCASSGNMT_TABLE    Account assignment fields for PR    Importing   MMPUR_T_PR_ACCTASSIGNMT_IMPORT

It is possible to use CDS view I_EntProjElmntBlockFunc_2 to fetch the block function for a WBS element.

Note:  This CDS view will be available from CE 2402.4 CFD release. This is current state of planning and may be changed by SAP at any time without notice. 

Check of Purchase Requisition Item

Check of Purchase Order Before Saving

purchase order, purchase requisition, WBS, PSP, blocked , KBA , PPM-SCL-STR , Project Structure (Public Cloud) , MM-PUR-REQ , Purchase Requisitions , MM-PUR-PO , Purchase Orders , Problem

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

IMAGES

  1. 😊 Account assignment. tukioka-clinic.com: Account Assignment Category

    sap po account assignment category table

  2. Account Assignment Category

    sap po account assignment category table

  3. Purchase Order Table

    sap po account assignment category table

  4. SAP PO Account Assignment to Cost Center Accounting (CCA)

    sap po account assignment category table

  5. SAP MM How to create a Purchase Order for Consumable material for Single Account assignment

    sap po account assignment category table

  6. Sap Purchase Requisition Table Name

    sap po account assignment category table

VIDEO

  1. How to define ACTIVITY TYPES in SAP S/4HANA Controlling

  2. SAP Tutorial : Create PO reference from Quotation

  3. Account assignment mandatory for material

  4. SAP End User Training

  5. Chart of Account and Account Groups |SAP S4 Hana FI-Financial Accounting

  6. SAP S/4 HANA 022 Field Status Customizing of the Customer's Account group

COMMENTS

  1. SAP table for account assignment category and item at PO lines

    Sales in SAP S/4HANA Cloud Public Edition 2402 in Enterprise Resource Planning Blogs by SAP Friday; PO with Multiple Account Assignment at time of GR will not set PO to Delivery Complete. Why ? in Enterprise Resource Planning Q&A Thursday; SAP Treasury Enhancements for Money Market Funds in S/4HANA in Enterprise Resource Planning Blogs by SAP ...

  2. Account Assignment

    Use. You can assign one or more account assignments to an item. Multiple account assignment allows you to apportion the costs covered by a purchase order partly to your own cost center and partly to others, for example. You specify which account assignment object is to be charged via the account assignment category. Account Assignment Category.

  3. SAP Purchase Order Tables: Main PO tables in SAP MM

    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 isT161. The Document Type are a subdivision of Document Category.

  4. Purchasing Data (Account Assignment)

    The account assignment category determines the account assignment data for an item, such as cost center and account number. VRTKZ - Distribution Indicator for Multiple Account Assignment This field indicates how the quantities and values of a purchase order item in multiple account assignment are distributed to the individual account assignments.

  5. Account Assignment

    Organization of an Enterprise in the SAP System. Purchasing Menu. Purchasing Document. Master Records from the Purchasing View. Purchasing Applications in Single-Screen Transactions: Purchase Requisition and Purchase Order. Purchase Requisitions (MM-PUR-REQ) RFQ and Quotation (MM-PUR-RFQ) Outline Purchase Agreements with Vendors (MM-PUR-OA)

  6. Purchase order account assignment category Table in SAP

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

  7. EKKN (Account Assignment in Purchasing Document) Table in SAP

    EKKN is a standard Purchasing Transparent Table in SAP MM application, which stores Account Assignment in Purchasing Document data. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition. ... Change Purchase Order: MM - Purchasing: BAPI_PO_CREATE1: Create Purchase Order: MM ...

  8. 3459521

    Reproducing the Issue. Set the blocked flag for Purchasing against a WBS Element in Project Control - Enterprise Projects -> Project Planning -> WBS Element. Purchase Requisition or Purchase Order creation is allowed with account assignment containing the above WBS Element where account assignment category is "Q".

  9. Po Account Assignment Category Tables in SAP

    Po Account Assignment Category Database Tables in SAP (30 Tables) 6 : CDHDR: Change document header Basis - Change Documents: Transparent Table

  10. PURCHASE_ORDER_ACCOUNTING (PO account assgt) Table in SAP

    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.

  11. Account Assignment Tables in SAP

    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.

  12. Account Assignment Category Tables in SAP

    T162K. Field Selection, account assignment Fields, Purchasing. MM - Purchasing. Pooled Table. 16. BSAS. account ing: Secondary Index for G/L account s (Cleared Items) FI - Financial Accounting. Transparent Table.

  13. Po with account assignment category 'X'

    I have an issue like I created PO based invoice using MIRO. In the PO account assignment category should be 'X'. When I create invoice using MIRO ,when I enter PO numver in the invoice, then the item is in disable mode.I am not able to edit price or quantity in the invoice. I have not ticked the option GR based in the PO also.

  14. Need to get history table of Account assignment in PO

    Oldest. Best Answer. Vote up 2 Vote down. Former Member. Sep 01, 2008 at 10:23 AM. Hi , PO history table is EKBE . Add a Comment. Alert Moderator.