I_UtilsProdChgOneTime

DDL: I_UTILSPRODCHGONETIME SQL: IUILPRDOTC Type: view COMPOSITE
17 Fields 1 Associations

One Time Charge for a Utilities Product

I_UtilsProdChgOneTime is a Composite CDS View that provides data about "One Time Charge for a Utilities Product" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDOTC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE 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 One Time Charge for a Utilities Product view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct _A UtilitiesProduct
KEY Characteristic _A Characteristic Field Name
UtilsPriceCategory _PriceCategory UtilsPriceCategory
UtilsSemanticsName1 UtilsSemanticsName1
UtilsSemanticsName2 UtilsSemanticsName2
UtilsPriceID _A CharcValue Char. Value
ValuePositionNumber _A CharcValuePositionNumber
Division _PriceItem Division Internal Division ID
UtilitiesBillingClass _PriceItem UtilitiesBillingClass
CharcFromAmountendasUtilsPriceAmount
CurrencyendasUtilsPriceCurrency
ProductType _A ProductType Product Type Group
ProductGroup _A ProductGroup Product Sold Group
ProductAuthorizationGroup _A ProductAuthorizationGroup
UtilitiesAuthorizationGroup _PriceItem UtilitiesAuthorizationGroup
_ProductType _A _ProductType
_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_UtilsProdChgOneTime.
-- 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: IUILPRDOTC

CREATE VIEW I_UtilsProdChgOneTime AS
SELECT
  _A.UtilitiesProduct AS UtilitiesProduct,
  _A.Characteristic AS Characteristic,
  _PriceCategory.UtilsPriceCategory AS UtilsPriceCategory,
  UtilsSemanticsName1,
  UtilsSemanticsName2,
  _A.CharcValue AS UtilsPriceID,
  _A.CharcValuePositionNumber AS ValuePositionNumber,
  _PriceItem.Division AS Division,
  _PriceItem.UtilitiesBillingClass AS UtilitiesBillingClass,
  case when _A.CharcDataType = 'CURR' then _A.CharcFromAmount end as UtilsPriceAmount AS CharcFromAmountendasUtilsPriceAmount,
  case when _A.CharcDataType = 'CURR' then _A.Currency end as UtilsPriceCurrency AS CurrencyendasUtilsPriceCurrency,
  _A.ProductType AS ProductType,
  _A.ProductGroup AS ProductGroup,
  _A.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _PriceItem.UtilitiesAuthorizationGroup AS UtilitiesAuthorizationGroup,
  _A._ProductType AS _ProductType,
  _A._ProductGroup AS _ProductGroup
LEFT OUTER JOIN I_UtilsPriceItem AS _PriceItem ON UtilsPriceID = _PriceItem.UtilsPriceID AND UtilsPriceCategory = _PriceItem.UtilsPriceCategory AND _PriceItem.UtilsPriceFromBlock = '0000000000'  -- association [0..*]
;

Learn More