SAP ABAP Table MDRS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDRS	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	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	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
6	UPSKZ	☐	UPSKZ	XFELD	CHAR	1	0	Indicator: Subitems Exist
7	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
8	TXTPS	☐	TXTPS	XFELD	CHAR	1	0	Item text indicator
9	DUMPS	☐	DUMPS	XFELD	CHAR	1	0	Phantom item indicator
10	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
11	DBSKZ	☐	DBSKZ	DBSKZ	CHAR	1	0	Direct procurement indicator
12	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
13	XWAOK	☐	XWAOK	XFELD	CHAR	1	0	Goods movement for reservation allowed
14	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
15	RSSTA	☐	RSSTA	STATR	CHAR	1	0	Status of reservation
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
18	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
19	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
20	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
21	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
22	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
23	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
24	NLFZT	☐	NLFZT	NLFZT	DEC	3	0	Lead-Time Offset
25	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
26	ALPOS	☐	ALTPS	XFELD	CHAR	1	0	Alternative item indicator
27	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
28	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
29	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
30	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
31	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
32	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
33	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
34	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
35	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
36	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
37	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
38	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
39	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
40	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
41	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
42	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
43	EBELE	☐	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	EKET
44	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
45	AUFPS	☐	AUFPS	CHAR2	CHAR	2	0	Order item number
46	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
47	UMLGO	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
48	KZAUS	☐	AUSLF	AUSLF	CHAR	1	0	Discontinuation type
49	NFEAG	☐	CS_NFEAG	CHAR2	CHAR	2	0	Discontinuation Group
50	NFGRP	☐	CS_NFGRP	CHAR2	CHAR	2	0	Follow-Up Group
51	NFPKZ	☐	CS_KZNFP	XFELD	CHAR	1	0	Indicator: Follow-Up Item
52	NAFKZ	☐	NAFKZ	XFELD	CHAR	1	0	Indicator: follow-up material active/not active
53	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
54	NFUML	☐	NFUML	NFUML	DEC	5	4	NOT USED: Quantity transfer factor for follow-up material
55	NOMAT	☐	NOMAT	MATNR	CHAR	18	0	Follow-Up/Original Material	MARA
56	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
57	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
58	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
59	VERTI	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
60	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
61	NDISP	☐	NO_DISP_PLUS	NO_DISP_PLUS	CHAR	1	0	Effective for Materials Planning
62	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
63	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
64	PBDNR	☐	PBDNR	CHAR10	CHAR	10	0	Requirements Plan Number
65	VRPLA	☐	VRPLA	XFELD	CHAR	1	0	Indicator: planning without final assembly
66	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
67	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
68	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
69	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
70	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
71	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
72	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
73	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
74	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
75	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer
76	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
77	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
78	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
79	VORAB	☐	VORABKZ	XFELD	CHAR	1	0	Ind: Preliminary order
80	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
81	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDRS	AUFNR	AUFK	AUFNR	REF	C	CN
2	MDRS	BAUGR	MARA	MATNR	REF	C	CN
3	MDRS	BNFPO	EBAN	BNFPO	REF	C	CN
4	MDRS	BWART	T156	BWART	REF	1	CN
5	MDRS	CHARG	MCHA	CHARG	REF	C	CN
6	MDRS	EBELE	EKET	ETENR	KEY	1	CN
7	MDRS	EBELN	EKKO	EBELN	KEY	1	CN
8	MDRS	EBELP	EKPO	EBELP	KEY	1	CN
9	MDRS	ERFME	T006	MSEHI	REF	C	CN
10	MDRS	KDAUF	VBUK	VBELN	REF	C	CN
11	MDRS	KNTTP	T163K	KNTTP	KEY	1	CN
12	MDRS	LGORT	T001L	LGORT	REF	C	CN
13	MDRS	LIFNR	LFA1	LIFNR	REF	C	CN
14	MDRS	MANDT	T000	MANDT	KEY	1	CN
15	MDRS	MATNR	MARA	MATNR	REF	1	CN
16	MDRS	MEINS	T006	MSEHI	REF	1	CN
17	MDRS	NOMAT	MARA	MATNR	REF	C	CN
18	MDRS	PLNUM	PLAF	PLNUM	REF	C	CN
19	MDRS	POSTP	T418	POSTP	REF	C	CN
20	MDRS	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
21	MDRS	PRIO_URG	PURG	PRIO_URG	REF	1	CN
22	MDRS	SERNR	SNUM	SERNR		C	CN
23	MDRS	SOBKZ	T148	SOBKZ	REF	C	CN
24	MDRS	UMLGO	T001L	LGORT	REF	C	CN
25	MDRS	UMWRK	T001W	WERKS	REF	C	CN
26	MDRS	VERTI	T437V	VERTL	REF	C	CN
27	MDRS	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in