20 SAP Purchase Order Tables – Most Important

0
1046

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

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:

TableDescription
EINAPurchasing Info Record: General Data
EKKOPurchase Order Header
EKPOPurchase Order Item
EKBEHistory per Purchasing Order
EKKNAccount Assignment in Purchasing Order
EKPAPartner Roles in Purchasing
T161Purchasing Document Types
T024Purchasing Groups
T024EPurchasing Organizations
T024WValid Purchasing Organizations for Plant
T161TTexts for Purchasing Document Types
T160SAP Transaction Control, Purchasing
T161BDefault Values for Purchasing
T162Field Selection, Purchasing Document
T163Item Categories in Purchasing Document
T167Number Range Management for Purchasing Master Data
T168Screen Control, Purchasing
TMKSCalculation Schemas: Purchasing
TMKTSAP Transaction Control: Conditions in Purchasing
T024ZPurchasing Organizations

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

OIA03Exchange item data – purchasing side
TOIA8Purchasing copy rules
OIA06HQuantity schedule header table – purchasing side
OIA06Quantity schedule scheduling table – purchasing side
OIH_J1B_PCKBrazil: Check table for tax codes in Purchasing
OIH_J_1BTXIX1Tax calc.: ISS rules for sales and purchasing exeptions
OIH25TDP additional checks for purchasing
TOIJ_EL_INCOMPIS-OIL TSW: Activate incompletion for sales and purchasing
S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object

SAP Recycling Administration Purchasing Tables

J_7LC192REA Data Filters: Splitting for Purchasing Transactions
J_7LC194REA Data Filters: Transaction-Dep. Purchasing Data Filters

Below are the SAP Logistics purchasing related tables

SAP Logistics Purchasing Tables

CHVW_ARC_2Archive Index: Batch Where-Used Data by Purchasing Document
MTM_ACC_V_CCODEMtM Accounting: Default Purchasing Organizations and Groups
TB2BCTrading Contract: Purchasing Grouping
TB2BCTTrading Contract: Purchasing Grouping Description
TWCBCPRULE_MWCB: Purchasing-Side Copy Control
S012Purchasing
S080Purchasing: Movements
S082Purchasing: Movements + Stock
S081Purchasing: Stock
S011PURCHIS: Purchasing Group Statistics
S011BIW1S011BIW1 * PURCHIS: Purchasing Group Statistics
S011BIW2S011BIW2 * PURCHIS: Purchasing Group Statistics
S012BIW1S012BIW1 * Purchasing
S012BIW2S012BIW2 * Purchasing
S275BIW1S275BIW1 * Transfer to BW: Purchasing Data
S275BIW2S275BIW2 * Transfer to BW: Purchasing Data
SUPLRPO_TEXT_DI_BUSINESSPARTNERTP I_BPSUPPLIERPURCHASINGORGTXTTP
LFM1Vendor master record purchasing organization data
LFM2Vendor Master Record: Purchasing Data
T405Purchasing Value Key
FSH_SLOG_MMSeason Determination Log storage for Purchasing Document
WRF_PRI_COND_EKPRICAT Inbound: Create Purchasing Conditions
DMF_PO_CUSTDDF Purchasing Organization Customizing
FSH_GRID_ITEMFashion Grid control data for sales and purchasing
MMSITEREFPlant grouping for purchasing
FIP_D_SP_PURFIP — Area of Responsibility — Purchasing table
WSTN_PP_PURCHPrepack definition – Purchasing price table
T026ZAssignement of purchasing group to purchasing area
T026TLanguage-dependent purchasing area
T026Purchasing Area
EDMMSAssignment of EDI partner to purchasing org. and plant
WRFT_POHF_EKGRPCross-Purchasing-Group Purchasing in Seasonal Procurement
WRFT_APC_PSCDItem Date Settings in Purchasing Lists
WRF_APC_PLIPOAPC: Purchasing List Item Prepack Information
WRF_APC_PAPURPlanned Article Purchasing Data and Prices
WRF_APC_PLASPurchasing List Assigned Quantities
WRF_APC_PLHTPurchasing List Description
WRF_APC_PLHPurchasing List Header Data
WRF_APC_IBIDPurchasing List Inbound Interface Detailed Totals
WRF_APC_IBITPurchasing List Inbound Interface Totals
WRF_APC_PLIPurchasing List Items
WRF_APC_PLPLPurchasing List Planned Data
WRF_APC_PLPOQPurchasing List Purchase Order Quantities
WRF_APC_PLDCPurchasing List Supplying DCs
WRF_APC_WLPLWorklist of Purchasing List Items for Follow-Up Processes
TBSGTPurchasing Documents: Reasons for Ordering: Texts
EINSGTPurchasing Info Record: Segmentation Specific Data

Conclusion

Congrats!! now you have the most important list of SAP purchase order tables.