SAP ABAP Table MDLA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDLA	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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	ETENS	☑	ETENS	NUM04	NUMC	4	0	Sequential Number of Vendor Confirmation
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
9	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
10	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
11	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
12	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
13	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
14	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
15	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
16	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
17	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
18	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
19	EINDT	☐	BBEIN	DATUM	DATS	8	0	Delivery Date of Vendor Confirmation
20	UZEIT	☐	BBUZE	UZEIT	TIMS	6	0	Delivery Date Time-Spot in Vendor Confirmation
21	MENGE	☐	BBMNG	MENGE	QUAN	13	3	Quantity as Per Vendor Confirmation
22	DABMG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
23	ESTKZ	☐	BBEST	BBEST	CHAR	1	0	Creation Indicator: Vendor Confirmation
24	KZDIS	☐	KZDIS	XFELD	CHAR	1	0	Indicator: Confirmation is Relevant to Materials Planning
25	BBLOE	☐	BBLOE	ELOEK	CHAR	1	0	Vendor confirmation deletion indicator
26	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
27	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
28	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
29	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
30	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
31	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
32	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
33	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
34	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
35	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
36	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
37	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
38	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
39	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
40	ITCONS	☐	ME_IR_CO_ORDER	XFELD	CHAR	1	0	Real-Time Consumption Posting of Subcontracting Components

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in