I_CostComponentGroupAssignment

DDL: I_COSTCOMPONENTGROUPASSIGNMENT SQL: ICOSTCOMPGASSGMT Type: view COMPOSITE
9 Fields 1 Data Sources 2 Associations

Cost Component Group Assignments

I_CostComponentGroupAssignment is a Composite CDS View that provides data about "Cost Component Group Assignments" in SAP S/4HANA. It reads from 1 data source (I_CostComponent) and exposes 9 fields with key fields CostComponentStructure, CostComponent, CostOriginGroup, ChartOfAccounts, FromCostElement. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostComponent I_CostComponent from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_CostComponentAssignment _CostComponentAssignment $projection.CostComponentStructure = _CostComponentAssignment.CostComponentStructure and $projection.CostComponent = _CostComponentAssignment.CostComponent
[1] P_CostComponentGroup _CostComponentGroup $projection.CostComponentStructure = _CostComponentGroup.CostComponentStructure and $projection.CostComponent = _CostComponentGroup.CostComponent

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICOSTCOMPGASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Component Group Assignments view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CostComponentStructure CostComponentStructure Reserve
KEY CostComponent CostComponent Cost Component
KEY CostOriginGroup _CostComponentAssignment CostOriginGroup Origin Group
KEY ChartOfAccounts _CostComponentAssignment ChartOfAccounts Node Class
KEY FromCostElement _CostComponentAssignment FromCostElement
CostComponentGroup CostComponentGroup Equity group
ToCostElement _CostComponentAssignment ToCostElement
CostCompIsForCOGM _CostComponentGroup CostCompIsForCOGM Cost of Goods Mfd
CostComponentGroupName

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_CostComponentGroupAssignment.
-- 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: ICOSTCOMPGASSGMT

CREATE VIEW I_CostComponentGroupAssignment AS
SELECT
  CostComponentStructure,
  CostComponent,
  _CostComponentAssignment.CostOriginGroup AS CostOriginGroup,
  _CostComponentAssignment.ChartOfAccounts AS ChartOfAccounts,
  _CostComponentAssignment.FromCostElement AS FromCostElement,
  CostComponentGroup,
  _CostComponentAssignment.ToCostElement AS ToCostElement,
  _CostComponentGroup.CostCompIsForCOGM AS CostCompIsForCOGM,
  _CostComponentGroup._Text[ Language = $session.system_language ].CostComponentGroupName AS CostComponentGroupName
FROM I_CostComponent
LEFT OUTER JOIN I_CostComponentAssignment AS _CostComponentAssignment ON CostComponentStructure = _CostComponentAssignment.CostComponentStructure AND CostComponent = _CostComponentAssignment.CostComponent  -- association [1..*]
LEFT OUTER JOIN P_CostComponentGroup AS _CostComponentGroup ON CostComponentStructure = _CostComponentGroup.CostComponentStructure AND CostComponent = _CostComponentGroup.CostComponent  -- association [1]
;

Learn More