/IAM/D_I_OBJ_REF

Transparent Table Application Table
31 Fields 82 CDS Views

Issue reference node DB table

/IAM/D_I_OBJ_REF is an SAP database table in S/4HANA. Issue reference node DB table. It contains 31 fields. 82 CDS views read from this table.

CDS Views using this table (82)

ViewTypeJoinVDMDescription
E_ChangeRecordRefCharcBsc view from EXTENSION Chg Recd Ref Obj Charc - Extension
E_ChangeRecordRefClassBsc view from EXTENSION Chg Recd Ref Obj Class - Extension
E_ChangeRecordRefOrderBOMBsc view from EXTENSION Chg Recd Ref Obj Order BOM - Extension
E_ChgRecdFuncLocTskListBsc view from EXTENSION Chg Recd Func Loc Task List - Extension
E_ChgRecdRateRtgTskListBsc view from EXTENSION Chg Recd Rate Rtg Task List - Extension
E_ChgRecdRefBOMBsc view from EXTENSION Custom Fields: Change Record Itm Include
E_ChgRecdRefBOMItmBsc view from EXTENSION Custom Fields: Change Record Itm Include
E_ChgRecdRefCutPlngPrflBsc view from EXTENSION Chg Recd Ref Cut Plng Prfl - Extension
E_ChgRecdRefDocBsc view from EXTENSION Custom Fields: Change Record Itm Include
E_ChgRecdRefEngBOMBsc view from EXTENSION Change Record Ref Obj EBOM Extension
E_ChgRecdRefEquipBOMBsc view from EXTENSION Chg Recd Ref Obj Order BOM - Extension
E_ChgRecdRefEquipTskListBsc view from EXTENSION Chg Recd Ref Equip TL - Extension
E_ChgRecdRefInspectionPlanBsc view from EXTENSION Change Record Ref Obj Inspection Plan Extension
E_ChgRecdRefLabelBsc view from EXTENSION Change Record Ref Obj Label Extension
E_ChgRecdRefMaintTskListBsc view from EXTENSION Chg Recd Obj Maint Tsk List - Extension
E_ChgRecdRefMasterRecipeBsc view from EXTENSION Change Record Ref Obj Master Recipe Extension
E_ChgRecdRefMatBsc view from EXTENSION Custom Fields: Change Record Itm Include
E_ChgRecdRefMfgBOMBsc view from EXTENSION Change Record Ref Obj MBOM Extension
E_ChgRecdRefOpSetTskListBsc view from EXTENSION Chg Recd Ref Op Set - Extension
E_ChgRecdRefPlngRoutingBsc view from EXTENSION Change Record Ref Obj Plng Rtg - Extension
E_ChgRecdRefPlngScpBsc view from EXTENSION Change Record Ref Obj Plng Scp Extension
E_ChgRecdRefProdnOrdBsc view from EXTENSION Change Record Ref Obj Prodn Ord Extension
E_ChgRecdRefProdnRoutingBsc view from EXTENSION Change Record Ref Obj Production Routing Extension
E_ChgRecdRefPurOrdBsc view from EXTENSION Change Record Ref Obj Pur Ord Extension
E_ChgRecdRefRateRtgTskListBsc view from EXTENSION Chg Recd Ref Rate Route TL - Extension
E_ChgRecdRefRecipeBsc view from EXTENSION Change Record Ref Obj Recipe Extension
E_ChgRecdRefRoutingBsc view from EXTENSION Change Record Ref Obj Routing Extension
E_ChgRecdRefSpecBsc view from EXTENSION Change Record Ref Obj Specification Extension
E_ChgRecdRefStdBOMBsc view from EXTENSION Chg Recd Ref Obj Std BOM - Extension
E_ChgRecdRefTmplRoutingBsc view from EXTENSION Change Record Ref Obj Tmpl Rtg - Extension
E_ChgRecdRefWBSElmntBOMBsc view from EXTENSION Chg Recd Ref Obj WBS BOM - Extension
E_ChgRecordRefCustomObjectBsc view_entity from EXTENSION Change Record Custom Objects - Extension
I_ChangeRecdRefStdBOMBsc view inner BASIC Change Record Ref Object Std BOM
I_ChangeRecdRefWBSElmntBOMBsc view inner BASIC Change Record Reference WBS BOM Basic
I_ChangeRecordDocument view_entity union_all COMPOSITE Documents attached to Change Record
I_ChangeRecordItem view_entity from BASIC Generic Change Record item
I_ChangeRecordItemCount view from BASIC Change Record Item Count
I_ChangeRecordRefCharcBsc view inner BASIC Chg Recd Reference Object Characteristic
I_ChangeRecordRefClassBsc view inner BASIC Chg Recd Reference Object Class
I_ChangeRecordRefDocument view_entity from COMPOSITE Change Record Document Reference Item
I_ChangeRecordRefOrderBOMBsc view inner BASIC Change Record Reference Object Order BOM
I_ChgMgmtReqRelatedObject view from BASIC Change Management Request Related Object
I_ChgRecdFuncLocTskListBsc view inner BASIC Chg Recd Functional Location Task List
I_ChgRecdItmLogDetsBsc view from BASIC Basic details for Itm Dgtl Sgntr
I_ChgRecdRateRtgTskListBsc view inner BASIC Chg Recd Ref Obj Rate Routing Task List
I_ChgRecdRefBOMBsc view inner BASIC Change Record Reference Object BOM
I_ChgRecdRefBOMItmBsc view from BASIC Change Record Reference Object BOM Item
I_ChgRecdRefCutPlngPrflBsc view inner BASIC Change Record Cut Plan Profile Task List
I_ChgRecdRefDefectBsc view inner BASIC Change Record Ref Object Defect
I_ChgRecdRefDocBsc view from BASIC Change Record Reference Object Document
I_ChgRecdRefEngBOMBsc view inner BASIC Change Record Reference Object EBOM
I_ChgRecdRefEngSnpshtBsc view inner BASIC Change Record Ref Object Eng Snpsht
I_ChgRecdRefEquipBOMBsc view inner BASIC Change Record Reference Equip BOM Basic
I_ChgRecdRefEquipTskListBsc view inner BASIC Change Recd Ref Obj Equipment Task List
I_ChgRecdRefETOVersBOMBsc view inner BASIC Change Record Ref Object ETO Vers BOM
I_ChgRecdRefFuncLocBOMBsc view inner BASIC Chg Recd Ref FuncLoc BOM Basic
I_ChgRecdRefInspectionPlanBsc view inner BASIC Change Record Reference Object Inspection Plan
I_ChgRecdRefLabelBsc view inner BASIC Change Record Reference Object Label
I_ChgRecdRefMaintTskListBsc view inner BASIC Change Record Ref Obj Maintain Task List
I_ChgRecdRefMasterRecipeBsc view inner BASIC Change Record Reference Object Master Recipe
I_ChgRecdRefMatBsc view from BASIC Change Record Reference Object Material
I_ChgRecdRefMfgBOMBsc view inner BASIC Change Record Reference MBOM
I_ChgRecdRefMfgSnpshtBsc view inner BASIC Change Record Ref Object Mfg Snpsht
I_ChgRecdRefNotificationBsc view_entity inner BASIC Change Record Ref Object Notification
I_ChgRecdRefOpSetTskListBsc view inner BASIC Chg Recd Ref Obj Ref Op Set Task List
I_ChgRecdRefPlngRoutingBsc view inner BASIC Change Record Ref Object Plng Routing
I_ChgRecdRefPlngScpBsc view inner BASIC Change Record Reference Object PLS
I_ChgRecdRefProdnOrdBsc view inner BASIC Change Record Reference Object Prodn Ord
I_ChgRecdRefProdnRoutingBsc view inner BASIC Change Record Reference Object Production Routing
I_ChgRecdRefProdStrucVarBsc view from BASIC Change Record Reference for Product Structure Variant Basic
I_ChgRecdRefPurOrdBsc view inner BASIC Change Record Reference Object Pur Ord
I_ChgRecdRefRateRtgTskListBsc view inner BASIC Change Record Ref Rate Route Task List
I_ChgRecdRefRecipeBsc view inner BASIC Change Record Reference Object Recipe
I_ChgRecdRefRoutingBsc view inner BASIC Change Record Reference Object Routing
I_ChgRecdRefScopeOfChangeBsc view_entity inner BASIC Change Record Ref Object Scope of Change
I_ChgRecdRefSpecBsc view inner BASIC Change Record Reference Specification
I_ChgRecdRefTmplRoutingBsc view inner BASIC Change Record Ref Object Tmpl Routing
I_ChgRecdRefVarBOMBsc view inner BASIC Change Record Reference Object BOM
I_ChgRecdSnapshotObjRefBsc view inner BASIC Snasht Obj Ref assigned to Chg Recd
I_ChgRecordRefCustomObjectBsc view_entity inner BASIC Basic interface for custom objects in CR
I_ChgRecordRelatedChangeBasic view_entity from BASIC Related Change Records
P_RootNode view inner BASIC

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
node_cat_key /BOBF/CONF_KEY NodeID
category_cd /IAM/CATEGORY Object Category
type_cd /IAM/TYPE Object Type
subtype_cd /IAM/SUBTYPE Subtype
id /IAM/REF_ID Ref. Object ID
internal_id1 /IAM/INTERNAL_ID Key
internal_id2 /IAM/INTERNAL_ID Key
internal_id3 /IAM/INTERNAL_ID Key
internal_id4 /IAM/INTERNAL_ID Key
internal_guid /IAM/INTERNAL_GUID GUID-Key
virtual_ref_ind /IAM/VIRTUAL_REF_IND Virtual Reference
par_objref_uuid /IAM/CONF_KEY Node ID
url /IAM/URL URL / URI
src_system /IAM/REF_SYSTEM Reference Syst.
main_ref_ind /IAM/MAIN_REF_IND Main Reference
add_field1 /IAM/ADDITIONAL_FIELD_1 Addit. Field 1
add_field2 /IAM/ADDITIONAL_FIELD_2 Addit. Field 2
add_field3 /IAM/ADDITIONAL_FIELD_3 Addit. Field 3
created_by /BOFU/USER_ID_CREATED_BY Created By
created_on /BOFU/TSTMP_CREATION_TIME Created On
changed_by /BOFU/USER_ID_CHANGED_BY Changed By
changed_on /BOFU/TSTMP_CHANGED_TIME Changed On
item_rel /IAM/CR_ITEMREL Relevance
i_obj_ref DUMMY Dummy function in length 1
isref /PICM/ISREF Issue Ref.
refissid /PICM/ISSUE_ID Issue
po_details /PICM/PO_DETAILS PO
reference_id /PICM/REFERENCE_ID Ref. Object ID

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.

