SAP ABAP Table MDSB (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	RESB
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	RSNUM	☑	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
3	RSPOS	☑	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
4	RSART	☑	RSART	RSART	CHAR	1	0	Record type
5	AUFST	☐	AUFST	AUFST	NUMC	2	0	Order level
6	AUFWG	☐	AUFWG	AUFWG	NUMC	2	0	Order path
7	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
8	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
10	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
12	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area
13	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
14	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
15	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
16	NODSP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
17	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
18	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
19	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
20	INPOS	☐	INPOS	XFELD	CHAR	1	0	Indicator: intra material
21	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
22	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
23	CLAKZ	☐	CLAKZ	XFELD	CHAR	1	0	Indicator: classification exists
24	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
25	SANKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
26	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
27	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
28	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
29	ESMNG	☐	ESMNG	ESMNG	FLTP	16	16	Usage quantity per order unit of measure
30	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
31	BEIKZ	☐	BEIKZ	BEIKZ	CHAR	1	0	Material Provision Indicators	T417
32	ERSKZ	☐	ERSKZ	ERSKZ	CHAR	1	0	Indicator: Spare Part	T413
33	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
34	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
35	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
36	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
37	FMENG	☐	FMENG	XFELD	CHAR	1	0	Quantity is fixed
38	ALPOS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
39	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
40	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
41	ALPRF	☐	CS_ALPRF	NUM2	NUMC	2	0	Alternative Item: Ranking Order
42	ALPST	☐	CS_ALPST	CS_ALPST	CHAR	1	0	Alternative Item: Strategy
43	AUSCH	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
44	AVOAU	☐	AVOAU	DEC3_2	DEC	5	2	Operation Scrap
45	NETAU	☐	NETAU	XFELD	CHAR	1	0	Indicator: Net Scrap
46	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
47	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
48	VERTI	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
49	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
50	BDZTP	☐	BDZTP	BDZTP	TIMS	6	0	Time that reservation quantity required
51	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
52	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
53	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
54	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
55	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
56	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
57	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
58	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
59	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
60	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
61	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
62	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
63	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
64	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
65	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
66	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
67	KZAUS	☐	AUSLF	AUSLF	CHAR	1	0	Discontinuation type
68	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
69	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
70	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
71	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
72	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
73	NFUML	☐	NFUML	NFUML	DEC	5	4	NOT USED: Quantity transfer factor for follow-up material
74	NOMAT	☐	NOMAT	MATNR	CHAR	18	0	Follow-Up/Original Material	MARA
75	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
76	POTX1	☐	POTX1	TEXT40	CHAR	40	0	BOM Item Text (Line 1)
77	POTX2	☐	POTX2	TEXT40	CHAR	40	0	BOM Item Text (Line 2)
78	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
79	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
80	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
81	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
82	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
83	EBELE	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	EKET
84	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
85	BAUST	☐	BAUST	AUFST	NUMC	2	0	Assembly order level
86	BAUWG	☐	BAUWG	AUFWG	NUMC	2	0	Assembly order path
87	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
88	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
89	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
90	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
91	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
92	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
93	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
94	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
95	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
96	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
97	KZKUP	☐	KZKUP	XFELD	CHAR	1	0	Indicator: Co-Product
98	STLAL	☐	STALT	ALTNR	CHAR	2	0	Alternative BOM
99	STVKN	☐	STVKN	KNTNR	NUMC	8	0	Inherited Node Number of BOM Item
100	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
101	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
102	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
103	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
104	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
105	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
106	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
107	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	T006
108	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
109	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDSB	AENNR	AENR	AENNR	REF	C	CN
2	MDSB	BAUGR	MARA	MATNR	REF	C	CN
3	MDSB	BEIKZ	T417	BEIKZ	REF	C	CN
4	MDSB	BNFPO	EBAN	BNFPO	REF	C	CN
5	MDSB	CHARG	MCHA	CHARG	REF	C	CN
6	MDSB	EBELE	EKET	ETENR	KEY	1	CN
7	MDSB	EBELN	EKKO	EBELN	KEY	1	CN
8	MDSB	EBELP	EKPO	EBELP	KEY	1	CN
9	MDSB	ERFME	T006	MSEHI	REF	C	CN
10	MDSB	ERSKZ	T413	ERSKZ	REF	C	CN
11	MDSB	KDAUF	VBUK	VBELN	REF	C	CN
12	MDSB	KNTTP	T163K	KNTTP	KEY	1	CN
13	MDSB	LGORT	T001L	LGORT	REF	C	CN
14	MDSB	LIFNR	LFA1	LIFNR	REF	C	CN
15	MDSB	LTXSP	T002	SPRAS	REF	C	CN
16	MDSB	MANDT	T000	MANDT	KEY	1	CN
17	MDSB	MATNR	MARA	MATNR	REF	1	CN
18	MDSB	MEINS	T006	MSEHI	REF	1	CN
19	MDSB	NLFMV	T006	MSEHI		1	N
20	MDSB	NOMAT	MARA	MATNR	REF	C	CN
21	MDSB	PLNUM	PLAF	PLNUM	REF	C	CN
22	MDSB	POSTP	T418	POSTP	REF	C	CN
23	MDSB	RFORM	T418F	RFORM	REF	C	CN
24	MDSB	ROMEI	T006	MSEHI	REF	C	CN
25	MDSB	SANKA	TCK08	SELKZ	KEY	1	CN
26	MDSB	SERNR	SNUM	SERNR		C	CN
27	MDSB	SOBKZ	T148	SOBKZ	REF	C	CN
28	MDSB	VERTI	T437V	VERTL	REF	C	CN
29	MDSB	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in