I_DFS_POSITIONTOQUALIFNBLOCKTP

CDS View
24 Fields 1 CDS Views

Transactional view for qualificationblock

I_DFS_POSITIONTOQUALIFNBLOCKTP is a CDS View in S/4HANA. Transactional view for qualificationblock. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DFS_PositionToQualifnBlockTP view from CONSUMPTION Consumption view for qualificationblock

Fields (24)

KeyField CDS FieldsUsed in Views
KEY DfsObjectID DfsObjectID 1
KEY DfsObjectPlanVersion DfsObjectPlanVersion 1
KEY DfsObjectPlngStatus DfsObjectPlngStatus 1
KEY DfsObjectType DfsObjectType 1
KEY DfsPositionRelatedObjectID DfsPositionRelatedObjectID 1
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 1
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 1
DfsObjectConcatenatedID DfsObjectConcatenatedID 1
DfsObjectInfoType DfsObjectInfoType 1
DfsObjectRelshpBtwnObj DfsObjectRelshpBtwnObj 1
DfsObjectRelshpPriority DfsObjectRelshpPriority 1
DfsObjectRelshpSpec DfsObjectRelshpSpec 1
DfsObjectSubType DfsObjectSubType 1
DfsObjectValdtyEndDateFoEd DfsObjectValdtyEndDateFoEd 1
DfsObjectValdtyStartDateFoEd DfsObjectValdtyStartDateFoEd 1
DfsObjRelshpLastChgdByUser DfsObjRelshpLastChgdByUser 1
DfsObjRelshpLastChgdByUserName DfsObjRelshpLastChgdByUserName 1
DfsObjRelshpLastChgdDate DfsObjRelshpLastChgdDate 1
DfsPositionDescRefSqncNmbr DfsPositionDescRefSqncNmbr 1
DfsPositionRelatedObjectIDFoEd DfsPositionRelatedObjectIDFoEd 1
DfsPositionRelatedObjectType DfsPositionRelatedObjectType 1
DfsQualificationLevel DfsQualificationLevel 1
DfsQualificationLevelFoEd DfsQualificationLevelFoEd 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.

-- Transactional view for qualificationblock
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_POSITIONTOQUALIFNBLOCKTP (
    DFSOBJECTID,
    DFSOBJECTPLANVERSION,
    DFSOBJECTPLNGSTATUS,
    DFSOBJECTTYPE,
    DFSPOSITIONRELATEDOBJECTID,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    DFSOBJECTCONCATENATEDID,
    DFSOBJECTINFOTYPE,
    DFSOBJECTRELSHPBTWNOBJ,
    DFSOBJECTRELSHPPRIORITY,
    DFSOBJECTRELSHPSPEC,
    DFSOBJECTSUBTYPE,
    DFSOBJECTVALDTYENDDATEFOED,
    DFSOBJECTVALDTYSTARTDATEFOED,
    DFSOBJRELSHPLASTCHGDBYUSER,
    DFSOBJRELSHPLASTCHGDBYUSERNAME,
    DFSOBJRELSHPLASTCHGDDATE,
    DFSPOSITIONDESCREFSQNCNMBR,
    DFSPOSITIONRELATEDOBJECTIDFOED,
    DFSPOSITIONRELATEDOBJECTTYPE,
    DFSQUALIFICATIONLEVEL,
    DFSQUALIFICATIONLEVELFOED,
    FRCELMNTORGPLNGSTSCRITLTY,
    PRIMARY KEY (DFSOBJECTID, DFSOBJECTPLANVERSION, DFSOBJECTPLNGSTATUS, DFSOBJECTTYPE, DFSPOSITIONRELATEDOBJECTID, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE)
);

Learn More