P_CostComponentGroup

DDL: P_COSTCOMPONENTGROUP SQL: PFICOSTCOMPGRP Type: view COMPOSITE
5 Fields 1 Data Sources 1 Associations

P_CostComponentGroup is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CostComponent) and exposes 5 fields with key fields CostComponentStructure, CostComponent. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostComponent I_CostComponent from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_CostComponentGroupText _Text $projection.CostComponentGroup = _Text.CostComponentGroup

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFICOSTCOMPGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CostComponentStructure CostComponentStructure Reserve
KEY CostComponent CostComponent Cost Component
CostComponentGroup Equity group
CostCompIsForCOGM CostCompIsForCOGM Cost of Goods Mfd
_Text _Text

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 P_CostComponentGroup.
-- 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: PFICOSTCOMPGRP

CREATE VIEW P_CostComponentGroup AS
SELECT
  CostComponentStructure,
  CostComponent,
  cast(CostComponentGroup as fis_ck_el_grup) AS CostComponentGroup,
  CostCompIsForCOGM
FROM I_CostComponent
LEFT OUTER JOIN I_CostComponentGroupText AS _Text ON CostComponentGroup = _Text.CostComponentGroup  -- association [1..*]
;

Learn More