I_ServiceCostRate

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_ServiceCostRate.
-- 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: IFISRVCOSTRATE

CREATE VIEW I_ServiceCostRate AS
SELECT
  AccountingCostRateUUID,
  _Rate.Ledger AS Ledger,
  CurrencyRole,
  CompanyCode,
  ControllingArea,
  CostCenter,
  ActivityType,
  IsIntercompanyRate,
  ReceivingCompanyCode,
  ServiceCostLevel,
  PersonnelNumber,
  WBSElementInternalID,
  WBSElementExternalID,
  WorkItem,
  TimeSheetOvertimeCategory,
  ValidityStartFiscalYear,
  ValidityStartFiscalPeriod,
  cast((concat( ValidityStartFiscalYear, ValidityStartFiscalPeriod )) as fins_fyearperiod) AS ValidityStartFiscalYearPeriod,
  ValidityStartDate,
  ValidityEndFiscalYear,
  ValidityEndFiscalPeriod,
  cast((concat( ValidityEndFiscalYear, ValidityEndFiscalPeriod )) as fins_fyearperiod) AS ValidityEndFiscalYearPeriod,
  ValidityEndDate,
  CostCtrActivityTypeQtyUnit,
  Currency,
  cast(CostRateTotalAmount - CostRateFixedAmount as fco_rate_varbl_amount) AS CostRateVarblAmount,
  CostRateScaleFactor
FROM P_AccountingCostRate AS _Rate
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _ReceivingCompanyCode ON ReceivingCompanyCode = _ReceivingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON ControllingArea = _CostCtrActivityType.ControllingArea AND ActivityType = _CostCtrActivityType.CostCtrActivityType  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _CurrentCostCtrActyType ON ControllingArea = _CurrentCostCtrActyType.ControllingArea AND ActivityType = _CurrentCostCtrActyType.CostCtrActivityType AND _CurrentCostCtrActyType.ValidityStartDate <= $session.system_date AND _CurrentCostCtrActyType.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_WorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceCostLevel AS _ServiceCostLevel ON ServiceCostLevel = _ServiceCostLevel.ServiceCostLevel  -- association [0..*]
LEFT OUTER JOIN I_ServiceCostLevel AS _CurrentServiceCostLevel ON ServiceCostLevel = _CurrentServiceCostLevel.ServiceCostLevel AND _CurrentServiceCostLevel.ValidityStartDate <= $session.system_date AND _CurrentServiceCostLevel.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID AND _Employment.StartDate <= $session.system_date AND _Employment.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonnelNumber = _PersonWorkAgreement.PersonWorkAgreement  -- association [1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementExternalID = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementInternalID ON WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CostCtrActivityTypeQtyUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_AccountingCostRate AS _Extension ON AccountingCostRateUUID = _Extension.AccountingCostRateUUID  -- association [1..1]
;