AFABB SAP (Network: Document Table for Relationships) Structure details

Dictionary Type: Structure
Description: Network: Document Table for Relationships




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




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

AFABB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Network: Document Table for Relationships" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_AFABB TYPE AFABB.

The AFABB table consists of various fields, each holding specific information or linking keys about Network: Document Table for Relationships data available in SAP. These include MANDT (Client), 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).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP AFABB structure 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
VBKZUpdate indicator VBKZCHAR1VERBUCHER
AUFNR_TVOROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
AUFNR_TNCHOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
FLG_LOCKIndicates whether this relationship is locked in data base FLG_LOCKCHAR1XFELD
FLG_SELSelection indicator FLG_SELCHAR1XFELD
VORN1Operation/Activity Number VORNRCHAR4NUMCVVORNRVGN
VORN2Operation/Activity Number VORNRCHAR4NUMCVVORNRVGN
INDBT_VOR1Field defined as in SY-TABIX TABIX_DINT410TABIX
INDBT_VOR2Field defined as in SY-TABIX TABIX_DINT410TABIX
VSNMRNumber or description of a version VSNMRCHAR12VSNMRVS2
INACTVersion inactive indicator VSINACTCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure AFABB using ABAP code?

As AFABB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AFABB as there is no data to select.

How to access SAP table AFABB

Within an ECC or HANA version of SAP you can also view further information about AFABB 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!