I_EMPLOYMENT

CDS View
3 Fields 6 CDS Views

Employment

I_EMPLOYMENT is a CDS View in S/4HANA. Employment. It contains 3 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_Empfactsheet_Employee view left_outer CONSUMPTION Employee Factsheet CDS - Employee
P_EmploymentKeyMapping view inner BASIC Keymapping for Employments
P_EmploySTDetCl view inner BASIC Employment status for Cloud
P_Projwipdetpernr view_entity from BASIC Employee name from PERNR
P_SalesOrderFlfmtContact3 view inner COMPOSITE SOFM Sales Order Fulfillment Contact 3
P_SalesOrderFlfmtContact4 view inner COMPOSITE SOFM Sales Order Fulfillment Contact 4

Fields (3)

KeyField CDS FieldsUsed in Views
EmploymentInternalID MainEmploymentInternalID,PersonnelNumber 2
IsMainEmployment IsMainEmployment 1
PersonnelNumber PersonnelNumber 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EMPLOYMENT (
    EMPLOYMENTINTERNALID,
    ISMAINEMPLOYMENT,
    PERSONNELNUMBER
);

Learn More