sap table po account assignment

• ABAP Snippets

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

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.

2733310 - Account Assignment and Free Items in Purchase Orders

Creating a Purchase Order for a free item with material type Non-valuated , the system requests account assignment details.

Environment

• Materials Management (MM)
• SAP ERP Central Component
• SAP enhancement package for SAP ERP
• SAP enhancement package for SAP ERP, version for SAP HANA
• SAP S/4HANA

REPOV, PO, ME 062, ME062, UNBW, cost center, free item, STO, UB, free, UMSON, account assigment, ME21N, ME22N, ME23N , KBA , MM-PUR-PO , Purchase Orders , MM-PUR-GF-ACC , Account assignment , Problem

About this page

Search for additional results.

Visit SAP Support Portal's SAP Notes and KBA Search .

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

• 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

• You are here:
• Home »
• SAP Tables »

SAP Purchase Order tables

Below is a list of Purchase order related SAP database tables, what data they store and how they are related to each other. Also, click on the table name for full details of its fields including which make up the table key along with other information such as check tables, text tables…

Purchasing Documents

This is a list of the main SAP PO tables which store the Purchasing information including the header and item details of each Purchase Order. EKKO – Purchasing Document Header        EKPO – Purchasing Document Item              MARA – General Material Data              EKET – Scheduling Agreement Schedule Lines              EKKN – Account Assignment in Purchasing Document              EKBE – Purchasing Document History

Accounting Documents

Accounting forms a big part of the purchase process so there are a number of direct relationships between the PO tables and the accounting tables such as BKPF and BSEG. BKPF – Accounting Document Header        BSET – Tax Data Document Segment        BSEG – Accounting Document Segment              BSEC – One-Time Account Data Document Segment              EKKO – Purchasing Document Header                    EKPO – Purchasing Document Item                          EKBE – Purchasing Document History

Purchasing Activities per Requirement Tracking No.

Also see relationship with purchase requision tables EBAN and EBKN. EKDY – Dummy Table for Database EBM        EKKO – Purchasing Document Header              EKPO – Purchasing Document Item                    EKET – Scheduling Agreement Schedule Lines                    MARA – General Material Data                    EKKN – Account Assignment in Purchasing Document                    EKBE – History per Purchasing Document        EBAN – Purchase Requisition              EBKN – Purchase Requisition Account Assignment

Archiving of Purchasing Documents

As you can imagine an SAP system can process a large amount of purchasing data via many thousands of PO documents. This data therefor needs to periodically archived and there are a number of standard SAP tables related to this archiving process, see below for list including the relationship to the main Purchase order tables. EKKO – Purchasing Document Header        EKPO – Purchasing Document Item              EKBE – History per Purchasing Document              EKBZ – History per Purchasing Document: Delivery Costs              EKAB – Release (Order) Documentation        EKKN – Account Assignment in Purchasing Document        EKET – Scheduling Agreement Schedule Lines        ESSR – Service Entry Sheet Header Data        ESKN – Account Assignment in Service Package        A019 – Contract Header        A016 – Contract Item        A068 – Outline Agreement Item: Plant-Dependent        KONM – Conditions (1-Dimensional Quantity Scale)        KONW – Conditions (1-Dimensional Value Scale)        KONP – Conditions (Item)        KONH – Conditions (Header)        KONV – Conditions (Transaction Data)        STXH – STXD SAPscript Text File Header              STXL – STXD SAPscript Text File Lines        CDHDR – Change Document Header              CDPOS – Change Document Items        EIKP – Foreign Trade: Export/Import: Header Data              EIPO – Foreign Trade: Export/Import: Item Data        NAST – Message Status        EKUB – Index for Stock Transport Orders for Material        EKPV – SD-Specific Data f. Stock Transfer for Purch. Doc.        RESB – Reservation/Dependent Requirements        EKES – Vendor Confirmations        EKPA – Partner Roles in Purchasing        EKBEH – Order History, Scheduling Agreement (Reorganized)        EKBZH – Delivery Costs History, Sched. Agreement (Reorg)        EKETH – Scheduling Agreement Schedule Lines (Reorganized)        EKEK – Scheduling Agreement Release History, Header        EKEH – Scheduling Agreement Release History, Sched. Lines

Purch. Order Tables and there relationship including Scheduling Agreement Releases

Details of how the Scheduling Agreement Releases tables EKEK and EKEH are related to PO data as well as the PRPS Project Structure Plan table. EKKO – Purchasing Document Header        EKPO – Purchasing Document Item              EKKN – Account Assignment in Purchasing Document              EKES – Vendor Confirmations              EKAB – Release Documentation              EKBZ – History per Purchasing Document: Delivery Costs              EKBE – History per Purchasing Document              EKEK – Header Data for Scheduling Agreement Releases                    EKEH – Scheduling Agreement Release Documentation              EKET – Scheduling Agreement Schedule Lines              T160T – Description of Selection Parameters              RESB – Reservation/Dependent Requirements              PRPS – PSP (Project Structure Plan) Element Master Data

Creating a Purchase Order for Consumable Material

After completing this lesson, you will be able to create a purchase order for consumable material

Introduction

In this unit, you will learn how to perform a procurement process for a consumable material, consisting of a purchase order, goods receipt, and invoice.

The following video describes the process, focusing on the first step, a purchase order for a consumable material, and introduces the account assignment category.

Purchase Order Creation with Account Assignment

When you buy a material, you procure it either for stock or for direct consumption. When procuring for direct consumption, you must specify the consumption purpose in the purchase order by manually entering account assignment data, such as the account assignment object.

At goods receipt and/or invoice receipt, the consumption account specified in the purchase order is debited with the procurement value. In addition, the data for the account assignment object is updated.

The goods receipt does not affect the total value and usually does not affect the total quantity of the stock.

To be able to enter account assignment data in a purchase order item, you must first specify an account assignment category in the item. The account assignment category determines which account assignment object can be entered.

To procure material for a project and a cost center, Paula must use the account assignment categories P for the account assignment object project and K for the account assignment object cost center.

Here are some examples of account assignment categories defined in the SAP S/4HANA system:

K for cost center

P for project

C for sales order

F for production order

A for asset

In the following demo, you will learn how to order a material with a material master record for a project using the Manage Purchase Orders app. 

Free Text Item

When a material is procured directly for consumption, a material master record is not mandatory. This means that a material number can be entered in a purchase order item with an account assignment category, but is not required.

When procuring a consumable material without a material master record, you must manually enter a short description, a material group, and a purchase order unit in a purchase order item, since this data cannot be taken from a master record. This is different from a material with a master record. 

Paula has been asked to purchase oil pumps and LED desk lamps. She has already created the purchase order for the oil pumps. However, the message for this purchase order has not yet been sent. Since the supplier for the lamps is the same as the supplier for the oil pumps, Paula wants to add another purchase order item to her existing purchase order. She already knows that there is no material master record for the lamps. 

In the following demo, you will see how to add another item to an existing purchase order using the Manage Purchase Orders application. You will also learn how to order a material without a material master record. 

Log in to track your progress & complete quizzes

• Knowledge Base

SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables

• Created 2021-01-13
• Author SAP Online Tutorials
• Category SAP MM

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).

SAP Purchase Order Tables

The main SAP Purchase Order Tables or SAP PO Tables as commonly called are:

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 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:

SAP Purchase Order Reference Tables

Purchasing document category bstyp.

The purchasing document category allows differentiation between the various kinds of purchasing document (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  purchase 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

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 order 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)

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*

Was this article helpful?

Related articles, leave a comment cancel reply.

You must be logged in to post a comment.