SAP ABAP View MDQM (MRP View of the QM Inspection Lot)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD (Package) Application development R/3 requirements planning

Basic Data

View Type	D	Database View
Database View	MDQM
Short Description	MRP View of the QM Inspection Lot
Root table	QALS	Inspection lot record

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QALS	QALS
2	JEST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QALS	MANDANT	JL	EQ				0	0
2	JEST	MANDT	JR	EQ			AND	0	0
3	QALS	OBJNR	JL	EQ				0	0
4	JEST	OBJNR	JR	EQ			AND	0	0
5	QALS	HERKUNFT		EQ	'01'		OR	0	0
6	QALS	HERKUNFT		EQ	'04'		OR	0	0
7	QALS	HERKUNFT		EQ	'05'		OR	0	0
8	QALS	HERKUNFT		EQ	'08'		OR	0	0
9	QALS	HERKUNFT		EQ	'09'		AND	0	0
10	QALS	STAT34		EQ	' '		AND	0	0
11	QALS	STAT01		EQ	'X'		AND	0	0
12	JEST	STAT		EQ	'I0203'		AND	0	0
13	JEST	INACT		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDANT	QALS	MANDANT		☐	MANDT	☐	Client
2	PRUEFLOS	QALS	PRUEFLOS		☐	QPLOS	☐	Inspection Lot Number
3	MATNR	QALS	MATNR		☐	MATNR	☐	Material Number
4	WERKVORG	QALS	WERKVORG		☐	QWERKVORG	☐	Plant Where Stock for Inspection Lot Is Held
5	INSMK	QALS	INSMK		☐	QVINSMK	☐	Quantity Is or Was in Inspection Stock
6	PASTRTERM	QALS	PASTRTERM		☐	QPRSTART	☐	Inspection Start Date
7	PAENDTERM	QALS	PAENDTERM		☐	QPRENDE	☐	End Date of the Inspection
8	CHARG	QALS	CHARG		☐	CHARG_D	☐	Batch Number
9	LAGORTVORG	QALS	LAGORTVORG		☐	QLGORTVORG	☐	Storage Location for Inspection Lot Stock
10	LOSMENGE	QALS	LOSMENGE		☐	QLOSMENGE	☐	Inspection Lot Quantity
11	LMENGEZUB	QALS	LMENGEZUB		☐	QLMENGEZUB	☐	Quantity That Must Be Posted
12	MENGENEINH	QALS	MENGENEINH		☐	QLOSMENGEH	☐	Base Unit of Measure for The Inspection Lot Quantity
13	SOBKZ	QALS	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
14	KNTTP	QALS	KNTTP		☐	KNTTP	☐	Account assignment category
15	KZVBR	QALS	KZVBR		☐	KZVBR	☐	Consumption posting
16	PSTYP	QALS	PSTYP		☐	PSTYP	☐	Item category in purchasing document
17	KDAUF	QALS	KDAUF		☐	MAT_KDAUF	☐	Sales order number of valuated sales order stock
18	KDPOS	QALS	KDPOS		☐	MAT_KDPOS	☐	Sales Order Item of Valuated Sales Order Stock
19	PS_PSP_PNR	QALS	PS_PSP_PNR		☐	MAT_PSPNR	☐	Valuated customer stock WBS element
20	STAT34	QALS	STAT34		☐	QSTAT34	☐	Stock Postings Completed
21	STAT35	QALS	STAT35		☐	QSTAT35	☐	Usage Decision Has Been Made
22	HERKUNFT	QALS	HERKUNFT		☐	QHERK	☐	Inspection Lot Origin
23	REVLV	QALS	REVLV		☐	REVLV	☐	Revision level

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in