I_EmploymentDetailsCurrent

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_EmploymentDetailsCurrent.
-- 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: IEMPLOYDETCUR

CREATE VIEW I_EmploymentDetailsCurrent AS
SELECT
  EmploymentDetails.EmploymentInternalID AS EmploymentInternalID,
  EmploymentDetails.StartDate AS StartDate,
  EmploymentDetails.EndDate AS EndDate,
  EmploymentDetails.EmploymentStatus AS EmploymentStatus,
  EmploymentDetails.CompanyCode AS CompanyCode,
  EmploymentDetails.CostCenter AS CostCenter,
  EmploymentDetails.EmploymentPercent AS EmploymentPercent,
  EmploymentDetails.WeeklyWorkingHours AS WeeklyWorkingHours,
  EmploymentDetails.WeeklyWorkdays AS WeeklyWorkdays,
  EmploymentDetails.Job AS Job,
  _JobCode.Name AS JobCode,
  EmploymentDetails.JobName AS JobName,
  EmploymentDetails.OrganizationalUnit AS OrganizationalUnit,
  _OrgUnitCode.Name AS OrganizationalUnitCode,
  EmploymentDetails.OrganizationalUnitName AS OrganizationalUnitName,
  EmploymentDetails.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg
FROM P_EmploymentDetailsCurrent AS EmploymentDetails
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND CompanyCode = _CostCenter.CompanyCode  -- association [1]
LEFT OUTER JOIN I_JobText AS _JobName ON Job = _JobName.Job AND _JobName.EndDate >= $session.system_date AND _JobName.StartDate <= $session.system_date  -- association [1]
LEFT OUTER JOIN I_OrgUnitText AS _OrganizationalUnitName ON OrganizationalUnit = _OrganizationalUnitName.OrganizationalUnit association[0..1] to P_PDOBJECT as _OrgUnitCode on OrganizationalUnit = _OrgUnitCode.ObjectID AND _OrgUnitCode.EndDate >= $session.system_date AND _OrgUnitCode.StartDate <= $session.system_date AND _OrgUnitCode.ObjectType = 'O' association[1] to P_J_PDOBJECT as _JobCode on Job = _JobCode.ObjectID AND _JobCode.EndDate >= $session.system_date AND _JobCode.StartDate <= $session.system_date AND _JobCode.ObjectType = 'C'  -- association [0..1]
LEFT OUTER JOIN I_EmploymentStatusText AS _EmploymentStatusText ON EmploymentStatus = _EmploymentStatusText.EmploymentStatus  -- association [0..*]
LEFT OUTER JOIN I_Employment AS _Employment ON EmploymentInternalID = _Employment.EmploymentInternalID AND StartDate <= _Employment.EndDate AND EndDate >= _Employment.StartDate  -- association [0..1]
LEFT OUTER JOIN I_Employmentcostlevel AS _ServiceCostLevel ON EmploymentInternalID = _ServiceCostLevel.EmploymentInternalID AND _ServiceCostLevel.EndDate >= $session.system_date AND _ServiceCostLevel.StartDate <= $session.system_date  -- association [0..1]
;