SAP ABAP Table MDRR (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	RESB
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	RSSTA	☐	RSSTA	STATR	CHAR	1	0	Status of reservation
7	XLOEK	☐	XLOEK	XFELD	CHAR	1	0	Item is deleted
8	XWAOK	☐	XWAOK	XFELD	CHAR	1	0	Goods movement for reservation allowed
9	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
10	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
14	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area
15	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
16	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
17	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
18	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
19	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
20	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
22	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
23	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
24	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
25	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
26	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
27	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
28	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
29	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
30	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
31	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
32	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
33	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
34	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
35	POSNR	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
36	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
37	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
38	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
39	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
40	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
41	ROHPS	☐	ROHPS	XFELD	CHAR	1	0	Variable-sized item indicator
42	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
43	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
44	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
45	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
46	STLKN	☐	STLKN	KNTNR	NUMC	8	0	BOM Item Node Number
47	STPOZ	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
48	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
49	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
50	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
51	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
52	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
53	PSPEL	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
54	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
55	PLNFL	☐	PLNFOLGE	PLNFOLGE	CHAR	6	0	Sequence
56	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
57	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
58	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
59	RGEKZ	☐	RGEKZ	XFELD	CHAR	1	0	Indicator: Backflush
60	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
61	PRREG	☐	PRREG	PRREG	CHAR	2	0	Checking rule for the availability check	T441R
62	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
63	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
64	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
65	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
66	ESMNG	☐	ESMNG	ESMNG	FLTP	16	16	Usage quantity per order unit of measure
67	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
68	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDRR	AUFNR	AUFK	AUFNR	REF	C	CN
2	MDRR	BAUGR	MARA	MATNR	REF	C	CN
3	MDRR	BWART	T156	BWART	REF	1	CN
4	MDRR	CHARG	MCHA	CHARG	REF	C	CN
5	MDRR	ERFME	T006	MSEHI	REF	C	CN
6	MDRR	KDAUF	VBUK	VBELN	REF	C	CN
7	MDRR	KNTTP	T163K	KNTTP	KEY	1	CN
8	MDRR	LGNUM	T300	LGNUM	REF	C	CN
9	MDRR	LGORT	T001L	LGORT	REF	C	CN
10	MDRR	LGPLA	LAGP	LGPLA	REF	C	CN
11	MDRR	LGTYP	T301	LGTYP	REF	C	CN
12	MDRR	LIFNR	LFA1	LIFNR	REF	C	CN
13	MDRR	MANDT	T000	MANDT	KEY	1	CN
14	MDRR	MATNR	MARA	MATNR	REF	1	CN
15	MDRR	MEINS	T006	MSEHI	REF	1	CN
16	MDRR	OBJNR	ONR00	OBJNR	REF	C	1
17	MDRR	PLNUM	PLAF	PLNUM	REF	C	CN
18	MDRR	POSTP	T418	POSTP	REF	C	CN
19	MDRR	PRREG	T441R	PRREG	KEY	1	1
20	MDRR	RFORM	T418F	RFORM	REF	C	CN
21	MDRR	ROMEI	T006	MSEHI	REF	C	CN
22	MDRR	SERNR	SNUM	SERNR		C	CN
23	MDRR	SOBKZ	T148	SOBKZ	REF	C	CN
24	MDRR	WAERS	TCURC	WAERS	REF	1	CN
25	MDRR	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in