I_PersonWorkAgrmtForKeyDate

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_PersonWorkAgrmtForKeyDate.
-- 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: IPERWKAGRKEYDATE
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_PersonWorkAgrmtForKeyDate AS
SELECT
  OrgDetails.PersonWorkAgreement AS PersonWorkAgreement,
  $parameters.P_KeyDate AS KeyDate,
  OrgDetails.CompanyCode AS CompanyCode,
  OrgDetails.CostCenter AS CostCenter,
  OrgDetails.Job AS Job,
  OrgDetails.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg,
  OrgDetails.OrganizationalUnit AS OrganizationalUnit,
  StatusDetails.WorkAgreementStatus AS WorkAgreementStatus,
  WSDetails.WorkingTimePercentage AS WorkingTimePercentage,
  WSDetails.WeeklyWorkdays AS WeeklyWorkdays,
  WSDetails.WeeklyWorkingHours AS WeeklyWorkingHours,
  ServiceCostLevel.ServiceCostLevel AS ServiceCostLevel
FROM I_PersonWorkAgrmtOrglDetails AS OrgDetails
INNER JOIN I_PersonWorkAgrmtStatus AS StatusDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PersonWorkAgrmtPlndWrkgTime AS WSDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PersonWorkAgrmtSrvcCostLevel AS ServiceCostLevel ON /* join condition not captured in parsed metadata */
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 AND _CostCenter.ValidityStartDate <= $parameters.P_KeyDate AND _CostCenter.ValidityEndDate >= $parameters.P_KeyDate  -- association [1]
LEFT OUTER JOIN I_PersonWorkAgrmtJobText AS _PersonWorkAgrmtJobText ON Job = _PersonWorkAgrmtJobText.Job AND _PersonWorkAgrmtJobText.StartDate <= $parameters.P_KeyDate AND _PersonWorkAgrmtJobText.EndDate >= $parameters.P_KeyDate  -- association [0..*]
LEFT OUTER JOIN I_OrganizationalUnitText AS _OrganizationalUnitName ON OrganizationalUnit = _OrganizationalUnitName.OrganizationalUnit AND _OrganizationalUnitName.StartDate <= $parameters.P_KeyDate AND _OrganizationalUnitName.EndDate >= $parameters.P_KeyDate  -- association [0..*]
LEFT OUTER JOIN I_PersonWorkAgrmtStatusText AS _PersonWorkAgrmtStatusText ON _PersonWorkAgrmtStatusText.WorkAgreementStatus = WorkAgreementStatus  -- association [0..*]
;