I_PlnCostRateCompBreakdown

DDL: I_PLNCOSTRATECOMPBREAKDOWN Type: view_entity BASIC
16 Fields 1 Data Sources 1 Associations

Plan Cost Rate Component Breakdown

I_PlnCostRateCompBreakdown is a Basic CDS View that provides data about "Plan Cost Rate Component Breakdown" in SAP S/4HANA. It reads from 1 data source (accostrate) and exposes 16 fields with key fields AccountingCostRateUUID, ComponentBreakdownMethod, CostComponent, Ledger. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
accostrate _PlanCostRate from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CostComponentText _CostComponentText _CostComponentText.Language = $session.system_language and $projection.CostComponentStructure = _CostComponentText.CostComponentStructure and $projection.CostComponent = _CostComponentText.CostComponent

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Plan Cost Rate Component Breakdown view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AccountingCostRateUUID accostrate rateuuid Cost Rate UUID
KEY ComponentBreakdownMethod _accdb ucb_method Breakdown Method
KEY CostComponent _component cost_component Cost Component
KEY Ledger _accdb ledger Ledger
CostComponentStructure _method cost_comp_struc Cost Comp. Structure
CostCenter accostrate kostl Substitute CC
ActivityType accostrate activity_type Inward/Outward Acty
ValidityStartDate accostrate datefrom Valid From
ValidityEndDate accostrate dateto Valid-To Date
ComponentBreakdownMethodName
CostComponentName _CostComponentText CostComponentName
Currency accostrate currency Valuation Crcy
CostRateScaleFactor accostrate scalefactor Per
CostCtrActivityTypeQtyUnit accostrate activity_unit Activity Unit
CompanyCode accostrate bukrs Value
ControllingArea accostrate kokrs Org. Value

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_PlnCostRateCompBreakdown.
-- 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 I_PlnCostRateCompBreakdown AS
SELECT
  _PlanCostRate.rateuuid AS AccountingCostRateUUID,
  _accdb.ucb_method AS ComponentBreakdownMethod,
  _component.cost_component AS CostComponent,
  _accdb.ledger AS Ledger,
  _method.cost_comp_struc AS CostComponentStructure,
  _PlanCostRate.kostl AS CostCenter,
  _PlanCostRate.activity_type AS ActivityType,
  _PlanCostRate.datefrom AS ValidityStartDate,
  _PlanCostRate.dateto AS ValidityEndDate,
  cast(coalesce( _methodtext.name, 'undefined' ) as fucb_method_name ) AS ComponentBreakdownMethodName,
  _CostComponentText.CostComponentName AS CostComponentName,
  _PlanCostRate.currency AS Currency,
  _PlanCostRate.scalefactor AS CostRateScaleFactor,
  _PlanCostRate.activity_unit AS CostCtrActivityTypeQtyUnit,
  _PlanCostRate.bukrs AS CompanyCode,
  _PlanCostRate.kokrs AS ControllingArea
FROM accostrate AS _PlanCostRate
LEFT OUTER JOIN I_CostComponentText AS _CostComponentText ON _CostComponentText.Language = $session.system_language AND CostComponentStructure = _CostComponentText.CostComponentStructure AND CostComponent = _CostComponentText.CostComponent  -- association [0..*]
;

Learn More