I_DFS_POSITIONTOJOBTP

CDS View
17 Fields 1 CDS Views

Transactional Processing View of Position To Job

I_DFS_POSITIONTOJOBTP is a CDS View in S/4HANA. Transactional Processing View of Position To Job. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DFS_PositionToJobTP view from CONSUMPTION

Fields (17)

KeyField CDS FieldsUsed in Views
KEY DfsPositionID DfsPositionID 1
KEY DfsPositionObjectType DfsPositionObjectType 1
KEY DfsPositionPlanVersion DfsPositionPlanVersion 1
KEY DfsPositionPlngStatus DfsPositionPlngStatus 1
KEY DfsPositionRelatedObjectID DfsPositionRelatedObjectID 1
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 1
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 1
DfsObjectConcatenatedID DfsObjectConcatenatedID 1
DfsPositionInfoType DfsPositionInfoType 1
DfsPositionRelatedObjectIDFoEd DfsPositionRelatedObjectIDFoEd 1
DfsPositionRelatedObjectType DfsPositionRelatedObjectType 1
DfsPositionRelshpBtwnObj DfsPositionRelshpBtwnObj 1
DfsPositionRelshpSpec DfsPositionRelshpSpec 1
DfsPositionSubType DfsPositionSubType 1
DfsPositionValdtyEndDateFoEd DfsPositionValdtyEndDateFoEd 1
DfsPositionValdtyStartDateFoEd DfsPositionValdtyStartDateFoEd 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 Processing View of Position To Job
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_POSITIONTOJOBTP (
    DFSPOSITIONID,
    DFSPOSITIONOBJECTTYPE,
    DFSPOSITIONPLANVERSION,
    DFSPOSITIONPLNGSTATUS,
    DFSPOSITIONRELATEDOBJECTID,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    DFSOBJECTCONCATENATEDID,
    DFSPOSITIONINFOTYPE,
    DFSPOSITIONRELATEDOBJECTIDFOED,
    DFSPOSITIONRELATEDOBJECTTYPE,
    DFSPOSITIONRELSHPBTWNOBJ,
    DFSPOSITIONRELSHPSPEC,
    DFSPOSITIONSUBTYPE,
    DFSPOSITIONVALDTYENDDATEFOED,
    DFSPOSITIONVALDTYSTARTDATEFOED,
    FRCELMNTORGPLNGSTSCRITLTY,
    PRIMARY KEY (DFSPOSITIONID, DFSPOSITIONOBJECTTYPE, DFSPOSITIONPLANVERSION, DFSPOSITIONPLNGSTATUS, DFSPOSITIONRELATEDOBJECTID, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE)
);

Learn More