SAP AFABI PSIS - Individual Overviews: Relationships Table data and field list

AFABI 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 "PSIS - Individual Overviews: 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_AFABI TYPE AFABI.

The AFABI table consists of various fields, each holding specific information or linking keys about PSIS - Individual Overviews: Relationships data available in SAP. These include ARNUMMER (Archiving Session Number), VSGRUPPE (Group for a project version), VSNUMMER (Number or description of a version), PRCTR (Profit Center)... 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. .

AFABI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AFABI structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the AFABI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
ARNUMMERArchiving Session Number ADMI_RUN_DCHAR6ADMI_RUN
VSGRUPPEGroup for a project version VSGRUPPECHAR20TEXT20
VSNUMMERNumber or description of a version VSNMRCHAR12VSNMRVS2
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PRNAMInvestment program name IM_PRNAMCHAR8IMTPIM_PRNAMIMT
PRPOSIdentification for an investment program position IM_POSIDCHAR24POSIDIM_POSIDIMP
PSPIDProject Definition PS_PSPIDCHAR24ABPSNPS_PSPIDPSPPD_DUMMY
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
KDAUFSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
KDPOSSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
AUFNROrder/Network number AUF_NETNRCHAR12Assigned to domainALPHAAUFNRANR
VORNRActivity number in network and standard network CN_VORNRCHAR4NUMCVVORNR
POSID2Work Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
AUFNR2Order/Network number AUF_NETNRCHAR12Assigned to domainALPHAAUFNRANR
VORNR2Activity number in network and standard network CN_VORNRCHAR4NUMCVVORNR
AUTYPTXTDisplay field for order category description AUTYPTEXTCHAR40TEXT40
AOBARType of relationship AOBARCHAR2AOBARAOBAR
MIMAXIndicates whether maximum time interval will be considered DAUMIMAXCHAR1XFELD
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
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
ARBPLWork center ARBPLCHAR8ARBPLAGR
ARBTXTShort text for the CIM operating resource PS_ARBTEXTCHAR40TEXT40
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
LTXA1Operation short text LTXA1CHAR40TEXT40
LTXA12Operation short text LTXA1CHAR40TEXT40
NCHSingle-Character Indicator CHAR1CHAR1CHAR1
AUTYPOrder category AUFTYPNUMC2AUFTYP
ARBIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
AUFPLNo. identifying the network to which the predecessor belongs AUFPL_VORNUMC10MDNUM
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
AUFPL2No. identifying the network to which the successor belongs AUFPL_NCHNUMC10MDNUM
APLZL2Internal counter CIM_COUNTNUMC8CIM_COUNT
VGTYPActivity or element category VGTYPCHAR3VORG_TYP
OBJNRObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
INT_IDID/Object key OBJEKT_IDCHAR30CHAR30
LOEKZDeletion Indicator LOEVMCHAR1XFELD
LIGHTALV control: Exception as LED LVC_EXLEDCHAR1CHAR1

Key field Non-key field



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

As AFABI 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 AFABI as there is no data to select.

How to access SAP table AFABI

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

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