I_DFS_OBJSTRUCTURERELATIONSHIP

CDS View
24 Fields 21 CDS Views

Interface View forStructure Relationship

I_DFS_OBJSTRUCTURERELATIONSHIP is a CDS View in S/4HANA. Interface View forStructure Relationship. It contains 24 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
C_DFS_PosToPersonStrucRelshp view from CONSUMPTION
I_AuthzdActlPosPersStrucRelshp view_entity from COMPOSITE Position to Person Relationship
I_AuthzdPosOrgStrucAssgdInfo view from COMPOSITE Position FMPO FE Org Structure
I_AuthzdPosOrgStrucAssgmtDet view_entity from COMPOSITE Org Structure Position FE
I_DFS_ObjStructureRelshpList view from BASIC Interface view for Object Structure List
I_DFS_PersonnelStockInHand view from COMPOSITE View to get FE, Material and Person
I_DFS_PositionJobToQualifn view from COMPOSITE Interface for Position Job to Qualification Relshp
I_DFS_PositionJobToQualifn view inner COMPOSITE Interface for Position Job to Qualification Relshp
I_DFS_PositionJobToQualifn view union COMPOSITE Interface for Position Job to Qualification Relshp
I_DFS_PositionObjRelationship view from COMPOSITE inteface view for the object relationship
I_DFS_PositionToJobTP view from TRANSACTIONAL Transactional Processing View of Position To Job
I_DFS_PositionToQualifnBlockTP view from TRANSACTIONAL Transactional view for qualificationblock
I_DFS_PositionToQualifnTP view from TRANSACTIONAL Transactional Processing View of Pos To Qualifn
I_DFS_PositionToStdWrkflwTskTP view from TRANSACTIONAL Transactional Processing View for Pos to Std Wrkflow Task
I_DFS_PositionToTaskTP view from TRANSACTIONAL Transactional Processing View of Position To Task
I_DFS_PosPersStrucStockInHand view_entity from COMPOSITE FE Material Position Person Stock
I_DFS_PosToFrcElmntStrucTP view from TRANSACTIONAL Transactional Processing View of Pos To FE Structure
I_DFS_PosToRefFrcElmntStrucTP view from TRANSACTIONAL Transactional Processing View of Pos To RFE Structure
I_FrcElmntToPosStrucRelshpTP view from TRANSACTIONAL Transactional Processing View of Pos To FE Struc Relshp
I_FrcElmntToPrftCostCtrRltnTP view from TRANSACTIONAL Transactional View for FE to Cost Center Assignment
I_FrcElmntToWBSElmnt view from BASIC Interface View of FE to additional WBS Element

Fields (24)

