AFFL SAP table for – Work order sequence

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

SAP AFFL table

Table AFFL technical data

TableAFFL
Data storingWork order sequence
ModulePP
ComponentPP-SFC
SAP PackageCO
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • FLGAT : Sequence category
    Its data type is C (Character String) with field length 1
  • BEZFL : Reference sequence for a sequence
    Its data type is C (Character String) with field length 6
  • BKNT1 : Reference node for start of a sequence
    Its data type is N (Character String with Digits Only) with field length 8
  • BKNT2 : Finish reference node of a sequence
    Its data type is N (Character String with Digits Only) with field length 8
  • LTXA1 : Sequence description
    Its data type is C (Character String) with field length 40
  • TXTSP : Language Key
    Its data type is C (Character String) with field length 1
  • LOSVN : From lot size
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LOSBS : To lot size
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BSCHL1 : Relationship key for branch operation of parallel sequences
    Its data type is C (Character String) with field length 1
  • 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
  • BSCHL2 : Relationship key for return operation of parallel sequences
    Its data type is C (Character String) with field length 1
  • AUSCHL : Alignment key for scheduling
    Its data type is C (Character String) with field length 1
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22
  • 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
  • APLZL : Internal counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • .INCLUDE : Work order sequence (Include structure)
    Its include structure/component is is AFFL_INC
  • 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
  • PLNAL : Group Counter
    Its data type is C (Character String) with field length 2
  • PLNFL : Sequence
    Its data type is C (Character String) with field length 6
  • ZAEHL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8