SAP ABAP Table MDRI (Generated Table for View MDRI)

Basic Data

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

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	RQNUM	☑	RQNUM	RQNUM	NUMC	10	0	Requirements record number
3	BAUGR	☑	PLMAT	MATNR	CHAR	18	0	Planning material	MARA
4	PLWRK	☑	PLWRK	WERKS	CHAR	4	0	Planning Plant	T001W
5	VERID	☑	VERID	VERID	CHAR	4	0	Production Version	MKAL
6	RSART	☑	RSART	RSART	CHAR	1	0	Record type
7	RQITM	☑	RQITM	IQPOS	NUMC	5	0	Requirements totals record item
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	PVBE
12	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
14	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
15	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
16	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDRI	BAUGR	MARA	MATNR		1	CN
2	MDRI	LGORT	T001L	LGORT		1	CN
3	MDRI	MANDT	T000	MANDT		1	CN
4	MDRI	PLWRK	T001W	WERKS		1	CN
5	MDRI	PRVBE	PVBE	PRVBE		1	CN
6	MDRI	SOBKZ	T148	SOBKZ
7	MDRI	VERID	MKAL	VERID
8	MDRI	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in