SAP table EKAB (Release Documentation)

SAP table EKAB has 5 primary key fields being MANDT,KONNR,KTPNR,EBELN,EBELP.

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.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KONNR Number of principal purchase agreement CHAR 10 0 EKKO KONNR
KTPNR Item number of principal purchase agreement NUMC 5 0 EKPO KTPNR
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
BEDAT Purchase Order Date DATS 8 0 BEDAT
MENGE Purchase Order Quantity QUAN 13 3 BSTMG
MEINS Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
NETWR Net Order Value in PO Currency CURR 13 2 BWERT
WAERS Currency Key CUKY 5 0 TCURC WAERS
WKURS Exchange Rate DEC 9 5 WKURS
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
EBELD PO number in local system CHAR 10 0 EBELD
LOGSY Logical System CHAR 10 0 LOGSYSTEM
BUKRS Company Code CHAR 4 0 T001 BUKRS
WERKS Plant CHAR 4 0 T001W EWERK
EKORG Purchasing organization CHAR 4 0 T024E EKORG
AEDAT Last Changed On DATS 8 0 AEDAT
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
MEMORYTYPE Category of Incompleteness CHAR 1 0 MEMORYTYPE
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE

EKAB foreign key relationships

Table Field Check Table Check Field
0 EKAB BUKRS T001 Company Codes BUKRS
1 EKAB EBELN EKKO Purchasing Document Header EBELN
0 EKAB EBELP EKPO Purchasing Document Item MANDT
0 EKAB EBELP EKPO Purchasing Document Item EBELN
1 EKAB EKORG T024E Purchasing Organizations EKORG
0 EKAB KONNR EKKO Purchasing Document Header MANDT
0 EKAB KONNR EKKO Purchasing Document Header EBELN
1 EKAB KTPNR EKPO Purchasing Document Item MANDT
1 EKAB KTPNR EKPO Purchasing Document Item EBELN
0 EKAB MANDT T000 Clients MANDT
1 EKAB MEINS T006 Units of Measurement MANDT
1 EKAB MEINS T006 Units of Measurement MSEHI
0 EKAB WAERS TCURC Currency Codes MANDT
0 EKAB WAERS TCURC Currency Codes WAERS
1 EKAB WERKS T001W Plants/Branches WERKS