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

Here we would like to draw your attention to AFVU 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). AFVU is a SAP standard transparent table used for storing DB structure of the user fields of the operation related data in SAP. It comes under the package CO.

SAP AFVU table

Table AFVU technical data

TableAFVU
Data storingDB structure of the user fields of the operation
ModulePP
ComponentPP-SFC
SAP PackageCO
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • USR04 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE04 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR05 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE05 : User field: Unit for quantity fields
    Its data type is C (Character String) with field length 3
  • USR06 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE06 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR07 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USE07 : User field: Unit for value fields
    Its data type is C (Character String) with field length 5
  • USR08 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USR09 : User field for date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • USR10 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • USR11 : User-defined field: Indicator for reports
    Its data type is C (Character String) with field length 1
  • VNAME : Joint venture
    Its data type is C (Character String) with field length 6
  • RECID : Recovery Indicator
    Its data type is C (Character String) with field length 2
  • ETYPE : Equity type
    Its data type is C (Character String) with field length 3
  • JV_OTYPE : Joint Venture Object Type
    Its data type is C (Character String) with field length 4
  • JV_JIBCL : JIB/JIBE Class
    Its data type is C (Character String) with field length 3
  • APLZL : General counter for order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • JV_JIBSA : JIB/JIBE Subclass A
    Its data type is C (Character String) with field length 5
  • JV_OCO : JV original cost object
    Its data type is C (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is AFVUI
  • SLWID : Key word ID for user-defined fields
    Its data type is C (Character String) with field length 7
  • USR00 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR01 : User field with 20 characters
    Its data type is C (Character String) with field length 20
  • USR02 : User field with 10 characters
    Its data type is C (Character String) with field length 10
  • USR03 : User field with 10 characters
    Its data type is C (Character String) with field length 10