SAP AFAB Network - Relationships Table
Overview
AFAB is a standard SAP S/4HANA table that stores Network - Relationships data. There are total 31 fields in the AFAB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFAB belongs to Network and Activity (PS-ST-OPR-NET) module and is located in the package Operative Network (CN_NET_OPR).
In addition, following links provide an overview of foreign key relationships, if any, that link AFAB to other SAP tables and standard CDS views available based on AFAB table in S/4HANA 2020.
Techincal Settings of AFAB
Below are technical details of the table AFAB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFAB Fields
The following table gives you an overview of the fields available in AFAB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| AUFPL_VOR | No. identifying the network to which the predecessor belongs | AUFPL_VOR | NUMC | 10 | |
| APLZL_VOR | Internal counter | CIM_COUNT | NUMC | 8 | |
| AUFPL_NCH | No. identifying the network to which the successor belongs | AUFPL_NCH | NUMC | 10 | |
| APLZL_NCH | Internal counter | CIM_COUNT | NUMC | 8 | |
| AOBAR | Type of relationship | AOBAR | CHAR | 2 | |
| MIMAX | Indicates whether maximum time interval will be considered | DAUMIMAX | CHAR | 1 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| ZEINH | Unit for the time interval between relationships | AOBDAUEH | T006 | UNIT | 3 |
| DAUER | Time Interval Between Relationships | AOBDAUER | QUAN | 5 | |
| DAUKZ | Indicator for the duration of the relationship | AOBDAUKZ | CHAR | 1 | |
| VORNC | Indicator: maintained after successor | VORG_NACH | CHAR | 1 | |
| NCVOR | Indicates whether data after predecessor is maintained | NACH_VORG | CHAR | 1 | |
| LOEKZ | Indicates whether an object is logically deleted. | LOLOE | CHAR | 1 | |
| KALID | Factory Calendar | WFCID | TFACD | CHAR | 2 |
| PRZNT | % used to calc. time interval between predecessor/successor | AOB_PRZNT | NUMC | 3 | |
| PROVG | Key for defining time intervals in a relationship | AOB_PROVG | CHAR | 1 | |
| ARBID | Object ID | OBJEKTID | NUMC | 8 | |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| FSABD | Earliest start date for the relationship | FSABD | DATS | 8 | |
| FSABZ | Earliest start time for the relationship | FSABZ | TIMS | 6 | |
| SSABD | Latest start date of the relationship | SSABD | DATS | 8 | |
| SSABZ | Latest start time of the relationship | SSABZ | TIMS | 6 | |
| FEABD | Earliest finish date for the relationship | FEABD | DATS | 8 | |
| FEABZ | Earliest finish time for the relationship | FEABZ | TIMS | 6 | |
| SEABD | Latest finish date of the relationship | SEABD | DATS | 8 | |
| SEABZ | Latest finish time of the relationship | SEABZ | TIMS | 6 | |
| DAUTM | Relationship duration (in seconds) as result of scheduling | DAUTM | INT4 | 10 | |
| AUCRE | Ind.: Relationship automatically generated | CN_AUCRE | CHAR | 1 | |
| DAUERMAX | Maximum time interval for relationship | AOBDAUERM | QUAN | 5 | |
| AENNR | Change Number | AENNR | * | CHAR | 12 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFAB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFAB | KALID | C: CN | TFACD |
| AFAB | OBJNR | 1: 1 | ONR00 |
| AFAB | WERKS | 1: CN | T001W |
| AFAB | ZEINH | C: CN | T006 |