I_DFS_QUALIFNMGMT

CDS View
19 Fields 3 CDS Views

Details for qualification management

I_DFS_QUALIFNMGMT is a CDS View in S/4HANA. Details for qualification management. It contains 19 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
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_PositionToQualifnBlockTP view union_all TRANSACTIONAL Transactional view for qualificationblock

Fields (19)

KeyField CDS FieldsUsed in Views
KEY DfsObjectID DfsObjectID 1
KEY DfsObjectPlanVersion DfsObjectPlanVersion 1
KEY DfsObjectPlngStatus DfsObjectPlngStatus 1
KEY DfsObjectType DfsObjectType 1
KEY DfsObjectValdtyEndDate DfsObjectValdtyEndDateFoEd,DfsPositionValdtyEndDate 1
KEY DfsObjectValdtyStartDate DfsObjectValdtyStartDateFoEd,DfsPositionValdtyStartDate 1
KEY DfsPositionRelatedObjectID DfsPositionRelatedObjectID,DfsPositionRelatedObjectIDFoEd 1
DfsObjectConcatenatedID DfsObjectConcatenatedID 1
DfsObjectInfoType DfsObjectInfoType 1
DfsObjectRelshpBtwnObj DfsObjectRelshpBtwnObj 1
DfsObjectRelshpPriority DfsObjectRelshpPriority 1
DfsObjectRelshpSpec DfsObjectRelshpSpec 1
DfsObjectSubType DfsObjectSubType 1
DfsObjRelshpLastChgdByUser DfsObjRelshpLastChgdByUser 1
DfsObjRelshpLastChgdByUserName DfsObjRelshpLastChgdByUserName 1
DfsObjRelshpLastChgdDate DfsObjRelshpLastChgdDate 1
DfsPositionDescRefSqncNmbr DfsPositionDescRefSqncNmbr 1
DfsPositionRelatedObjectType DfsPositionRelatedObjectType 1
FrcElmntOrgPlngStsCritlty FrcElmntOrgPlngStsCritlty 1

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.

-- Details for qualification management
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_QUALIFNMGMT (
    DFSOBJECTID,
    DFSOBJECTPLANVERSION,
    DFSOBJECTPLNGSTATUS,
    DFSOBJECTTYPE,
    DFSOBJECTVALDTYENDDATE,
    DFSOBJECTVALDTYSTARTDATE,
    DFSPOSITIONRELATEDOBJECTID,
    DFSOBJECTCONCATENATEDID,
    DFSOBJECTINFOTYPE,
    DFSOBJECTRELSHPBTWNOBJ,
    DFSOBJECTRELSHPPRIORITY,
    DFSOBJECTRELSHPSPEC,
    DFSOBJECTSUBTYPE,
    DFSOBJRELSHPLASTCHGDBYUSER,
    DFSOBJRELSHPLASTCHGDBYUSERNAME,
    DFSOBJRELSHPLASTCHGDDATE,
    DFSPOSITIONDESCREFSQNCNMBR,
    DFSPOSITIONRELATEDOBJECTTYPE,
    FRCELMNTORGPLNGSTSCRITLTY,
    PRIMARY KEY (DFSOBJECTID, DFSOBJECTPLANVERSION, DFSOBJECTPLNGSTATUS, DFSOBJECTTYPE, DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, DFSPOSITIONRELATEDOBJECTID)
);

Learn More