C_ServiceCostRateHistory

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 C_ServiceCostRateHistory.
-- 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: CFISRVCOSTRATEH

CREATE VIEW C_ServiceCostRateHistory AS
SELECT
  AccountingCostRateUUID,
  CompanyCode,
  ReceivingCompanyCode,
  IsIntercompanyRate,
  CostCenter,
  TimeSheetOvertimeCategory,
  ActivityType,
  ServiceCostLevel,
  WorkItem,
  PersonnelNumber,
  cast( _PersonWorkAgreement.PersonFullName as fco_employee_full_name preserving type) AS EmployeeFullName,
  WBSElementExternalID,
  ValidityStartFiscalYear,
  ValidityStartFiscalPeriod,
  Currency,
  Ledger,
  _LedgerText.LedgerName AS LedgerName,
  cast( CostRateVarblAmount as fco_cost_rate preserving type ) AS CostRateVarblAmount,
  CostRateScaleFactor,
  CostCtrActivityTypeQtyUnit,
  ControllingArea,
  WBSElementInternalID,
  ValidityEndFiscalYear,
  ValidityEndFiscalPeriod,
  ValidityStartDate,
  ValidityEndDate,
  CreationDateTime,
  DeletionDateTime,
  CostRateIsDeleted,
  CreatedByUser,
  DeletedByUser,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  cast( _ReceivingCompanyCode.CompanyCodeName as fco_receiving_companycode_name preserving type ) AS ReceivingCompanyCodeName,
  cast( _CurrentCostCenter._Text[1: Language = $session.system_language].CostCenterName as fis_kostl_name preserving type) AS CostCenterName,
  cast( _CurrentCostCtrActyType._Text[1: Language = $session.system_language].CostCtrActivityTypeName as fco_activity_type_name preserving type) AS CostCtrActivityTypeName,
  cast( _CurrentServiceCostLevel._Text[1: Language = $session.system_language].ServiceCostLevelName as fco_service_cost_level_name preserving type) AS ServiceCostLevelName,
  _WorkItem._Text[1: Language = $session.system_language].WorkItemName AS WorkItemName,
  _WBSElementInternalID.WBSDescription AS WBSElementDescription
FROM I_AccountingCostRateHistory
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
;