The SAP table EKKO is a critical component in the SAP ERP system, particularly within the Materials Management (MM) module. It serves as the header table for purchase documents, including purchase orders (POs), scheduling agreements, and contracts. The EKKO table provides an overview of the essential details and control information of these procurement documents.
SAP table EKKO has 2 primary key fields being MANDT,EBELN.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Document was not created using Seasonal Procurement
1
Seasonal Procurement Grouped Purchase Order Document
2
Seasonal Procurement Purchase Order
EQ_EINDT
Delivery Date Header: All Items Have Same Delivery Date
DATS
8
0
WRF_POHF_EQ_EINDT
EQ_WERKS
Plant Header: All Items Have Same Receiving Plant
CHAR
4
0
*
WRF_POHF_EQ_EWERK
FIXPO
Firm Deal Indicator
CHAR
1
0
WRF_POHF_FIXPO
EKGRP_ALLOW
Take Account of Purch. Group
CHAR
1
0
WRF_POHF_EKGRP_ALLOW
WERKS_ALLOW
Take Account of Plants
CHAR
1
0
WRF_POHF_WERKS_ALLOW
CONTRACT_ALLOW
Take Account of Contracts
CHAR
1
0
WRF_POHF_CONTRACT_ALLOW
PSTYP_ALLOW
Take Account of Item Categories
CHAR
1
0
WRF_POHF_PSTYP_ALLOW
FIXPO_ALLOW
Take Account of Fixed-Date Purchases Indicator
CHAR
1
0
WRF_POHF_FIXPO_ALLOW
KEY_ID_ALLOW
Consider Budget
CHAR
1
0
WRF_POHF_KEY_ID_ALLOW
AUREL_ALLOW
Take Account of Alloc. Table Relevance
CHAR
1
0
WRF_POHF_AUREL_ALLOW
DELPER_ALLOW
Take Account of Dlvy Period
CHAR
1
0
WRF_POHF_DELPER_ALLOW
EINDT_ALLOW
Take Account of Delivery Date
CHAR
1
0
WRF_POHF_EINDT_ALLOW
LTSNR_ALLOW
Include Vendor Subrange
CHAR
1
0
WRF_POHF_LTSNR_ALLOW
OTB_LEVEL
OTB Check Level
CHAR
1
0
WRF_POTB_CHECK_LEVEL
1
Header
2
Schedule Line
OTB_COND_TYPE
OTB Condition Type
CHAR
4
0
*
WRF_POTB_COND_TYPE
KEY_ID
Unique Number of Budget
NUMC
16
0
WRF_BUDG_KEY_ID
OTB_VALUE
Required Budget
CURR
17
2
WRF_POTB_VALUE
OTB_CURR
OTB Currency
CUKY
5
0
*
WRF_POTB_CURRENCY
OTB_RES_VALUE
Reserved Budget for OTB-Relevant Purchasing Document
CURR
17
2
WRF_POTB_RES_VALUE
OTB_SPEC_VALUE
Special Release Budget
CURR
17
2
WRF_POTB_SPECIAL_VALUE
SPR_RSN_PROFILE
Reason Profile for OTB Special Release
CHAR
4
0
WRF_POTB_SPR_RSN_PROFILE
BUDG_TYPE
Budget Type
CHAR
2
0
WRF_BUDG_TYPE
OTB_STATUS
OTB Check Status
CHAR
1
0
WRF_POTB_STATUS
Not Checked
1
OTB Check Without Errors
2
Checked with Errors
OTB_REASON
Reason Indicator for OTB Check Status
CHAR
3
0
WRF_POTB_STATUS_REASON
001
No Check Required
002
Active Budget Available
005
Complete OTB Check Successful
006
Complete OTB Check Not Successful
007
OTB Check Not Active According to Customizing
008
OTB Check Deactivated According to BAdI
009
At Least One Variant of Generic Material w. Negative OTB Ch.
010
All Variants of Generic Material with Positive OTB Check
011
At least one doc. w. same coll. no. OTB neg. (reason 006)
CHECK_TYPE
Type of OTB Check
CHAR
1
0
WRF_BUDG_OTB_CHECK
1
Full Check
2
Limited Check
3
No Check
CON_OTB_REQ
OTB-Relevant Contract
CHAR
1
0
WRF_POTB_CON_REQ
CON_PREBOOK_LEV
OTB Indicator Level for Contracts
CHAR
1
0
WRF_POTB_PREBOOK_LEVEL
1
OTB Indicator on Header Level
2
OTB Indicator on Item Level
CON_DISTR_LEV
Distribution Using Target Value or Item Data
CHAR
1
0
WRF_POTB_DISTRIB_LEVEL
1
Distribution Using Contract Target Value
2
Distribution Using Item Quantities
EKKO foreign key relationships
The EKKO table is intricately connected to several other SAP tables to ensure a robust and interconnected procurement system. Here are some of the most important connections:
EKPO (Purchasing Document Item)
Connection: EKKO.EBELN = EKPO.EBELN
Description: EKPO stores the item-level details for each purchasing document, providing a granular view of each line item associated with the purchase document header.
LFA1 (Vendor Master - General Section)
Connection: EKKO.LIFNR = LFA1.LIFNR
Description: LFA1 holds the general information about vendors. This connection is crucial for retrieving vendor-specific data linked to purchase documents.
BKPF (Accounting Document Header)
Connection: EKKO.EBELN = BKPF.AWKEY (through reference in FI documents)
Description: BKPF contains the header information for financial accounting documents. The link between EKKO and BKPF is established through the procurement process's financial postings.
MSEG (Document Segment: Material)
Connection: Indirect connection through material document references
Description: MSEG records material movements. Purchase orders and goods receipts often reference each other through document numbers.
EKKO_EKET (Scheduling Agreement Schedule Lines)
Connection: EKKO.EBELN = EKET.EBELN
Description: EKET stores schedule line details for scheduling agreements, specifying delivery schedules for ordered items.
EKKN (Account Assignment in Purchasing Document)
Connection: EKKO.EBELN = EKKN.EBELN
Description: EKKN captures account assignment details, linking purchase documents to cost centers, orders, and other account assignments.
CEKKO (SAP HANA Custom EKKO Table)
Connection: Extension of EKKO for custom fields
Description: In SAP HANA environments, CEKKO is used to store custom fields and enhance the standard EKKO table.
These connections illustrate the EKKO table's role in the SAP system, serving as a central hub for purchase document information and integrating with various modules to support the comprehensive procurement process.