SAP ABAP Table MDBS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDBS	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	ETENR	☑	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter
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	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
20	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
21	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
22	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
23	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
24	ETDRK	☐	ETDRK	ETDRK	CHAR	1	0	Indicator: Print-relevant schedule lines exist
25	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
26	MENGE	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
27	WEMNG	☐	WEEMG	MENG13	QUAN	13	3	Quantity of goods received
28	DABMG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
29	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
30	GLMNG	☐	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
31	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
32	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
33	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
34	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
35	BEDAT	☐	ETBDT	DATUM	DATS	8	0	Order date of schedule line
36	FIXKZ	☐	ETFIX	XFELD	CHAR	1	0	Schedule Line is "Fixed"
37	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number
38	AMENG	☐	VOMNG	MENG13V	QUAN	13	3	Previous Quantity (Delivery Schedule Lines)
39	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
40	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
41	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
42	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
43	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
44	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
45	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
46	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
47	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
48	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
49	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
50	EGLKZ	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
51	KZFIX	☐	MRPRE	KZFIX	CHAR	1	0	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
52	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
53	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
54	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
55	VERID	☐	VERID	VERID	CHAR	4	0	Production Version
56	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
57	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
58	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
59	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
60	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
61	NODISP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
62	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
63	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
64	ITCONS	☐	ME_IR_CO_ORDER	XFELD	CHAR	1	0	Real-Time Consumption Posting of Subcontracting Components
65	FIXMG	☐	ME_FIXMG	ME_FIXMG	CHAR	1	0	Delivery Date and Quantity Fixed
66	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
67	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDBS	AKTNR	WAKH	AKTNR	KEY	1	N
2	MDBS	BERID	MDLV	BERID	REF	1	CN
3	MDBS	BNFPO	EBAN	BNFPO	REF	1	N
4	MDBS	BSTAE	T163L	BSTAE	KEY	1	N
5	MDBS	BWTAR	T149D	BWTAR	REF	1	N
6	MDBS	EBELN	EKKO	EBELN	KEY	1	N
7	MDBS	EMLIF	LFA1	LIFNR	KEY	1	N
8	MDBS	KNTTP	T163K	KNTTP	REF	1	N
9	MDBS	LGORT	T001L	LGORT	REF	1	N
10	MDBS	MANDT	T000	MANDT	KEY	1	N
11	MDBS	MATNR	MARA	MATNR	REF	1	N
12	MDBS	MEINS	T006	MSEHI	REF	1	N
13	MDBS	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
14	MDBS	PRIO_URG	PURG	PRIO_URG	REF	1	CN
15	MDBS	PSTYP	T163	PSTYP	REF	1	N
16	MDBS	RESLO	T001L	LGORT
17	MDBS	SOBKZ	T148	SOBKZ	REF	1	N
18	MDBS	UPTYP	TMSI1	UPTYP	REF	1	N
19	MDBS	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in