SAP ABAP Table CYAFVG (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CYAFVG	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CYAFVG	ARBEH	T006	MSEHI
2	CYAFVG	ARBID	CRID	OBJID
3	CYAFVG	BUKRS	T001	BUKRS
4	CYAFVG	DAUNE	T006	MSEHI
5	CYAFVG	EWDNE	T006	MSEHI
6	CYAFVG	LOGRP	T421	LOGRP
7	CYAFVG	MANDT	T000	MANDT
8	CYAFVG	MEINH	T006	MSEHI
9	CYAFVG	NPRIO	TCN07	NPRIO
10	CYAFVG	OBJNR	ONR00	OBJNR
11	CYAFVG	PLNTY	TCA01	PLNTY
12	CYAFVG	PROJN	PRPS	PSPNR
13	CYAFVG	QUALF	T423	QUALF
14	CYAFVG	RASCH	T428	RASCH
15	CYAFVG	RFGRP	T426	RFGRP
16	CYAFVG	RFSCH	T425	RFSCH
17	CYAFVG	SLWID	TCN00	SLWID
18	CYAFVG	USE04	T006	MSEHI
19	CYAFVG	USE05	T006	MSEHI
20	CYAFVG	USE06	TCURC	WAERS
21	CYAFVG	USE07	TCURC	WAERS
22	CYAFVG	VERTL	TC29	VERTL
23	CYAFVG	VNAME	T8JV	VNAME
24	CYAFVG	WERKS	T001W	WERKS
25	CYAFVG	ZEIER	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in