I_DFS_POSITIONEMPLOYEEGROUPTP

CDS View
13 Fields 1 CDS Views

Transactional View of DFS Employee Group

I_DFS_POSITIONEMPLOYEEGROUPTP is a CDS View in S/4HANA. Transactional View of DFS Employee Group. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_DFS_PositionEmployeeGroupTP view from CONSUMPTION

Fields (13)

KeyField CDS FieldsUsed in Views
KEY DfsPositionID DfsPositionID 1
KEY DfsPositionObjectType DfsPositionObjectType 1
KEY DfsPositionPlanVersion DfsPositionPlanVersion 1
KEY DfsPositionPlngStatus DfsPositionPlngStatus 1
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 1
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 1
DfsPositionConcatenatedID DfsPositionConcatenatedID 1
DfsPositionEmployeeGroup DfsPositionEmployeeGroup 1
DfsPositionEmployeeSubGroup DfsPositionEmployeeSubGroup 1
DfsPositionInfoType DfsPositionInfoType 1
DfsPositionPlngStsCritlty DfsPositionPlngStsCritlty 1
DfsPositionValdtyEndDateFoEd DfsPositionValdtyEndDateFoEd 1
DfsPositionValdtyStartDateFoEd DfsPositionValdtyStartDateFoEd 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 of DFS Employee Group
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_POSITIONEMPLOYEEGROUPTP (
    DFSPOSITIONID,
    DFSPOSITIONOBJECTTYPE,
    DFSPOSITIONPLANVERSION,
    DFSPOSITIONPLNGSTATUS,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    DFSPOSITIONCONCATENATEDID,
    DFSPOSITIONEMPLOYEEGROUP,
    DFSPOSITIONEMPLOYEESUBGROUP,
    DFSPOSITIONINFOTYPE,
    DFSPOSITIONPLNGSTSCRITLTY,
    DFSPOSITIONVALDTYENDDATEFOED,
    DFSPOSITIONVALDTYSTARTDATEFOED,
    PRIMARY KEY (DFSPOSITIONID, DFSPOSITIONOBJECTTYPE, DFSPOSITIONPLANVERSION, DFSPOSITIONPLNGSTATUS, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE)
);

Learn More