I_Empfactsheet_Contrinfo

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_Empfactsheet_Contrinfo.
-- 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: IEMPFSCI

CREATE VIEW I_Empfactsheet_Contrinfo 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.Job AS Job,
  _JobCode.Name AS JobCode,
  EmploymentDetails.JobName AS JobName,
  EmploymentDetails.OrganizationalUnit AS OrganizationalUnit,
  EmploymentDetails.OrganizationalUnitName AS OrganizationalUnitName,
  _ServiceCostLevel.StartDate AS ValidityStartDate,
  _ServiceCostLevel.EndDate AS ValidityEndDate
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.StartDate <= StartDate AND _JobName.EndDate >= EndDate association[1] to P_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  -- association [0..1]
;