1. Home
  2. Resources
  3. SAP Tables
  4. AFVV - DB structure of the quantities/dates/values in the operation

SAP Table AFVV

DB structure of the quantities/dates/values in the operation

AFVV (DB structure of the quantities/dates/values in the operation) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFVV to other SAP tables.

AFVV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL General counter for order CO_APLZL AFVC NUMC 8 0
MEINH Unit of Measure for Activity/Operation VORME T006 UNIT 3 0
UMREN Denominator for converting rtg and op units of measure CP_UMREN DEC 5 0
UMREZ Numerator for converting task list and oper. un. of measure CP_UMREZ DEC 5 0
BMSCH Base Quantity BMSCH QUAN 13 3
ZMERH Break DZMERH QUAN 9 3
ZEIER Unit for the break time DZEIER T006 UNIT 3 0
VGE01 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
VGW01 Standard Value VGWRT QUAN 9 3
VGE02 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
VGW02 Standard Value VGWRT QUAN 9 3
VGE03 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
VGW03 Standard Value VGWRT QUAN 9 3
VGE04 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
VGW04 Standard Value VGWRT QUAN 9 3
VGE05 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
VGW05 Standard Value VGWRT QUAN 9 3
VGE06 Unit of measure for the standard value VGWRTEH T006 UNIT 3 0
VGW06 Standard Value VGWRT QUAN 9 3
ZEIMU Unit for the minimum overlap time DZEIMU T006 UNIT 3 0
ZMINU Minimum overlap time DZMINU QUAN 9 3
MINWE Minimum Send-Ahead Quantity MINWEI QUAN 13 3
ZEIMB Unit for the minimum processing time DZEIMB T006 UNIT 3 0
ZMINB Minimum processing time DZMINB QUAN 9 3
ZEILM Unit for the maximum wait time DZEILM T006 UNIT 3 0
ZLMAX Maximum wait time DZLMAX QUAN 9 3
ZEILP Unit for the required wait time DZEILP T006 UNIT 3 0
ZLPRO Minimum wait time DZLPRO QUAN 9 3
ZEIWN Unit for the standard queue time DZEIWN T006 UNIT 3 0
ZWNOR Standard queue time DZWNOR QUAN 9 3
ZEIWM Unit for the minumum queue time DZEIWM T006 UNIT 3 0
ZWMIN Minimum queue time DZWMIN QUAN 9 3
ZEITN Unit for the standard move time DZEITN T006 UNIT 3 0
ZTNOR Standard move time DZTNOR QUAN 9 3
ZEITM Unit for the minimum move time DZEITM T006 UNIT 3 0
ZTMIN Minimum move time DZTMIN QUAN 9 3
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
DAUNO Normal duration of the activity DAUNOR QUAN 5 1
DAUNE Normal duration/unit DAUNORE T006 UNIT 3 0
DAUMI Minimum activity duration DAUMIN QUAN 5 1
DAUME Unit for the minimum duration DAUMINE T006 UNIT 3 0
EINSA Constraint on the basic start date for the activity EINSCHRA CHAR 1 0
1 Must start on
2 Cannot start before
3 Cannot start later
5 Start from resource planning
EINSE Constraint on the finish date of the activity EINSCHRE CHAR 1 0
1 Must finish on
2 Cannot finish before
3 Finish not later
4 Finish from confirmation
NULL
ARBEI Work involved in the activity ARBEIT QUAN 7 1
ARBEH Unit for work ARBEITE T006 UNIT 3 0
MGVRG Operation Quantity MGVRG QUAN 13 3
ASVRG Operation scrap ASVRG QUAN 13 3
LMNGA Total Yield Confirmed LMNGA QUAN 13 3
XMNGA Total scrap quantity confirmed XMNGA QUAN 13 3
GMNGA Confirmed yield in order unit of measure GMNGA QUAN 13 3
ISM01 Previously confirmed activity CO_RUMNG QUAN 13 3
ISM02 Previously confirmed activity CO_RUMNG QUAN 13 3
ISM03 Previously confirmed activity CO_RUMNG QUAN 13 3
ISM04 Previously confirmed activity CO_RUMNG QUAN 13 3
ISM05 Previously confirmed activity CO_RUMNG QUAN 13 3
ISM06 Previously confirmed activity CO_RUMNG QUAN 13 3
ISMNW Actual work CO_ISMNW QUAN 13 3
FSAVD Earliest scheduled start: Execution (date) FSAVD DATS 8 0
FSAVZ Earliest scheduled start: Execution (time) FSAVZ TIMS 6 0
FSSBD Earliest scheduled start: Processing (date) FSSBD DATS 8 0
FSSBZ Earliest scheduled start: Processing (time) FSSBZ TIMS 6 0
FSSAD Earliest scheduled start: Teardown (date) FSSAD DATS 8 0
FSSAZ Earliest scheduled start: Teardown (time) FSSAZ TIMS 6 0
FSEDD Earliest scheduled finish: Execution (date) FSEDD DATS 8 0
FSEDZ Earliest scheduled finish: Execution (time) FSEDZ TIMS 6 0
FSSLD Earliest scheduled start: Wait (date) FSSLD DATS 8 0
FSSLZ Earliest scheduled start: Wait (time) FSSLZ TIMS 6 0
FSELD Earliest scheduled finish: Wait (date) FSELD DATS 8 0
FSELZ Earliest scheduled finish: Wait (time) FSELZ TIMS 6 0
SSAVD Latest scheduled start: Execution (date) SSAVD DATS 8 0
SSAVZ Latest scheduled start: Execution (time) SSAVZ TIMS 6 0
SSSBD Latest scheduled start: Processing (date) SSSBD DATS 8 0
SSSBZ Latest scheduled start: Processing (time) SSSBZ TIMS 6 0
SSSAD Latest scheduled start: Teardown (date) SSSAD DATS 8 0
SSSAZ Latest scheduled start: Teardown (time) SSSAZ TIMS 6 0
SSEDD Latest scheduled finish: Execution (date) SSEDD DATS 8 0
SSEDZ Latest scheduled finish: Execution (time) SSEDZ TIMS 6 0
SSSLD Latest scheduled start: Wait time (date) SSSLD DATS 8 0
SSSLZ Latest scheduled start: Wait time SSSLZ TIMS 6 0
SSELD Latest scheduled finish: Wait time (date) SSELD DATS 8 0
SSELZ Latest scheduled finish: Wait time SSELZ TIMS 6 0
ISAVD Actual operation start (date) ISAVD DATS 8 0
IEAVD Actual finish of operation (date) IEAVD DATS 8 0
ISDD Actual start: Execution (date) ISDD DATS 8 0
ISDZ Actual start: Execution/setup (time) ISDZ TIMS 6 0
IERD Actual finish: Setup (date) IERD DATS 8 0
IERZ Actual finish: Setup (time) IERZ TIMS 6 0
ISBD Actual start: Processing (date) ISBD DATS 8 0
ISBZ Actual start: Processing (time) ISBZ TIMS 6 0
IEBD Actual finish: Processing (date) IEBD DATS 8 0
IEBZ Actual processing finish (time) IEBZ TIMS 6 0
ISAD Actual start: Teardown (date) ISAD DATS 8 0
ISAZ Actual start: Teardown (time) ISAZ TIMS 6 0
IEDD Actual finish: Execution (date) IEDD DATS 8 0
IEDZ Actual finish: Execution (time) IEDZ TIMS 6 0
PEDD Forecast finish date of operation from confirmation CO_PEDD DATS 8 0
PEDZ Forecast finish time of operation from confirmation CO_PEDZ TIMS 6 0
PUFFR Free float PUFFR_FREI DEC 3 0
PUFGS Total float PUFFR_GESM DEC 3 0
NTANF Constraint for activity start (Basic) VORGABESTD DATS 8 0
NTANZ Constraint for activity start time (Basic) VORGABESTZ TIMS 6 0
NTEND Constraint for Finish of Activity (Basic) VORGABEEND2 DATS 8 0
NTENZ Basic finish time of the activity VORGABEENZ TIMS 6 0
EWSTD Forecasted start date for the activity EWSTARTD DATS 8 0
EWSTZ Forecast start time of the activity EWSTARTZ TIMS 6 0
EWEND Forecast finish date EWENDED DATS 8 0
EWENZ Forecast finish time for the activity EWENDEZ TIMS 6 0
EWDAN Normal duration (from forecast) of activity EWDAN QUAN 5 1
EWDNE Unit for forecast normal duration EWDNE T006 UNIT 3 0
EWDAM Minimum duration (from forecast) for activity EWDAM QUAN 5 1
EWDME Unit for forecast minimum duration EWDME T006 UNIT 3 0
EWSTE Forecast date constraint on activity finish PS_RESTE CHAR 1 0
1 Must finish on
2 Cannot finish before
3 Finish not later
4 Finish from confirmation
NULL
EWSTA Forecast date constraint on activity start PS_RESTA CHAR 1 0
1 Must start on
2 Cannot start before
3 Cannot start later
5 Start from resource planning
WARTZ Queue time used for scheduling WARTEZEIT FLTP 16 16
WRTZE Unit of measure for queue time WTRZE UNIT 3 0
RUEST Setup time RUEST FLTP 16 16
RSTZE Unit of measure for setup time RSTZE UNIT 3 0
BEARZ Processing time BEARZEIT FLTP 16 16
BEAZE Unit of measure for processing time BEAZE UNIT 3 0
ABRUE Teardown ABRUE FLTP 16 16
ARUZE Unit of measure for teardown ARUZE UNIT 3 0
LIEGZ Wait time used for scheduling LIEGEZEIT FLTP 16 16
LIGZE Unit of measure for wait time LIGZE UNIT 3 0
TRANZ Move time used for scheduling TRANSZEIT FLTP 16 16
TRAZE Unit of measure for move time TRAZE UNIT 3 0
ISERH Confirmed break time ISERH QUAN 9 3
OFM01 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFM02 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFM03 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFM04 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFM05 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFM06 Forecast value used to update the standard value CO_SCHAETZ QUAN 9 3
OFMNW Forecasted work (actual + remaining) OFMNW QUAN 7 1
BZOFFB Reference date for start of sub-operation CP_OBZOFFB TCA54 CHAR 2 0
EHOFFB Unit for offset to start CP_OEHOFFB T006 UNIT 3 0
OFFSTB Offset to sub-operation start CP_OOFFSTB QUAN 5 0
OFFSTE Offset to sub-operation finish CP_OOFFSTE QUAN 5 0
BZOFFE Reference date for finish of sub-operation CP_OBZOFFE TCA54 CHAR 2 0
EHOFFE Unit for offset to finish CP_OEHOFFE T006 UNIT 3 0
FPAVD Earliest scheduled start date (forecast) FPAVD DATS 8 0
FPAVZ Earliest scheduled start time (forecast) FPAVZ TIMS 6 0
FPEDD Earliest scheduled finish date (forecast) FPEDD DATS 8 0
FPEDZ Earliest scheduled finish time (forecast) FPEDZ TIMS 6 0
SPAVD Latest scheduled start date (forecast) SPAVD DATS 8 0
SPAVZ Latest scheduled start time (forecast) SPAVZ TIMS 6 0
SPEDD Latest scheduled finish date (forecast) SPEDD DATS 8 0
SPEDZ Latest scheduled finish time (forecast) SPEDZ TIMS 6 0
BEAZP Unit of processing time (Forecast) BEAZEP UNIT 3 0
PUFGP Total float (from forecast) PPUFF_GESM DEC 3 0
PUFFP Free float (from forecast) PPUFF_FREI DEC 3 0
BEARP Processing time (forecast) PBEARZEIT FLTP 16 16
EPANF Dispatched start date for operation EPANF DATS 8 0
EPANZ Dispatched start time for operation EPANZ TIMS 6 0
EPEND Dispatched finish date EPEND DATS 8 0
EPENZ Dispatched finish time EPENZ TIMS 6 0
PDAU Forecasted duration of activity from confirmation PDAU QUAN 5 1
PDAE Unit of the forecasted duration from the confirmation PDAE T006 UNIT 3 0
KNOTE Transportation Connection Points KNOTE TVKN CHAR 10 0
VSTZW Deadline function VSTZW TVTZ CHAR 4 0
VSTGA Deadline deviation reason VSTGA TVTG CHAR 4 0
QRASTZEHT Time Unit QRASTZEHT UNIT 3 0
QRASTZFAK Time Factor QRASTZFAK DEC 5 2
QRASTMENG Quantity Between Two Inspections QRASTMENG QUAN 13 3
QRASTEREH Grid Unit of Measure QRASTEREH UNIT 3 0
AUFKT Execution Factor AFAKT DEC 3 0
RMNGA Total confirmed rework quantity RMNGA QUAN 13 3
ILE01 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ILE02 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ILE03 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ILE04 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ILE05 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
ILE06 Unit of measure for the activity to be confirmed CO_ISMNGEH UNIT 3 0
RWFAK Rework factor (is not used yet) RWFAK DEC 5 3
IPRZ1 Confirmed quantity/work for business process CO_IPRZS QUAN 13 3
IPRE1 Unit of measurement for conf. quantity for business process RU_IPRZE UNIT 3 0
IPRK1 No remaining quantity expected for business process RU_IPRZK CHAR 1 0
X Yes
NULL No
TAKT takt within a line segment LD_TAKT NUMC 4 0
OPRZ1 Remaining quantity for business process OPRZ1 QUAN 13 3
OPRE1 Unit for remaining quantity of business process OPRE1 UNIT 3 0
PSPM_INDICATOR Indicates PMCS date influence activity scheduling PSPM_INDICATOR CHAR 1 0

