AFAB SAP (Network - Relationships) Table details

Dictionary Type: Table
Description: Network - Relationships




ABAP Code to SELECT data from AFAB
Related tables to AFAB
Access table AFAB




Table field list including key, data, relationships and ABAP select examples

AFAB is a standard SAP Table which is used to store Network - Relationships data and is available within R/3 SAP systems depending on the version and release level.

The AFAB table consists of various fields, each holding specific information or linking keys about Network - Relationships data available in SAP. These include AUFPL_VOR (No. identifying the network to which the predecessor belongs), APLZL_VOR (Internal counter), AUFPL_NCH (No. identifying the network to which the successor belongs), APLZL_NCH (Internal counter).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AFAB table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
AUFPL_VORNo. identifying the network to which the predecessor belongs AUFPL_VORNUMC10MDNUM
APLZL_VORInternal counter CIM_COUNTNUMC8CIM_COUNT
AUFPL_NCHNo. identifying the network to which the successor belongs AUFPL_NCHNUMC10MDNUM
APLZL_NCHInternal counter CIM_COUNTNUMC8CIM_COUNT
AOBARType of relationship AOBARCHAR2AOBARAOBAR
MIMAXIndicates whether maximum time interval will be considered DAUMIMAXCHAR1XFELD
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
ZEINHUnit for the time interval between relationships AOBDAUEHUNIT3T006CUNITMEINS
DAUERTime interval between relationships AOBDAUERQUAN5(1) AOBDAUER
DAUKZIndicator for the duration of the relationship AOBDAUKZCHAR1AOBDAUKZ
VORNCIndicator: maintained after successor VORG_NACHCHAR1XFELD
NCVORIndicates whether data after predecessor is maintained NACH_VORGCHAR1XFELD
LOEKZIndicates whether an object is logically deleted. LOLOECHAR1XFELD
KALIDFactory Calendar WFCIDCHAR2TFACDWFCIDFCI
PRZNT% used to calc. time interval between predecessor/successor AOB_PRZNTNUMC3AOB_PRZNT
PROVGKey for defining time intervals in a relationship AOB_PROVGCHAR1AOB_PROVG
ARBIDObject ID OBJEKTIDNUMC8NUM08PON
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
FSABDEarliest start date for the relationship FSABDDATS8DATUM
FSABZEarliest start time for the relationship FSABZTIMS6ATIME
SSABDLatest start date of the relationship SSABDDATS8DATUM
SSABZLatest start time of the relationship SSABZTIMS6ATIME
FEABDEarliest finish date for the relationship FEABDDATS8DATUM
FEABZEarliest finish time for the relationship FEABZTIMS6ATIME
SEABDLatest finish date of the relationship SEABDDATS8DATUM
SEABZLatest finish time of the relationship SEABZTIMS6ATIME
DAUTMRelationship duration (in seconds) as result of scheduling DAUTMINT410CX_DAUERS
AUCREInd.: Relationship automatically generated CN_AUCRECHAR1XFELD
DAUERMAXMaximum time interval for relationship AOBDAUERMQUAN5(1) AOBDAUER
AENNRChange Number AENNRCHAR12Assigned to domainAENNRAENNRAEN

Key field Non-key field



How do I retrieve data from SAP table AFAB using ABAP code

The following ABAP code Example will allow you to do a basic selection on AFAB to SELECT all data from the table
DATA: WA_AFAB TYPE AFAB.

SELECT SINGLE *
FROM AFAB
INTO CORRESPONDING FIELDS OF WA_AFAB
WHERE...

How to access SAP table AFAB

Within an ECC or HANA version of SAP you can also view further information about AFAB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!