I_ProductStdVH

DDL: I_PRODUCTSTDVH Type: view COMPOSITE
8 Fields 1 Data Sources

Product Value Help

I_ProductStdVH (Composite)

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

Database & Data Management

I_ProductStdVH is a Composite CDS View that provides data about "Product Value Help" in SAP S/4HANA. It reads from 1 data source (I_Product) and exposes 8 fields with key field Product.

SAP Help Documentation

CategoryCDS Views for Product Master
Data CategoryDimension
StatusC1 Released
Purpose
This CDS view provides the consumer with list of Product records along with its description. This CDS view can be used only as a value help view.

SAP Business Warehouse (SAP BW) Extraction
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 . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessDatabase & Data Management
Application ComponentLO-MD-MM
CapabilitiesData Source for Defining CDS Entities, Data Provider for Value Help, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Search
PackageDatabase & Data Management for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the consumer with list of Product records along with its description. This CDS view can be used only as a value help view.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_Product I_Product from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPROD_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Product view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Product Value Help view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Number
ProductExternalID ProductExternalID External Representation of Material Number
_Text _Text
ProductGroup ProductGroup Product Sold Group
ProductType ProductType Product Type Group
AuthorizationGroup AuthorizationGroup Authorization Group
_ProductGroup_2 _ProductGroup_2
_ProductType _ProductType

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_ProductStdVH.
-- 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_ProductStdVH AS
SELECT
  Product,
  ProductExternalID,
  ProductGroup,
  ProductType,
  AuthorizationGroup
FROM I_Product
;

Learn More