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 | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
EMATN
Material Number Corresponding to Manufacturer Part Number
|
EMATN | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||
|
NOTKZ
Blocked Source of Supply
|
ORDSP |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||||||||||
|
VRTYP
Purchasing Document Category
|
BSTYP |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
EORTP
Category of Source List Record
|
EORTP |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
AUTET
Source List Usage in Materials Planning
|
AUTET |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
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 | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EORD | EBELP | EORD | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| EORD | EBELP | EORD | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| 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 | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| EORD | LIFNR | EORD | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| EORD | LOGSY | EORD | LOGSY |
TBDLS
Logical system
|
LOGSYS |
| EORD | MANDT | EORD | MANDT |
T000
Clients
|
MANDT |
| EORD | MATNR | EORD | MANDT |
MARA
General Material Data
|
MANDT |
| EORD | MATNR | EORD | MATNR |
MARA
General Material Data
|
MATNR |
| EORD | MEINS | EORD | MANDT |
T006
Units of Measurement
|
MANDT |
| EORD | MEINS | EORD | MEINS |
T006
Units of Measurement
|
MSEHI |
| EORD | WERKS | EORD | MANDT |
T001W
Plants/Branches
|
MANDT |
| EORD | WERKS | EORD | WERKS |
T001W
Plants/Branches
|
WERKS |