C_PlanCostRate

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_PlanCostRate.
-- 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: CFIPLANCOSTRATE

CREATE VIEW C_PlanCostRate AS
SELECT
  AccountingCostRateUUID,
  cast(ValidityStartDate as fco_valid_on) AS ValidityDate,
  CostCenter,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  ActivityType,
  Ledger,
  Currency,
  ValidityStartFiscalYear,
  ValidityStartFiscalPeriod,
  CostRateFixedAmount,
  CostRateTotalAmount,
  CostRateVarblAmount,
  CostRateScaleFactor,
  CostCtrActivityTypeQtyUnit,
  CompanyCode,
  ControllingArea,
  ValidityEndFiscalYear,
  ValidityEndFiscalPeriod,
  ValidityStartDate,
  ValidityEndDate,
  PlanningCategory,
  ControllingObject,
  CostObject,
  AccountingCostRateDesc,
  cast( 0 as int4) AS RowIndex,
  cast( '' as fco_overwrite) AS CostRateIsOverwriteMode,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  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,
  _LedgerText.LedgerName AS LedgerName
FROM I_PlanCostRate
LEFT OUTER JOIN I_CostCenterVH AS _CostCenterVH ON ControllingArea = _CostCenterVH.ControllingArea AND CostCenter = _CostCenterVH.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeVH AS _ActivityTypeVH ON ControllingArea = _ActivityTypeVH.ControllingArea AND ActivityType = _ActivityTypeVH.CostCtrActivityType AND CostCtrActivityTypeQtyUnit = _ActivityTypeVH.CostCtrActivityTypeQtyUnit  -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CostCenterHierarchyLeafNode ON CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101'  -- association [0..*]
LEFT OUTER JOIN C_PlnCostRateCompBreakdown AS _CompBreakdown ON AccountingCostRateUUID = _CompBreakdown.AccountingCostRateUUID  -- association [0..*]
;