SAP ABAP View QMISU_12M1_01_A (Monitor the flag Inspection set up in the Material Master.)

Hierarchy

☛ GRCPIERP (Software Component) GRCPIERP
   ⤷ GRC-PCE (Application Component) Process Controls -Automated Controls
     ⤷ GRPCRTA_MAIN (Package) SAP GRC Process Control : Main Package

Basic Data

View Type	D	Database View
Database View	QMISU_12M1_01_A
Short Description	Monitor the flag Inspection set up in the Material Master.
Root table	MARC	Plant Data for Material

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARC	MARC
2	MARA
3	T134
4	T001W
5	T134T
6	MAKT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	MARC	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MARC	MATNR	JR	EQ			AND	0	0
5	T134	MANDT	JL	EQ				0	0
6	MARA	MANDT	JR	EQ			AND	0	0
7	T134	MTART	JL	EQ				0	0
8	MARA	MTART	JR	EQ			AND	0	0
9	T001W	MANDT	JL	EQ				0	0
10	MARC	MANDT	JR	EQ			AND	0	0
11	T001W	WERKS	JL	EQ				0	0
12	MARC	WERKS	JR	EQ			AND	0	0
13	T134	MANDT	JL	EQ				0	0
14	T134T	MANDT	JR	EQ			AND	0	0
15	T134	MTART	JL	EQ				0	0
16	T134T	MTART	JR	EQ			AND	0	0
17	MARA	MANDT	JL	EQ				0	0
18	MAKT	MANDT	JR	EQ			AND	0	0
19	MARA	MATNR	JL	EQ				0	0
20	MAKT	MATNR	JR	EQ			AND	0	0
21	T001W	SPRAS	JL	EQ				0	0
22	T134T	SPRAS	JR	EQ			AND	0	0
23	T001W	SPRAS	JL	EQ				0	0
24	MAKT	SPRAS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MARC	MANDT		☐	MANDT	☐	Client
2	MATNR	MARC	MATNR		☐	MATNR	☐	Material Number
3	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
4	QMATV	MARC	QMATV		☐	QMATV	☐	Inspection Setup Exists for Material/Plant
5	MTART	T134	MTART		☐	MTART	☐	Material type
6	NAME1	T001W	NAME1		☐	NAME1	☐	Name
7	SPRAS	T001W	SPRAS		☐	SPRAS	☐	Language Key
8	MTBEZ	T134T	MTBEZ		☐	MTBEZ	☐	Description of material type
9	MAKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
10	PRFRQ	MARC	PRFRQ		☐	PRFRQ	☐	Interval until next recurring inspection

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	20141106
SAP Release Created in	300_46C