AFVV SAP table for – DB structure of the quantities/dates/values in the operation

Here we would like to draw your attention to AFVV table in SAP. As we know it is being mainly used with the SAP PP-SFC (Production Orders – PP) component which is coming under PP module (Production Planning). AFVV is a SAP standard transparent table used for storing DB structure of the quantities/dates/values in the operation related data in SAP. It comes under the package CO.

SAP AFVV table

Table AFVV technical data

TableAFVV
Data storingDB structure of the quantities/dates/values in the operation
ModulePP
ComponentPP-SFC
SAP PackageCO
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFVV Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AFVV table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ZEIER : Unit for the break time
    Its data type is C (Character String) with field length 3
  • PEDZ : Forecast finish time of operation from confirmation
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PUFFR : Free float
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • PUFGS : Total float
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • NTANF : Constraint for activity start (Basic)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NTANZ : Constraint for activity start time (Basic)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • NTEND : Constraint for finish of activity (Basic)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • NTENZ : Basic finish time of the activity
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • EWSTD : Forecasted start date for the activity
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EWSTZ : Forecast start time of the activity
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • EWEND : Forecast finish date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VGE01 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • EWENZ : Forecast finish time for the activity
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • EWDAN : Normal duration (from forecast) of activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EWDNE : Unit for forecast normal duration
    Its data type is C (Character String) with field length 3
  • EWDAM : Minimum duration (from forecast) for activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EWDME : Unit for forecast minimum duration
    Its data type is C (Character String) with field length 3
  • EWSTE : Forecast date constraint on activity finish
    Its data type is C (Character String) with field length 1
  • EWSTA : Forecast date constraint on activity start
    Its data type is C (Character String) with field length 1
  • WARTZ : Queue time used for scheduling
    Its data type is F (Floating point number) with field length 8
  • WRTZE : Unit of measure for queue time
    Its data type is C (Character String) with field length 3
  • RUEST : Setup time
    Its data type is F (Floating point number) with field length 8
  • VGW01 : Standard Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • RSTZE : Unit of measure for setup time
    Its data type is C (Character String) with field length 3
  • BEARZ : Processing time
    Its data type is F (Floating point number) with field length 8
  • BEAZE : Unit of measure for processing time
    Its data type is C (Character String) with field length 3
  • ABRUE : Teardown
    Its data type is F (Floating point number) with field length 8
  • ARUZE : Unit of measure for teardown
    Its data type is C (Character String) with field length 3
  • LIEGZ : Wait time used for scheduling
    Its data type is F (Floating point number) with field length 8
  • LIGZE : Unit of measure for wait time
    Its data type is C (Character String) with field length 3
  • TRANZ : Move time used for scheduling
    Its data type is F (Floating point number) with field length 8
  • TRAZE : Unit of measure for move time
    Its data type is C (Character String) with field length 3
  • ISERH : Confirmed break time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • VGE02 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • OFM01 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFM02 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFM03 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFM04 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFM05 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFM06 : Forecast value used to update the standard value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFMNW : Forecasted work (actual + remaining)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • BZOFFB : Reference date for start of sub-operation
    Its data type is C (Character String) with field length 2
  • EHOFFB : Unit for offset to start
    Its data type is C (Character String) with field length 3
  • OFFSTB : Offset to sub-operation start
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VGW02 : Standard Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • OFFSTE : Offset to sub-operation finish
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • BZOFFE : Reference date for finish of sub-operation
    Its data type is C (Character String) with field length 2
  • EHOFFE : Unit for offset to finish
    Its data type is C (Character String) with field length 3
  • FPAVD : Earliest scheduled start date (forecast)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FPAVZ : Earliest scheduled start time (forecast)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FPEDD : Earliest scheduled finish date (forecast)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FPEDZ : Earliest scheduled finish time (forecast)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SPAVD : Latest scheduled start date (forecast)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SPAVZ : Latest scheduled start time (forecast)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SPEDD : Latest scheduled finish date (forecast)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VGE03 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • SPEDZ : Latest scheduled finish time (forecast)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • BEAZP : Unit of processing time (Forecast)
    Its data type is C (Character String) with field length 3
  • PUFGP : Total float (from forecast)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • PUFFP : Free float (from forecast)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • BEARP : Processing time (forecast)
    Its data type is F (Floating point number) with field length 8
  • EPANF : Dispatched start date for operation
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EPANZ : Dispatched start time for operation
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • EPEND : Dispatched finish date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • EPENZ : Dispatched finish time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PDAU : Forecasted duration of activity from confirmation
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VGW03 : Standard Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • PDAE : Unit of the forecasted duration from the confirmation
    Its data type is C (Character String) with field length 3
  • KNOTE : Transportation Connection Points
    Its data type is C (Character String) with field length 10
  • VSTZW : Deadline function
    Its data type is C (Character String) with field length 4
  • VSTGA : Deadline deviation reason
    Its data type is C (Character String) with field length 4
  • QRASTZEHT : Time Unit
    Its data type is C (Character String) with field length 3
  • QRASTZFAK : Time Factor
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • QRASTMENG : Quantity Between Two Inspections
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • QRASTEREH : Grid Unit of Measure
    Its data type is C (Character String) with field length 3
  • AUFKT : Execution Factor
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • RMNGA : Total confirmed rework quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VGE04 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • ILE01 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ILE02 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ILE03 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ILE04 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ILE05 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • ILE06 : Unit of measure for the activity to be confirmed
    Its data type is C (Character String) with field length 3
  • RWFAK : Rework factor (is not used yet)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • IPRZ1 : Confirmed quantity/work for business process
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • IPRE1 : Unit of measurement for conf. quantity for business process
    Its data type is C (Character String) with field length 3
  • IPRK1 : No remaining quantity expected for business process
    Its data type is C (Character String) with field length 1
  • VGW04 : Standard Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • TAKT : takt within a line segment
    Its data type is N (Character String with Digits Only) with field length 4
  • OPRZ1 : Remaining quantity for business process
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • OPRE1 : Unit for remaining quantity of business process
    Its data type is C (Character String) with field length 3
  • VGE05 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • AUFPL : Routing number of operations in the order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • VGW05 : Standard Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • VGE06 : Unit of measure for the standard value
    Its data type is C (Character String) with field length 3
  • VGW06 : Standard Value
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ZEIMU : Unit for the minimum overlap time
    Its data type is C (Character String) with field length 3
  • ZMINU : Minimum overlap time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • MINWE : Minimum Send-Ahead Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ZEIMB : Unit for the minimum processing time
    Its data type is C (Character String) with field length 3
  • ZMINB : Minimum processing time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ZEILM : Unit for the maximum wait time
    Its data type is C (Character String) with field length 3
  • ZLMAX : Maximum wait time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • APLZL : General counter for order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • ZEILP : Unit for the required wait time
    Its data type is C (Character String) with field length 3
  • ZLPRO : Minimum wait time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ZEIWN : Unit for the standard queue time
    Its data type is C (Character String) with field length 3
  • ZWNOR : Standard queue time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ZEIWM : Unit for the minumum queue time
    Its data type is C (Character String) with field length 3
  • ZWMIN : Minimum queue time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ZEITN : Unit for the standard move time
    Its data type is C (Character String) with field length 3
  • ZTNOR : Standard move time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ZEITM : Unit for the minimum move time
    Its data type is C (Character String) with field length 3
  • ZTMIN : Minimum move time
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • .INCLUDE : Include structure of the operation quantities/dates/values
    Its include structure/component is is AFVVI
  • PLIFZ : Planned delivery time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • DAUNO : Normal duration of the activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • DAUNE : Normal duration/unit
    Its data type is C (Character String) with field length 3
  • DAUMI : Minimum activity duration
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • DAUME : Unit for the minimum duration
    Its data type is C (Character String) with field length 3
  • EINSA : Constraint on the basic start date for the activity
    Its data type is C (Character String) with field length 1
  • EINSE : Constraint on the finish date of the activity
    Its data type is C (Character String) with field length 1
  • ARBEI : Work involved in the activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 4
  • ARBEH : Unit for work
    Its data type is C (Character String) with field length 3
  • MGVRG : Operation Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINH : Unit of measure for activity
    Its data type is C (Character String) with field length 3
  • ASVRG : Operation scrap
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMNGA : Total Yield Confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • XMNGA : Total scrap quantity confirmed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GMNGA : Confirmed yield in order unit of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ISM01 : Previously confirmed activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ISM02 : Previously confirmed activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ISM03 : Previously confirmed activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ISM04 : Previously confirmed activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ISM05 : Previously confirmed activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ISM06 : Previously confirmed activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • UMREN : Denominator for converting rtg and op units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • ISMNW : Actual work
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • FSAVD : Earliest scheduled start: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSAVZ : Earliest scheduled start: Execution (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FSSBD : Earliest scheduled start: Processing (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSSBZ : Earliest scheduled start: Processing (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FSSAD : Earliest scheduled start: Teardown (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSSAZ : Earliest scheduled start: Teardown (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FSEDD : Earliest scheduled finish: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSEDZ : Earliest scheduled finish: Execution (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FSSLD : Earliest scheduled start: Wait (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UMREZ : Numerator for converting task list and oper. un. of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • FSSLZ : Earliest scheduled start: Wait (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FSELD : Earliest scheduled finish: Wait (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSELZ : Earliest scheduled finish: Wait (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSAVD : Latest scheduled start: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSAVZ : Latest scheduled start: Execution (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSSBD : Latest scheduled start: Processing (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSSBZ : Latest scheduled start: Processing (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSSAD : Latest scheduled start: Teardown (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSSAZ : Latest scheduled start: Teardown (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSEDD : Latest scheduled finish: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BMSCH : Base Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SSEDZ : Latest scheduled finish: Execution (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSSLD : Latest scheduled start: Wait time (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSSLZ : Latest scheduled start: Wait time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSELD : Latest scheduled finish: Wait time (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSELZ : Latest scheduled finish: Wait time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ISAVD : Actual operation start (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEAVD : Actual finish of operation (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISDD : Actual start: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISDZ : Actual start: Execution/setup (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IERD : Actual finish: Setup (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ZMERH : Break
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • IERZ : Actual finish: Setup (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ISBD : Actual start: Processing (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISBZ : Actual start: Processing (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IEBD : Actual finish: Processing (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEBZ : Actual processing finish (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ISAD : Actual start: Teardown (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ISAZ : Actual start: Teardown (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • IEDD : Actual finish: Execution (date)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • IEDZ : Actual finish: Execution (time)
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • PEDD : Forecast finish date of operation from confirmation
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.