AFVC SAP table for – Operation within an order

Here we would like to draw your attention to AFVC 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). AFVC is a SAP standard transparent table used for storing Operation within an order related data in SAP. It comes under the package CO.

SAP AFVC table

Table AFVC technical data

TableAFVC
Data storingOperation within an order
ModulePP
ComponentPP-SFC
SAP PackageCO
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AFVC 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 AFVC table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PLNNR : Key for Task List Group
    Its data type is C (Character String) with field length 8
  • ISTTY : BOM Category
    Its data type is C (Character String) with field length 1
  • ISTNR : Bill of Material
    Its data type is C (Character String) with field length 8
  • ISTKN : BOM Item Node Number
    Its data type is N (Character String with Digits Only) with field length 8
  • ISTPO : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • IUPOZ : Subitem Number
    Its data type is C (Character String) with field length 4
  • EBORT : Installation Point for Subitem
    Its data type is C (Character String) with field length 20
  • VERTL : Distr.cap.reqmts (plant maint.,process order, network)
    Its data type is C (Character String) with field length 8
  • LEKNW : Indicator: No Remaining Work Expected
    Its data type is C (Character String) with field length 1
  • NPRIO : Priority
    Its data type is C (Character String) with field length 1
  • PVZKN : General counter for order
    Its data type is N (Character String with Digits Only) with field length 8
  • ZAEHL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • PHFLG : Indicator: Phase
    Its data type is C (Character String) with field length 1
  • PHSEQ : Control Recipe Destination
    Its data type is C (Character String) with field length 2
  • KNOBJ : Number of Object with Assigned Dependencies
    Its data type is N (Character String with Digits Only) with field length 18
  • ERFSICHT : Recording View
    Its data type is C (Character String) with field length 2
  • QPPKTABS : Flow Variants for Inspection Point Completion
    Its data type is C (Character String) with field length 1
  • OTYPE : Object Type
    Its data type is C (Character String) with field length 2
  • OBJEKTID : Object ID
    Its data type is N (Character String with Digits Only) with field length 8
  • QLKAPAR : Capacity category
    Its data type is C (Character String) with field length 3
  • RSTUF : Reduction level which reduces operation lead time
    Its data type is N (Character String with Digits Only) with field length 1
  • NPTXTKY : Internal text number (12-character)
    Its data type is C (Character String) with field length 12
  • VORNR : Operation/Activity Number
    Its data type is C (Character String) with field length 4
  • SUBSYS : Subsystem Identifier for QM Subsystem Interface
    Its data type is C (Character String) with field length 6
  • PSPNR : Standard WBS element
    Its data type is N (Character String with Digits Only) with field length 8
  • PACKNO : Package number
    Its data type is N (Character String with Digits Only) with field length 10
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • SCOPE : Object Class
    Its data type is C (Character String) with field length 2
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • NO_DISP : Effective for Materials Planning
    Its data type is C (Character String) with field length 1
  • QKZPRZEIT : Interval = Time (Time-Related)
    Its data type is C (Character String) with field length 1
  • QKZZTMG1 : Quantity Confirmation for Each Partial Lot
    Its data type is C (Character String) with field length 1
  • STEUS : Control key
    Its data type is C (Character String) with field length 4
  • QKZPRMENG : Creation Cycle = Quantity (Quantity-Reference)
    Its data type is C (Character String) with field length 1
  • QKZPRFREI : Interval Without Reference to Time or Quantity
    Its data type is C (Character String) with field length 1
  • KZFEAT : Indicator Is Not Used Currently
    Its data type is C (Character String) with field length 1
  • QKZTLSBEST : Operation with Stock-Related Partial Lot Assignment
    Its data type is C (Character String) with field length 1
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • CUOBJ_ARB : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • EVGEW : Aggregation weight for POC (PS progress)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • ARBII : Actual operating resources object identification
    Its data type is N (Character String with Digits Only) with field length 8
  • WERKI : Actual plant
    Its data type is C (Character String) with field length 4
  • CY_SEQNRV : Sequence number operation
    Its data type is N (Character String with Digits Only) with field length 14
  • ARBID : Object ID of the resource
    Its data type is N (Character String with Digits Only) with field length 8
  • KAPT_PUFFR : Operation floats after finite scheduling (in seconds)
    Its data type is X (Byte string) with field length 4
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is N (Character String with Digits Only) with field length 5
  • WEMPF : Goods recipient
    Its data type is C (Character String) with field length 12
  • ABLAD : Unloading Point
    Its data type is C (Character String) with field length 25
  • CLASF : Ind.: Take Activity Into Account for Project Summarization
    Its data type is C (Character String) with field length 1
  • FRUNV : Indicator: External procurement data incomplete
    Its data type is C (Character String) with field length 1
  • ZSCHL : Overhead key
    Its data type is C (Character String) with field length 6
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • SCHED_END : Ind.: Purchase requisition at activity finish date
    Its data type is C (Character String) with field length 1
  • PDEST : Printer for shop papers
    Its data type is C (Character String) with field length 4
  • NETZKONT : Indicator for the account assignment of a network(hdr/act.)
    Its data type is C (Character String) with field length 1
  • OWAER : Object currency for network activity
    Its data type is C (Character String) with field length 5
  • AFNAM : Name of requisitioner/requester
    Its data type is C (Character String) with field length 12
  • BEDNR : Requirement Tracking Number
    Its data type is C (Character String) with field length 10
  • KZFIX : Indicator: Purchasing info record data are fixed
    Its data type is C (Character String) with field length 1
  • PERNR : Personnel number
    Its data type is N (Character String with Digits Only) with field length 8
  • FRDLB : Indicator: Externally processed op. with subcontracting
    Its data type is C (Character String) with field length 1
  • QPART : Inspection Type
    Its data type is C (Character String) with field length 8
  • LOEKZ : Deletion flag
    Its data type is C (Character String) with field length 1
  • WKURS : Exchange Rate
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • PROD_ACT : Indicator: Activity is a production activity
    Its data type is C (Character String) with field length 1
  • FPLNR : Billing plan number / invoicing plan number
    Its data type is C (Character String) with field length 10
  • OBJTYPE : Change indicator
    Its data type is C (Character String) with field length 1
  • CH_PROC : Process that has lead to the change of an object
    Its data type is C (Character String) with field length 1
  • KLVAR : Costing Variant
    Its data type is C (Character String) with field length 4
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its data type is N (Character String with Digits Only) with field length 12
  • FORDN : Framework Order
    Its data type is C (Character String) with field length 10
  • FORDP : Item of framework order
    Its data type is N (Character String with Digits Only) with field length 5
  • MAT_PRKST : Material planning in networks: primary costs
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • PRZ01 : Business Process
    Its data type is C (Character String) with field length 12
  • KTSCH : Standard text key
    Its data type is C (Character String) with field length 7
  • LTXA1 : Operation short text
    Its data type is C (Character String) with field length 40
  • LTXA2 : Second line of the description
    Its data type is C (Character String) with field length 40
  • 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
  • TXTSP : Language Key
    Its data type is C (Character String) with field length 1
  • VPLTY : Type of the referenced task list
    Its data type is C (Character String) with field length 1
  • VPLNR : Group of the referenced task list
    Its data type is C (Character String) with field length 8
  • VPLAL : Group counter of the referenced task list
    Its data type is C (Character String) with field length 2
  • VPLFL : Referenced sequence in routing
    Its data type is C (Character String) with field length 6
  • VGWTS : Standard value key
    Its data type is C (Character String) with field length 4
  • LAR01 : Activity Type
    Its data type is C (Character String) with field length 6
  • LAR02 : Activity Type
    Its data type is C (Character String) with field length 6
  • LAR03 : Activity Type
    Its data type is C (Character String) with field length 6
  • LAR04 : Activity Type
    Its data type is C (Character String) with field length 6
  • APLZL : General counter for order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • LAR05 : Activity Type
    Its data type is C (Character String) with field length 6
  • LAR06 : Activity Type
    Its data type is C (Character String) with field length 6
  • ZERMA : Type of standard value calculation
    Its data type is C (Character String) with field length 5
  • ZGDAT : Date when the standard value was calculated
    Its data type is C (Character String) with field length 4
  • ZCODE : Reference number for standard value code
    Its data type is C (Character String) with field length 6
  • ZULNR : Basis for standard value calculation
    Its data type is C (Character String) with field length 5
  • LOANZ : Number of Time Tickets
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • LOART : Wage type
    Its data type is C (Character String) with field length 4
  • RSANZ : Number of confirmation slips
    Its data type is N (Character String with Digits Only) with field length 3
  • QUALF : Suitability
    Its data type is C (Character String) with field length 2
  • .INCLUDE : General include structure of the operation data
    Its include structure/component is is AFVGI
  • ANZMA : Number of employees
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • RFGRP : Setup group category
    Its data type is C (Character String) with field length 10
  • RFSCH : Setup group key
    Its data type is C (Character String) with field length 10
  • RASCH : Setup Type Key
    Its data type is C (Character String) with field length 2
  • AUFAK : Scrap factor
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • LOGRP : Wage group
    Its data type is C (Character String) with field length 3
  • UEMUS : Required overlapping
    Its data type is C (Character String) with field length 1
  • UEKAN : Optional overlapping
    Its data type is C (Character String) with field length 1
  • FLIES : Indicator: continuous flow production
    Its data type is C (Character String) with field length 1
  • SPMUS : Required splitting
    Its data type is C (Character String) with field length 1
  • PLNFL : Sequence
    Its data type is C (Character String) with field length 6
  • SPLIM : Maximum number of splits
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • ABLIPKZ : Indicator: simultaneous teardown and wait
    Its data type is C (Character String) with field length 1
  • RSTRA : Reduction strategy per operation/activity
    Its data type is C (Character String) with field length 2
  • SUMNR : Node number of the superior operation
    Its data type is N (Character String with Digits Only) with field length 8
  • SORTL : Sort Term for Non-Stock Info Records
    Its data type is C (Character String) with field length 10
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is C (Character String) with field length 10
  • PREIS : Price
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • SAKTO : Cost Element
    Its data type is C (Character String) with field length 10
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • PLNKN : Number of the task list node
    Its data type is N (Character String with Digits Only) with field length 8
  • INFNR : Number of purchasing info record
    Its data type is C (Character String) with field length 10
  • ESOKZ : Purchasing info record category
    Its data type is C (Character String) with field length 1
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • KZLGF : Indicator: fixed lot external processing
    Its data type is C (Character String) with field length 1
  • KZWRTF : Indicator: Fixed price for external processing
    Its data type is C (Character String) with field length 1
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • DDEHN : Indicator: flexible duration
    Its data type is C (Character String) with field length 1
  • ANZZL : Number of capacities required
    Its data type is X (Byte string) with field length 1
  • PRZNT : Work percentage
    Its data type is X (Byte string) with field length 1
  • PLNAL : Group Counter
    Its data type is C (Character String) with field length 2
  • MLSTN : Usage
    Its data type is C (Character String) with field length 5
  • PPRIO : Priority
    Its data type is C (Character String) with field length 2
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • ANFKO : Requesting cost center
    Its data type is C (Character String) with field length 10
  • ANFKOKRS : Controlling area of the requesting cost center
    Its data type is C (Character String) with field length 4
  • INDET : Calculation key
    Its data type is C (Character String) with field length 1
  • LARNT : Activity Type
    Its data type is C (Character String) with field length 6
  • PRKST : Costs in the activity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • APLFL : Sequence
    Its data type is C (Character String) with field length 6
  • RUECK : Completion confirmation number for the operation
    Its data type is N (Character String with Digits Only) with field length 10
  • PLNTY : Task List Type
    Its data type is C (Character String) with field length 1
  • RMZHL : Confirmation counter
    Its data type is N (Character String with Digits Only) with field length 8
  • PROJN : Work breakdown structure element (WBS element)
    Its data type is N (Character String with Digits Only) with field length 8
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • SPANZ : Actual number of splits
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • BEDID : ID of the capacity requirements record
    Its data type is N (Character String with Digits Only) with field length 12
  • BEDZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • BANFN : Purchase requisition number
    Its data type is C (Character String) with field length 10
  • BNFPO : Item number of the purchase requisition in the order
    Its data type is N (Character String with Digits Only) with field length 5
  • LEK01 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • LEK02 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • VINTV : Increment between referenced operations
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • LEK03 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • LEK04 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • LEK05 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • LEK06 : Indicator: No remaining activity expected
    Its data type is C (Character String) with field length 1
  • SELKZ : Selection indicator for costing line items
    Its data type is C (Character String) with field length 1
  • KALID : Factory Calendar
    Its data type is C (Character String) with field length 2
  • FRSP : Earliest possible activity / Latest possible activity
    Its data type is C (Character String) with field length 1
  • STDKN : Node of operation within reference operation set
    Its data type is N (Character String with Digits Only) with field length 8
  • ANLZU : Syst.Condition
    Its data type is C (Character String) with field length 1
  • ISTRU : Assembly
    Its data type is C (Character String) with field length 18