I_EMPLOYORGDET

CDS View
11 Fields 7 CDS Views

Employment organization details

I_EMPLOYORGDET is a CDS View in S/4HANA. Employment organization details. It contains 11 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_EmploymentDetails view from BASIC Employment Details
P_Empfactsheet_Employments view from CONSUMPTION Employee Factsheet CDS - Employments
P_Empfactsheet_Projects view left_outer CONSUMPTION Employee Factsheet CDS - Projects
P_EmployeeAllAttribs view left_outer BASIC
P_Employeeorgdet view from CONSUMPTION
P_EmpProjects view left_outer CONSUMPTION Projects of an Employee
P_ETDetailsOfEE view from CONSUMPTION Employment Details of Employee

Fields (11)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 4
KEY PersonnelNumber PersonnelNumber 2
KEY StartDate EmploymentDetailsStartDate,StartDate 3
_CostCenter _CostCenter 2
CompanyCode CompanyCode 3
CostCenter CostCenter 3
EndDate EmploymentDetailsEndDate,EndDate 3
Job Job 3
JobCode JobCode 2
OrganizationalUnit BusinessUnit,Department,Division 3
OrganizationalUnitCode OrganizationalUnitCode 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 organization details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EMPLOYORGDET (
    EMPLOYMENTINTERNALID,
    PERSONNELNUMBER,
    STARTDATE,
    _COSTCENTER,
    COMPANYCODE,
    COSTCENTER,
    ENDDATE,
    JOB,
    JOBCODE,
    ORGANIZATIONALUNIT,
    ORGANIZATIONALUNITCODE,
    PRIMARY KEY (EMPLOYMENTINTERNALID, PERSONNELNUMBER, STARTDATE)
);

Learn More