VSAFVV_CN SAP (Version: Quantities/Dates/Values in order operation) Table details
Description: Version: Quantities/Dates/Values in order operation
Table field list including key, data, relationships and ABAP select examples
VSAFVV_CN is a standard SAP Table which is used to store Version: Quantities/Dates/Values in order operation data and is available within R/3 SAP systems depending on the version and release level.
The VSAFVV_CN table consists of various fields, each holding specific information or linking keys about Version: Quantities/Dates/Values in order operation data available in SAP. These include VSNMR (Number or description of a version), AUFPL (Routing number of operations in the order), APLZL (General counter for order), MEINH (Unit of Measure for Activity/Operation).. 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 VSAFVV_CN 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 | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
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 VSAFVV_CN using ABAP code
The following ABAP code Example will allow you to do a basic selection on VSAFVV_CN to SELECT all data from the tableDATA: WA_VSAFVV_CN TYPE VSAFVV_CN.
SELECT SINGLE *
FROM VSAFVV_CN
INTO CORRESPONDING FIELDS OF WA_VSAFVV_CN
WHERE...
How to access SAP table VSAFVV_CN
Within an ECC or HANA version of SAP you can also view further information about VSAFVV_CN 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