SAP Table AFAB

Network - Relationships

AFAB (Network - Relationships) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFAB to other SAP tables.

AFAB table fields

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

AFAB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFAB KALID AFAB KALID TFACD Factory calendar definition IDENT
AFAB OBJNR AFAB MANDT ONR00 General Object Number MANDT
AFAB OBJNR AFAB OBJNR ONR00 General Object Number OBJNR
AFAB WERKS AFAB MANDT T001W Plants/Branches MANDT
AFAB WERKS AFAB WERKS T001W Plants/Branches WERKS
AFAB ZEINH AFAB MANDT T006 Units of Measurement MANDT
AFAB ZEINH AFAB ZEINH T006 Units of Measurement MSEHI