SAP ABAP Table MB_MDBS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MB_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	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
55	BSTMG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
56	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in