C_PlanCostRateHistory

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_PlanCostRateHistory.
-- 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: CFIPLANCOSTRATEH

CREATE VIEW C_PlanCostRateHistory AS
SELECT
  AccountingCostRateUUID,
  CostCenter,
  ActivityType,
  Currency,
  Ledger,
  _LedgerText.LedgerName AS LedgerName,
  ValidityStartFiscalYear,
  ValidityStartFiscalPeriod,
  CostRateFixedAmount,
  CostRateTotalAmount,
  CostRateVarblAmount,
  CostRateScaleFactor,
  CostCtrActivityTypeQtyUnit,
  CompanyCode,
  ControllingArea,
  ValidityEndFiscalYear,
  ValidityEndFiscalPeriod,
  ValidityStartDate,
  ValidityEndDate,
  CreationDateTime,
  DeletionDateTime,
  CostRateIsDeleted,
  CreatedByUser,
  DeletedByUser,
  PlanningCategory,
  ControllingObject,
  CostObject,
  AccountingCostRateDesc,
  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
FROM I_AccountingCostRateHistory
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
;