KeyField CDS FieldsUsed in Views
KEY DfsObjectID DfsObjectID,DfsObjectIDFoEd,DfsObjectIDForEdit,DfsPositionID,DfsPositionIDFoEd,ForceElementOrgID,ForceElementOrgSrceID 16
KEY DfsObjectPlanVersion DfsObjectPlanVersion,DfsPositionPlanVersion,FrcElmntOrgPlanVersion 12
KEY DfsObjectPlngStatus DfsObjectPlngStatus,DfsPositionPlngStatus,DfsPositionPlngStatusFoEd,FrcElmntOrgPlngStatus 13
KEY DfsObjectRelatedObjectID DfsPositionRelatedObjectID 1
KEY DfsObjectRelshpBtwnObj DfsObjectRelshpBtwnObj,DfsPositionRelshpBtwnObj,FrcElmntOrgRelshpBtwnObj 13
KEY DfsObjectRelshpPriority DfsObjectRelshpPriority,DfsPositionRelshpPriority,FrcElmntOrgRelshpPriority 11
KEY DfsObjectRelshpSpec DfsObjectRelshpSpec,DfsPositionRelshpSpec,FrcElmntOrgRelshpSpec 12
KEY DfsObjectSubType DfsObjectSubType,DfsObjectSubTypeFoEd,DfsPositionSubType,FrcElmntOrgSubType 13
KEY DfsObjectType DfsObjectType,DfsPositionObjectType,FrcElmntOrgType 12
KEY DfsObjectValdtyEndDate DfsObjectValdtyEndDate,DfsObjectValdtyEndDateFoEd,DfsPositionValdtyEndDate,DfsPositionValdtyEndDateFoEd,FrcElmntOrgValdtyEndDate 16
KEY DfsObjectValdtyStartDate DfsObjectValdtyStartDate,DfsObjectValdtyStartDateFoEd,DfsPositionValdtyStartDate,DfsPositionValdtyStartDateFoEd,FrcElmntOrgValdtyStartDate 16
KEY DfsPositionRelatedObjectID DfsObjectRelatedObjectID,DfsPositionRelatedObjectID,DfsPositionRelatedObjectIDFoEd,ForceElementOrgID,ForceElementOrgIDFoEd,FrcElmntOrgRelatedOrgID 15
KEY FrcElmntOrgVariationID FrcElmntOrgVariationID 2
_ObjHeader _ObjHeader 3
DfsObjectConcatenatedID DfsObjectConcatenatedID,FrcElmntOrgConcatenatedID 12
DfsObjectInfoType DfsObjectInfoType,DfsPositionInfoType,FrcElmntOrgInfoType 12
DfsObjectRelatedObjectType DfsPositionRelatedObjectType 1
DfsObjRelshpLastChgdByUser DfsObjRelshpLastChgdByUser,DfsPositionRelshpLastChgdByUsr,FrcElmntOrgLastChgdByUser 11
DfsObjRelshpLastChgdByUserName DfsObjRelshpLastChgdByUserName,DfsPosRelshpLastChgdByUserName 9
DfsObjRelshpLastChgdDate DfsObjRelshpLastChgdDate,DfsPositionRelshpLastChgdDate 10
DfsPositionDescRefSqncNmbr DfsPositionDescRefSqncNmbr,NumberOfForceElementOrg 10
DfsPositionRelatedObjectType DfsObjectRelatedObjectType,DfsPositionRelatedObjectType,FrcElmntOrgRelatedOrgType 14
FrcElmntOrgIsRefFrcElmntOrg FrcElmntOrgIsRefFrcElmntOrg 1
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 9

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.

-- Interface View forStructure Relationship
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_OBJSTRUCTURERELATIONSHIP (
    DFSOBJECTID,
    DFSOBJECTPLANVERSION,
    DFSOBJECTPLNGSTATUS,
    DFSOBJECTRELATEDOBJECTID,
    DFSOBJECTRELSHPBTWNOBJ,
    DFSOBJECTRELSHPPRIORITY,
    DFSOBJECTRELSHPSPEC,
    DFSOBJECTSUBTYPE,
    DFSOBJECTTYPE,
    DFSOBJECTVALDTYENDDATE,
    DFSOBJECTVALDTYSTARTDATE,
    DFSPOSITIONRELATEDOBJECTID,
    FRCELMNTORGVARIATIONID,
    _OBJHEADER,
    DFSOBJECTCONCATENATEDID,
    DFSOBJECTINFOTYPE,
    DFSOBJECTRELATEDOBJECTTYPE,
    DFSOBJRELSHPLASTCHGDBYUSER,
    DFSOBJRELSHPLASTCHGDBYUSERNAME,
    DFSOBJRELSHPLASTCHGDDATE,
    DFSPOSITIONDESCREFSQNCNMBR,
    DFSPOSITIONRELATEDOBJECTTYPE,
    FRCELMNTORGISREFFRCELMNTORG,
    FRCELMNTORGPLNGSTSCRITLTY,
    PRIMARY KEY (DFSOBJECTID, DFSOBJECTPLANVERSION, DFSOBJECTPLNGSTATUS, DFSOBJECTRELATEDOBJECTID, DFSOBJECTRELSHPBTWNOBJ, DFSOBJECTRELSHPPRIORITY, DFSOBJECTRELSHPSPEC, DFSOBJECTSUBTYPE, DFSOBJECTTYPE, DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, DFSPOSITIONRELATEDOBJECTID, FRCELMNTORGVARIATIONID)
);

Learn More