AFVV SAP (DB structure of the quantities/dates/values in the operation) Table details
Description: DB structure of the quantities/dates/values in the operation
Table field list including key, data, relationships and ABAP select examples
AFVV is a standard SAP Table which is used to store DB structure of the quantities/dates/values in the operation data and is available within R/3 SAP systems depending on the version and release level.
The AFVV table consists of various fields, each holding specific information or linking keys about DB structure of the quantities/dates/values in the operation data available in SAP. These include AUFPL (Routing number of operations in the order), APLZL (General counter for order), MEINH (Unit of Measure for Activity/Operation), UMREN (Denominator for converting rtg and op units of measure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AFVV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
APLZL | General counter for order | CO_APLZL | NUMC | 8 | AFVC | CO_APLZL | |||
MEINH | Unit of Measure for Activity/Operation | VORME | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMREN | Denominator for converting rtg and op units of measure | CP_UMREN | DEC | 5 | UMBSN | ||||
UMREZ | Numerator for converting task list and oper. un. of measure | CP_UMREZ | DEC | 5 | UMBSZ | ||||
BMSCH | Base Quantity | BMSCH | QUAN | 13(3) | BMSCH | ||||
ZMERH | Break | DZMERH | QUAN | 9(3) | VGWRT | ||||
ZEIER | Unit for the break time | DZEIER | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGE01 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGW01 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
VGE02 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGW02 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
VGE03 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGW03 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
VGE04 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGW04 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
VGE05 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGW05 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
VGE06 | Unit of measure for the standard value | VGWRTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VGW06 | Standard Value | VGWRT | QUAN | 9(3) | VGWRT | ||||
ZEIMU | Unit for the minimum overlap time | DZEIMU | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZMINU | Minimum overlap time | DZMINU | QUAN | 9(3) | VGWRT | ||||
MINWE | Minimum Send-Ahead Quantity | MINWEI | QUAN | 13(3) | MINWEI | ||||
ZEIMB | Unit for the minimum processing time | DZEIMB | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZMINB | Minimum processing time | DZMINB | QUAN | 9(3) | VGWRT | ||||
ZEILM | Unit for the maximum wait time | DZEILM | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZLMAX | Maximum wait time | DZLMAX | QUAN | 9(3) | VGWRT | ||||
ZEILP | Unit for the required wait time | DZEILP | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZLPRO | Minimum wait time | DZLPRO | QUAN | 9(3) | VGWRT | ||||
ZEIWN | Unit for the standard queue time | DZEIWN | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZWNOR | Standard queue time | DZWNOR | QUAN | 9(3) | VGWRT | ||||
ZEIWM | Unit for the minumum queue time | DZEIWM | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZWMIN | Minimum queue time | DZWMIN | QUAN | 9(3) | VGWRT | ||||
ZEITN | Unit for the standard move time | DZEITN | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZTNOR | Standard move time | DZTNOR | QUAN | 9(3) | VGWRT | ||||
ZEITM | Unit for the minimum move time | DZEITM | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZTMIN | Minimum move time | DZTMIN | QUAN | 9(3) | VGWRT | ||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
DAUNO | Normal duration of the activity | DAUNOR | QUAN | 5(1) | DAUER_4_1 | ||||
DAUNE | Normal duration/unit | DAUNORE | UNIT | 3 | T006 | CUNIT | MEINS | ||
DAUMI | Minimum activity duration | DAUMIN | QUAN | 5(1) | DAUER_4_1 | ||||
DAUME | Unit for the minimum duration | DAUMINE | UNIT | 3 | T006 | CUNIT | MEINS | ||
EINSA | Constraint on the basic start date for the activity | EINSCHRA | CHAR | 1 | RESTRIKSTR | ||||
EINSE | Constraint on the finish date of the activity | EINSCHRE | CHAR | 1 | RESTRIKEND | ||||
ARBEI | Work involved in the activity | ARBEIT | QUAN | 7(1) | ARBEIT | ||||
ARBEH | Unit for work | ARBEITE | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGVRG | Operation Quantity | MGVRG | QUAN | 13(3) | MENG13 | ||||
ASVRG | Operation scrap | ASVRG | QUAN | 13(3) | MENG13 | ||||
LMNGA | Total Yield Confirmed | LMNGA | QUAN | 13(3) | MENG13 | ||||
XMNGA | Total scrap quantity confirmed | XMNGA | QUAN | 13(3) | MENG13 | ||||
GMNGA | Confirmed yield in order unit of measure | GMNGA | QUAN | 13(3) | MENG13 | ||||
ISM01 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM02 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM03 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM04 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM05 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISM06 | Previously confirmed activity | CO_RUMNG | QUAN | 13(3) | MENGV13 | ||||
ISMNW | Actual work | CO_ISMNW | QUAN | 13(3) | MENG13 | ||||
FSAVD | Earliest scheduled start: Execution (date) | FSAVD | DATS | 8 | DATUM | ||||
FSAVZ | Earliest scheduled start: Execution (time) | FSAVZ | TIMS | 6 | ATIME | ||||
FSSBD | Earliest scheduled start: Processing (date) | FSSBD | DATS | 8 | DATUM | ||||
FSSBZ | Earliest scheduled start: Processing (time) | FSSBZ | TIMS | 6 | ATIME | ||||
FSSAD | Earliest scheduled start: Teardown (date) | FSSAD | DATS | 8 | DATUM | ||||
FSSAZ | Earliest scheduled start: Teardown (time) | FSSAZ | TIMS | 6 | ATIME | ||||
FSEDD | Earliest scheduled finish: Execution (date) | FSEDD | DATS | 8 | DATUM | ||||
FSEDZ | Earliest scheduled finish: Execution (time) | FSEDZ | TIMS | 6 | ATIME | ||||
FSSLD | Earliest scheduled start: Wait (date) | FSSLD | DATS | 8 | DATUM | ||||
FSSLZ | Earliest scheduled start: Wait (time) | FSSLZ | TIMS | 6 | ATIME | ||||
FSELD | Earliest scheduled finish: Wait (date) | FSELD | DATS | 8 | DATUM | ||||
FSELZ | Earliest scheduled finish: Wait (time) | FSELZ | TIMS | 6 | ATIME | ||||
SSAVD | Latest scheduled start: Execution (date) | SSAVD | DATS | 8 | DATUM | ||||
SSAVZ | Latest scheduled start: Execution (time) | SSAVZ | TIMS | 6 | ATIME | ||||
SSSBD | Latest scheduled start: Processing (date) | SSSBD | DATS | 8 | DATUM | ||||
SSSBZ | Latest scheduled start: Processing (time) | SSSBZ | TIMS | 6 | ATIME | ||||
SSSAD | Latest scheduled start: Teardown (date) | SSSAD | DATS | 8 | DATUM | ||||
SSSAZ | Latest scheduled start: Teardown (time) | SSSAZ | TIMS | 6 | ATIME | ||||
SSEDD | Latest scheduled finish: Execution (date) | SSEDD | DATS | 8 | DATUM | ||||
SSEDZ | Latest scheduled finish: Execution (time) | SSEDZ | TIMS | 6 | ATIME | ||||
SSSLD | Latest scheduled start: Wait time (date) | SSSLD | DATS | 8 | DATUM | ||||
SSSLZ | Latest scheduled start: Wait time | SSSLZ | TIMS | 6 | ATIME | ||||
SSELD | Latest scheduled finish: Wait time (date) | SSELD | DATS | 8 | DATUM | ||||
SSELZ | Latest scheduled finish: Wait time | SSELZ | TIMS | 6 | ATIME | ||||
ISAVD | Actual operation start (date) | ISAVD | DATS | 8 | DATUM | ||||
IEAVD | Actual finish of operation (date) | IEAVD | DATS | 8 | DATUM | ||||
ISDD | Actual start: Execution (date) | ISDD | DATS | 8 | DATUM | ||||
ISDZ | Actual start: Execution/setup (time) | ISDZ | TIMS | 6 | ATIME | ||||
IERD | Actual finish: Setup (date) | IERD | DATS | 8 | DATUM | ||||
IERZ | Actual finish: Setup (time) | IERZ | TIMS | 6 | ATIME | ||||
ISBD | Actual start: Processing (date) | ISBD | DATS | 8 | DATUM | ||||
ISBZ | Actual start: Processing (time) | ISBZ | TIMS | 6 | ATIME | ||||
IEBD | Actual finish: Processing (date) | IEBD | DATS | 8 | DATUM | ||||
IEBZ | Actual processing finish (time) | IEBZ | TIMS | 6 | ATIME | ||||
ISAD | Actual start: Teardown (date) | ISAD | DATS | 8 | DATUM | ||||
ISAZ | Actual start: Teardown (time) | ISAZ | TIMS | 6 | ATIME | ||||
IEDD | Actual finish: Execution (date) | IEDD | DATS | 8 | DATUM | EDR | |||
IEDZ | Actual finish: Execution (time) | IEDZ | TIMS | 6 | ATIME | EZR | |||
PEDD | Forecast finish date of operation from confirmation | CO_PEDD | DATS | 8 | DATUM | ||||
PEDZ | Forecast finish time of operation from confirmation | CO_PEDZ | TIMS | 6 | ATIME | ||||
PUFFR | Free float | PUFFR_FREI | DEC | 3 | PUFFER | ||||
PUFGS | Total float | PUFFR_GESM | DEC | 3 | PUFFER | ||||
NTANF | Constraint for activity start (Basic) | VORGABESTD | DATS | 8 | VORGABESTR | ||||
NTANZ | Constraint for activity start time (Basic) | VORGABESTZ | TIMS | 6 | ATIME | ||||
NTEND | Constraint for Finish of Activity (Basic) | VORGABEEND2 | DATS | 8 | VORGABEEND | ||||
NTENZ | Basic finish time of the activity | VORGABEENZ | TIMS | 6 | ATIME | ||||
EWSTD | Forecasted start date for the activity | EWSTARTD | DATS | 8 | DATUM | ||||
EWSTZ | Forecast start time of the activity | EWSTARTZ | TIMS | 6 | ATIME | ||||
EWEND | Forecast finish date | EWENDED | DATS | 8 | DATUM | ||||
EWENZ | Forecast finish time for the activity | EWENDEZ | TIMS | 6 | ATIME | ||||
EWDAN | Normal duration (from forecast) of activity | EWDAN | QUAN | 5(1) | DAUER_4_1 | ||||
EWDNE | Unit for forecast normal duration | EWDNE | UNIT | 3 | T006 | CUNIT | MEINS | ||
EWDAM | Minimum duration (from forecast) for activity | EWDAM | QUAN | 5(1) | DAUER_4_1 | ||||
EWDME | Unit for forecast minimum duration | EWDME | UNIT | 3 | T006 | CUNIT | MEINS | ||
EWSTE | Forecast date constraint on activity finish | PS_RESTE | CHAR | 1 | RESTRIKEND | ||||
EWSTA | Forecast date constraint on activity start | PS_RESTA | CHAR | 1 | RESTRIKSTR | ||||
WARTZ | Queue time used for scheduling | WARTEZEIT | FLTP | 16(16) | CX_ZEIT | ||||
WRTZE | Unit of measure for queue time | WTRZE | UNIT | 3 | CUNIT | EINHEIT | |||
RUEST | Setup time | RUEST | FLTP | 16(16) | CX_ZEIT | ||||
RSTZE | Unit of measure for setup time | RSTZE | UNIT | 3 | CUNIT | EINHEIT | |||
BEARZ | Processing time | BEARZEIT | FLTP | 16(16) | CX_ZEIT | ||||
BEAZE | Unit of measure for processing time | BEAZE | UNIT | 3 | CUNIT | EINHEIT | |||
ABRUE | Teardown | ABRUE | FLTP | 16(16) | CX_ZEIT | ||||
ARUZE | Unit of measure for teardown | ARUZE | UNIT | 3 | CUNIT | EINHEIT | |||
LIEGZ | Wait time used for scheduling | LIEGEZEIT | FLTP | 16(16) | CX_ZEIT | ||||
LIGZE | Unit of measure for wait time | LIGZE | UNIT | 3 | CUNIT | EINHEIT | |||
TRANZ | Move time used for scheduling | TRANSZEIT | FLTP | 16(16) | CX_ZEIT | ||||
TRAZE | Unit of measure for move time | TRAZE | UNIT | 3 | CUNIT | EINHEIT | |||
ISERH | Confirmed break time | ISERH | QUAN | 9(3) | VGWRT | ||||
OFM01 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM02 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM03 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM04 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM05 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFM06 | Forecast value used to update the standard value | CO_SCHAETZ | QUAN | 9(3) | VGWRT | ||||
OFMNW | Forecasted work (actual + remaining) | OFMNW | QUAN | 7(1) | ARBEIT | ||||
BZOFFB | Reference date for start of sub-operation | CP_OBZOFFB | CHAR | 2 | TCA54 | CP_BZOFF | |||
EHOFFB | Unit for offset to start | CP_OEHOFFB | UNIT | 3 | T006 | CUNIT | MEINS | ||
OFFSTB | Offset to sub-operation start | CP_OOFFSTB | QUAN | 5 | VNZTV | ||||
OFFSTE | Offset to sub-operation finish | CP_OOFFSTE | QUAN | 5 | VNZTV | ||||
BZOFFE | Reference date for finish of sub-operation | CP_OBZOFFE | CHAR | 2 | TCA54 | CP_BZOFF | |||
EHOFFE | Unit for offset to finish | CP_OEHOFFE | UNIT | 3 | T006 | CUNIT | MEINS | ||
FPAVD | Earliest scheduled start date (forecast) | FPAVD | DATS | 8 | DATUM | ||||
FPAVZ | Earliest scheduled start time (forecast) | FPAVZ | TIMS | 6 | ATIME | ||||
FPEDD | Earliest scheduled finish date (forecast) | FPEDD | DATS | 8 | DATUM | ||||
FPEDZ | Earliest scheduled finish time (forecast) | FPEDZ | TIMS | 6 | ATIME | ||||
SPAVD | Latest scheduled start date (forecast) | SPAVD | DATS | 8 | DATUM | ||||
SPAVZ | Latest scheduled start time (forecast) | SPAVZ | TIMS | 6 | ATIME | ||||
SPEDD | Latest scheduled finish date (forecast) | SPEDD | DATS | 8 | DATUM | ||||
SPEDZ | Latest scheduled finish time (forecast) | SPEDZ | TIMS | 6 | ATIME | ||||
BEAZP | Unit of processing time (Forecast) | BEAZEP | UNIT | 3 | CUNIT | EINHEIT | |||
PUFGP | Total float (from forecast) | PPUFF_GESM | DEC | 3 | PUFFER | ||||
PUFFP | Free float (from forecast) | PPUFF_FREI | DEC | 3 | PUFFER | ||||
BEARP | Processing time (forecast) | PBEARZEIT | FLTP | 16(16) | CX_ZEIT | ||||
EPANF | Dispatched start date for operation | EPANF | DATS | 8 | DATUM | ||||
EPANZ | Dispatched start time for operation | EPANZ | TIMS | 6 | ATIME | ||||
EPEND | Dispatched finish date | EPEND | DATS | 8 | DATUM | ||||
EPENZ | Dispatched finish time | EPENZ | TIMS | 6 | ATIME | ||||
PDAU | Forecasted duration of activity from confirmation | PDAU | QUAN | 5(1) | DAUER_4_1 | ||||
PDAE | Unit of the forecasted duration from the confirmation | PDAE | UNIT | 3 | T006 | CUNIT | MEINS | ||
KNOTE | Transportation Connection Points | KNOTE | CHAR | 10 | TVKN | KNOTN | |||
VSTZW | Deadline function | VSTZW | CHAR | 4 | TVTZ | VSTZW | |||
VSTGA | Deadline deviation reason | VSTGA | CHAR | 4 | TVTG | VSTGA | |||
QRASTZEHT | Time Unit | QRASTZEHT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QRASTZFAK | Time Factor | QRASTZFAK | DEC | 5(2) | QPROBEFAK | ||||
QRASTMENG | Quantity Between Two Inspections | QRASTMENG | QUAN | 13(3) | MENG13 | ||||
QRASTEREH | Grid Unit of Measure | QRASTEREH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AUFKT | Execution Factor | AFAKT | DEC | 3 | AFAKT | ||||
RMNGA | Total confirmed rework quantity | RMNGA | QUAN | 13(3) | MENGV13 | ||||
ILE01 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE02 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE03 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE04 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE05 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ILE06 | Unit of measure for the activity to be confirmed | CO_ISMNGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RWFAK | Rework factor (is not used yet) | RWFAK | DEC | 5(3) | AUSCHUFAK | ||||
IPRZ1 | Confirmed quantity/work for business process | CO_IPRZS | QUAN | 13(3) | MENGV13 | ||||
IPRE1 | Unit of measurement for conf. quantity for business process | RU_IPRZE | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IPRK1 | No remaining quantity expected for business process | RU_IPRZK | CHAR | 1 | XFELD | ||||
TAKT | takt within a line segment | LD_TAKT | NUMC | 4 | LD_TAKT | ||||
OPRZ1 | Remaining quantity for business process | OPRZ1 | QUAN | 13(3) | MENGV13 | ||||
OPRE1 | Unit for remaining quantity of business process | OPRE1 | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PSPM_INDICATOR | Indicates PMCS date influence activity scheduling | PSPM_INDICATOR | CHAR | 1 | PSPM_INDICATOR |
Key field | Non-key field |
How do I retrieve data from SAP table AFVV using ABAP code
The following ABAP code Example will allow you to do a basic selection on AFVV to SELECT all data from the tableDATA: WA_AFVV TYPE AFVV.
SELECT SINGLE *
FROM AFVV
INTO CORRESPONDING FIELDS OF WA_AFVV
WHERE...
How to access SAP table AFVV
Within an ECC or HANA version of SAP you can also view further information about AFVV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects