SAP ABAP Table MDQM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDQM	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	MANDANT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRUEFLOS	☑	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	WERKVORG	☐	QWERKVORG	WERKS	CHAR	4	0	Plant Where Stock for Inspection Lot Is Held	T001W
5	INSMK	☐	QVINSMK	QKZ	CHAR	1	0	Quantity Is or Was in Inspection Stock
6	PASTRTERM	☐	QPRSTART	DATUM	DATS	8	0	Inspection Start Date
7	PAENDTERM	☐	QPRENDE	DATUM	DATS	8	0	End Date of the Inspection
8	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
9	LAGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
10	LOSMENGE	☐	QLOSMENGE	QMENGEPLOS	QUAN	13	3	Inspection Lot Quantity
11	LMENGEZUB	☐	QLMENGEZUB	QMENGEPLOS	QUAN	13	3	Quantity That Must Be Posted
12	MENGENEINH	☐	QLOSMENGEH	MEINS	UNIT	3	0	Base Unit of Measure for The Inspection Lot Quantity	T006
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
14	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
15	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
16	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
17	KDAUF	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	VBUK
18	KDPOS	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
19	PS_PSP_PNR	☐	MAT_PSPNR	PS_POSNR	NUMC	8	0	Valuated customer stock WBS element	PRPS
20	STAT34	☐	QSTAT34	QKZ	CHAR	1	0	Stock Postings Completed
21	STAT35	☐	QSTAT35	QKZ	CHAR	1	0	Usage Decision Has Been Made
22	HERKUNFT	☐	QHERK	QHERK	CHAR	2	0	Inspection Lot Origin	TQ31
23	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDQM	CHARG	MCH1	CHARG	REF	C	CN
2	MDQM	HERKUNFT	TQ31	HERKUNFT	KEY	1	CN
3	MDQM	KDAUF	VBUK	VBELN	REF	C	CN
4	MDQM	KNTTP	T163K	KNTTP	REF	C	CN
5	MDQM	LAGORTVORG	T001L	LGORT	REF	C	CN
6	MDQM	MANDANT	T000	MANDT	KEY	1	CN
7	MDQM	MATNR	MARA	MATNR	REF	C	CN
8	MDQM	MENGENEINH	T006	MSEHI	REF	C	CN
9	MDQM	PSTYP	T163	PSTYP	REF	C	CN
10	MDQM	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
11	MDQM	SOBKZ	T148	SOBKZ	REF	C	CN
12	MDQM	WERKVORG	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in