I_EmployOrgDet

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 I_EmployOrgDet.
-- 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: IEMPLOYORGDET

CREATE VIEW I_EmployOrgDet AS
SELECT
  EmploymentInternalID,
  StartDate,
  EndDate,
  PersonnelNumber,
  IsMainEmployment,
  EmploymentStatus,
  CompanyCode,
  CostCenter,
  PersonWorkAgrmtAuthznGrpg,
  Job,
  _JobCode.Name AS JobCode,
  _JobName[1: Language = 'E' ].JobName AS JobName,
  OrganizationalUnit,
  cast('' as short_d ) AS OrganizationalUnitCode,
  cast( '' as orgtx ) AS OrganizationalUnitName
FROM I_EmployOrgDetOp AS org
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON org.CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON org.CostCenter = _CostCenter.CostCenter AND org.CompanyCode = _CostCenter.CompanyCode AND _CostCenter.ValidityStartDate <= $session.system_date AND _CostCenter.ValidityEndDate >= $session.system_date  -- association [1]
LEFT OUTER JOIN I_JobText AS _JobName ON org.Job = _JobName.Job AND _JobName.StartDate <= org.StartDate AND _JobName.EndDate >= org.EndDate  -- association [1]
LEFT OUTER JOIN I_OrgUnitText AS _OrganizationalUnitName ON OrganizationalUnit = _OrganizationalUnitName.OrganizationalUnit  -- association [0..1]
LEFT OUTER JOIN P_J_PDOBJECT AS _JobCode ON org.Job = _JobCode.ObjectID AND org.StartDate <= _JobCode.EndDate AND org.EndDate >= _JobCode.StartDate AND _JobCode.ObjectType = 'C' AND _JobCode.Language = $session.system_language  -- association [1]
;