I_UtilsDiscountItem

DDL: I_UTILSDISCOUNTITEM SQL: IUTILDISITEM Type: view BASIC
12 Fields 1 Data Sources 2 Associations

Utilities Discount Item

I_UtilsDiscountItem is a Basic CDS View that provides data about "Utilities Discount Item" in SAP S/4HANA. It reads from 1 data source (edsch) and exposes 12 fields with key fields UtilsDiscountID, UtilsDiscountCurrency, UtilsDiscountStartDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
edsch edsch from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.UtilsDiscountCurrency = _Currency.Currency
[1..1] I_UtilsDiscountHeader _UtilsDiscountHeader $projection.UtilsDiscountID = _UtilsDiscountHeader.UtilsDiscountID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IUTILDISITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey UtilsDiscountID view
EndUserText.label Utilities Discount Item view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY UtilsDiscountID rabzus Discount
KEY UtilsDiscountCurrency twaers Trans. currency
KEY UtilsDiscountStartDate ab Valid From
UtilsDiscountEndDate bis Value
UtilsDiscountInPercent rabproz Discount perc.
UtilsDiscountAmount rabbetrag Discount amount
UtilsDiscountQuantity rabmenge Discount qty
UtilsDiscountAmountForPrice rabpreis Discount price
UtilsDiscountDemand rableistung Discount demand
Division _UtilsDiscountHeader Division Internal Division ID
UtilitiesBillingClass _UtilsDiscountHeader UtilitiesBillingClass
_Currency _Currency

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_UtilsDiscountItem.
-- 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: IUTILDISITEM

CREATE VIEW I_UtilsDiscountItem AS
SELECT
  rabzus AS UtilsDiscountID,
  twaers AS UtilsDiscountCurrency,
  ab AS UtilsDiscountStartDate,
  bis AS UtilsDiscountEndDate,
  rabproz AS UtilsDiscountInPercent,
  rabbetrag AS UtilsDiscountAmount,
  rabmenge AS UtilsDiscountQuantity,
  rabpreis AS UtilsDiscountAmountForPrice,
  rableistung AS UtilsDiscountDemand,
  _UtilsDiscountHeader.Division AS Division,
  _UtilsDiscountHeader.UtilitiesBillingClass AS UtilitiesBillingClass
FROM edsch
LEFT OUTER JOIN I_Currency AS _Currency ON UtilsDiscountCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UtilsDiscountHeader AS _UtilsDiscountHeader ON UtilsDiscountID = _UtilsDiscountHeader.UtilsDiscountID  -- association [1..1]
;

Learn More