I_EMPLOYMENTDETAILSCURRENT

CDS View
7 Fields 2 CDS Views

Current Employment Details

I_EMPLOYMENTDETAILSCURRENT is a CDS View in S/4HANA. Current Employment Details. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EmpDetailsCurrent view from CONSUMPTION Private view for Current Employment details
P_Servicecostlevel view from COMPOSITE Cost rate level

Fields (7)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 2
KEY StartDate StartDate 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
Job Job 2
JobName JobName 2
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 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.

-- Current Employment Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EMPLOYMENTDETAILSCURRENT (
    EMPLOYMENTINTERNALID,
    STARTDATE,
    COMPANYCODE,
    COSTCENTER,
    JOB,
    JOBNAME,
    PERSONWORKAGRMTAUTHZNGRPG,
    PRIMARY KEY (EMPLOYMENTINTERNALID, STARTDATE)
);

Learn More