SAP ABAP Table EORD (Purchasing Source List)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EORD	Table Relationship Diagram
Short Description	Purchasing Source List

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
4	ZEORD	☑	DZEORD	NUM5	NUMC	5	0	Number of Source List Record
5	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
6	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	VDATU	☐	ORDAB	DATUM	DATS	8	0	Source List Record Valid From
8	BDATU	☐	ORDBI	DATUM	DATS	8	0	Source List Record Valid To
9	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
10	FLIFN	☐	FLIFN	XFELD	CHAR	1	0	Indicator: Fixed vendor
11	EBELN	☐	EVRTN	EBELN	CHAR	10	0	Agreement Number	EKKO
12	EBELP	☐	EVRTP	EBELP	NUMC	5	0	Agreement Item	EKPO
13	FEBEL	☐	FEBEL	XFELD	CHAR	1	0	Fixed Outline Purchase Agreement Item
14	RESWK	☐	BEWRK	WERKS	CHAR	4	0	Plant from Which Material is Procured	*
15	FRESW	☐	FRESW	XFELD	CHAR	1	0	Fixed issuing plant in case of stock transport order
16	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
17	NOTKZ	☐	ORDSP	XFELD	CHAR	1	0	Blocked Source of Supply
18	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
19	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
20	EORTP	☐	EORTP	EORTP	CHAR	1	0	Category of Source List Record
21	AUTET	☐	AUTET	AUTET	CHAR	1	0	Source List Usage in Materials Planning
22	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
23	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	TBDLS
24	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
25	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
26	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EORD	EBELN	EKKO	EBELN	REF	1	CN
2	EORD	EBELP	EKPO	EBELP	REF	1	CN
3	EORD	EKORG	T024E	EKORG	REF	1	CN
4	EORD	EMATN	MARA	MATNR	REF	1	CN
5	EORD	LIFNR	LFA1	LIFNR	REF	1	CN
6	EORD	LOGSY	TBDLS	LOGSYS	REF	1	N
7	EORD	MANDT	T000	MANDT	KEY	1	CN
8	EORD	MATNR	MARA	MATNR	KEY	1	CN
9	EORD	MEINS	T006	MSEHI	REF	1	N
10	EORD	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in