AFVV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFVV APLZL AFVV APLZL AFVC Operation within an order APLZL
AFVV APLZL AFVV MANDT AFVC Operation within an order MANDT
AFVV APLZL AFVV AUFPL AFVC Operation within an order AUFPL
AFVV ARBEH AFVKI MANDT T006 Units of Measurement MANDT
AFVV ARBEH AFVV ARBEH T006 Units of Measurement MSEHI
AFVV BZOFFB AFVV BZOFFB TCA54 Key for reference dates used in offset scheduling BZOFF
AFVV BZOFFE AFVV BZOFFE TCA54 Key for reference dates used in offset scheduling BZOFF
AFVV DAUME AFVV DAUME T006 Units of Measurement MSEHI
AFVV DAUME AFVKI MANDT T006 Units of Measurement MANDT
AFVV DAUNE AFVKI MANDT T006 Units of Measurement MANDT
AFVV DAUNE AFVV DAUNE T006 Units of Measurement MSEHI
AFVV EHOFFB AFVKI MANDT T006 Units of Measurement MANDT
AFVV EHOFFB AFVV EHOFFB T006 Units of Measurement MSEHI
AFVV EHOFFE AFVKI MANDT T006 Units of Measurement MANDT
AFVV EHOFFE AFVV EHOFFE T006 Units of Measurement MSEHI
AFVV EWDME AFVVK MANDT T006 Units of Measurement MANDT
AFVV EWDME AFVV EWDME T006 Units of Measurement MSEHI
AFVV EWDNE AFVVK MANDT T006 Units of Measurement MANDT
AFVV EWDNE AFVV EWDNE T006 Units of Measurement MSEHI
AFVV KNOTE AFVV KNOTE TVKN Routes: Transportation Connection Points KNOTE
AFVV KNOTE SYST MANDT TVKN Routes: Transportation Connection Points MANDT
AFVV MANDT AFVV MANDT T000 Clients MANDT
AFVV MEINH AFVKI MANDT T006 Units of Measurement MANDT
AFVV MEINH AFVV MEINH T006 Units of Measurement MSEHI
AFVV PDAE AFVGK MANDT T006 Units of Measurement MANDT
AFVV PDAE AFVV PDAE T006 Units of Measurement MSEHI
AFVV VGE01 AFVV VGE01 T006 Units of Measurement MSEHI
AFVV VGE01 AFVKI MANDT T006 Units of Measurement MANDT
AFVV VGE02 AFVKI MANDT T006 Units of Measurement MANDT
AFVV VGE02 AFVV VGE02 T006 Units of Measurement MSEHI
AFVV VGE03 AFVKI MANDT T006 Units of Measurement MANDT
AFVV VGE03 AFVV VGE03 T006 Units of Measurement MSEHI
AFVV VGE04 AFVKI MANDT T006 Units of Measurement MANDT
AFVV VGE04 AFVV VGE04 T006 Units of Measurement MSEHI
AFVV VGE05 AFVKI MANDT T006 Units of Measurement MANDT
AFVV VGE05 AFVV VGE05 T006 Units of Measurement MSEHI
AFVV VGE06 AFVKI MANDT T006 Units of Measurement MANDT
AFVV VGE06 AFVV VGE06 T006 Units of Measurement MSEHI
AFVV VSTGA SYST MANDT TVTG Reasons for Date Deviation MANDT
AFVV VSTGA AFVV VSTGA TVTG Reasons for Date Deviation VSTGA
AFVV VSTZW SYST MANDT TVTZ Deadline Functions MANDT
AFVV VSTZW AFVV VSTZW TVTZ Deadline Functions VSTZW
AFVV ZEIER AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEIER AFVV ZEIER T006 Units of Measurement MSEHI
AFVV ZEILM AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEILM AFVV ZEILM T006 Units of Measurement MSEHI
AFVV ZEILP AFVV ZEILP T006 Units of Measurement MSEHI
AFVV ZEILP AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEIMB AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEIMB AFVV ZEIMB T006 Units of Measurement MSEHI
AFVV ZEIMU AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEIMU AFVV ZEIMU T006 Units of Measurement MSEHI
AFVV ZEITM AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEITM AFVV ZEITM T006 Units of Measurement MSEHI
AFVV ZEITN AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEITN AFVV ZEITN T006 Units of Measurement MSEHI
AFVV ZEIWM AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEIWM AFVV ZEIWM T006 Units of Measurement MSEHI
AFVV ZEIWN AFVKI MANDT T006 Units of Measurement MANDT
AFVV ZEIWN AFVV ZEIWN T006 Units of Measurement MSEHI