C_CPurConHierFltrMatlGrpVH

DDL: C_CPURCONHIERFLTRMATLGRPVH SQL: CCCTRHRFMTLGRPVH Type: view CONSUMPTION
3 Fields 1 Data Sources 1 Associations

Hierarhy CCTR Matl Grp Filter

C_CPurConHierFltrMatlGrpVH is a Consumption CDS View that provides data about "Hierarhy CCTR Matl Grp Filter" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocument) and exposes 3 fields with key field MaterialGroup. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocument I_PurchasingDocument inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialGroupText _MaterialGroupText _MaterialGroupText.MaterialGroup = $projection.MaterialGroup and _MaterialGroupText.Language = $session.system_language

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCCTRHRFMTLGRPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey MaterialGroup view
ObjectModel.representativeKey MaterialGroup view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Hierarhy CCTR Matl Grp Filter view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MaterialGroup I_PurchasingDocumentItem MaterialGroup Product Group
MaterialGroupText _MaterialGroupText MaterialGroupText Material Group Text
MaterialGroupName _MaterialGroupText MaterialGroupName Material Group Description

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 C_CPurConHierFltrMatlGrpVH.
-- 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: CCCTRHRFMTLGRPVH

CREATE VIEW C_CPurConHierFltrMatlGrpVH AS
SELECT
  I_PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
  _MaterialGroupText.MaterialGroupText AS MaterialGroupText,
  _MaterialGroupText.MaterialGroupName AS MaterialGroupName
INNER JOIN I_PurchasingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON _MaterialGroupText.MaterialGroup = MaterialGroup AND _MaterialGroupText.Language = $session.system_language  -- association [0..1]
;

Learn More