SAP Tabel AFVV (DB structure of the quantities/dates/values in the operation)
SAP table AFVV has 3 primary key fields being MANDT,AUFPL,APLZL.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||
| APLZL | General counter for order | NUMC | 8 | 0 | AFVC | CO_APLZL | |
| MEINH | Unit of measure for activity | UNIT | 3 | 0 | T006 | VORME | |
| UMREN | Denominator for Converting Routing and Operation UoM | DEC | 5 | 0 | CP_UMREN | ||
| UMREZ | Numerator for Converting Routing and Operation UoM | DEC | 5 | 0 | CP_UMREZ | ||
| BMSCH | Base Quantity | QUAN | 13 | 3 | BMSCH | ||
| ZMERH | Break Time | QUAN | 9 | 3 | DZMERH | ||
| ZEIER | Unit for a Break Time | UNIT | 3 | 0 | T006 | DZEIER | |
| VGE01 | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VGW01 | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| VGE02 | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VGW02 | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| VGE03 | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VGW03 | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| VGE04 | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VGW04 | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| VGE05 | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VGW05 | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| VGE06 | Unit of Measurement of Standard Value | UNIT | 3 | 0 | T006 | VGWRTEH | |
| VGW06 | Standard Value | QUAN | 9 | 3 | VGWRT | ||
| ZEIMU | Unit for the Minimum Overlap Time | UNIT | 3 | 0 | T006 | DZEIMU | |
| ZMINU | Minimum Overlap Time | QUAN | 9 | 3 | DZMINU | ||
| MINWE | Minimum Send-Ahead Quantity | QUAN | 13 | 3 | MINWEI | ||
| ZEIMB | Unit for the Minimum Processing Time | UNIT | 3 | 0 | T006 | DZEIMB | |
| ZMINB | Minimum Processing Time | QUAN | 9 | 3 | DZMINB | ||
| ZEILM | Unit for the Maximum Wait Time | UNIT | 3 | 0 | T006 | DZEILM | |
| ZLMAX | Maximum Wait Time | QUAN | 9 | 3 | DZLMAX | ||
| ZEILP | Unit for the Required Wait Time | UNIT | 3 | 0 | T006 | DZEILP | |
| ZLPRO | Minimum Wait Time | QUAN | 9 | 3 | DZLPRO | ||
| ZEIWN | Unit for the Standard Queue Time | UNIT | 3 | 0 | T006 | DZEIWN | |
| ZWNOR | Standard Queue Time | QUAN | 9 | 3 | DZWNOR | ||
| ZEIWM | Unit for the Minimum Queue Time | UNIT | 3 | 0 | T006 | DZEIWM | |
| ZWMIN | Minimum Queue Time | QUAN | 9 | 3 | DZWMIN | ||
| ZEITN | Unit for the standard move time | UNIT | 3 | 0 | T006 | DZEITN | |
| ZTNOR | Standard Move Time | QUAN | 9 | 3 | DZTNOR | ||
| ZEITM | Unit for the minimum move time | UNIT | 3 | 0 | T006 | DZEITM | |
| ZTMIN | Minimum Move Time | QUAN | 9 | 3 | DZTMIN | ||
| PLIFZ | Planned Delivery Time in Days | DEC | 3 | 0 | PLIFZ | ||
| DAUNO | Normal duration of the activity | QUAN | 5 | 1 | DAUNOR | ||
| DAUNE | Normal duration/unit | UNIT | 3 | 0 | T006 | DAUNORE | |
| DAUMI | Minimum activity duration | QUAN | 5 | 1 | DAUMIN | ||
| DAUME | Unit for the minimum duration | UNIT | 3 | 0 | T006 | DAUMINE | |
| EINSA | Constraint on the basic start date for the activity | CHAR | 1 | 0 | EINSCHRA | ||
| EINSE | Constraint on the finish date of the activity | CHAR | 1 | 0 | EINSCHRE | ||
| ARBEI | Work involved in the activity | QUAN | 7 | 1 | ARBEIT | ||
| ARBEH | Unit for work | UNIT | 3 | 0 | T006 | ARBEITE | |
| MGVRG | Operation Total Quantity | QUAN | 13 | 3 | MGVRG | ||
| ASVRG | Operation Planned Scrap Quantity | QUAN | 13 | 3 | ASVRG | ||
| LMNGA | Total Confirmed Yield | QUAN | 13 | 3 | LMNGA | ||
| XMNGA | Total Scrap Quantity Confirmed | QUAN | 13 | 3 | XMNGA | ||
| GMNGA | Confirmed yield in order unit of measure | QUAN | 13 | 3 | GMNGA | ||
| ISM01 | Already Confirmed Activity | QUAN | 13 | 3 | CO_RUMNG | ||
| ISM02 | Already Confirmed Activity | QUAN | 13 | 3 | CO_RUMNG | ||
| ISM03 | Already Confirmed Activity | QUAN | 13 | 3 | CO_RUMNG | ||
| ISM04 | Already Confirmed Activity | QUAN | 13 | 3 | CO_RUMNG | ||
| ISM05 | Already Confirmed Activity | QUAN | 13 | 3 | CO_RUMNG | ||
| ISM06 | Already Confirmed Activity | QUAN | 13 | 3 | CO_RUMNG | ||
| ISMNW | Actual work | QUAN | 13 | 3 | CO_ISMNW | ||
| FSAVD | Earliest scheduled start: Execution (date) | DATS | 8 | 0 | FSAVD | ||
| FSAVZ | Earliest scheduled start: Execution (time) | TIMS | 6 | 0 | FSAVZ | ||
| FSSBD | Earliest scheduled start: Processing (date) | DATS | 8 | 0 | FSSBD | ||
| FSSBZ | Earliest Scheduled Start: Processing (Time) | TIMS | 6 | 0 | FSSBZ | ||
| FSSAD | Earliest scheduled start: Teardown (date) | DATS | 8 | 0 | FSSAD | ||
| FSSAZ | Earliest Scheduled Start: Teardown (Time) | TIMS | 6 | 0 | FSSAZ | ||
| FSEDD | Earliest scheduled finish: Execution (date) | DATS | 8 | 0 | FSEDD | ||
| FSEDZ | Earliest scheduled finish: Execution (time) | TIMS | 6 | 0 | FSEDZ | ||
| FSSLD | Earliest Scheduled Wait Start Date | DATS | 8 | 0 | FSSLD | ||
| FSSLZ | Earliest Scheduled Wait Start Time | TIMS | 6 | 0 | FSSLZ | ||
| FSELD | Earliest Scheduled Wait End Date | DATS | 8 | 0 | FSELD | ||
| FSELZ | Earliest Scheduled Wait End Time | TIMS | 6 | 0 | FSELZ | ||
| SSAVD | Latest scheduled start: Execution (date) | DATS | 8 | 0 | SSAVD | ||
| SSAVZ | Latest scheduled start: Execution (time) | TIMS | 6 | 0 | SSAVZ | ||
| SSSBD | Latest Scheduled Start: Processing (Date) | DATS | 8 | 0 | SSSBD | ||
| SSSBZ | Latest Scheduled Start: Processing (Time) | TIMS | 6 | 0 | SSSBZ | ||
| SSSAD | Latest Scheduled Start: Teardown (Date) | DATS | 8 | 0 | SSSAD | ||
| SSSAZ | Latest Scheduled Start: Teardown (Time) | TIMS | 6 | 0 | SSSAZ | ||
| SSEDD | Latest scheduled finish: Execution (date) | DATS | 8 | 0 | SSEDD | ||
| SSEDZ | Latest scheduled finish: Execution (time) | TIMS | 6 | 0 | SSEDZ | ||
| SSSLD | Latest Scheduled Wait Start Date | DATS | 8 | 0 | SSSLD | ||
| SSSLZ | Latest Scheduled Wait Start Time | TIMS | 6 | 0 | SSSLZ | ||
| SSELD | Latest Scheduled Wait End Date | DATS | 8 | 0 | SSELD | ||
| SSELZ | Latest Scheduled Wait End Time | TIMS | 6 | 0 | SSELZ | ||
| ISAVD | Actual Operation Start Date | DATS | 8 | 0 | ISAVD | ||
| IEAVD | Actual Operation End Date | DATS | 8 | 0 | IEAVD | ||
| ISDD | Actual Execution Start Date | DATS | 8 | 0 | ISDD | ||
| ISDZ | Actual Execution Start Time | TIMS | 6 | 0 | ISDZ | ||
| IERD | Actual Setup End Date | DATS | 8 | 0 | IERD | ||
| IERZ | Actual Setup End Time | TIMS | 6 | 0 | IERZ | ||
| ISBD | Actual Processing Start Date | DATS | 8 | 0 | ISBD | ||
| ISBZ | Actual Processing Start Time | TIMS | 6 | 0 | ISBZ | ||
| IEBD | Actual Processing End Date | DATS | 8 | 0 | IEBD | ||
| IEBZ | Actual Processing End Time | TIMS | 6 | 0 | IEBZ | ||
| ISAD | Actual Teardown Start Date | DATS | 8 | 0 | ISAD | ||
| ISAZ | Actual Teardown Start Time | TIMS | 6 | 0 | ISAZ | ||
| IEDD | Actual Execution End Date | DATS | 8 | 0 | IEDD | ||
| IEDZ | Actual Execution End Time | TIMS | 6 | 0 | IEDZ | ||
| PEDD | Forecast finish date of operation from confirmation | DATS | 8 | 0 | CO_PEDD | ||
| PEDZ | Forecast End Time of Operation from Confirmation | TIMS | 6 | 0 | CO_PEDZ | ||
| PUFFR | Free float | DEC | 3 | 0 | PUFFR_FREI | ||
| PUFGS | Total float | DEC | 3 | 0 | PUFFR_GESM | ||
| NTANF | Constraint for activity start (Basic) | DATS | 8 | 0 | VORGABESTD | ||
| NTANZ | Constraint for activity start time (Basic) | TIMS | 6 | 0 | VORGABESTZ | ||
| NTEND | Constraint for Finish of Activity (Basic) | DATS | 8 | 0 | VORGABEEND2 | ||
| NTENZ | Basic finish time of the activity | TIMS | 6 | 0 | VORGABEENZ | ||
| EWSTD | Forecasted start date for the activity | DATS | 8 | 0 | EWSTARTD | ||
| EWSTZ | Forecast start time of the activity | TIMS | 6 | 0 | EWSTARTZ | ||
| EWEND | Forecast finish date | DATS | 8 | 0 | EWENDED | ||
| EWENZ | Forecast finish time for the activity | TIMS | 6 | 0 | EWENDEZ | ||
| EWDAN | Normal duration (from forecast) of activity | QUAN | 5 | 1 | EWDAN | ||
| EWDNE | Unit for forecast normal duration | UNIT | 3 | 0 | T006 | EWDNE | |
| EWDAM | Minimum duration (from forecast) for activity | QUAN | 5 | 1 | EWDAM | ||
| EWDME | Unit for forecast minimum duration | UNIT | 3 | 0 | T006 | EWDME | |
| EWSTE | Forecast date constraint on activity finish | CHAR | 1 | 0 | PS_RESTE | ||
| EWSTA | Forecast date constraint on activity start | CHAR | 1 | 0 | PS_RESTA | ||
| WARTZ | Queue Time Used for Scheduling | FLTP | 16 | 16 | WARTEZEIT | ||
| WRTZE | Unit of Measure for Queue Time | UNIT | 3 | 0 | WTRZE | ||
| RUEST | Setup Time | FLTP | 16 | 16 | RUEST | ||
| RSTZE | Unit of Measure for Setup Time | UNIT | 3 | 0 | RSTZE | ||
| BEARZ | Processing Time | FLTP | 16 | 16 | BEARZEIT | ||
| BEAZE | Unit of measure for processing time | UNIT | 3 | 0 | BEAZE | ||
| ABRUE | Teardown | FLTP | 16 | 16 | ABRUE | ||
| ARUZE | Unit of Measure for Teardown | UNIT | 3 | 0 | ARUZE | ||
| LIEGZ | Wait Time Used for Scheduling | FLTP | 16 | 16 | LIEGEZEIT | ||
| LIGZE | Unit of Measure for Wait Time | UNIT | 3 | 0 | LIGZE | ||
| TRANZ | Move Time used for Scheduling | FLTP | 16 | 16 | TRANSZEIT | ||
| TRAZE | Unit of Measure for Move Time | UNIT | 3 | 0 | TRAZE | ||
| ISERH | Confirmed Break Time | QUAN | 9 | 3 | ISERH | ||
| OFM01 | Forecast Value for Updating of Standard Value | QUAN | 9 | 3 | CO_SCHAETZ | ||
| OFM02 | Forecast Value for Updating of Standard Value | QUAN | 9 | 3 | CO_SCHAETZ | ||
| OFM03 | Forecast Value for Updating of Standard Value | QUAN | 9 | 3 | CO_SCHAETZ | ||
| OFM04 | Forecast Value for Updating of Standard Value | QUAN | 9 | 3 | CO_SCHAETZ | ||
| OFM05 | Forecast Value for Updating of Standard Value | QUAN | 9 | 3 | CO_SCHAETZ | ||
| OFM06 | Forecast Value for Updating of Standard Value | QUAN | 9 | 3 | CO_SCHAETZ | ||
| OFMNW | Forecasted work (actual + remaining) | QUAN | 7 | 1 | OFMNW | ||
| BZOFFB | Reference Date for Start of Sub-Operation | CHAR | 2 | 0 | TCA54 | CP_OBZOFFB | |
| EHOFFB | Unit for Offset to Start | UNIT | 3 | 0 | T006 | CP_OEHOFFB | |
| OFFSTB | Offset to sub-operation start | QUAN | 5 | 0 | CP_OOFFSTB | ||
| OFFSTE | Offset to sub-operation finish | QUAN | 5 | 0 | CP_OOFFSTE | ||
| BZOFFE | Reference Date for Finish of Sub-Operation | CHAR | 2 | 0 | TCA54 | CP_OBZOFFE | |
| EHOFFE | Unit for Offset to Finish | UNIT | 3 | 0 | T006 | CP_OEHOFFE | |
| FPAVD | Earliest scheduled start date (forecast) | DATS | 8 | 0 | FPAVD | ||
| FPAVZ | Earliest scheduled start time (forecast) | TIMS | 6 | 0 | FPAVZ | ||
| FPEDD | Earliest scheduled finish date (forecast) | DATS | 8 | 0 | FPEDD | ||
| FPEDZ | Earliest scheduled finish time (forecast) | TIMS | 6 | 0 | FPEDZ | ||
| SPAVD | Latest scheduled start date (forecast) | DATS | 8 | 0 | SPAVD | ||
| SPAVZ | Latest scheduled start time (forecast) | TIMS | 6 | 0 | SPAVZ | ||
| SPEDD | Latest scheduled finish date (forecast) | DATS | 8 | 0 | SPEDD | ||
| SPEDZ | Latest scheduled finish time (forecast) | TIMS | 6 | 0 | SPEDZ | ||
| BEAZP | Unit of processing time (Forecast) | UNIT | 3 | 0 | BEAZEP | ||
| PUFGP | Total float (from forecast) | DEC | 3 | 0 | PPUFF_GESM | ||
| PUFFP | Free float (from forecast) | DEC | 3 | 0 | PPUFF_FREI | ||
| BEARP | Processing time (forecast) | FLTP | 16 | 16 | PBEARZEIT | ||
| EPANF | Dispatched start date for operation | DATS | 8 | 0 | EPANF | ||
| EPANZ | Dispatched start time for operation | TIMS | 6 | 0 | EPANZ | ||
| EPEND | Dispatched finish date | DATS | 8 | 0 | EPEND | ||
| EPENZ | Dispatched finish time | TIMS | 6 | 0 | EPENZ | ||
| PDAU | Forecasted duration of activity from confirmation | QUAN | 5 | 1 | PDAU | ||
| PDAE | Unit of the forecasted duration from the confirmation | UNIT | 3 | 0 | T006 | PDAE | |
| KNOTE | Transportation Connection Points | CHAR | 10 | 0 | TVKN | KNOTE | |
| VSTZW | Deadline function | CHAR | 4 | 0 | TVTZ | VSTZW | |
| VSTGA | Deadline deviation reason | CHAR | 4 | 0 | TVTG | VSTGA | |
| QRASTZEHT | Time Unit | UNIT | 3 | 0 | * | QRASTZEHT | |
| QRASTZFAK | Time Factor | DEC | 5 | 2 | QRASTZFAK | ||
| QRASTMENG | Quantity Between Two Inspections | QUAN | 13 | 3 | QRASTMENG | ||
| QRASTEREH | Grid Unit of Measure | UNIT | 3 | 0 | * | QRASTEREH | |
| AUFKT | Execution Factor | DEC | 3 | 0 | AFAKT | ||
| RMNGA | Total Confirmed Rework Quantity | QUAN | 13 | 3 | RMNGA | ||
| ILE01 | Unit of measure for the activity to be confirmed | UNIT | 3 | 0 | * | CO_ISMNGEH | |
| ILE02 | Unit of measure for the activity to be confirmed | UNIT | 3 | 0 | * | CO_ISMNGEH | |
| ILE03 | Unit of measure for the activity to be confirmed | UNIT | 3 | 0 | * | CO_ISMNGEH | |
| ILE04 | Unit of measure for the activity to be confirmed | UNIT | 3 | 0 | * | CO_ISMNGEH | |
| ILE05 | Unit of measure for the activity to be confirmed | UNIT | 3 | 0 | * | CO_ISMNGEH | |
| ILE06 | Unit of measure for the activity to be confirmed | UNIT | 3 | 0 | * | CO_ISMNGEH | |
| RWFAK | Rework factor (is not used yet) | DEC | 5 | 3 | RWFAK | ||
| IPRZ1 | Confirmed Quantity/Activity for Business Process | QUAN | 13 | 3 | CO_IPRZS | ||
| IPRE1 | Unit of Measure for Business Process Quantity | UNIT | 3 | 0 | * | RU_IPRZE | |
| IPRK1 | No Remaining Quantity Expected for Business Process | CHAR | 1 | 0 | RU_IPRZK | ||
| TAKT | takt within a line segment | NUMC | 4 | 0 | LD_TAKT | ||
| OPRZ1 | Remaining Quantity for Business Process | QUAN | 13 | 3 | OPRZ1 | ||
| OPRE1 | Unit for Remaining Quantity of Business Process | UNIT | 3 | 0 | * | OPRE1 | |
| PSPM_INDICATOR | Indicates PMCS date influence activity scheduling | CHAR | 1 | 0 | PSPM_INDICATOR |
AFVV foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 AFVV | APLZL | AFVC | Operation within an order | AUFPL |
| 0 AFVV | APLZL | AFVC | Operation within an order | APLZL |
| 1 AFVV | ARBEH | T006 | Units of Measurement | MANDT |
| 0 AFVV | BZOFFB | TCA54 | Key for reference dates used in offset scheduling | BZOFF |
| 1 AFVV | BZOFFE | TCA54 | Key for reference dates used in offset scheduling | BZOFF |
| 0 AFVV | DAUME | T006 | Units of Measurement | MANDT |
| 0 AFVV | DAUME | T006 | Units of Measurement | MSEHI |
| 1 AFVV | DAUNE | T006 | Units of Measurement | MANDT |
| 0 AFVV | EHOFFB | T006 | Units of Measurement | MANDT |
| 1 AFVV | EHOFFE | T006 | Units of Measurement | MANDT |
| 0 AFVV | EWDME | T006 | Units of Measurement | MANDT |
| 0 AFVV | EWDME | T006 | Units of Measurement | MSEHI |
| 1 AFVV | EWDNE | T006 | Units of Measurement | MANDT |
| 0 AFVV | KNOTE | TVKN | Routes: Transportation Connection Points | MANDT |
| 0 AFVV | KNOTE | TVKN | Routes: Transportation Connection Points | KNOTE |
| 1 AFVV | MANDT | T000 | Clients | MANDT |
| 0 AFVV | MEINH | T006 | Units of Measurement | MANDT |
| 0 AFVV | MEINH | T006 | Units of Measurement | MSEHI |
| 1 AFVV | PDAE | T006 | Units of Measurement | MANDT |
| 0 AFVV | VGE01 | T006 | Units of Measurement | MANDT |
| 1 AFVV | VGE02 | T006 | Units of Measurement | MANDT |
| 0 AFVV | VGE03 | T006 | Units of Measurement | MANDT |
| 1 AFVV | VGE04 | T006 | Units of Measurement | MANDT |
| 0 AFVV | VGE05 | T006 | Units of Measurement | MANDT |
| 1 AFVV | VGE06 | T006 | Units of Measurement | MANDT |
| 0 AFVV | VSTGA | TVTG | Reasons for Date Deviation | VSTGA |
| 1 AFVV | VSTZW | TVTZ | Deadline Functions | VSTZW |
| 0 AFVV | ZEIER | T006 | Units of Measurement | MANDT |
| 1 AFVV | ZEILM | T006 | Units of Measurement | MANDT |
| 0 AFVV | ZEILP | T006 | Units of Measurement | MANDT |
| 1 AFVV | ZEIMB | T006 | Units of Measurement | MANDT |
| 0 AFVV | ZEIMU | T006 | Units of Measurement | MANDT |
| 1 AFVV | ZEITM | T006 | Units of Measurement | MANDT |
| 0 AFVV | ZEITN | T006 | Units of Measurement | MANDT |
| 1 AFVV | ZEIWM | T006 | Units of Measurement | MANDT |
| 1 AFVV | ZEIWM | T006 | Units of Measurement | MSEHI |
| 0 AFVV | ZEIWN | T006 | Units of Measurement | MANDT |