-- Issue reference node DB table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /IAM/D_I_OBJ_REF (
    MANDT,            -- Client [MANDT]
    DB_KEY,           -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,       -- NodeID [/BOBF/CONF_KEY]
    NODE_CAT_KEY,     -- NodeID [/BOBF/CONF_KEY]
    CATEGORY_CD,      -- Object Category [/IAM/CATEGORY]
    TYPE_CD,          -- Object Type [/IAM/TYPE]
    SUBTYPE_CD,       -- Subtype [/IAM/SUBTYPE]
    ID,               -- Ref. Object ID [/IAM/REF_ID]
    INTERNAL_ID1,     -- Key [/IAM/INTERNAL_ID]
    INTERNAL_ID2,     -- Key [/IAM/INTERNAL_ID]
    INTERNAL_ID3,     -- Key [/IAM/INTERNAL_ID]
    INTERNAL_ID4,     -- Key [/IAM/INTERNAL_ID]
    INTERNAL_GUID,    -- GUID-Key [/IAM/INTERNAL_GUID]
    VIRTUAL_REF_IND,  -- Virtual Reference [/IAM/VIRTUAL_REF_IND]
    PAR_OBJREF_UUID,  -- Node ID [/IAM/CONF_KEY]
    URL,              -- URL / URI [/IAM/URL]
    SRC_SYSTEM,       -- Reference Syst. [/IAM/REF_SYSTEM]
    MAIN_REF_IND,     -- Main Reference [/IAM/MAIN_REF_IND]
    ADD_FIELD1,       -- Addit. Field 1 [/IAM/ADDITIONAL_FIELD_1]
    ADD_FIELD2,       -- Addit. Field 2 [/IAM/ADDITIONAL_FIELD_2]
    ADD_FIELD3,       -- Addit. Field 3 [/IAM/ADDITIONAL_FIELD_3]
    CREATED_BY,       -- Created By [/BOFU/USER_ID_CREATED_BY]
    CREATED_ON,       -- Created On [/BOFU/TSTMP_CREATION_TIME]
    CHANGED_BY,       -- Changed By [/BOFU/USER_ID_CHANGED_BY]
    CHANGED_ON,       -- Changed On [/BOFU/TSTMP_CHANGED_TIME]
    ITEM_REL,         -- Relevance [/IAM/CR_ITEMREL]
    I_OBJ_REF,        -- Dummy function in length 1 [DUMMY]
    ISREF,            -- Issue Ref. [/PICM/ISREF]
    REFISSID,         -- Issue [/PICM/ISSUE_ID]
    PO_DETAILS,       -- PO [/PICM/PO_DETAILS]
    REFERENCE_ID,     -- Ref. Object ID [/PICM/REFERENCE_ID]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More