I_UtilsProdChgRecurring

DDL: I_UTILSPRODCHGRECURRING SQL: IUILPRDRECCHG Type: view COMPOSITE
29 Fields 2 Data Sources 2 Associations

Recurring Charge for a Utilities Product

I_UtilsProdChgRecurring is a Composite CDS View that provides data about "Recurring Charge for a Utilities Product" in SAP S/4HANA. It reads from 2 data sources (I_UtilsRefProdPriceTemplate, I_UtilsOperand) and exposes 29 fields with key fields UtilitiesProduct, Characteristic. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_UtilsRefProdPriceTemplate _PriceTemplateCust inner
I_UtilsOperand _UtilsOperand inner

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_UtilsPriceItem _PriceItem $projection.UtilsPriceID = _PriceItem.UtilsPriceID and $projection.UtilsPriceCategory = _PriceItem.UtilsPriceCategory and $projection.UtilsPriceLevel = _PriceItem.UtilsPriceLevel and _PriceItem.UtilsPriceFromBlock = '0000000000'
[0..1] I_UtilitiesPrice _Price $projection.UtilsPriceID = _Price.UtilsPriceID and $projection.UtilsPriceCategory = _Price.UtilsPriceCategory and $projection.UtilsPriceLevel = _Price.UtilsPriceLevel

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDRECCHG view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Recurring Charge for a Utilities Product view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct _A UtilitiesProduct
KEY Characteristic _A Characteristic Field Name
UtilsPriceCategory _PriceCategory UtilsPriceCategory Price category
UtilsPriceLevel I_UtilsRefProdPriceTemplate UtilsPriceLevel Price level
UtilsSemanticsName1 _A UtilsSemanticsName1
UtilsSemanticsName2 _A UtilsSemanticsName2
ValuePositionNumber _A CharcValuePositionNumber
Division _PriceItem Division Internal Division ID
UtilitiesBillingClass _PriceItem UtilitiesBillingClass
UtilsPriceID _A CharcValue Char. Value
UtilsPriceName _PriceItem UtilsPriceName
UtilsPriceFrequencyUnit _PriceItem UtilsTimeCategory
UtilsPriceFrequencyValue _PriceItem UtilsTimeBasis
CharcFromAmountendasUtilsPriceAmount
UtilsPriceCurrency _A Currency Valuation Crcy
UtilsPriceTierType _PriceItem UtilsPriceTierType
_UtilsChargeTierType _PriceItem _UtilsChargeTierType
_UtilsPriceFrequencyUnit _PriceItem _UtilsPriceFrequencyUnit
UtilsTimeSliceDurationFrom _A UtilsTimeSliceDurationFrom
UtilsTimeSliceDurationTo _A UtilsTimeSliceDurationTo
UtilsTimeSliceDurationUoM _A UtilsTimeSliceDurationUoM
ProductType _A ProductType Product Type Group
ProductGroup _A ProductGroup Product Sold Group
ProductAuthorizationGroup _A ProductAuthorizationGroup
UtilitiesAuthorizationGroup _PriceItem UtilitiesAuthorizationGroup
_ProductType _A _ProductType
_Price _Price
_PriceItem _PriceItem
_ProductGroup _A _ProductGroup

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_UtilsProdChgRecurring.
-- 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: IUILPRDRECCHG

CREATE VIEW I_UtilsProdChgRecurring AS
SELECT
  _A.UtilitiesProduct AS UtilitiesProduct,
  _A.Characteristic AS Characteristic,
  _PriceCategory.UtilsPriceCategory AS UtilsPriceCategory,
  _PriceTemplateCust.UtilsPriceLevel AS UtilsPriceLevel,
  _A.UtilsSemanticsName1 AS UtilsSemanticsName1,
  _A.UtilsSemanticsName2 AS UtilsSemanticsName2,
  _A.CharcValuePositionNumber AS ValuePositionNumber,
  _PriceItem.Division AS Division,
  _PriceItem.UtilitiesBillingClass AS UtilitiesBillingClass,
  _A.CharcValue AS UtilsPriceID,
  _PriceItem.UtilsPriceName AS UtilsPriceName,
  _PriceItem.UtilsTimeCategory AS UtilsPriceFrequencyUnit,
  _PriceItem.UtilsTimeBasis AS UtilsPriceFrequencyValue,
  case when _A.CharcDataType = 'CURR' then _A.CharcFromAmount end as UtilsPriceAmount AS CharcFromAmountendasUtilsPriceAmount,
  _A.Currency AS UtilsPriceCurrency,
  _PriceItem.UtilsPriceTierType AS UtilsPriceTierType,
  _PriceItem._UtilsChargeTierType AS _UtilsChargeTierType,
  _PriceItem._UtilsPriceFrequencyUnit AS _UtilsPriceFrequencyUnit,
  _A.UtilsTimeSliceDurationFrom AS UtilsTimeSliceDurationFrom,
  _A.UtilsTimeSliceDurationTo AS UtilsTimeSliceDurationTo,
  _A.UtilsTimeSliceDurationUoM AS UtilsTimeSliceDurationUoM,
  _A.ProductType AS ProductType,
  _A.ProductGroup AS ProductGroup,
  _A.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _PriceItem.UtilitiesAuthorizationGroup AS UtilitiesAuthorizationGroup,
  _A._ProductType AS _ProductType,
  _A._ProductGroup AS _ProductGroup
INNER JOIN I_UtilsOperand AS _UtilsOperand ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsRefProdPriceTemplate AS _PriceTemplateCust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsPriceItem AS _PriceItem ON UtilsPriceID = _PriceItem.UtilsPriceID AND UtilsPriceCategory = _PriceItem.UtilsPriceCategory AND UtilsPriceLevel = _PriceItem.UtilsPriceLevel AND _PriceItem.UtilsPriceFromBlock = '0000000000'  -- association [0..*]
LEFT OUTER JOIN I_UtilitiesPrice AS _Price ON UtilsPriceID = _Price.UtilsPriceID AND UtilsPriceCategory = _Price.UtilsPriceCategory AND UtilsPriceLevel = _Price.UtilsPriceLevel  -- association [0..1]
;

Learn More