SAP ABAP Table MDRELA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDRELA	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RESWK	☑	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
4	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
5	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
6	ETENS	☑	ETENS	NUM04	NUMC	4	0	Sequential Number of Vendor Confirmation
7	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
8	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
9	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
10	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
12	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
13	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
14	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
15	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
16	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
17	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
18	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
19	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
20	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
21	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
22	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
23	EINDT	☐	BBEIN	DATUM	DATS	8	0	Delivery Date of Vendor Confirmation
24	UZEIT	☐	BBUZE	UZEIT	TIMS	6	0	Delivery Date Time-Spot in Vendor Confirmation
25	MENGE	☐	BBMNG	MENGE	QUAN	13	3	Quantity as Per Vendor Confirmation
26	DABMG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
27	ESTKZ	☐	BBEST	BBEST	CHAR	1	0	Creation Indicator: Vendor Confirmation
28	KZDIS	☐	KZDIS	XFELD	CHAR	1	0	Indicator: Confirmation is Relevant to Materials Planning
29	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
30	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
31	SPE_INSMK_SRC	☐	/SPE/INSMK_SRC	INSMK	CHAR	1	0	Stock Type of Source Storage Location in STO
32	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDRELA	BERID	MDLV	BERID	REF	1	CN
2	MDRELA	BWTAR	T149D	BWTAR	REF	1	N
3	MDRELA	EBELN	EKKO	EBELN	KEY	1	CN
4	MDRELA	EBELP	EKPO	EBELP	KEY	1	CN
5	MDRELA	KNTTP	T163K	KNTTP	REF	1	N
6	MDRELA	LGORT	T001L	LGORT	REF	1	N
7	MDRELA	MANDT	T000	MANDT	KEY	1	CN
8	MDRELA	MATNR	MARA	MATNR	KEY	1	CN
9	MDRELA	MEINS	T006	MSEHI	REF	1	N
10	MDRELA	PSTYP	T163	PSTYP	REF	1	N
11	MDRELA	RESLO	T001L	LGORT
12	MDRELA	RESWK	T001W	WERKS	KEY	1	CN
13	MDRELA	SOBKZ	T148	SOBKZ	REF	1	N
14	MDRELA	UPTYP	TMSI1	UPTYP	REF	1	N
15	MDRELA	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in