1. SAP Tutorial
  2. PP Module

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

    • AFVV related tables

    • AFVU : DB structure of the user fields of the operation
    • TCO63 : Sequence of detail screens when maintaining components
    • AFPO : Order item
    • TCOFST : Texts for Missing Parts Info System: Sort Criteria
    • TC62 : Sequence of detail screens when processing header externally
    • TCOAOB : Profile order progress report: Displayed fields objects
    • T496N : CIM order: List descriptions
    • TCOP : Field selection profile
    • TCOPT : Description of Profile for Field Selection
    • TCO61 : Sequence key for PP orders
    • TDUMMY : Dummy structure of a table for READ with VERSION
    • T490 : Transactions PP – orders – order category
    • T496P : Print PP documents: Determination of output device
    • T496V : PP Print: Default Value for Printing Online or Background
    • T024F : Production scheduler
    • TCOKT : Account assignment categories for order
    • TCOFT : Texts for Missing Parts Info System
    • T496D : CIM: Destination/lists/spool parameters per user/plant
    • TCOAOBT : Profile order progress report: Displayed fields objs (Text)
    • TCO09 : CIM order: Text IDs of objects in orders

    AFVV related transaction codes under SAP package CO

    • CO03S : Display simulation order
    • COTF : Comm. File Missing Parts Info System
    • CO10 : Production order with project
    • CB85 : Maint. Print Control for Proc. Ords
    • COS4 : Sort profiles – maintain proc. order
    • CO03 : Display Production Order
    • CO01 : Create production order
    • CO08 : Production order with sales order
    • COPAWA : Pack components for order
    • CO01S : Adding simulation order
    • CO05 : Collective Release of Prod. Orders
    • COW1 : Production Order Workplace
    • CORU : Maintain prod. scheduler group
    • COSS : Transport of C Tables
    • CO81 : Number assignment: routing to order
    • MB26 : Picking list
    • CO82 : Number ranges for orders
    • CO80 : Number range maintenance: AUF_RUECK
    • CO02S : Change simulation order
    • COWBHUWA : GI HU for Production Order

    Related References

    Related Tutorials

    VSAFVV_CN SAP table for – Version: Quantities/Dates/Values in order operation

    VSAFVV_CN table in SAP PS (Simulation in PS) module. This tables is used for storing data of Version: Quantities/Dates/Values in...

    AFRD SAP table for – Default values for collective confirmation

    AFRD table in SAP PP (Production Orders - PP) module. This tables is used for storing data of Default values...

    AFVU SAP table for – DB structure of the user fields of the operation

    AFVU table in SAP PP (Production Orders - PP) module. This tables is used for storing data of DB structure...

    KBEZ SAP table for – Add. data for table KBED (for indiv. capacities/splits)

    KBEZ table in SAP PP (Capacity Requirements Planning - PP) module. This tables is used for storing data of Add....

    AFFH SAP table for – PRT assignment data for the work order

    AFFH table in SAP PP (Basic Data - PP) module. This tables is used for storing data of PRT assignment...

    MCSFIS SAP table for – R/2 SFIS Data: Old

    MCSFIS table in SAP PP (Information System - PP) module. This tables is used for storing data of R/2 SFIS...

    AFRP0 SAP table for – Table of planned changes for confirmation (PDC)

    AFRP0 table in SAP PP (Production Orders - PP) module. This tables is used for storing data of Table of...

    «
    »