SAP Table EORD
Purchasing Source List
EORD (Purchasing Source List) 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 EORD to other SAP tables.
EORD table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||
WERKS | Plant | EWERK | T001W | CHAR | 4 | 0 | ||||||||||||||||||
ZEORD | Number of Source List Record | DZEORD | NUMC | 5 | 0 | |||||||||||||||||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||
VDATU | Source List Record Valid From | ORDAB | DATS | 8 | 0 | |||||||||||||||||||
BDATU | Source List Record Valid To | ORDBI | DATS | 8 | 0 | |||||||||||||||||||
LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||
FLIFN | Indicator: Fixed vendor | FLIFN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
EBELN | Agreement Number | EVRTN | EKKO | CHAR | 10 | 0 | ||||||||||||||||||
EBELP | Agreement Item | EVRTP | EKPO | NUMC | 5 | 0 | ||||||||||||||||||
FEBEL | Fixed Outline Purchase Agreement Item | FEBEL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
RESWK | Plant from Which Material is Procured | BEWRK | CHAR | 4 | 0 | |||||||||||||||||||
FRESW | Fixed issuing plant in case of stock transport order | FRESW | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | MARA | CHAR | 18 | 0 | ||||||||||||||||||
NOTKZ | Blocked Source of Supply | ORDSP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||||||||||
VRTYP | Purchasing Document Category | BSTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
EORTP | Category of Source List Record | EORTP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
AUTET | Source List Usage in Materials Planning | AUTET | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
MEINS | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 | 0 | ||||||||||||||||||
LOGSY | Logical System | LOGSYSTEM | TBDLS | CHAR | 10 | 0 | ||||||||||||||||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | 0 | |||||||||||||||||||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | 0 | |||||||||||||||||||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | 0 |
EORD foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
EORD | EBELN | EORD | MANDT | EKKO | Purchasing Document Header | MANDT |
EORD | EBELN | EORD | EBELN | EKKO | Purchasing Document Header | EBELN |
EORD | EBELP | EORD | EBELP | EKPO | Purchasing Document Item | EBELP |
EORD | EBELP | EORD | MANDT | EKPO | Purchasing Document Item | MANDT |
EORD | EBELP | EORD | EBELN | EKPO | Purchasing Document Item | EBELN |
EORD | EKORG | EORD | MANDT | T024E | Purchasing Organizations | MANDT |
EORD | EKORG | EORD | EKORG | T024E | Purchasing Organizations | EKORG |
EORD | EMATN | EORD | MANDT | MARA | General Material Data | MANDT |
EORD | EMATN | EORD | EMATN | MARA | General Material Data | MATNR |
EORD | LIFNR | EORD | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
EORD | LIFNR | EORD | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
EORD | LOGSY | EORD | LOGSY | TBDLS | Logical system | LOGSYS |
EORD | MANDT | EORD | MANDT | T000 | Clients | MANDT |
EORD | MATNR | EORD | MATNR | MARA | General Material Data | MATNR |
EORD | MATNR | EORD | MANDT | MARA | General Material Data | MANDT |
EORD | MEINS | EORD | MEINS | T006 | Units of Measurement | MSEHI |
EORD | MEINS | EORD | MANDT | T006 | Units of Measurement | MANDT |
EORD | WERKS | EORD | MANDT | T001W | Plants/Branches | MANDT |
EORD | WERKS | EORD | WERKS | T001W | Plants/Branches | WERKS |