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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CY (Package) R/3 Application development: Capacity Planning

Basic Data

View Type	D	Database View
Database View	CYAUKO
Short Description	"Fields from AUFK/AFKO relevant for Capacity Planning"
Root table	AFKO	Order Header Data PP Orders

Table

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

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	AFKO	MANDT	JR	EQ			AND	0	0
3	AUFK	AUFNR	JL	EQ				0	0
4	AFKO	AUFNR	JR	EQ				0	0

View Fields

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

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