I_UtilsReferenceProduct

DDL: I_UTILSREFERENCEPRODUCT SQL: IUILREFPRODUCT Type: view COMPOSITE
7 Fields 3 Data Sources 1 Associations

Reference Product for Utilities Product

I_UtilsReferenceProduct is a Composite CDS View that provides data about "Reference Product for Utilities Product" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharacteristic, I_UtilsCommonFields, I_Product) and exposes 7 fields with key fields CharcInternalID, UtilitiesProduct. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharacteristic _C inner
I_UtilsCommonFields _Comm inner
I_Product _P inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UtilsProdRateCat _UtilsRateCat _UtilsRateCat.UtilitiesProduct = $projection.UtilitiesProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUILREFPRODUCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Reference Product for Utilities Product view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharacteristicsValue CharcInternalID Characteristic Internal ID
KEY UtilitiesProduct CharacteristicsValue ClfnObjectID
Characteristic I_ClfnCharacteristic Characteristic Field Name
ProductName
UtilitiesRateCategory _UtilsRateCat UtilitiesRateCategory
CharcValue CharacteristicsValue CharcValue Char. Value
ProductGroup I_Product ProductGroup Product Sold Group

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_UtilsReferenceProduct.
-- 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: IUILREFPRODUCT

CREATE VIEW I_UtilsReferenceProduct AS
SELECT
  CharacteristicsValue.CharcInternalID AS CharcInternalID,
  CharacteristicsValue.ClfnObjectID AS UtilitiesProduct,
  _C.Characteristic AS Characteristic,
  _Text[Language = $session.system_language ].ProductName AS ProductName,
  _UtilsRateCat.UtilitiesRateCategory AS UtilitiesRateCategory,
  CharacteristicsValue.CharcValue AS CharcValue,
  _P.ProductGroup AS ProductGroup
INNER JOIN I_ClfnCharacteristic AS _C ON /* join condition not captured in parsed metadata */
INNER JOIN I_Product AS _P ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsCommonFields AS _Comm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsProdRateCat AS _UtilsRateCat ON _UtilsRateCat.UtilitiesProduct = UtilitiesProduct  -- association [0..1]
;

Learn More