SAP ABAP View CYAUPM (Selection of PM Orders for Capacity Planning)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	CYAUPM
Short Description	Selection of PM Orders 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
3	AFIH
4	ILOA

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			AND	0	0
5	AUFK	MANDT	JL	EQ				0	0
6	AFIH	MANDT	JR	EQ			AND	0	0
7	AUFK	AUFNR	JL	EQ				0	0
8	AFIH	AUFNR	JR	EQ			AND	0	0
9	ILOA	MANDT	JL	EQ				0	0
10	AFIH	MANDT	JR	EQ			AND	0	0
11	ILOA	ILOAN	JL	EQ				0	0
12	AFIH	ILOAN	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	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
23	AUFPL	AFKO	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
24	FEVOR	AFKO	FEVOR		☐	FEVOR	☐	Production Supervisor
25	BEDID	AFKO	BEDID		☐	BEDID	☐	ID of the capacity requirements record
26	APRIO	AFKO	APRIO		☐	CO_APRIO	☐	Order priority
27	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
28	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
29	BUKRS	AUFK	BUKRS		☐	BUKRS	☐	Company Code
30	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
31	GSBER	AUFK	GSBER		☐	GSBER	☐	Business Area
32	KOKRS	AUFK	KOKRS		☐	KOKRS	☐	Controlling Area
33	CCKEY	AUFK	CCKEY		☐	CCKEY	☐	Cost collector key
34	KOSTV	AUFK	KOSTV		☐	AUFKOSTV	☐	Responsible cost center
35	PDAT1	AUFK	PDAT1		☐	AUFPDAT1	☐	Planned release date
36	PDAT2	AUFK	PDAT2		☐	AUFPDAT2	☐	Planned completion date
37	PDAT3	AUFK	PDAT3		☐	AUFPDAT3	☐	Planned closing date
38	IDAT1	AUFK	IDAT1		☐	AUFIDAT1	☐	Release date
39	IDAT2	AUFK	IDAT2		☐	AUFIDAT2	☐	Technical completion date
40	IDAT3	AUFK	IDAT3		☐	AUFIDAT3	☐	Close date
41	ABKRS	AUFK	ABKRS		☐	AUFABKRS	☐	Processing group
42	KSTAR	AUFK	KSTAR		☐	AUFKSTAR	☐	Settlement cost element
43	KOSTL	AUFK	KOSTL		☐	AUFKOSTL	☐	Cost center for basic settlement
44	SAKNR	AUFK	SAKNR		☐	AUFSAKNR	☐	G/L account for basic settlement
45	KTEXT	AUFK	KTEXT		☐	AUFTEXT	☐	Description
46	OBJNR	AUFK	OBJNR		☐	J_OBJNR	☐	Object number
47	PRONR	AFKO	PRONR		☐	PS_PSP_PRO	☐	Project definition
48	PRIOK	AFIH	PRIOK		☐	PRIOK	☐	Priority
49	EQUNR	AFIH	EQUNR		☐	EQUNR	☐	Equipment Number
50	BAUTL	AFIH	BAUTL		☐	BAUTL	☐	Assembly
51	ILOAN	AFIH	ILOAN		☐	ILOAN	☐	Location and account assignment for technical object
52	ANLZU	AFIH	ANLZU		☐	ANLZU	☐	Syst.Condition
53	IWERK	AFIH	IWERK		☐	IWERK	☐	Maintenance Planning Plant
54	INGPR	AFIH	INGPR		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
55	APGRP	AFIH	APGRP		☐	VAGRP	☐	Responsible planner group/department
56	GEWRK	AFIH	GEWRK		☐	LGWID	☐	Object ID of the Work Center
57	WARPL	AFIH	WARPL		☐	WARPL	☐	Maintenance Plan
58	WAPOS	AFIH	WAPOS		☐	WAPOS	☐	Maintenance item
59	REVNR	AFIH	REVNR		☐	REVNI	☐	Revision of Plant Maintenance and Customer Service
60	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
61	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
62	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
63	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
64	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
65	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
66	PPSID	ILOA	PPSID		☐	PPSID	☐	Object ID of PP work center
67	IPHAS	AFIH	IPHAS		☐	PM_PHASE	☐	Maintenance Processing Phase
68	ILART	AFIH	ILART		☐	ILA	☐	Maintenance activity type
69	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
70	PSPEL	AUFK	PSPEL		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)

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