P_Employeeorgdet

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Employeeorgdet.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PEMPLOYEEORGDET

CREATE VIEW P_Employeeorgdet AS
SELECT
  EmploymentInternalID,
  StartDate,
  EndDate,
  cast(PersonnelNumber as /shcm/employee_int_id) AS PersonnelNumber,
  IsMainEmployment,
  CompanyCode,
  case CostCenter when '' then EE._CostCenter._Text[1: Language = $session.system_language ].CostCenterName else case EE._CostCenter._Text[1: Language = $session.system_language ].CostCenterName when '' then CostCenter else cast(concat(EE._CostCenter._Text[1: Language = $session.system_language ].CostCenterName, concat('(',concat(CostCenter,')'))) as abap.char( 35 )) end end as CostCenter AS char35endendasCostCenter,
  case JobCode when '' then JobName else case JobName when '' then JobCode else cast(concat(JobName, concat('(',concat(JobCode,')'))) as abap.char( 390 )) end end as Job AS char390endendasJob,
  case OrganizationalUnitCode when '' then OrganizationalUnitName else case OrganizationalUnitName when '' then OrganizationalUnitCode else cast(concat(OrganizationalUnitName, concat('(',concat(OrganizationalUnitCode,')'))) as abap.char( 42 )) end end as OrganizationalUnit AS char42endendasOrganizationalUnit
FROM I_EmployOrgDet AS EE
;