P_EMPLOYMENTDETAILSCURRENT

CDS View
14 Fields 2 CDS Views

P_EMPLOYMENTDETAILSCURRENT is a CDS View in S/4HANA. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Empfactsheet_Contrinfo view from BASIC Employee Factsheet CDS - Controlling Information
I_EmploymentDetailsCurrent view from BASIC Current Employment Details

Fields (14)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 2
CompanyCode CompanyCode 2
CostCenter CostCenter 2
EmploymentPercent EmploymentPercent 2
EmploymentStatus EmploymentStatus 2
EndDate EndDate 2
Job Job 2
JobName JobName 2
OrganizationalUnit OrganizationalUnit 2
OrganizationalUnitName OrganizationalUnitName 2
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 1
StartDate StartDate 2
WeeklyWorkdays WeeklyWorkdays 1
WeeklyWorkingHours WeeklyWorkingHours 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EMPLOYMENTDETAILSCURRENT (
    EMPLOYMENTINTERNALID,
    COMPANYCODE,
    COSTCENTER,
    EMPLOYMENTPERCENT,
    EMPLOYMENTSTATUS,
    ENDDATE,
    JOB,
    JOBNAME,
    ORGANIZATIONALUNIT,
    ORGANIZATIONALUNITNAME,
    PERSONWORKAGRMTAUTHZNGRPG,
    STARTDATE,
    WEEKLYWORKDAYS,
    WEEKLYWORKINGHOURS,
    PRIMARY KEY (EMPLOYMENTINTERNALID)
);

Learn More