/PF1/DB_OBJ_REL

Transparent Table Application Table
29 Fields 9 CDS Views

PE Business Object Relations

/PF1/DB_OBJ_REL is an SAP database table in S/4HANA. PE Business Object Relations. It contains 29 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
/PF1/C_OBJREL_BCM_BATCH view from BCM Batch
/PF1/C_OBJREL_TEMSE view from BCM Batch
/PF1/I_ITEM_INACTIVE_PO_REL view from InActive Order Relation
/PF1/I_OBJREL_BCM view from Batch
/PF1/I_OBJREL_IPF view from Incoming Payment File
/PF1/I_OBJREL_MBC view from MBC Message
/PF1/I_OBJREL_STMT view from MBC Message
/PF1/I_PAYM_FILE_RELATION view from Payment File Relations
/PF1/P_OBJ_REL view from Object Relations (P View)

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY guid GUID GUID
clearing_area /PF1/DTE_BPE_CLEARING_AREA Clearing Area
object_category /PF1/DTE_BPE_OBJECT_CATEGORY Object Category
obj_date /PF1/DTE_EH_OBJ_DATE Object Date
obj_no /PF1/DTE_EH_OBJ_NO Object Number
obj_ext /PF1/DTE_EH_OBJ_EXT Additional Object ID
obj_long_ext /PF1/DTE_BPE_LONG_REFERENCE extended Reference
object_relation /PF1/DTE_BPE_OBJECT_RELATION Object Relation
object_category_rel /PF1/DTE_BPE_OBJECT_CATEGORY Object Category
clearing_area_rel /PF1/DTE_BPE_CLEARING_AREA Clearing Area
obj_date_rel /PF1/DTE_EH_OBJ_DATE Object Date
obj_no_rel /PF1/DTE_EH_OBJ_NO Object Number
obj_ext_rel /PF1/DTE_EH_OBJ_EXT Additional Object ID
obj_long_ext_rel /PF1/DTE_BPE_LONG_REFERENCE extended Reference
ext_system /PF1/DTE_EXTERNAL_COMPONENTS External System
relation_state /PF1/DTE_BPE_RELATION_STATE Relation State
flg_bus_obj_arc /PF1/DTE_AR_FLG_BUS_OBJ_ARC Bus. Object Arch.
flg_rel_obj_arc /PF1/DTE_AR_FLG_REL_OBJ_ARC Related Object Arch.
crusr /PF1/DTE_BPE_CRUSR Created By
crdat /PF1/DTE_BPE_CRDAT Created On
crtim /PF1/DTE_BPE_CRTIM Created At
chusr /PF1/DTE_BPE_CHUSR Changed By
chdat /PF1/DTE_BPE_CHDAT Changed On
chtim /PF1/DTE_BPE_CHTIM Changed At
rlusr /PF1/DTE_BPE_RLUSR Released By
rldat /PF1/DTE_BPE_RLDAT Released
rltim /PF1/DTE_BPE_RLTIM Released At
process_guid /PF1/DTE_BPE_PROCESS_GUID Process GUID

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.

-- PE Business Object Relations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PF1/DB_OBJ_REL (
    CLIENT,               -- Client [MANDT]
    GUID,                 -- GUID [GUID]
    CLEARING_AREA,        -- Clearing Area [/PF1/DTE_BPE_CLEARING_AREA]
    OBJECT_CATEGORY,      -- Object Category [/PF1/DTE_BPE_OBJECT_CATEGORY]
    OBJ_DATE,             -- Object Date [/PF1/DTE_EH_OBJ_DATE]
    OBJ_NO,               -- Object Number [/PF1/DTE_EH_OBJ_NO]
    OBJ_EXT,              -- Additional Object ID [/PF1/DTE_EH_OBJ_EXT]
    OBJ_LONG_EXT,         -- extended Reference [/PF1/DTE_BPE_LONG_REFERENCE]
    OBJECT_RELATION,      -- Object Relation [/PF1/DTE_BPE_OBJECT_RELATION]
    OBJECT_CATEGORY_REL,  -- Object Category [/PF1/DTE_BPE_OBJECT_CATEGORY]
    CLEARING_AREA_REL,    -- Clearing Area [/PF1/DTE_BPE_CLEARING_AREA]
    OBJ_DATE_REL,         -- Object Date [/PF1/DTE_EH_OBJ_DATE]
    OBJ_NO_REL,           -- Object Number [/PF1/DTE_EH_OBJ_NO]
    OBJ_EXT_REL,          -- Additional Object ID [/PF1/DTE_EH_OBJ_EXT]
    OBJ_LONG_EXT_REL,     -- extended Reference [/PF1/DTE_BPE_LONG_REFERENCE]
    EXT_SYSTEM,           -- External System [/PF1/DTE_EXTERNAL_COMPONENTS]
    RELATION_STATE,       -- Relation State [/PF1/DTE_BPE_RELATION_STATE]
    FLG_BUS_OBJ_ARC,      -- Bus. Object Arch. [/PF1/DTE_AR_FLG_BUS_OBJ_ARC]
    FLG_REL_OBJ_ARC,      -- Related Object Arch. [/PF1/DTE_AR_FLG_REL_OBJ_ARC]
    CRUSR,                -- Created By [/PF1/DTE_BPE_CRUSR]
    CRDAT,                -- Created On [/PF1/DTE_BPE_CRDAT]
    CRTIM,                -- Created At [/PF1/DTE_BPE_CRTIM]
    CHUSR,                -- Changed By [/PF1/DTE_BPE_CHUSR]
    CHDAT,                -- Changed On [/PF1/DTE_BPE_CHDAT]
    CHTIM,                -- Changed At [/PF1/DTE_BPE_CHTIM]
    RLUSR,                -- Released By [/PF1/DTE_BPE_RLUSR]
    RLDAT,                -- Released [/PF1/DTE_BPE_RLDAT]
    RLTIM,                -- Released At [/PF1/DTE_BPE_RLTIM]
    PROCESS_GUID,         -- Process GUID [/PF1/DTE_BPE_PROCESS_GUID]
    PRIMARY KEY (CLIENT, GUID)
);

Learn More