P_DFS_POSITIONVACANCY

CDS View
10 Fields 1 CDS Views

P_DFS_POSITIONVACANCY is a CDS View in S/4HANA. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DFS_PositionVacancy view from BASIC Interface view for position vacancy

Fields (10)

KeyField CDS FieldsUsed in Views
KEY DfsPositionID DfsPositionID 1
KEY DfsPositionObjectType DfsPositionObjectType 1
KEY DfsPositionPlanVersion DfsPositionPlanVersion 1
KEY DfsPositionPlngStatus DfsPositionPlngStatus 1
KEY DfsPositionSubType DfsPositionSubType 1
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 1
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 1
DfsPositionInfoType DfsPositionInfoType 1
DfsPositionIsVacant DfsPositionIsVacant 1
DfsPositionVacancyStatus DfsPositionVacancyStatus 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_DFS_POSITIONVACANCY (
    DFSPOSITIONID,
    DFSPOSITIONOBJECTTYPE,
    DFSPOSITIONPLANVERSION,
    DFSPOSITIONPLNGSTATUS,
    DFSPOSITIONSUBTYPE,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    DFSPOSITIONINFOTYPE,
    DFSPOSITIONISVACANT,
    DFSPOSITIONVACANCYSTATUS,
    PRIMARY KEY (DFSPOSITIONID, DFSPOSITIONOBJECTTYPE, DFSPOSITIONPLANVERSION, DFSPOSITIONPLNGSTATUS, DFSPOSITIONSUBTYPE, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE)
);

Learn More