SAP ABAP View VSCYAUKO ("Fields from AUFK/AFKO relevant for Capacity Planning")

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ CNVS (Package) R/3 Application development: Version Management

Basic Data

View Type	D	Database View
Database View	VSCYAUKO
Short Description	"Fields from AUFK/AFKO relevant for Capacity Planning"
Root table	VSAFKO_CN	Version: Order header data for PP orders

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VSAFKO_CN	VSAFKO_CN
2	VSAUFK_CN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VSAUFK_CN	MANDT	JL	EQ				0	0
2	VSAFKO_CN	MANDT	JR	EQ			AND	0	0
3	VSAUFK_CN	AUFNR	JL	EQ				0	0
4	VSAFKO_CN	AUFNR	JR	EQ			AND	0	0
5	VSAUFK_CN	VSNMR	JL	EQ				0	0
6	VSAFKO_CN	VSNMR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VSAFKO_CN	MANDT		☐	MANDT	☐	Client
2	VSNMR	VSAFKO_CN	VSNMR		☐	VSNMR	☐	Number or description of a version
3	AUFNR	VSAFKO_CN	AUFNR		☐	AUFNR	☐	Order Number
4	GLTRP	VSAFKO_CN	GLTRP		☐	CO_GLTRP	☐	Basic finish date
5	GSTRP	VSAFKO_CN	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date
6	FTRMS	VSAFKO_CN	FTRMS		☐	CO_FTRMS	☐	Scheduled release date
7	GLTRS	VSAFKO_CN	GLTRS		☐	CO_GLTRS	☐	Scheduled finish
8	GSTRS	VSAFKO_CN	GSTRS		☐	CO_GSTRS	☐	Scheduled start
9	GSTRI	VSAFKO_CN	GSTRI		☐	CO_GSTRI	☐	Actual start date
10	GETRI	VSAFKO_CN	GETRI		☐	CO_GETRI	☐	Confirmed Order Finish Date
11	GLTRI	VSAFKO_CN	GLTRI		☐	CO_GLTRI	☐	Actual finish date
12	FTRMI	VSAFKO_CN	FTRMI		☐	CO_FTRMI	☐	Actual release date
13	FTRMP	VSAFKO_CN	FTRMP		☐	CO_FTRMP	☐	Planned release date
14	PLNBEZ	VSAFKO_CN	PLNBEZ		☐	MATNR	☐	Material Number
15	GAMNG	VSAFKO_CN	GAMNG		☐	GAMNG	☐	Total order quantity
16	GMEIN	VSAFKO_CN	GMEIN		☐	MEINS	☐	Base Unit of Measure
17	PLNTY	VSAFKO_CN	PLNTY		☐	PLNTY	☐	Task List Type
18	PLNNR	VSAFKO_CN	PLNNR		☐	PLNNR	☐	Key for Task List Group
19	PLNAW	VSAFKO_CN	PLNAW		☐	PLNAW	☐	Application of the task list
20	PLNAL	VSAFKO_CN	PLNAL		☐	PLNAL	☐	Group Counter
21	PVERW	VSAFKO_CN	PVERW		☐	PLN_VERWE	☐	Task list usage
22	PLGRP	VSAFKO_CN	PLGRP		☐	VAGRP	☐	Responsible planner group/department
23	STLNR	VSAFKO_CN	STLNR		☐	STNUM	☐	Bill of Material
24	DISPO	VSAFKO_CN	DISPO		☐	CO_DISPO	☐	MRP controller for the order
25	AUFPL	VSAFKO_CN	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
26	FEVOR	VSAFKO_CN	FEVOR		☐	FEVOR	☐	Production Supervisor
27	BEDID	VSAFKO_CN	BEDID		☐	BEDID	☐	ID of the capacity requirements record
28	APRIO	VSAFKO_CN	APRIO		☐	CO_APRIO	☐	Order priority
29	CY_SEQNR	VSAFKO_CN	CY_SEQNR		☐	CY_SEQNR	☐	Seq. number order
30	AUART	VSAUFK_CN	AUART		☐	AUFART	☐	Order Type
31	AUTYP	VSAUFK_CN	AUTYP		☐	AUFTYP	☐	Order category
32	BUKRS	VSAUFK_CN	BUKRS		☐	BUKRS	☐	Company Code
33	WERKS	VSAUFK_CN	WERKS		☐	WERKS_D	☐	Plant
34	GSBER	VSAUFK_CN	GSBER		☐	GSBER	☐	Business Area
35	KOKRS	VSAUFK_CN	KOKRS		☐	KOKRS	☐	Controlling Area
36	CCKEY	VSAUFK_CN	CCKEY		☐	CCKEY	☐	Cost collector key
37	KOSTV	VSAUFK_CN	KOSTV		☐	AUFKOSTV	☐	Responsible cost center
38	PDAT1	VSAUFK_CN	PDAT1		☐	AUFPDAT1	☐	Planned release date
39	PDAT2	VSAUFK_CN	PDAT2		☐	AUFPDAT2	☐	Planned completion date
40	PDAT3	VSAUFK_CN	PDAT3		☐	AUFPDAT3	☐	Planned closing date
41	IDAT1	VSAUFK_CN	IDAT1		☐	AUFIDAT1	☐	Release date
42	IDAT2	VSAUFK_CN	IDAT2		☐	AUFIDAT2	☐	Technical completion date
43	IDAT3	VSAUFK_CN	IDAT3		☐	AUFIDAT3	☐	Close date
44	ABKRS	VSAUFK_CN	ABKRS		☐	AUFABKRS	☐	Processing group
45	KSTAR	VSAUFK_CN	KSTAR		☐	AUFKSTAR	☐	Settlement cost element
46	KOSTL	VSAUFK_CN	KOSTL		☐	AUFKOSTL	☐	Cost center for basic settlement
47	SAKNR	VSAUFK_CN	SAKNR		☐	AUFSAKNR	☐	G/L account for basic settlement
48	KTEXT	VSAUFK_CN	KTEXT		☐	AUFTEXT	☐	Description
49	OBJNR	VSAUFK_CN	OBJNR		☐	J_OBJNR	☐	Object number
50	PRONR	VSAFKO_CN	PRONR		☐	PS_PSP_PRO	☐	Project definition
51	PLSVB	VSAFKO_CN	PLSVB		☐	LOSGRBIS	☐	To lot size
52	PLSVN	VSAFKO_CN	PLSVN		☐	LOSGRVON	☐	From Lot Size
53	PLNME	VSAFKO_CN	PLNME		☐	PLNME	☐	Task list unit of measure
54	RATID	VSAFKO_CN	RATID		☐	BEDID	☐	ID of the capacity requirements record
55	GROID	VSAFKO_CN	GROID		☐	BEDID	☐	ID of the capacity requirements record
56	PSPEL	VSAUFK_CN	PSPEL		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
57	EXT_AUFNR	VSAUFK_CN	EXT_AUFNR		☐	AUFNR	☐	Order Number

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