P_EMPLOYEESTATUS

CDS View
3 Fields 1 CDS Views

Employment Status of Employee

P_EMPLOYEESTATUS is a CDS View in S/4HANA. Employment Status of Employee. It contains 3 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ActiveEmployee view from BASIC Active Employee

Fields (3)

KeyField CDS FieldsUsed in Views
KEY PersonnelNumber PersonnelNumber 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Employment Status of Employee
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EMPLOYEESTATUS (
    PERSONNELNUMBER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PERSONNELNUMBER)
);

Learn More