AFAB SAP table for – Network – Relationships

Here we would like to draw your attention to AFAB table in SAP. As we know it is being mainly used with the SAP PS-ST (Structures in PS) component which is coming under PS module (Project Systems). AFAB is a SAP standard transparent table used for storing Network – Relationships related data in SAP. It comes under the package CN_NET_OPR.

SAP AFAB table

Table AFAB technical data

TableAFAB
Data storingNetwork – Relationships
ModulePS
ComponentPS-ST
SAP PackageCN_NET_OPR
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ZEINH : Unit for the time interval between relationships
    Its data type is C (Character String) with field length 3
  • DAUER : Time interval between relationships
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • DAUKZ : Indicator for the duration of the relationship
    Its data type is C (Character String) with field length 1
  • VORNC : Indicator: maintained after successor
    Its data type is C (Character String) with field length 1
  • NCVOR : Indicates whether data after predecessor is maintained
    Its data type is C (Character String) with field length 1
  • LOEKZ : Indicates whether an object is logically deleted.
    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
  • PRZNT : % used to calc. time interval between predecessor/successor
    Its data type is N (Character String with Digits Only) with field length 3
  • PROVG : Key for defining time intervals in a relationship
    Its data type is C (Character String) with field length 1
  • ARBID : Object ID
    Its data type is N (Character String with Digits Only) with field length 8
  • AUFPL_VOR : No. identifying the network to which the predecessor belongs
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • FSABD : Earliest start date for the relationship
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FSABZ : Earliest start time for the relationship
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SSABD : Latest start date of the relationship
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSABZ : Latest start time of the relationship
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FEABD : Earliest finish date for the relationship
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FEABZ : Earliest finish time for the relationship
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • SEABD : Latest finish date of the relationship
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SEABZ : Latest finish time of the relationship
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • DAUTM : Relationship duration (in seconds) as result of scheduling
    Its data type is X (Byte string) with field length 4
  • APLZL_VOR : Internal counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • AUCRE : Ind.: Relationship automatically generated
    Its data type is C (Character String) with field length 1
  • DAUERMAX : Maximum time interval for relationship
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • AUFPL_NCH : No. identifying the network to which the successor belongs
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • APLZL_NCH : Internal counter
    Its a key field. Its data type is N (Character String with Digits Only) with field length 8
  • AOBAR : Type of relationship
    Its a key field. Its data type is C (Character String) with field length 2
  • MIMAX : Indicates whether maximum time interval will be considered
    Its a key field. Its data type is C (Character String) with field length 1
  • .INCLUDE : Network relationships (Include structure)
    Its include structure/component is is AFAB_INC
  • OBJNR : Object number
    Its data type is C (Character String) with field length 22