I_UtilsProdDiscount

DDL: I_UTILSPRODDISCOUNT SQL: IUILPRDDISC Type: view COMPOSITE
25 Fields 4 Associations

Discount for Utilities Product

I_UtilsProdDiscount is a Composite CDS View that provides data about "Discount for Utilities Product" in SAP S/4HANA. It has 4 associations to related views.

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_UtilsDiscountTypeVH _DiscountType $projection.utilsdiscounttype = _DiscountType.UtilsDiscountType
[0..1] I_UtilsDiscountCategoryVH _DiscountCategory $projection.utilsdiscountcategory = _DiscountCategory.UtilsDiscountCategory
[0..1] I_Currency _Currency $projection.UtilsDiscountCurrency = _Currency.Currency
[0..1] I_UtilsDiscount _Discount $projection.UtilsDiscountID = _Discount.UtilsDiscountID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDDISC 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 Discount for Utilities Product view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct _A UtilitiesProduct
KEY Characteristic _A Characteristic Field Name
UtilsSemanticsName1 _A UtilsSemanticsName1
UtilsSemanticsName2 _A UtilsSemanticsName2
ValuePositionNumber _A CharcValuePositionNumber
UtilsDiscountID _A CharcValue Char. Value
Division _Discount Division Internal Division ID
UtilitiesBillingClass _Discount UtilitiesBillingClass
UtilsDiscountText _Discount UtilsDiscountText
UtilsDiscountCategory _Discount UtilsDiscountCategory
UtilsDiscountType _Discount UtilsDiscountType
CharcFromAmountendasUtilsDiscountAmount
CurrencyendasUtilsDiscountCurrency
UtilsTimeSliceDurationFrom _A UtilsTimeSliceDurationFrom
UtilsTimeSliceDurationTo _A UtilsTimeSliceDurationTo
UtilsTimeSliceDurationUoM _A UtilsTimeSliceDurationUoM
ProductType _A ProductType Product Type Group
ProductGroup _A ProductGroup Product Sold Group
ProductAuthorizationGroup _A ProductAuthorizationGroup
_ProductType _A _ProductType
_ProductGroup _A _ProductGroup
_DiscountType _DiscountType
_DiscountCategory _DiscountCategory
_Currency _Currency
_Discount _Discount

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_UtilsProdDiscount.
-- 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: IUILPRDDISC

CREATE VIEW I_UtilsProdDiscount AS
SELECT
  _A.UtilitiesProduct AS UtilitiesProduct,
  _A.Characteristic AS Characteristic,
  _A.UtilsSemanticsName1 AS UtilsSemanticsName1,
  _A.UtilsSemanticsName2 AS UtilsSemanticsName2,
  _A.CharcValuePositionNumber AS ValuePositionNumber,
  _A.CharcValue AS UtilsDiscountID,
  _Discount.Division AS Division,
  _Discount.UtilitiesBillingClass AS UtilitiesBillingClass,
  _Discount.UtilsDiscountText AS UtilsDiscountText,
  _Discount.UtilsDiscountCategory AS UtilsDiscountCategory,
  _Discount.UtilsDiscountType AS UtilsDiscountType,
  case when _A.CharcDataType = 'CURR' then _A.CharcFromAmount end as UtilsDiscountAmount AS CharcFromAmountendasUtilsDiscountAmount,
  case when _A.CharcDataType = 'CURR' then _A.Currency end as UtilsDiscountCurrency AS CurrencyendasUtilsDiscountCurrency,
  _A.UtilsTimeSliceDurationFrom AS UtilsTimeSliceDurationFrom,
  _A.UtilsTimeSliceDurationTo AS UtilsTimeSliceDurationTo,
  _A.UtilsTimeSliceDurationUoM AS UtilsTimeSliceDurationUoM,
  _A.ProductType AS ProductType,
  _A.ProductGroup AS ProductGroup,
  _A.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _A._ProductType AS _ProductType,
  _A._ProductGroup AS _ProductGroup
LEFT OUTER JOIN I_UtilsDiscountTypeVH AS _DiscountType ON utilsdiscounttype = _DiscountType.UtilsDiscountType  -- association [0..1]
LEFT OUTER JOIN I_UtilsDiscountCategoryVH AS _DiscountCategory ON utilsdiscountcategory = _DiscountCategory.UtilsDiscountCategory  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON UtilsDiscountCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UtilsDiscount AS _Discount ON UtilsDiscountID = _Discount.UtilsDiscountID  -- association [0..1]
;

Learn More