I_UtilsReferenceProduct

DDL: I_UTILSREFERENCEPRODUCT SQL: IUILREFPRODUCT Type: view COMPOSITE

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.

3 data source(s) 7 fields

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
KEY UtilitiesProduct CharacteristicsValue ClfnObjectID
Characteristic I_ClfnCharacteristic Characteristic
ProductName
UtilitiesRateCategory _UtilsRateCat UtilitiesRateCategory
CharcValue CharacteristicsValue CharcValue
ProductGroup I_Product ProductGroup 
@AbapCatalog.sqlViewName: 'IUILREFPRODUCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Reference Product for Utilities Product'
define view I_UtilsReferenceProduct
  as select distinct from I_ClfnObjectCharcValue as CharacteristicsValue
    inner join            I_ClfnCharacteristic   as _C    on _C.CharcInternalID = CharacteristicsValue.CharcInternalID
    inner join            I_Product              as _P    on _P.Product = CharacteristicsValue.ClfnObjectID
    inner join            I_UtilsCommonFields    as _Comm on _Comm.UtilsProductGroup = _P.ProductGroup
  //                                                          or _Comm.UtilsReferenceProductGroup = _P.ProductGroup

  association [0..1] to I_UtilsProdRateCat as _UtilsRateCat on _UtilsRateCat.UtilitiesProduct = $projection.UtilitiesProduct

{
  key CharacteristicsValue.CharcInternalID,
  key CharacteristicsValue.ClfnObjectID     as UtilitiesProduct,
      _C.Characteristic,
      _Text[Language = $session.system_language ].ProductName,
      _UtilsRateCat.UtilitiesRateCategory,
      CharacteristicsValue.CharcValue,
      _P.ProductGroup
//      _Comm.UtilsReferenceProductGroup

}
where
  _C.Characteristic = _Comm.RefProdCharacteristic
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTIC",
"I_CLFNOBJECTCHARCVALUE",
"I_PRODUCT",
"I_PRODUCTTEXT",
"I_UTILSCOMMONFIELDS",
"I_UTILSPRODRATECAT"
],
"ASSOCIATED":
[
"I_UTILSPRODRATECAT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More