P_CostComponentGroup

DDL: P_COSTCOMPONENTGROUP SQL: PFICOSTCOMPGRP Type: view COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS

Cost Component Group

P_CostComponentGroup is a Composite CDS View that provides data about "Cost Component Group" 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. Part of development package ODATA_CO_RT_PRODUCTION_COSTS.

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
KEY CostComponent CostComponent
CostComponentGroup
CostCompIsForCOGM CostCompIsForCOGM
_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..*]
;