Follow us on LinkedIn for your next SAP project

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 Possible values
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
EINSE
Constraint on the finish date of the activity
EINSCHRE
CHAR
1 0
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
EWSTA
Forecast date constraint on activity start
PS_RESTA
CHAR
1 0
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
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 MANDT AFVC
Operation within an order
MANDT
AFVV APLZL AFVV AUFPL AFVC
Operation within an order
AUFPL
AFVV APLZL AFVV APLZL AFVC
Operation within an order
APLZL
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 AFVKI MANDT T006
Units of Measurement
MANDT
AFVV DAUME AFVV DAUME T006
Units of Measurement
MSEHI
AFVV DAUNE AFVKI MANDT T006
Units of Measurement
MANDT
AFVV DAUNE AFVV DAUNE T006
Units of Measurement
MSEHI
AFVV EHOFFB AFVV EHOFFB T006
Units of Measurement
MSEHI
AFVV EHOFFB AFVKI MANDT T006
Units of Measurement
MANDT
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 SYST MANDT TVKN
Routes: Transportation Connection Points
MANDT
AFVV KNOTE AFVV KNOTE TVKN
Routes: Transportation Connection Points
KNOTE
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 AFVKI MANDT T006
Units of Measurement
MANDT
AFVV VGE01 AFVV VGE01 T006
Units of Measurement
MSEHI
AFVV VGE02 AFVKI MANDT T006
Units of Measurement
MANDT
AFVV VGE02 AFVV VGE02 T006
Units of Measurement
MSEHI
AFVV VGE03 AFVV VGE03 T006
Units of Measurement
MSEHI
AFVV VGE03 AFVKI MANDT T006
Units of Measurement
MANDT
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 AFVV VSTZW TVTZ
Deadline Functions
VSTZW
AFVV VSTZW SYST MANDT TVTZ
Deadline Functions
MANDT
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 AFVKI MANDT T006
Units of Measurement
MANDT
AFVV ZEILP AFVV ZEILP T006
Units of Measurement
MSEHI
AFVV ZEIMB AFVKI MANDT T006
Units of Measurement
MANDT
AFVV ZEIMB AFVV ZEIMB T006
Units of Measurement
MSEHI
AFVV ZEIMU AFVV ZEIMU T006
Units of Measurement
MSEHI
AFVV ZEIMU AFVKI MANDT T006
Units of Measurement
MANDT
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