I_ProductGroup_2

DDL: I_PRODUCTGROUP_2 Type: view BASIC
8 Fields 1 Data Sources 4 Associations

Product Group

I_ProductGroup_2 (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Product Group · Database & Data Management

I_ProductGroup_2 is a Basic CDS View (Dimension) that provides data about "Product Group" in SAP S/4HANA. It reads from 1 data source (t023) and exposes 8 fields with key field ProductGroup. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Product Master
Data CategoryDimension
Purpose
This CDS view provides the consumer with a list of product groups.

Structure
Fields Used for Filtering Field Name Description ProductGroup Product Group AuthorizationGroup Authorization Group ValuationClass Valuation Class PurchasingAcknProfile Purchasing value key

Data Extraction
This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture. Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-MM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Provider for Value Help, Data Source for Data Extraction, Data Source for Search, Analytical Dimension
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the consumer with list of product groups.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
t023 t023 from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ProductGroupText_2 _ProductGroupText $projection.ProductGroup = _ProductGroupText.ProductGroup
[0..1] I_Prodvaluationclass _ProductValuationClass $projection.ValuationClass = _ProductValuationClass.ValuationClass
[0..1] I_PurgAcknowledgmentProfile _PurgAcknowledgmentProfile $projection.PurchasingAcknProfile = _PurgAcknowledgmentProfile.PurchasingAcknProfile
[0..*] I_ProductGroupHierarchyNode _ProductGroupHierarchyNode $projection.ProductGroup = _ProductGroupHierarchyNode.ProductGroup

Annotations (24)

NameValueLevelField
AbapCatalog.sqlViewName IPRODGRP2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Product Group view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ProductGroup view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ProductGroup view
Consumption.ranked true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProductGroup Product Group
AuthorizationGroup t023 begru Authorization Group
ValuationClass t023 bklas Valuation Class
PurchasingAcknProfile t023 ekwsl Purchasing Value Key
_ProductGroupText _ProductGroupText
_ProductValuationClass _ProductValuationClass
_PurgAcknowledgmentProfile _PurgAcknowledgmentProfile
_ProductGroupHierarchyNode _ProductGroupHierarchyNode

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_ProductGroup_2.
-- 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_ProductGroup_2 AS
SELECT
  cast(t023.matkl as productgroup preserving type ) AS ProductGroup,
  t023.begru AS AuthorizationGroup,
  t023.bklas AS ValuationClass,
  t023.ekwsl AS PurchasingAcknProfile
FROM t023
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON ProductGroup = _ProductGroupText.ProductGroup  -- association [0..*]
LEFT OUTER JOIN I_Prodvaluationclass AS _ProductValuationClass ON ValuationClass = _ProductValuationClass.ValuationClass  -- association [0..1]
LEFT OUTER JOIN I_PurgAcknowledgmentProfile AS _PurgAcknowledgmentProfile ON PurchasingAcknProfile = _PurgAcknowledgmentProfile.PurchasingAcknProfile  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupHierarchyNode AS _ProductGroupHierarchyNode ON ProductGroup = _ProductGroupHierarchyNode.ProductGroup  -- association [0..*]
;

Learn More