R_PlanCostRateTP

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 R_PlanCostRateTP.
-- 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.

CREATE VIEW R_PlanCostRateTP AS
SELECT
  _PlanCostRate.AccountingCostRateUUID AS AccountingCostRateUUID,
  _PlanCostRate.Ledger AS Ledger,
  _PlanCostRate.CurrencyRole AS CurrencyRole,
  _PlanCostRate.CompanyCode AS CompanyCode,
  _PlanCostRate.ControllingArea AS ControllingArea,
  _PlanCostRate.CostCenter AS CostCenter,
  _PlanCostRate.ActivityType AS ActivityType,
  _PlanCostRate.PlanningCategory AS PlanningCategory,
  _PlanCostRate.ValidityStartFiscalYear AS ValidityStartFiscalYear,
  _PlanCostRate.ValidityStartFiscalPeriod AS ValidityStartFiscalPeriod,
  _PlanCostRate.ValidityStartDate AS ValidityStartDate,
  _PlanCostRate.ValidityEndFiscalYear AS ValidityEndFiscalYear,
  _PlanCostRate.ValidityEndFiscalPeriod AS ValidityEndFiscalPeriod,
  _PlanCostRate.ValidityEndDate AS ValidityEndDate,
  _PlanCostRate.CostCtrActivityTypeQtyUnit AS CostCtrActivityTypeQtyUnit,
  _PlanCostRate.Currency AS Currency,
  _PlanCostRate.CostRateFixedAmount AS CostRateFixedAmount,
  _PlanCostRate.CostRateTotalAmount AS CostRateTotalAmount,
  _PlanCostRate.CostRateVarblAmount AS CostRateVarblAmount,
  _PlanCostRate.CostRateScaleFactor AS CostRateScaleFactor,
  _PlanCostRate.ControllingObject AS ControllingObject,
  _PlanCostRate.AccountingCostRateObject AS AccountingCostRateObject,
  _PlanCostRate.ComponentBreakdown AS ComponentBreakdown,
  cast(0.0000000 as abp_lastchange_tstmpl) AS LocalLastChangeDateTime,
  cast(0.0000000 as vdm_lastchangedon) AS LastChangeDateTime,
  cast(_PlanCostRate.ValidityStartDate as fco_valid_on) AS ValidityDate,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as hrytxt) AS CostCenterHierarchyName,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast('' as nodetxt) AS HierarchyNodeText,
  cast( 0 as int4) AS RowIndex,
  cast( '' as fco_overwrite) AS CostRateIsOverwriteMode,
  CreatedByUser,
  CreationDateTime,
  _PlanCostRate._CompanyCode AS _CompanyCode,
  _PlanCostRate._CostCenter AS _CostCenter,
  _PlanCostRate._CostCtrActivityType AS _CostCtrActivityType,
  _PlanCostRate._Currency AS _Currency,
  _PlanCostRate._CurrentCostCenter AS _CurrentCostCenter,
  _PlanCostRate._CurrentCostCtrActyType AS _CurrentCostCtrActyType,
  _PlanCostRate._UnitOfMeasure AS _UnitOfMeasure,
  _PlanCostRate._LedgerText AS _LedgerText,
  _PlanCostRate._CostCtrActivityTypeText AS _CostCtrActivityTypeText,
  _PlanCostRate._ControllingAreaText AS _ControllingAreaText
FROM I_AccountingCostRate_2 AS _PlanCostRate
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategory ON PlanningCategory = _PlanningCategory.PlanningCategory  -- association [0..1]
LEFT OUTER JOIN E_AccountingCostRate AS _Extension ON AccountingCostRateUUID = _Extension.AccountingCostRateUUID  -- association [1]
;