AFFV SAP table for – Order – Process Instruction Values

Here we would like to draw your attention to AFFV table in SAP. As we know it is being mainly used with the SAP PP-PI (Production Planning for Process Industries – PP) component which is coming under PP module (Production Planning). AFFV is a SAP standard transparent table used for storing Order – Process Instruction Values related data in SAP. It comes under the package COCR.

SAP AFFV table

Table AFFV technical data

TableAFFV
Data storingOrder – Process Instruction Values
ModulePP
ComponentPP-PI
SAP PackageCOCR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PLNPH : Internal Sub-Calculation Number
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNFT : Internal process instruction number
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNFV : Internal PI characteristic/characteristic value number
    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
  • FVLNR : Line Number of Process Instruction Characteristic
    Its data type is C (Character String) with field length 4
  • ATINN : Internal characteristic
    Its data type is N (Character String with Digits Only) with field length 10
  • ATZHL : Int counter
    Its data type is N (Character String with Digits Only) with field length 4
  • ATWRT : Characteristic Value
    Its data type is C (Character String) with field length 30
  • ATFLV : Internal floating point from
    Its data type is F (Floating point number) with field length 8
  • ATFLB : Internal floating point value to
    Its data type is F (Floating point number) 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
  • ATCOD : Code for value dependency
    Its data type is C (Character String) with field length 1
  • ATAWE : Alternative unit
    Its data type is C (Character String) with field length 3
  • ATAW1 : Alternative unit
    Its data type is C (Character String) with field length 3
  • ATFOR : Data type of characteristic
    Its data type is C (Character String) with field length 4
  • WRTKZ : Indicator: Characteristic value assigned
    Its data type is C (Character String) with field length 1
  • TXTSP : Language Key
    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
  • APLZL : General counter for order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • APHZL : Internal Sub-Calculation Number
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • AFTZL : Internal process instruction number
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • AFVZL : Internal PI characteristic/characteristic value number
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • PLNTY : Task List Type
    Its data type is C (Character String) with field length 1
  • PLNNR : Key for Task List Group
    Its data type is C (Character String) with field length 8
  • PLNKN : Number of the task list node
    Its data type is N (Character String with Digits Only) with field length 8