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