I_AccountingCostRate

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_AccountingCostRate.
-- 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: IFIACCOSTRATE

CREATE VIEW I_AccountingCostRate AS
SELECT
  AccountingCostRateUUID,
  _Rate.Ledger AS Ledger,
  _Rate.CompanyCode AS CompanyCode,
  _Rate.ControllingArea AS ControllingArea,
  _Rate.CostCenter AS CostCenter,
  ActivityType,
  PlanningCategory,
  _P_CostRateBusinessTransType.BusinessTransactionTypeName AS BusinessTransactionTypeName,
  _Rate.ValidityStartDate AS ValidityStartDate,
  _Rate.ValidityEndDate AS ValidityEndDate,
  _Rate.CostCtrActivityTypeQtyUnit AS CostCtrActivityTypeQtyUnit,
  Currency,
  CostRateTotalAmount,
  CostRateScaleFactor,
  AccountingCostRateDesc,
  _I_CostCenterActivityTypeText.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _CurrentCostCenterText.CostCenterName AS CostCenterName
FROM P_AccountingCostRate AS _Rate
INNER JOIN I_Ledger AS _Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN P_CostRateBusinessTransTypeTxt AS _P_CostRateBusinessTransType ON /* join condition not captured in parsed metadata */
INNER JOIN I_CostCenterActivityTypeText AS _I_CostCenterActivityTypeText ON /* join condition not captured in parsed metadata */
INNER JOIN I_CostCenterText AS _CurrentCostCenterText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= ValidityStartDate AND _CurrentCostCenter.ValidityEndDate >= ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CostCtrActivityTypeQtyUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;