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