SAP ABAP Table CX_AFVG_V1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CX_AFVG_V1	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	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
2	STEUS	☐	STEUS	STEUS	CHAR	4	0	Control key	T430
3	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
4	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	ANZMA	☐	ANZMS	ANZMA	DEC	5	2	Number of employees
6	AUFAK	☐	AUSCHUFAK	AUSCHUFAK	DEC	5	3	Scrap factor
7	UEMUS	☐	UEMUSKZ	XFELD	CHAR	1	0	Required overlapping
8	UEKAN	☐	UEKANKZ	XFELD	CHAR	1	0	Optional overlapping
9	FLIES	☐	FLIESSKZ	XFELD	CHAR	1	0	Indicator: continuous flow production
10	SPMUS	☐	SPLITTUNG	XFELD	CHAR	1	0	Required splitting
11	SPLIM	☐	SPLITTANZ	SPLITTANZ	DEC	3	0	Maximum number of splits
12	ABLIPKZ	☐	ABLIPKZ	FLAG	CHAR	1	0	Indicator: simultaneous teardown and wait
13	RSTRA	☐	RSTRA	RSTRA	CHAR	2	0	Reduction strategy per operation/activity	T499Q
14	DDEHN	☐	DAUDEHN	X	CHAR	1	0	Indicator: flexible duration
15	ANZZL	☐	ANZKAP	INT1	INT1	3	0	Number of capacities required
16	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
17	SPANZ	☐	SPLITTERM	DEC3	DEC	3	0	Actual number of splits
18	LEK01	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
19	LEK02	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
20	LEK03	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
21	LEK04	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
22	LEK05	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
23	LEK06	☐	CO_LEIKZ	XFELD	CHAR	1	0	Indicator: No remaining activity expected
24	KALID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
25	FRSP	☐	FRSP	FRSP	CHAR	1	0	Earliest possible activity / Latest possible activity
26	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
27	UMREN	☐	CP_UMREN	UMBSN	DEC	5	0	Denominator for converting rtg and op units of measure
28	UMREZ	☐	CP_UMREZ	UMBSZ	DEC	5	0	Numerator for converting task list and oper. un. of measure
29	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
30	VGE01	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
31	VGW01	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
32	VGE02	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
33	VGW02	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
34	VGE03	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
35	VGW03	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
36	VGE04	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
37	VGW04	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
38	VGE05	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
39	VGW05	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
40	VGE06	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
41	VGW06	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
42	ZEIMU	☐	DZEIMU	MEINS	UNIT	3	0	Unit for the minimum overlap time	T006
43	ZMINU	☐	DZMINU	VGWRT	QUAN	9	3	Minimum overlap time
44	MINWE	☐	MINWEI	MINWEI	QUAN	13	3	Minimum Send-Ahead Quantity
45	ZEIMB	☐	DZEIMB	MEINS	UNIT	3	0	Unit for the minimum processing time	T006
46	ZMINB	☐	DZMINB	VGWRT	QUAN	9	3	Minimum processing time
47	ZEILP	☐	DZEILP	MEINS	UNIT	3	0	Unit for the required wait time	T006
48	ZLPRO	☐	DZLPRO	VGWRT	QUAN	9	3	Minimum wait time
49	ZEIWN	☐	DZEIWN	MEINS	UNIT	3	0	Unit for the standard queue time	T006
50	ZWNOR	☐	DZWNOR	VGWRT	QUAN	9	3	Standard queue time
51	ZEIWM	☐	DZEIWM	MEINS	UNIT	3	0	Unit for the minumum queue time	T006
52	ZWMIN	☐	DZWMIN	VGWRT	QUAN	9	3	Minimum queue time
53	ZEITN	☐	DZEITN	MEINS	UNIT	3	0	Unit for the standard move time	T006
54	ZTNOR	☐	DZTNOR	VGWRT	QUAN	9	3	Standard move time
55	ZEITM	☐	DZEITM	MEINS	UNIT	3	0	Unit for the minimum move time	T006
56	ZTMIN	☐	DZTMIN	VGWRT	QUAN	9	3	Minimum move time
57	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
58	MGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
59	ASVRG	☐	ASVRG	MENG13	QUAN	13	3	Operation scrap
60	LMNGA	☐	LMNGA	MENG13	QUAN	13	3	Total Yield Confirmed
61	XMNGA	☐	XMNGA	MENG13	QUAN	13	3	Total scrap quantity confirmed
62	RMNGA	☐	RMNGA	MENGV13	QUAN	13	3	Total confirmed rework quantity
63	ISM01	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
64	ISM02	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
65	ISM03	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
66	ISM04	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
67	ISM05	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
68	ISM06	☐	CO_RUMNG	MENGV13	QUAN	13	3	Previously confirmed activity
69	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
70	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
71	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
72	IERD	☐	IERD	DATUM	DATS	8	0	Actual finish: Setup (date)
73	IERZ	☐	IERZ	ATIME	TIMS	6	0	Actual finish: Setup (time)
74	ISBD	☐	ISBD	DATUM	DATS	8	0	Actual start: Processing (date)
75	ISBZ	☐	ISBZ	ATIME	TIMS	6	0	Actual start: Processing (time)
76	IEBD	☐	IEBD	DATUM	DATS	8	0	Actual finish: Processing (date)
77	IEBZ	☐	IEBZ	ATIME	TIMS	6	0	Actual processing finish (time)
78	ISAD	☐	ISAD	DATUM	DATS	8	0	Actual start: Teardown (date)
79	ISAZ	☐	ISAZ	ATIME	TIMS	6	0	Actual start: Teardown (time)
80	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
81	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
82	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
83	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
84	OFM01	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
85	OFM02	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
86	OFM03	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
87	OFM04	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
88	OFM05	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
89	OFM06	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
90	BZOFFB	☐	CP_OBZOFFB	CP_BZOFF	CHAR	2	0	Reference date for start of sub-operation	TCA54
91	EHOFFB	☐	CP_OEHOFFB	MEINS	UNIT	3	0	Unit for offset to start	T006
92	OFFSTB	☐	CP_OOFFSTB	VNZTV	QUAN	5	0	Offset to sub-operation start
93	OFFSTE	☐	CP_OOFFSTE	VNZTV	QUAN	5	0	Offset to sub-operation finish
94	BZOFFE	☐	CP_OBZOFFE	CP_BZOFF	CHAR	2	0	Reference date for finish of sub-operation	TCA54
95	EHOFFE	☐	CP_OEHOFFE	MEINS	UNIT	3	0	Unit for offset to finish	T006
96	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
97	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
98	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
99	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
100	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
101	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
102	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
103	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
104	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
105	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
106	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
107	RSTUF	☐	RSTUF	REDST	NUMC	1	0	Reduction level which reduces operation lead time
108	ZLMAX	☐	DZLMAX	VGWRT	QUAN	9	3	Maximum wait time
109	ZEILM	☐	DZEILM	MEINS	UNIT	3	0	Unit for the maximum wait time	T006
110	ZMERH	☐	DZMERH	VGWRT	QUAN	9	3	Break
111	ZEIER	☐	DZEIER	MEINS	UNIT	3	0	Unit for the break time	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CX_AFVG_V1	ARBID	CRID	OBJID
2	CX_AFVG_V1	BZOFFB	TCA54	BZOFF
3	CX_AFVG_V1	BZOFFE	TCA54	BZOFF
4	CX_AFVG_V1	EHOFFB	T006	MSEHI
5	CX_AFVG_V1	EHOFFE	T006	MSEHI
6	CX_AFVG_V1	KALID	TFACD	IDENT
7	CX_AFVG_V1	MEINH	T006	MSEHI
8	CX_AFVG_V1	OBJNR	ONR00	OBJNR
9	CX_AFVG_V1	RSTRA	T499Q	RSTRA
10	CX_AFVG_V1	SLWID	TCN00	SLWID
11	CX_AFVG_V1	STEUS	T430	STEUS
12	CX_AFVG_V1	USE04	T006	MSEHI
13	CX_AFVG_V1	USE05	T006	MSEHI
14	CX_AFVG_V1	VGE01	T006	MSEHI
15	CX_AFVG_V1	VGE02	T006	MSEHI
16	CX_AFVG_V1	VGE03	T006	MSEHI
17	CX_AFVG_V1	VGE04	T006	MSEHI
18	CX_AFVG_V1	VGE05	T006	MSEHI
19	CX_AFVG_V1	VGE06	T006	MSEHI
20	CX_AFVG_V1	WERKS	T001W	WERKS
21	CX_AFVG_V1	ZEIER	T006	MSEHI
22	CX_AFVG_V1	ZEILM	T006	MSEHI
23	CX_AFVG_V1	ZEILP	T006	MSEHI
24	CX_AFVG_V1	ZEIMB	T006	MSEHI
25	CX_AFVG_V1	ZEIMU	T006	MSEHI
26	CX_AFVG_V1	ZEITM	T006	MSEHI
27	CX_AFVG_V1	ZEITN	T006	MSEHI
28	CX_AFVG_V1	ZEIWM	T006	MSEHI
29	CX_AFVG_V1	ZEIWN	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in