SAP ABAP View V_QAPO (View of AFVC and AFVV for reading operation in PGQ database)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG01 (Package) QM quality inspection analysis

Basic Data

View Type	D	Database View
Database View	V_QAPO
Short Description	View of AFVC and AFVV for reading operation in PGQ database
Root table	AFVC	Operation within an order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFVC	AFVC
2	AFVV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFVC	MANDT	JL	EQ				0	0
2	AFVV	MANDT	JR	EQ			AND	0	0
3	AFVC	AUFPL	JL	EQ				0	0
4	AFVV	AUFPL	JR	EQ			AND	0	0
5	AFVC	APLZL	JL	EQ				0	0
6	AFVV	APLZL	JR	EQ			AND	0	0
7	AFVC	SUMNR		EQ	'00000000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDANT	AFVC	MANDT		☐	MANDT	☐	Client
2	AUFPL	AFVC	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
3	VORGLFNR	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
4	PLNTY	AFVC	PLNTY		☐	PLNTY	☐	Task List Type
5	PLNNR	AFVC	PLNNR		☐	PLNNR	☐	Key for Task List Group
6	PLNAL	AFVC	PLNAL		☐	PLNAL	☐	Group Counter
7	APLFL	AFVC	APLFL		☐	PLNFOLGE	☐	Sequence
8	PLNFL	AFVC	PLNFL		☐	PLNFOLGE	☐	Sequence
9	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
10	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
11	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
12	VORSTEUS	AFVC	STEUS		☐	STEUS	☐	Control key
13	VORKTXT	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
14	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
15	SPRACHE	AFVC	TXTSP		☐	SPRAS	☐	Language Key
16	ZAEHL	AFVC	ZAEHL		☐	CIM_COUNT	☐	Internal counter
17	VPLTY	AFVC	VPLTY		☐	VPLNTY	☐	Type of the referenced task list
18	VPLNR	AFVC	VPLNR		☐	VPLNNR	☐	Group of the referenced task list
19	VPLAL	AFVC	VPLAL		☐	VPLNAL	☐	Group counter of the referenced task list
20	VPLFL	AFVC	VPLFL		☐	VPLBFL	☐	Referenced sequence in routing
21	VPLNKN	AFVC	STDKN		☐	STDKN	☐	Node of operation within reference operation set
22	PPLNKN	AFVC	PLNKN		☐	PLNKN	☐	Number of the task list node
23	ERFSICHT	AFVC	ERFSICHT		☐	QERFSICHT	☐	Recording View
24	SUBSYS	AFVC	SUBSYS		☐	QEIFSUBSYS	☐	Subsystem Identifier for QM Subsystem Interface
25	RUECK	AFVC	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
26	RMZHL	AFVC	RMZHL		☐	CO_RMZHL	☐	Confirmation counter
27	LAR01	AFVC	LAR01		☐	LSTAR	☐	Activity Type
28	LAR02	AFVC	LAR02		☐	LSTAR	☐	Activity Type
29	LAR03	AFVC	LAR03		☐	LSTAR	☐	Activity Type
30	LAR04	AFVC	LAR04		☐	LSTAR	☐	Activity Type
31	LAR05	AFVC	LAR05		☐	LSTAR	☐	Activity Type
32	LAR06	AFVC	LAR06		☐	LSTAR	☐	Activity Type
33	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
34	LEK01	AFVC	LEK01		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
35	LEK02	AFVC	LEK02		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
36	LEK03	AFVC	LEK03		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
37	LEK04	AFVC	LEK04		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
38	LEK05	AFVC	LEK05		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
39	LEK06	AFVC	LEK06		☐	CO_LEIKZ	☐	Indicator: No remaining activity expected
40	MEINH	AFVV	MEINH		☐	VORME	☐	Unit of measure for activity
41	UMREN	AFVV	UMREN		☐	CP_UMREN	☐	Denominator for converting rtg and op units of measure
42	UMREZ	AFVV	UMREZ		☐	CP_UMREZ	☐	Numerator for converting task list and oper. un. of measure
43	BMSCH	AFVV	BMSCH		☐	BMSCH	☐	Base Quantity
44	VGE01	AFVV	VGE01		☐	VGWRTEH	☐	Unit of measure for the standard value
45	VGW01	AFVV	VGW01		☐	VGWRT	☐	Standard Value
46	VGE02	AFVV	VGE02		☐	VGWRTEH	☐	Unit of measure for the standard value
47	VGW02	AFVV	VGW02		☐	VGWRT	☐	Standard Value
48	VGE03	AFVV	VGE03		☐	VGWRTEH	☐	Unit of measure for the standard value
49	VGW03	AFVV	VGW03		☐	VGWRT	☐	Standard Value
50	VGE04	AFVV	VGE04		☐	VGWRTEH	☐	Unit of measure for the standard value
51	VGW04	AFVV	VGW04		☐	VGWRT	☐	Standard Value
52	VGE05	AFVV	VGE05		☐	VGWRTEH	☐	Unit of measure for the standard value
53	VGW05	AFVV	VGW05		☐	VGWRT	☐	Standard Value
54	VGE06	AFVV	VGE06		☐	VGWRTEH	☐	Unit of measure for the standard value
55	VGW06	AFVV	VGW06		☐	VGWRT	☐	Standard Value
56	MGVRG	AFVV	MGVRG		☐	MGVRG	☐	Operation Quantity
57	ASVRG	AFVV	ASVRG		☐	ASVRG	☐	Operation scrap
58	LMNGA	AFVV	LMNGA		☐	LMNGA	☐	Total Yield Confirmed
59	XMNGA	AFVV	XMNGA		☐	XMNGA	☐	Total scrap quantity confirmed
60	GMNGA	AFVV	GMNGA		☐	GMNGA	☐	Confirmed yield in order unit of measure
61	ISM01	AFVV	ISM01		☐	CO_RUMNG	☐	Previously confirmed activity
62	ISM02	AFVV	ISM02		☐	CO_RUMNG	☐	Previously confirmed activity
63	ISM03	AFVV	ISM03		☐	CO_RUMNG	☐	Previously confirmed activity
64	ISM04	AFVV	ISM04		☐	CO_RUMNG	☐	Previously confirmed activity
65	ISM05	AFVV	ISM05		☐	CO_RUMNG	☐	Previously confirmed activity
66	ISM06	AFVV	ISM06		☐	CO_RUMNG	☐	Previously confirmed activity
67	OFM01	AFVV	OFM01		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
68	OFM02	AFVV	OFM02		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
69	OFM03	AFVV	OFM03		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
70	OFM04	AFVV	OFM04		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
71	OFM05	AFVV	OFM05		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
72	OFM06	AFVV	OFM06		☐	CO_SCHAETZ	☐	Forecast value used to update the standard value
73	QKZPRZEIT	AFVC	QKZPRZEIT		☐	QKZPRZEIT	☐	Interval = Time (Time-Related)
74	QKZZTMG1	AFVC	QKZZTMG1		☐	QKZZTMG1	☐	Quantity Confirmation for Each Partial Lot
75	QKZPRMENG	AFVC	QKZPRMENG		☐	QKZPRMENG	☐	Creation Cycle = Quantity (Quantity-Reference)
76	QKZPRFREI	AFVC	QKZPRFREI		☐	QKZPRFREI	☐	Interval Without Reference to Time or Quantity
77	QKZTLSBEST	AFVC	QKZTLSBEST		☐	QKZTLSBEST	☐	Operation with Stock-Related Partial Lot Assignment
78	KZFEAT	AFVC	KZFEAT		☐	QKZFEAT	☐	Indicator Is Not Used Currently
79	QRASTZEHT	AFVV	QRASTZEHT		☐	QRASTZEHT	☐	Time Unit
80	QRASTZFAK	AFVV	QRASTZFAK		☐	QRASTZFAK	☐	Time Factor
81	QRASTMENG	AFVV	QRASTMENG		☐	QRASTMENG	☐	Quantity Between Two Inspections
82	QRASTEREH	AFVV	QRASTEREH		☐	QRASTEREH	☐	Grid Unit of Measure
83	QPPKTABS	AFVC	QPPKTABS		☐	QPPKTABS	☐	Flow Variants for Inspection Point Completion
84	PDEST	AFVC	PDEST		☐	CR_PDEST	☐	Printer for shop papers
85	KTSCH	AFVC	KTSCH		☐	KTSCH	☐	Standard text key

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