SAP ABAP Table AFVVI (Include structure of the operation quantities/dates/values)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

Table Category	INTTAB	Structure
Structure	AFVVI	Table Relationship Diagram
Short Description	Include structure of the operation quantities/dates/values

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	MEINH	☐	VORME	MEINS	UNIT	3	0	Unit of measure for activity	T006
2	UMREN	☐	CP_UMREN	UMBSN	DEC	5	0	Denominator for converting rtg and op units of measure
3	UMREZ	☐	CP_UMREZ	UMBSZ	DEC	5	0	Numerator for converting task list and oper. un. of measure
4	BMSCH	☐	BMSCH	BMSCH	QUAN	13	3	Base Quantity
5	ZMERH	☐	DZMERH	VGWRT	QUAN	9	3	Break
6	ZEIER	☐	DZEIER	MEINS	UNIT	3	0	Unit for the break time	T006
7	VGE01	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
8	VGW01	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
9	VGE02	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
10	VGW02	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
11	VGE03	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
12	VGW03	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
13	VGE04	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
14	VGW04	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
15	VGE05	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
16	VGW05	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
17	VGE06	☐	VGWRTEH	MEINS	UNIT	3	0	Unit of measure for the standard value	T006
18	VGW06	☐	VGWRT	VGWRT	QUAN	9	3	Standard Value
19	ZEIMU	☐	DZEIMU	MEINS	UNIT	3	0	Unit for the minimum overlap time	T006
20	ZMINU	☐	DZMINU	VGWRT	QUAN	9	3	Minimum overlap time
21	MINWE	☐	MINWEI	MINWEI	QUAN	13	3	Minimum Send-Ahead Quantity
22	ZEIMB	☐	DZEIMB	MEINS	UNIT	3	0	Unit for the minimum processing time	T006
23	ZMINB	☐	DZMINB	VGWRT	QUAN	9	3	Minimum processing time
24	ZEILM	☐	DZEILM	MEINS	UNIT	3	0	Unit for the maximum wait time	T006
25	ZLMAX	☐	DZLMAX	VGWRT	QUAN	9	3	Maximum wait time
26	ZEILP	☐	DZEILP	MEINS	UNIT	3	0	Unit for the required wait time	T006
27	ZLPRO	☐	DZLPRO	VGWRT	QUAN	9	3	Minimum wait time
28	ZEIWN	☐	DZEIWN	MEINS	UNIT	3	0	Unit for the standard queue time	T006
29	ZWNOR	☐	DZWNOR	VGWRT	QUAN	9	3	Standard queue time
30	ZEIWM	☐	DZEIWM	MEINS	UNIT	3	0	Unit for the minumum queue time	T006
31	ZWMIN	☐	DZWMIN	VGWRT	QUAN	9	3	Minimum queue time
32	ZEITN	☐	DZEITN	MEINS	UNIT	3	0	Unit for the standard move time	T006
33	ZTNOR	☐	DZTNOR	VGWRT	QUAN	9	3	Standard move time
34	ZEITM	☐	DZEITM	MEINS	UNIT	3	0	Unit for the minimum move time	T006
35	ZTMIN	☐	DZTMIN	VGWRT	QUAN	9	3	Minimum move time
36	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
37	DAUNO	☐	DAUNOR	DAUER_4_1	QUAN	5	1	Normal duration of the activity
38	DAUNE	☐	DAUNORE	MEINS	UNIT	3	0	Normal duration/unit	T006
39	DAUMI	☐	DAUMIN	DAUER_4_1	QUAN	5	1	Minimum activity duration
40	DAUME	☐	DAUMINE	MEINS	UNIT	3	0	Unit for the minimum duration	T006
41	EINSA	☐	EINSCHRA	RESTRIKSTR	CHAR	1	0	Constraint on the basic start date for the activity
42	EINSE	☐	EINSCHRE	RESTRIKEND	CHAR	1	0	Constraint on the finish date of the activity
43	ARBEI	☐	ARBEIT	ARBEIT	QUAN	7	1	Work involved in the activity
44	ARBEH	☐	ARBEITE	MEINS	UNIT	3	0	Unit for work	T006
45	MGVRG	☐	MGVRG	MENG13	QUAN	13	3	Operation Quantity
46	ASVRG	☐	ASVRG	MENG13	QUAN	13	3	Operation scrap
47	LMNGA	☐	LMNGA	MENG13	QUAN	13	3	Total Yield Confirmed
48	XMNGA	☐	XMNGA	MENG13	QUAN	13	3	Total scrap quantity confirmed
49	GMNGA	☐	GMNGA	MENG13	QUAN	13	3	Confirmed yield in order unit of measure
50	ISM01	☐	CO_RUMNG	MENG13	QUAN	13	3	Previously confirmed activity
51	ISM02	☐	CO_RUMNG	MENG13	QUAN	13	3	Previously confirmed activity
52	ISM03	☐	CO_RUMNG	MENG13	QUAN	13	3	Previously confirmed activity
53	ISM04	☐	CO_RUMNG	MENG13	QUAN	13	3	Previously confirmed activity
54	ISM05	☐	CO_RUMNG	MENG13	QUAN	13	3	Previously confirmed activity
55	ISM06	☐	CO_RUMNG	MENG13	QUAN	13	3	Previously confirmed activity
56	ISMNW	☐	CO_ISMNW	MENG13	QUAN	13	3	Actual work
57	FSAVD	☐	FSAVD	DATUM	DATS	8	0	Earliest scheduled start: Execution (date)
58	FSAVZ	☐	FSAVZ	ATIME	TIMS	6	0	Earliest scheduled start: Execution (time)
59	FSSBD	☐	FSSBD	DATUM	DATS	8	0	Earliest scheduled start: Processing (date)
60	FSSBZ	☐	FSSBZ	ATIME	TIMS	6	0	Earliest scheduled start: Processing (time)
61	FSSAD	☐	FSSAD	DATUM	DATS	8	0	Earliest scheduled start: Teardown (date)
62	FSSAZ	☐	FSSAZ	ATIME	TIMS	6	0	Earliest scheduled start: Teardown (time)
63	FSEDD	☐	FSEDD	DATUM	DATS	8	0	Earliest scheduled finish: Execution (date)
64	FSEDZ	☐	FSEDZ	ATIME	TIMS	6	0	Earliest scheduled finish: Execution (time)
65	FSSLD	☐	FSSLD	DATUM	DATS	8	0	Earliest scheduled start: Wait (date)
66	FSSLZ	☐	FSSLZ	ATIME	TIMS	6	0	Earliest scheduled start: Wait (time)
67	FSELD	☐	FSELD	DATUM	DATS	8	0	Earliest scheduled finish: Wait (date)
68	FSELZ	☐	FSELZ	ATIME	TIMS	6	0	Earliest scheduled finish: Wait (time)
69	SSAVD	☐	SSAVD	DATUM	DATS	8	0	Latest scheduled start: Execution (date)
70	SSAVZ	☐	SSAVZ	ATIME	TIMS	6	0	Latest scheduled start: Execution (time)
71	SSSBD	☐	SSSBD	DATUM	DATS	8	0	Latest scheduled start: Processing (date)
72	SSSBZ	☐	SSSBZ	ATIME	TIMS	6	0	Latest scheduled start: Processing (time)
73	SSSAD	☐	SSSAD	DATUM	DATS	8	0	Latest scheduled start: Teardown (date)
74	SSSAZ	☐	SSSAZ	ATIME	TIMS	6	0	Latest scheduled start: Teardown (time)
75	SSEDD	☐	SSEDD	DATUM	DATS	8	0	Latest scheduled finish: Execution (date)
76	SSEDZ	☐	SSEDZ	ATIME	TIMS	6	0	Latest scheduled finish: Execution (time)
77	SSSLD	☐	SSSLD	DATUM	DATS	8	0	Latest scheduled start: Wait time (date)
78	SSSLZ	☐	SSSLZ	ATIME	TIMS	6	0	Latest scheduled start: Wait time
79	SSELD	☐	SSELD	DATUM	DATS	8	0	Latest scheduled finish: Wait time (date)
80	SSELZ	☐	SSELZ	ATIME	TIMS	6	0	Latest scheduled finish: Wait time
81	ISAVD	☐	ISAVD	DATUM	DATS	8	0	Actual operation start (date)
82	IEAVD	☐	IEAVD	DATUM	DATS	8	0	Actual finish of operation (date)
83	ISDD	☐	ISDD	DATUM	DATS	8	0	Actual start: Execution (date)
84	ISDZ	☐	ISDZ	ATIME	TIMS	6	0	Actual start: Execution/setup (time)
85	IERD	☐	IERD	DATUM	DATS	8	0	Actual finish: Setup (date)
86	IERZ	☐	IERZ	ATIME	TIMS	6	0	Actual finish: Setup (time)
87	ISBD	☐	ISBD	DATUM	DATS	8	0	Actual start: Processing (date)
88	ISBZ	☐	ISBZ	ATIME	TIMS	6	0	Actual start: Processing (time)
89	IEBD	☐	IEBD	DATUM	DATS	8	0	Actual finish: Processing (date)
90	IEBZ	☐	IEBZ	ATIME	TIMS	6	0	Actual processing finish (time)
91	ISAD	☐	ISAD	DATUM	DATS	8	0	Actual start: Teardown (date)
92	ISAZ	☐	ISAZ	ATIME	TIMS	6	0	Actual start: Teardown (time)
93	IEDD	☐	IEDD	DATUM	DATS	8	0	Actual finish: Execution (date)
94	IEDZ	☐	IEDZ	ATIME	TIMS	6	0	Actual finish: Execution (time)
95	PEDD	☐	CO_PEDD	DATUM	DATS	8	0	Forecast finish date of operation from confirmation
96	PEDZ	☐	CO_PEDZ	ATIME	TIMS	6	0	Forecast finish time of operation from confirmation
97	PUFFR	☐	PUFFR_FREI	PUFFER	DEC	3	0	Free float
98	PUFGS	☐	PUFFR_GESM	PUFFER	DEC	3	0	Total float
99	NTANF	☐	VORGABESTD	VORGABESTR	DATS	8	0	Constraint for activity start (Basic)
100	NTANZ	☐	VORGABESTZ	ATIME	TIMS	6	0	Constraint for activity start time (Basic)
101	NTEND	☐	VORGABEEND	VORGABEEND	DATS	8	0	Constraint for finish of activity (Basic)
102	NTENZ	☐	VORGABEENZ	ATIME	TIMS	6	0	Basic finish time of the activity
103	EWSTD	☐	EWSTARTD	DATUM	DATS	8	0	Forecasted start date for the activity
104	EWSTZ	☐	EWSTARTZ	ATIME	TIMS	6	0	Forecast start time of the activity
105	EWEND	☐	EWENDED	DATUM	DATS	8	0	Forecast finish date
106	EWENZ	☐	EWENDEZ	ATIME	TIMS	6	0	Forecast finish time for the activity
107	EWDAN	☐	EWDAN	DAUER_4_1	QUAN	5	1	Normal duration (from forecast) of activity
108	EWDNE	☐	EWDNE	MEINS	UNIT	3	0	Unit for forecast normal duration	T006
109	EWDAM	☐	EWDAM	DAUER_4_1	QUAN	5	1	Minimum duration (from forecast) for activity
110	EWDME	☐	EWDME	MEINS	UNIT	3	0	Unit for forecast minimum duration	T006
111	EWSTE	☐	PS_RESTE	RESTRIKEND	CHAR	1	0	Forecast date constraint on activity finish
112	EWSTA	☐	PS_RESTA	RESTRIKSTR	CHAR	1	0	Forecast date constraint on activity start
113	WARTZ	☐	WARTEZEIT	CX_ZEIT	FLTP	16	16	Queue time used for scheduling
114	WRTZE	☐	WTRZE	EINHEIT	UNIT	3	0	Unit of measure for queue time
115	RUEST	☐	RUEST	CX_ZEIT	FLTP	16	16	Setup time
116	RSTZE	☐	RSTZE	EINHEIT	UNIT	3	0	Unit of measure for setup time
117	BEARZ	☐	BEARZEIT	CX_ZEIT	FLTP	16	16	Processing time
118	BEAZE	☐	BEAZE	EINHEIT	UNIT	3	0	Unit of measure for processing time
119	ABRUE	☐	ABRUE	CX_ZEIT	FLTP	16	16	Teardown
120	ARUZE	☐	ARUZE	EINHEIT	UNIT	3	0	Unit of measure for teardown
121	LIEGZ	☐	LIEGEZEIT	CX_ZEIT	FLTP	16	16	Wait time used for scheduling
122	LIGZE	☐	LIGZE	EINHEIT	UNIT	3	0	Unit of measure for wait time
123	TRANZ	☐	TRANSZEIT	CX_ZEIT	FLTP	16	16	Move time used for scheduling
124	TRAZE	☐	TRAZE	EINHEIT	UNIT	3	0	Unit of measure for move time
125	ISERH	☐	ISERH	VGWRT	QUAN	9	3	Confirmed break time
126	OFM01	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
127	OFM02	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
128	OFM03	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
129	OFM04	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
130	OFM05	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
131	OFM06	☐	CO_SCHAETZ	VGWRT	QUAN	9	3	Forecast value used to update the standard value
132	OFMNW	☐	OFMNW	ARBEIT	QUAN	7	1	Forecasted work (actual + remaining)
133	BZOFFB	☐	CP_OBZOFFB	CP_BZOFF	CHAR	2	0	Reference date for start of sub-operation	*
134	EHOFFB	☐	CP_OEHOFFB	MEINS	UNIT	3	0	Unit for offset to start	T006
135	OFFSTB	☐	CP_OOFFSTB	VNZTV	QUAN	5	0	Offset to sub-operation start
136	OFFSTE	☐	CP_OOFFSTE	VNZTV	QUAN	5	0	Offset to sub-operation finish
137	BZOFFE	☐	CP_OBZOFFE	CP_BZOFF	CHAR	2	0	Reference date for finish of sub-operation	*
138	EHOFFE	☐	CP_OEHOFFE	MEINS	UNIT	3	0	Unit for offset to finish	T006
139	FPAVD	☐	FPAVD	DATUM	DATS	8	0	Earliest scheduled start date (forecast)
140	FPAVZ	☐	FPAVZ	ATIME	TIMS	6	0	Earliest scheduled start time (forecast)
141	FPEDD	☐	FPEDD	DATUM	DATS	8	0	Earliest scheduled finish date (forecast)
142	FPEDZ	☐	FPEDZ	ATIME	TIMS	6	0	Earliest scheduled finish time (forecast)
143	SPAVD	☐	SPAVD	DATUM	DATS	8	0	Latest scheduled start date (forecast)
144	SPAVZ	☐	SPAVZ	ATIME	TIMS	6	0	Latest scheduled start time (forecast)
145	SPEDD	☐	SPEDD	DATUM	DATS	8	0	Latest scheduled finish date (forecast)
146	SPEDZ	☐	SPEDZ	ATIME	TIMS	6	0	Latest scheduled finish time (forecast)
147	BEAZP	☐	BEAZEP	EINHEIT	UNIT	3	0	Unit of processing time (Forecast)
148	PUFGP	☐	PPUFF_GESM	PUFFER	DEC	3	0	Total float (from forecast)
149	PUFFP	☐	PPUFF_FREI	PUFFER	DEC	3	0	Free float (from forecast)
150	BEARP	☐	PBEARZEIT	CX_ZEIT	FLTP	16	16	Processing time (forecast)
151	EPANF	☐	EPANF	DATUM	DATS	8	0	Dispatched start date for operation
152	EPANZ	☐	EPANZ	ATIME	TIMS	6	0	Dispatched start time for operation
153	EPEND	☐	EPEND	DATUM	DATS	8	0	Dispatched finish date
154	EPENZ	☐	EPENZ	ATIME	TIMS	6	0	Dispatched finish time
155	PDAU	☐	PDAU	DAUER_4_1	QUAN	5	1	Forecasted duration of activity from confirmation
156	PDAE	☐	PDAE	MEINS	UNIT	3	0	Unit of the forecasted duration from the confirmation	T006
157	KNOTE	☐	KNOTE	KNOTN	CHAR	10	0	Transportation Connection Points	*
158	VSTZW	☐	VSTZW	VSTZW	CHAR	4	0	Deadline function	*
159	VSTGA	☐	VSTGA	VSTGA	CHAR	4	0	Deadline deviation reason	*
160	QRASTZEHT	☐	QRASTZEHT	MEINS	UNIT	3	0	Time Unit	*
161	QRASTZFAK	☐	QRASTZFAK	QPROBEFAK	DEC	5	2	Time Factor
162	QRASTMENG	☐	QRASTMENG	MENG13	QUAN	13	3	Quantity Between Two Inspections
163	QRASTEREH	☐	QRASTEREH	MEINS	UNIT	3	0	Grid Unit of Measure	*
164	AUFKT	☐	AFAKT	AFAKT	DEC	3	0	Execution Factor
165	RMNGA	☐	RMNGA	MENG13	QUAN	13	3	Total confirmed rework quantity
166	ILE01	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
167	ILE02	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
168	ILE03	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
169	ILE04	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
170	ILE05	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
171	ILE06	☐	CO_ISMNGEH	MEINS	UNIT	3	0	Unit of measure for the activity to be confirmed	*
172	RWFAK	☐	RWFAK	AUSCHUFAK	DEC	5	3	Rework factor (is not used yet)
173	IPRZ1	☐	CO_IPRZS	MENGV13	QUAN	13	3	Confirmed quantity/work for business process
174	IPRE1	☐	RU_IPRZE	MEINS	UNIT	3	0	Unit of measurement for conf. quantity for business process	*
175	IPRK1	☐	RU_IPRZK	XFELD	CHAR	1	0	No remaining quantity expected for business process
176	TAKT	☐	LD_TAKT	LD_TAKT	NUMC	4	0	takt within a line segment
177	OPRZ1	☐	OPRZ1	MENGV13	QUAN	13	3	Remaining quantity for business process
178	OPRE1	☐	OPRE1	MEINS	UNIT	3	0	Unit for remaining quantity of business process	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFVVI	ARBEH	T006	MSEHI
2	AFVVI	DAUME	T006	MSEHI
3	AFVVI	DAUNE	T006	MSEHI
4	AFVVI	EHOFFB	T006	MSEHI
5	AFVVI	EHOFFE	T006	MSEHI
6	AFVVI	EWDME	T006	MSEHI
7	AFVVI	EWDNE	T006	MSEHI
8	AFVVI	MEINH	T006	MSEHI
9	AFVVI	PDAE	T006	MSEHI
10	AFVVI	VGE01	T006	MSEHI
11	AFVVI	VGE02	T006	MSEHI
12	AFVVI	VGE03	T006	MSEHI
13	AFVVI	VGE04	T006	MSEHI
14	AFVVI	VGE05	T006	MSEHI
15	AFVVI	VGE06	T006	MSEHI
16	AFVVI	ZEIER	T006	MSEHI
17	AFVVI	ZEILM	T006	MSEHI
18	AFVVI	ZEILP	T006	MSEHI
19	AFVVI	ZEIMB	T006	MSEHI
20	AFVVI	ZEIMU	T006	MSEHI
21	AFVVI	ZEITM	T006	MSEHI
22	AFVVI	ZEITN	T006	MSEHI
23	AFVVI	ZEIWM	T006	MSEHI
24	AFVVI	ZEIWN	T006	MSEHI

History

Last changed by/on	SAP	19991124
SAP Release Created in