SAP table AFAB (Network - Relationships)

SAP table AFAB has 7 primary key fields being MANDT,AUFPL_VOR,APLZL_VOR,AUFPL_NCH,APLZL_NCH,AOBAR,MIMAX.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
AUFPL_VOR No. identifying the network to which the predecessor belongs NUMC 10 0 AUFPL_VOR
APLZL_VOR Internal counter NUMC 8 0 CIM_COUNT
AUFPL_NCH No. identifying the network to which the successor belongs NUMC 10 0 AUFPL_NCH
APLZL_NCH Internal counter NUMC 8 0 CIM_COUNT
AOBAR Type of relationship CHAR 2 0 AOBAR
MIMAX Indicates whether maximum time interval will be considered CHAR 1 0 DAUMIMAX
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
ZEINH Unit for the time interval between relationships UNIT 3 0 T006 AOBDAUEH
DAUER Time Interval Between Relationships QUAN 5 1 AOBDAUER
DAUKZ Indicator for the duration of the relationship CHAR 1 0 AOBDAUKZ
VORNC Indicator: maintained after successor CHAR 1 0 VORG_NACH
NCVOR Indicates whether data after predecessor is maintained CHAR 1 0 NACH_VORG
LOEKZ Indicates whether an object is logically deleted. CHAR 1 0 LOLOE
KALID Factory Calendar CHAR 2 0 TFACD WFCID
PRZNT % used to calc. time interval between predecessor/successor NUMC 3 0 AOB_PRZNT
PROVG Key for defining time intervals in a relationship CHAR 1 0 AOB_PROVG
Absolute (standard)
1 % duration of predecessor
2 % duration of successor
ARBID Object ID NUMC 8 0 OBJEKTID
WERKS Plant CHAR 4 0 T001W WERKS_D
FSABD Earliest start date for the relationship DATS 8 0 FSABD
FSABZ Earliest start time for the relationship TIMS 6 0 FSABZ
SSABD Latest start date of the relationship DATS 8 0 SSABD
SSABZ Latest start time of the relationship TIMS 6 0 SSABZ
FEABD Earliest finish date for the relationship DATS 8 0 FEABD
FEABZ Earliest finish time for the relationship TIMS 6 0 FEABZ
SEABD Latest finish date of the relationship DATS 8 0 SEABD
SEABZ Latest finish time of the relationship TIMS 6 0 SEABZ
DAUTM Relationship duration (in seconds) as result of scheduling INT4 10 0 DAUTM
AUCRE Ind.: Relationship automatically generated CHAR 1 0 CN_AUCRE
DAUERMAX Maximum time interval for relationship QUAN 5 1 AOBDAUERM
AENNR Change Number CHAR 12 0 * AENNR

AFAB foreign key relationships

Table Field Check Table Check Field
0 AFAB OBJNR ONR00 General Object Number MANDT
1 AFAB WERKS T001W Plants/Branches MANDT
1 AFAB WERKS T001W Plants/Branches WERKS
0 AFAB ZEINH T006 Units of Measurement MANDT