AFVV - DB structure of the quantities/dates/values in the operation
DB structure of the quantities/dates/values in the operation information is stored in SAP table AFVV.
It is part of development package CO in software component PP-SFC. This development package consists of objects that can be grouped under "Application Development ERP PP Production Orders".
It is part of development package CO in software component PP-SFC. This development package consists of objects that can be grouped under "Application Development ERP PP Production Orders".
Fields for table AFVV
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| AUFPL | Routing number of operations in the order | X | CO_AUFPL | NUMC | 20 | |
| APLZL | General counter for order | X | CO_APLZL | NUMC | 16 | AFVC |
| .INCLUDE | AFVVI | 0 | ||||
| MEINH | Unit of measure for activity | VORME | UNIT | 6 | T006 | |
| UMREN | Denominator for Converting Routing and Operation UoM | CP_UMREN | DEC | 3 | ||
| UMREZ | Numerator for Converting Routing and Operation UoM | CP_UMREZ | DEC | 3 | ||
| BMSCH | Base Quantity | BMSCH | QUAN | 7 | ||
| VGE01 | Unit of Measurement of Standard Value | VGWRTEH | UNIT | 6 | T006 | |
| VGW01 | Standard Value | VGWRT | QUAN | 5 | ||
| VGE02 | Unit of Measurement of Standard Value | VGWRTEH | UNIT | 6 | T006 | |
| VGW02 | Standard Value | VGWRT | QUAN | 5 | ||
| VGE03 | Unit of Measurement of Standard Value | VGWRTEH | UNIT | 6 | T006 | |
| VGW03 | Standard Value | VGWRT | QUAN | 5 | ||
| VGE04 | Unit of Measurement of Standard Value | VGWRTEH | UNIT | 6 | T006 | |
| VGW04 | Standard Value | VGWRT | QUAN | 5 | ||
| VGE05 | Unit of Measurement of Standard Value | VGWRTEH | UNIT | 6 | T006 | |
| VGW05 | Standard Value | VGWRT | QUAN | 5 | ||
| VGE06 | Unit of Measurement of Standard Value | VGWRTEH | UNIT | 6 | T006 | |
| VGW06 | Standard Value | VGWRT | QUAN | 5 | ||
| MINWE | Minimum Send-Ahead Quantity | MINWEI | QUAN | 7 | ||
| PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 2 | ||
| DAUNO | Normal duration of the activity | DAUNOR | QUAN | 3 | ||
| DAUNE | Normal duration/unit | DAUNORE | UNIT | 6 | T006 | |
| DAUMI | Minimum activity duration | DAUMIN | QUAN | 3 | ||
| DAUME | Unit for the minimum duration | DAUMINE | UNIT | 6 | T006 | |
| EINSA | Constraint on the basic start date for the activity | EINSCHRA | CHAR | 2 | ||
| EINSE | Constraint on the finish date of the activity | EINSCHRE | CHAR | 2 | ||
| ARBEI | Work involved in the activity | ARBEIT | QUAN | 4 | ||
| ARBEH | Unit for work | ARBEITE | UNIT | 6 | T006 | |
| MGVRG | Operation Total Quantity | MGVRG | QUAN | 7 | ||
| ASVRG | Operation Planned Scrap Quantity | ASVRG | QUAN | 7 | ||
| LMNGA | Total Confirmed Yield | LMNGA | QUAN | 7 | ||
| XMNGA | Total Scrap Quantity Confirmed | XMNGA | QUAN | 7 | ||
| GMNGA | Confirmed yield in order unit of measure | GMNGA | QUAN | 7 | ||
| ISM01 | Already Confirmed Activity | CO_RUMNG | QUAN | 7 | ||
| ISM02 | Already Confirmed Activity | CO_RUMNG | QUAN | 7 | ||
| ISM03 | Already Confirmed Activity | CO_RUMNG | QUAN | 7 | ||
| ISM04 | Already Confirmed Activity | CO_RUMNG | QUAN | 7 | ||
| ISM05 | Already Confirmed Activity | CO_RUMNG | QUAN | 7 | ||
| ISM06 | Already Confirmed Activity | CO_RUMNG | QUAN | 7 | ||
| ISMNW | Actual work | CO_ISMNW | QUAN | 7 | ||
| FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 16 | ||
| FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 12 | ||
| FSSBD | Earliest scheduled start: Processing (date) | FSSBD | DATS | 16 | ||
| FSSBZ | Earliest Scheduled Start: Processing (Time) | FSSBZ | TIMS | 12 | ||
| FSSAD | Earliest scheduled start: Teardown (date) | FSSAD | DATS | 16 | ||
| FSSAZ | Earliest Scheduled Start: Teardown (Time) | FSSAZ | TIMS | 12 | ||
| FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 16 | ||
| FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 12 | ||
| FSSLD | Earliest Scheduled Wait Start Date | FSSLD | DATS | 16 | ||
| FSSLZ | Earliest Scheduled Wait Start Time | FSSLZ | TIMS | 12 | ||
| FSELD | Earliest Scheduled Wait End Date | FSELD | DATS | 16 | ||
| FSELZ | Earliest Scheduled Wait End Time | FSELZ | TIMS | 12 | ||
| SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 16 | ||
| SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 12 | ||
| SSSBD | Latest Scheduled Start: Processing (Date) | SSSBD | DATS | 16 | ||
| SSSBZ | Latest Scheduled Start: Processing (Time) | SSSBZ | TIMS | 12 | ||
| SSSAD | Latest Scheduled Start: Teardown (Date) | SSSAD | DATS | 16 | ||
| SSSAZ | Latest Scheduled Start: Teardown (Time) | SSSAZ | TIMS | 12 | ||
| SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 16 | ||
| SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 12 | ||
| SSSLD | Latest Scheduled Wait Start Date | SSSLD | DATS | 16 | ||
| SSSLZ | Latest Scheduled Wait Start Time | SSSLZ | TIMS | 12 | ||
| SSELD | Latest Scheduled Wait End Date | SSELD | DATS | 16 | ||
| SSELZ | Latest Scheduled Wait End Time | SSELZ | TIMS | 12 | ||
| ISAVD | Actual Operation Start Date | ISAVD | DATS | 16 | ||
| IEAVD | Actual Operation End Date | IEAVD | DATS | 16 | ||
| ISDD | Actual Execution Start Date | ISDD | DATS | 16 | ||
| ISDZ | Actual Execution Start Time | ISDZ | TIMS | 12 | ||
| IERD | Actual Setup End Date | IERD | DATS | 16 | ||
| IERZ | Actual Setup End Time | IERZ | TIMS | 12 | ||
| ISBD | Actual Processing Start Date | ISBD | DATS | 16 | ||
| ISBZ | Actual Processing Start Time | ISBZ | TIMS | 12 | ||
| IEBD | Actual Processing End Date | IEBD | DATS | 16 | ||
| IEBZ | Actual Processing End Time | IEBZ | TIMS | 12 | ||
| ISAD | Actual Teardown Start Date | ISAD | DATS | 16 | ||
| ISAZ | Actual Teardown Start Time | ISAZ | TIMS | 12 | ||
| IEDD | Actual Execution End Date | IEDD | DATS | 16 | ||
| IEDZ | Actual Execution End Time | IEDZ | TIMS | 12 | ||
| PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 16 | ||
| PEDZ | Forecast End Time of Operation from Confirmation | CO_PEDZ | TIMS | 12 | ||
| PUFFR | Free float | PUFFR_FREI | DEC | 2 | ||
| PUFGS | Total float | PUFFR_GESM | DEC | 2 | ||
| NTANF | Constraint for activity start (Basic) | VORGABESTD | DATS | 16 | ||
| NTANZ | Constraint for activity start time (Basic) | VORGABESTZ | TIMS | 12 | ||
| NTEND | Constraint for Finish of Activity (Basic) | VORGABEEND2 | DATS | 16 | ||
| NTENZ | Basic finish time of the activity | VORGABEENZ | TIMS | 12 | ||
| EWSTD | Forecasted start date for the activity | EWSTARTD | DATS | 16 | ||
| EWSTZ | Forecast start time of the activity | EWSTARTZ | TIMS | 12 | ||
| EWEND | Forecast finish date | EWENDED | DATS | 16 | ||
| EWENZ | Forecast finish time for the activity | EWENDEZ | TIMS | 12 | ||
| EWDAN | Normal duration (from forecast) of activity | EWDAN | QUAN | 3 | ||
| EWDNE | Unit for forecast normal duration | EWDNE | UNIT | 6 | T006 | |
| EWDAM | Minimum duration (from forecast) for activity | EWDAM | QUAN | 3 | ||
| EWDME | Unit for forecast minimum duration | EWDME | UNIT | 6 | T006 | |
| EWSTE | Forecast date constraint on activity finish | PS_RESTE | CHAR | 2 | ||
| EWSTA | Forecast date constraint on activity start | PS_RESTA | CHAR | 2 | ||
| WARTZ | Queue Time Used for Scheduling | WARTEZEIT | FLTP | 8 | ||
| WRTZE | Unit of Measure for Queue Time | WTRZE | UNIT | 6 | ||
| RUEST | Setup Time | RUEST | FLTP | 8 | ||
| RSTZE | Unit of Measure for Setup Time | RSTZE | UNIT | 6 | ||
| BEARZ | Processing Time | BEARZEIT | FLTP | 8 | ||
| BEAZE | Unit of measure for processing time | BEAZE | UNIT | 6 | ||
| ABRUE | Teardown | ABRUE | FLTP | 8 | ||
| ARUZE | Unit of Measure for Teardown | ARUZE | UNIT | 6 | ||
| LIEGZ | Wait Time Used for Scheduling | LIEGEZEIT | FLTP | 8 | ||
| LIGZE | Unit of Measure for Wait Time | LIGZE | UNIT | 6 | ||
| TRANZ | Move Time used for Scheduling | TRANSZEIT | FLTP | 8 | ||
| TRAZE | Unit of Measure for Move Time | TRAZE | UNIT | 6 | ||
| ISERH | Confirmed Break Time | ISERH | QUAN | 5 | ||
| OFM01 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 5 | ||
| OFM02 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 5 | ||
| OFM03 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 5 | ||
| OFM04 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 5 | ||
| OFM05 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 5 | ||
| OFM06 | Forecast Value for Updating of Standard Value | CO_SCHAETZ | QUAN | 5 | ||
| OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 4 | ||
| BZOFFB | Reference Date for Start of Sub-Operation | CP_OBZOFFB | CHAR | 4 | TCA54 | |
| EHOFFB | Unit for Offset to Start | CP_OEHOFFB | UNIT | 6 | T006 | |
| OFFSTB | Offset to sub-operation start | CP_OOFFSTB | QUAN | 3 | ||
| OFFSTE | Offset to sub-operation finish | CP_OOFFSTE | QUAN | 3 | ||
| BZOFFE | Reference Date for Finish of Sub-Operation | CP_OBZOFFE | CHAR | 4 | TCA54 | |
| EHOFFE | Unit for Offset to Finish | CP_OEHOFFE | UNIT | 6 | T006 | |
| FPAVD | Earliest scheduled start date (forecast) | FPAVD | DATS | 16 | ||
| FPAVZ | Earliest scheduled start time (forecast) | FPAVZ | TIMS | 12 | ||
| FPEDD | Earliest scheduled finish date (forecast) | FPEDD | DATS | 16 | ||
| FPEDZ | Earliest scheduled finish time (forecast) | FPEDZ | TIMS | 12 | ||
| SPAVD | Latest scheduled start date (forecast) | SPAVD | DATS | 16 | ||
| SPAVZ | Latest scheduled start time (forecast) | SPAVZ | TIMS | 12 | ||
| SPEDD | Latest scheduled finish date (forecast) | SPEDD | DATS | 16 | ||
| SPEDZ | Latest scheduled finish time (forecast) | SPEDZ | TIMS | 12 | ||
| BEAZP | Unit of processing time (Forecast) | BEAZEP | UNIT | 6 | ||
| PUFGP | Total float (from forecast) | PPUFF_GESM | DEC | 2 | ||
| PUFFP | Free float (from forecast) | PPUFF_FREI | DEC | 2 | ||
| BEARP | Processing time (forecast) | PBEARZEIT | FLTP | 8 | ||
| EPANF | Dispatched start date for operation | EPANF | DATS | 16 | ||
| EPANZ | Dispatched start time for operation | EPANZ | TIMS | 12 | ||
| EPEND | Dispatched finish date | EPEND | DATS | 16 | ||
| EPENZ | Dispatched finish time | EPENZ | TIMS | 12 | ||
| PDAU | Forecasted duration of activity from confirmation | PDAU | QUAN | 3 | ||
| PDAE | Unit of the forecasted duration from the confirmation | PDAE | UNIT | 6 | T006 | |
| KNOTE | Transportation Connection Points | KNOTE | CHAR | 20 | TVKN | |
| VSTZW | Deadline function | VSTZW | CHAR | 8 | TVTZ | |
| VSTGA | Deadline deviation reason | VSTGA | CHAR | 8 | TVTG | |
| QRASTZEHT | Time Unit | QRASTZEHT | UNIT | 6 | * | |
| QRASTZFAK | Time Factor | QRASTZFAK | DEC | 3 | ||
| QRASTMENG | Quantity Between Two Inspections | QRASTMENG | QUAN | 7 | ||
| QRASTEREH | Grid Unit of Measure | QRASTEREH | UNIT | 6 | * | |
| AUFKT | Execution Factor | AFAKT | DEC | 2 | ||
| RMNGA | Total Confirmed Rework Quantity | RMNGA | QUAN | 7 | ||
| ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 6 | * | |
| ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 6 | * | |
| ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 6 | * | |
| ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 6 | * | |
| ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 6 | * | |
| ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 6 | * | |
| RWFAK | Rework factor (is not used yet) | RWFAK | DEC | 3 | ||
| IPRZ1 | Confirmed Quantity/Activity for Business Process | CO_IPRZS | QUAN | 7 | ||
| IPRE1 | Unit of Measure for Business Process Quantity | RU_IPRZE | UNIT | 6 | * | |
| IPRK1 | No Remaining Quantity Expected for Business Process | RU_IPRZK | CHAR | 2 | ||
| TAKT | takt within a line segment | LD_TAKT | NUMC | 8 | ||
| OPRZ1 | Remaining Quantity for Business Process | OPRZ1 | QUAN | 7 | ||
| OPRE1 | Unit for Remaining Quantity of Business Process | OPRE1 | UNIT | 6 | * | |
| PSPM_INDICATOR | Indicates PMCS date influence activity scheduling | PSPM_INDICATOR | CHAR | 2 |