I_EMPLOYSTATDET

CDS View
2 Fields 4 CDS Views

Employment status

I_EMPLOYSTATDET is a CDS View in S/4HANA. Employment status. It contains 2 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ChgRecdWorkflowRecipientVH view inner CONSUMPTION People Picker for Change Record task processor
I_Employeeshlp view left_outer BASIC Search Help for Employee
I_Employmentshlp view inner BASIC Search Help for Personnel Assignments of Employee
P_EmploymentDetailsCurrent view left_outer BASIC

Fields (2)

KeyField CDS FieldsUsed in Views
KEY PersonnelNumber PersonnelNumber 1
EmploymentStatus EmploymentStatus 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EMPLOYSTATDET (
    PERSONNELNUMBER,
    EMPLOYMENTSTATUS,
    PRIMARY KEY (PERSONNELNUMBER)
);

Learn More