SAP table EORD (Purchasing Source List)

SAP table EORD has 4 primary key fields being MANDT,MATNR,WERKS,ZEORD.

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
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W EWERK
ZEORD Number of Source List Record NUMC 5 0 DZEORD
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
VDATU Source List Record Valid From DATS 8 0 ORDAB
BDATU Source List Record Valid To DATS 8 0 ORDBI
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
FLIFN Indicator: Fixed Supplier CHAR 1 0 FLIFN
EBELN Agreement Number CHAR 10 0 EKKO EVRTN
EBELP Agreement Item NUMC 5 0 EKPO EVRTP
FEBEL Fixed Outline Purchase Agreement Item CHAR 1 0 FEBEL
RESWK Plant from Which Material is Procured CHAR 4 0 BEWRK
FRESW Fixed issuing plant in case of stock transport order CHAR 1 0 FRESW
EMATN Material number corresponding to manufacturer part number CHAR 40 0 MARA EMATN
NOTKZ Blocked Source of Supply CHAR 1 0 ORDSP
EKORG Purchasing organization CHAR 4 0 T024E EKORG
VRTYP 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
EORTP Category of Source List Record CHAR 1 0 EORTP
0 Standard
2 Consignment
AUTET Source List Usage in Materials Planning CHAR 1 0 AUTET
Source list record not relevant to MRP
1 Record relevant to MRP
2 Record relevant to MRP. Sched. lines generated automatically
MEINS Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
LOGSY Logical System CHAR 10 0 TBDLS LOGSYSTEM
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
SRM_CONTRACT_ID Central Contract CHAR 10 0 SRM_CONTRACT_ID
SRM_CONTRACT_ITM Central Contract Item Number NUMC 10 0 SRM_CONTRACT_ITEM
DUMMY_EORD_INCL_EEW_PS Data element for Source List Extensibility CHAR 1 0 EORD_INCL_EEW
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL

EORD foreign key relationships

Table Field Check Table Check Field
0 EORD EBELN EKKO Purchasing Document Header EBELN
1 EORD EBELP EKPO Purchasing Document Item MANDT
1 EORD EBELP EKPO Purchasing Document Item EBELN
0 EORD EKORG T024E Purchasing Organizations EKORG
1 EORD EMATN MARA General Material Data MANDT
1 EORD EMATN MARA General Material Data MATNR
0 EORD LIFNR LFA1 Supplier Master (General Section) MANDT
0 EORD LIFNR LFA1 Supplier Master (General Section) LIFNR
1 EORD LOGSY TBDLS Logical system LOGSYS
0 EORD MANDT T000 Clients MANDT
1 EORD MATNR MARA General Material Data MANDT
1 EORD MATNR MARA General Material Data MATNR
0 EORD MEINS T006 Units of Measurement MANDT
0 EORD MEINS T006 Units of Measurement MSEHI
1 EORD WERKS T001W Plants/Branches MANDT
1 EORD WERKS T001W Plants/Branches WERKS