C_SchedProdnProductGroupVH

DDL: C_SCHEDPRODNPRODUCTGROUPVH SQL: CSHPDGRPVH Type: view CONSUMPTION
3 Fields 3 Data Sources

Value Help for Product Group

C_SchedProdnProductGroupVH is a Consumption CDS View that provides data about "Value Help for Product Group" in SAP S/4HANA. It reads from 3 data sources (I_SDMAreaOfResponsibility, I_Product, I_ProductPlant) and exposes 3 fields with key field ProductGroup.

Data Sources (3)

SourceAliasJoin Type
I_SDMAreaOfResponsibility _SDMAreaOfResponsibility inner
I_Product Product inner
I_ProductPlant ProductPlant inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CSHPDGRPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
ObjectModel.semanticKey ProductGroup view
ObjectModel.representativeKey ProductGroup view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Value Help for Product Group view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ProductGroup ProductGroup ProductGroup Product Sold Group
ProductGroupName
AuthorizationGroup ProductGroup AuthorizationGroup AuthorizGroup

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_SchedProdnProductGroupVH.
-- 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: CSHPDGRPVH

CREATE VIEW C_SchedProdnProductGroupVH AS
SELECT
  ProductGroup.ProductGroup AS ProductGroup,
  ProductGroup._ProductGroupText[1: Language = $session.system_language].ProductGroupName AS ProductGroupName,
  ProductGroup.AuthorizationGroup AS AuthorizationGroup
INNER JOIN I_Product AS Product ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductPlant AS ProductPlant ON /* join condition not captured in parsed metadata */
INNER JOIN I_SDMAreaOfResponsibility AS _SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
;

Learn More