AFAB

Transparent Table Application Table
31 Fields 3 CDS Views

Network - Relationships

AFAB is an SAP database table in S/4HANA. Network - Relationships. It contains 31 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintOrderOpRelationship view from BASIC Maintenance Order Operation Relationship
I_ProjectNetworkRelationship view from BASIC Project Network Relationships
I_ProjectObjectActivityRltn view_entity from BASIC Project Object Activity Relationship

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufpl_vor AUFPL_VOR Prdcsr ID no.
KEY aplzl_vor CIM_COUNT Counter
KEY aufpl_nch AUFPL_NCH No. identifying the network to which the successor belongs
KEY aplzl_nch CIM_COUNT Counter
KEY aobar AOBAR Relations. type
KEY mimax DAUMIMAX Max. interval
objnr J_OBJNR Object number
zeinh AOBDAUEH Rel. unit
dauer AOBDAUER Time Interval
daukz AOBDAUKZ Rel. duration
vornc VORG_NACH Maint.frm.succ.
ncvor NACH_VORG Sucsr maint.
loekz LOLOE Deletion Indic.
kalid WFCID Factory Cal. ID
prznt AOB_PRZNT Time interval %
provg AOB_PROVG Time intvl key
arbid OBJEKTID Object ID
werks WERKS_D Plant
fsabd FSABD Erl. start/rel.
fsabz FSABZ EST / rel.
ssabd SSABD Latest strt-rel
ssabz SSABZ LST - rel.
feabd FEABD Earl. fin./rel.
feabz FEABZ ErlFinTime/Rel.
seabd SEABD Latest fin.-rel
seabz SEABZ LateFinTime-rel
dautm DAUTM Rel. duration
aucre CN_AUCRE Ind.: Relationship automatically generated
dauermax AOBDAUERM max. time inter.
aennr AENNR Change Number

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Network - Relationships
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFAB (
    MANDT,      -- Client [MANDT]
    AUFPL_VOR,  -- Prdcsr ID no. [AUFPL_VOR]
    APLZL_VOR,  -- Counter [CIM_COUNT]
    AUFPL_NCH,  -- No. identifying the network to which the successor belongs [AUFPL_NCH]
    APLZL_NCH,  -- Counter [CIM_COUNT]
    AOBAR,      -- Relations. type [AOBAR]
    MIMAX,      -- Max. interval [DAUMIMAX]
    OBJNR,      -- Object number [J_OBJNR]
    ZEINH,      -- Rel. unit [AOBDAUEH]
    DAUER,      -- Time Interval [AOBDAUER]
    DAUKZ,      -- Rel. duration [AOBDAUKZ]
    VORNC,      -- Maint.frm.succ. [VORG_NACH]
    NCVOR,      -- Sucsr maint. [NACH_VORG]
    LOEKZ,      -- Deletion Indic. [LOLOE]
    KALID,      -- Factory Cal. ID [WFCID]
    PRZNT,      -- Time interval % [AOB_PRZNT]
    PROVG,      -- Time intvl key [AOB_PROVG]
    ARBID,      -- Object ID [OBJEKTID]
    WERKS,      -- Plant [WERKS_D]
    FSABD,      -- Erl. start/rel. [FSABD]
    FSABZ,      -- EST / rel. [FSABZ]
    SSABD,      -- Latest strt-rel [SSABD]
    SSABZ,      -- LST - rel. [SSABZ]
    FEABD,      -- Earl. fin./rel. [FEABD]
    FEABZ,      -- ErlFinTime/Rel. [FEABZ]
    SEABD,      -- Latest fin.-rel [SEABD]
    SEABZ,      -- LateFinTime-rel [SEABZ]
    DAUTM,      -- Rel. duration [DAUTM]
    AUCRE,      -- Ind.: Relationship automatically generated [CN_AUCRE]
    DAUERMAX,   -- max. time inter. [AOBDAUERM]
    AENNR,      -- Change Number [AENNR]
    PRIMARY KEY (MANDT, AUFPL_VOR, APLZL_VOR, AUFPL_NCH, APLZL_NCH, AOBAR, MIMAX)
);

Learn More