SAP ABAP View CYAFVG (View for Capacity Planning: "Order Operatns/netw.activities")

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	CYAFVG
Short Description	View for Capacity Planning: "Order Operatns/netw.activities"
Root table	AFVC	Operation within an order

Table

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

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	AFVU	MANDT	JL	EQ				0	0
8	AFVV	MANDT	JR	EQ			AND	0	0
9	AFVU	AUFPL	JL	EQ				0	0
10	AFVV	AUFPL	JR	EQ			AND	0	0
11	AFVU	APLZL	JL	EQ				0	0
12	AFVV	APLZL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFVC	MANDT		☐	MANDT	☐	Client
2	AUFPL	AFVC	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
3	APLZL	AFVC	APLZL		☐	CO_APLZL	☐	General counter for order
4	PLNAL	AFVC	PLNAL		☐	PLNAL	☐	Group Counter
5	PLNFL	AFVC	PLNFL		☐	PLNFOLGE	☐	Sequence
6	PLNTY	AFVC	PLNTY		☐	PLNTY	☐	Task List Type
7	PLNNR	AFVC	PLNNR		☐	PLNNR	☐	Key for Task List Group
8	PLNKN	AFVC	PLNKN		☐	PLNKN	☐	Number of the task list node
9	VORNR	AFVC	VORNR		☐	VORNR	☐	Operation/Activity Number
10	ARBID	AFVC	ARBID		☐	CR_OBJID	☐	Object ID of the resource
11	WERKS	AFVC	WERKS		☐	WERKS_D	☐	Plant
12	LTXA1	AFVC	LTXA1		☐	LTXA1	☐	Operation short text
13	LOART	AFVC	LOART		☐	LOHNART	☐	Wage type
14	QUALF	AFVC	QUALF		☐	QUALF	☐	Suitability
15	LOGRP	AFVC	LOGRP		☐	LOHNGRP	☐	Wage group
16	BUKRS	AFVC	BUKRS		☐	BUKRS	☐	Company Code
17	RUECK	AFVC	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
18	OBJNR	AFVC	OBJNR		☐	J_OBJNR	☐	Object number
19	PROJN	AFVC	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
20	BEDID	AFVC	BEDID		☐	BEDID	☐	ID of the capacity requirements record
21	BEDZL	AFVC	BEDZL		☐	CIM_COUNT	☐	Internal counter
22	SUMNR	AFVC	SUMNR		☐	SUMKNTNR	☐	Node number of the superior operation
23	CY_SEQNRV	AFVC	CY_SEQNRV		☐	CY_SEQNRV	☐	Sequence number operation
24	ZMERH	AFVV	ZMERH		☐	DZMERH	☐	Break
25	ZEIER	AFVV	ZEIER		☐	DZEIER	☐	Unit for the break time
26	FSAVD	AFVV	FSAVD		☐	FSAVD	☐	Earliest scheduled start: Execution (date)
27	FSAVZ	AFVV	FSAVZ		☐	FSAVZ	☐	Earliest scheduled start: Execution (time)
28	FSSBD	AFVV	FSSBD		☐	FSSBD	☐	Earliest scheduled start: Processing (date)
29	FSSBZ	AFVV	FSSBZ		☐	FSSBZ	☐	Earliest scheduled start: Processing (time)
30	FSSAD	AFVV	FSSAD		☐	FSSAD	☐	Earliest scheduled start: Teardown (date)
31	FSSAZ	AFVV	FSSAZ		☐	FSSAZ	☐	Earliest scheduled start: Teardown (time)
32	FSEDD	AFVV	FSEDD		☐	FSEDD	☐	Earliest scheduled finish: Execution (date)
33	FSEDZ	AFVV	FSEDZ		☐	FSEDZ	☐	Earliest scheduled finish: Execution (time)
34	FSSLD	AFVV	FSSLD		☐	FSSLD	☐	Earliest scheduled start: Wait (date)
35	FSSLZ	AFVV	FSSLZ		☐	FSSLZ	☐	Earliest scheduled start: Wait (time)
36	FSELD	AFVV	FSELD		☐	FSELD	☐	Earliest scheduled finish: Wait (date)
37	FSELZ	AFVV	FSELZ		☐	FSELZ	☐	Earliest scheduled finish: Wait (time)
38	SSAVD	AFVV	SSAVD		☐	SSAVD	☐	Latest scheduled start: Execution (date)
39	SSAVZ	AFVV	SSAVZ		☐	SSAVZ	☐	Latest scheduled start: Execution (time)
40	SSSBD	AFVV	SSSBD		☐	SSSBD	☐	Latest scheduled start: Processing (date)
41	SSSBZ	AFVV	SSSBZ		☐	SSSBZ	☐	Latest scheduled start: Processing (time)
42	SSSAD	AFVV	SSSAD		☐	SSSAD	☐	Latest scheduled start: Teardown (date)
43	SSSAZ	AFVV	SSSAZ		☐	SSSAZ	☐	Latest scheduled start: Teardown (time)
44	SSEDD	AFVV	SSEDD		☐	SSEDD	☐	Latest scheduled finish: Execution (date)
45	SSEDZ	AFVV	SSEDZ		☐	SSEDZ	☐	Latest scheduled finish: Execution (time)
46	SSSLD	AFVV	SSSLD		☐	SSSLD	☐	Latest scheduled start: Wait time (date)
47	SSSLZ	AFVV	SSSLZ		☐	SSSLZ	☐	Latest scheduled start: Wait time
48	SSELD	AFVV	SSELD		☐	SSELD	☐	Latest scheduled finish: Wait time (date)
49	SSELZ	AFVV	SSELZ		☐	SSELZ	☐	Latest scheduled finish: Wait time
50	ISAVD	AFVV	ISAVD		☐	ISAVD	☐	Actual operation start (date)
51	IEAVD	AFVV	IEAVD		☐	IEAVD	☐	Actual finish of operation (date)
52	ISDD	AFVV	ISDD		☐	ISDD	☐	Actual start: Execution (date)
53	ISDZ	AFVV	ISDZ		☐	ISDZ	☐	Actual start: Execution/setup (time)
54	IERD	AFVV	IERD		☐	IERD	☐	Actual finish: Setup (date)
55	IERZ	AFVV	IERZ		☐	IERZ	☐	Actual finish: Setup (time)
56	ISBD	AFVV	ISBD		☐	ISBD	☐	Actual start: Processing (date)
57	ISBZ	AFVV	ISBZ		☐	ISBZ	☐	Actual start: Processing (time)
58	IEBD	AFVV	IEBD		☐	IEBD	☐	Actual finish: Processing (date)
59	IEBZ	AFVV	IEBZ		☐	IEBZ	☐	Actual processing finish (time)
60	ISAD	AFVV	ISAD		☐	ISAD	☐	Actual start: Teardown (date)
61	ISAZ	AFVV	ISAZ		☐	ISAZ	☐	Actual start: Teardown (time)
62	IEDD	AFVV	IEDD		☐	IEDD	☐	Actual finish: Execution (date)
63	IEDZ	AFVV	IEDZ		☐	IEDZ	☐	Actual finish: Execution (time)
64	WARTZ	AFVV	WARTZ		☐	WARTEZEIT	☐	Queue time used for scheduling
65	WRTZE	AFVV	WRTZE		☐	WTRZE	☐	Unit of measure for queue time
66	RUEST	AFVV	RUEST		☐	RUEST	☐	Setup time
67	RSTZE	AFVV	RSTZE		☐	RSTZE	☐	Unit of measure for setup time
68	BEARZ	AFVV	BEARZ		☐	BEARZEIT	☐	Processing time
69	BEAZE	AFVV	BEAZE		☐	BEAZE	☐	Unit of measure for processing time
70	ABRUE	AFVV	ABRUE		☐	ABRUE	☐	Teardown
71	ARUZE	AFVV	ARUZE		☐	ARUZE	☐	Unit of measure for teardown
72	LIEGZ	AFVV	LIEGZ		☐	LIEGEZEIT	☐	Wait time used for scheduling
73	LIGZE	AFVV	LIGZE		☐	LIGZE	☐	Unit of measure for wait time
74	TRANZ	AFVV	TRANZ		☐	TRANSZEIT	☐	Move time used for scheduling
75	TRAZE	AFVV	TRAZE		☐	TRAZE	☐	Unit of measure for move time
76	VERTL	AFVC	VERTL		☐	CR_VERTN	☐	Distr.cap.reqmts (plant maint.,process order, network)
77	PHFLG	AFVC	PHFLG		☐	PHFLG	☐	Indicator: Phase
78	RFGRP	AFVC	RFGRP		☐	RUEFAGRP	☐	Setup group category
79	RFSCH	AFVC	RFSCH		☐	RUEFASCHLU	☐	Setup group key
80	RASCH	AFVC	RASCH		☐	RUEARSCHLU	☐	Setup Type Key
81	MGVRG	AFVV	MGVRG		☐	MGVRG	☐	Operation Quantity
82	MEINH	AFVV	MEINH		☐	VORME	☐	Unit of measure for activity
83	ARBEI	AFVV	ARBEI		☐	ARBEIT	☐	Work involved in the activity
84	ARBEH	AFVV	ARBEH		☐	ARBEITE	☐	Unit for work
85	DAUNO	AFVV	DAUNO		☐	DAUNOR	☐	Normal duration of the activity
86	DAUNE	AFVV	DAUNE		☐	DAUNORE	☐	Normal duration/unit
87	EWDAN	AFVV	EWDAN		☐	EWDAN	☐	Normal duration (from forecast) of activity
88	EWDNE	AFVV	EWDNE		☐	EWDNE	☐	Unit for forecast normal duration
89	OFMNW	AFVV	OFMNW		☐	OFMNW	☐	Forecasted work (actual + remaining)
90	ASVRG	AFVV	ASVRG		☐	ASVRG	☐	Operation scrap
91	NPRIO	AFVC	NPRIO		☐	NW_PRIO	☐	Priority
92	LMNGA	AFVV	LMNGA		☐	LMNGA	☐	Total Yield Confirmed
93	ISMNW	AFVV	ISMNW		☐	CO_ISMNW	☐	Actual work
94	SLWID	AFVU	SLWID		☐	SLWID	☐	Key word ID for user-defined fields
95	USR00	AFVU	USR00		☐	USRCHAR20	☐	User field with 20 characters
96	USR01	AFVU	USR01		☐	USRCHAR20	☐	User field with 20 characters
97	USR02	AFVU	USR02		☐	USRCHAR10	☐	User field with 10 characters
98	USR03	AFVU	USR03		☐	USRCHAR10	☐	User field with 10 characters
99	USR04	AFVU	USR04		☐	USRQUAN13	☐	User field for quantity (length 10.3)
100	USE04	AFVU	USE04		☐	USRUNIT	☐	User field: Unit for quantity fields
101	USR05	AFVU	USR05		☐	USRQUAN13	☐	User field for quantity (length 10.3)
102	USE05	AFVU	USE05		☐	USRUNIT	☐	User field: Unit for quantity fields
103	USR06	AFVU	USR06		☐	USRCURR13	☐	User-defined field for values (length 10,3)
104	USE06	AFVU	USE06		☐	USRCUKY	☐	User field: Unit for value fields
105	USR07	AFVU	USR07		☐	USRCURR13	☐	User-defined field for values (length 10,3)
106	USE07	AFVU	USE07		☐	USRCUKY	☐	User field: Unit for value fields
107	USR08	AFVU	USR08		☐	USRDATE	☐	User field for date
108	USR09	AFVU	USR09		☐	USRDATE	☐	User field for date
109	USR10	AFVU	USR10		☐	USRFLAG	☐	User-defined field: Indicator for reports
110	USR11	AFVU	USR11		☐	USRFLAG	☐	User-defined field: Indicator for reports
111	VNAME	AFVU	VNAME		☐	JV_NAME	☐	Joint venture
112	PERNR	AFVC	PERNR		☐	CO_PERNR	☐	Personnel 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