SAP ABAP View VKKS0 (Selection of Orders for Variance and Scrap Calculation)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-PC-OBJ-PER (Application Component) Product Cost by Period
     ⤷ KKS (Package) Cost Object Controlling: Repetitive Manufacturing

Basic Data

View Type	D	Database View
Database View	VKKS0
Short Description	Selection of Orders for Variance and Scrap Calculation
Root table	AUFK	Order master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AUFK	AUFK
2	AFPO
3	AFKO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AUFK	MANDT	JL	EQ				0	0
2	AFPO	MANDT	JR	EQ			AND	0	0
3	AUFK	AUFNR	JL	EQ				0	0
4	AFPO	AUFNR	JR	EQ			AND	0	0
5	AUFK	MANDT	JL	EQ				0	0
6	AFKO	MANDT	JR	EQ			AND	0	0
7	AUFK	AUFNR	JL	EQ				0	0
8	AFKO	AUFNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AUFK	MANDT		☐	MANDT	☐	Client
2	AUFNR	AUFK	AUFNR		☐	AUFNR	☐	Order Number
3	POSNR	AFPO	POSNR		☐	CO_POSNR	☐	Order item number
4	OBJNR	AUFK	OBJNR		☐	J_OBJNR	☐	Object number
5	PKOSA	AUFK	PKOSA		☐	PKOSA_D	☐	Cost collector for production process PROCNR
6	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
7	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
8	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
9	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
10	ERDAT	AUFK	ERDAT		☐	AUFERFDAT	☐	Created on
11	BUKRS	AUFK	BUKRS		☐	BUKRS	☐	Company Code
12	WAERS	AUFK	WAERS		☐	AUFWAERS	☐	Order Currency
13	IDAT2	AUFK	IDAT2		☐	AUFIDAT2	☐	Technical completion date
14	LOEKZ	AUFK	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
15	AWSLS	AUFK	AWSLS		☐	AWSLS	☐	Variance Key
16	ABGSL	AUFK	ABGSL		☐	ABGR_SCHL	☐	Results Analysis Key
17	MLTPS	AUFK	FLG_MLTPS		☐	CO_MLTPS	☐	Order with multiple items
18	PROCNR	AUFK	PROCNR		☐	CKML_F_PROCNR	☐	Production Process
19	PROTY	AUFK	PROTY		☐	CKML_PROZESS_TYP	☐	Process Category (Procurement/Consumption)
20	GSBER	AUFK	GSBER		☐	GSBER	☐	Business Area
21	AUFPL	AFKO	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
22	PRNET	AFKO	PRODNET		☐	CO_PRODNET	☐	Indicator: Order is part of collective order
23	CPROC	AFKO	COLORDPROC		☐	CO_COLORDPRC	☐	Collective order with/without automatic goods movement
24	LAUFN	AFKO	LEAD_AUFNR		☐	CO_LAUFNR	☐	Leading order in current processing
25	PWERK	AFPO	PWERK		☐	CO_PWERK	☐	Planning plant for the order
26	PROJN	AFPO	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
27	KDAUF	AFPO	KDAUF		☐	CO_KDAUF	☐	Sales order number
28	KDPOS	AFPO	KDPOS		☐	CO_KDPOS	☐	Sales order item
29	KZBWS	AFPO	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
30	SOBKZ	AFPO	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
31	MATNR	AFPO	MATNR		☐	CO_MATNR	☐	Material Number for Order
32	LTRMI	AFPO	LTRMI		☐	CO_LTRMI	☐	Actual delivery/finish date
33	ELIKZ	AFPO	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
34	SAFNR	AFPO	SAFNR		☐	SA_AUFNR	☐	Run schedule header number
35	VERID	AFPO	VERID		☐	VERID	☐	Production Version
36	RTP01	AFPO	RTP01		☐	RTP01	☐	Cost collector for repetitive manufacturing
37	RTP02	AFPO	RTP02		☐	RTP02	☐	Cost collector for KANBAN
38	RTP03	AFPO	RTP03		☐	RTP03	☐	Cost collector for valuated sales order stock
39	OBJNP	AFPO	OBJNP		☐	J_OBJNR	☐	Object number
40	FXPRU	AFPO	FXPRU		☐	CK_FIXPRKU	☐	Fixed-Price Co-Product
41	MAUFNR	AFKO	MAUFNR		☐	MAUFNR	☐	Number of superior order
42	SPLSTAT	AFKO	SPLSTAT		☐	SPLIT_STAT	☐	Status of an order in a split hierarchy

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