I_EMPLOYMENTDETAILSCURRENT

CDS View
7 Fields 3 CDS Views

Current Employment Details

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PersonWorkAgrmtSrvcCostLevel view from CONSUMPTION Work Agreement Service Cost Level for Employment
P_EmpDetailsCurrent view from CONSUMPTION
P_Servicecostlevel view from COMPOSITE

Fields (7)

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

-- 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