I_UtilitiesPrice

DDL: I_UTILITIESPRICE SQL: IEUILPRICE Type: view COMPOSITE
19 Fields 1 Data Sources 1 Associations

Utilities Price

I_UtilitiesPrice is a Composite CDS View that provides data about "Utilities Price" in SAP S/4HANA. It reads from 1 data source (I_UtilsPriceHeader) and exposes 19 fields with key fields UtilsPriceID, UtilsPriceCategory, UtilsPriceLevel. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for the Utilities Product Integration Layer
StatusNot Released
Purpose
This CDS view retrieves all the existing price IDs along with their price category and division. This view provides the data to answer the business question: How many price IDs are in the system for each price category?

Prerequisites
You have authorization to access the utilities price object.

Structure
Object types This view is built on the I_UtilsPriceHeader business object. Main parameters and filters of the CDS view The main parameters are as follows: UtilsPriceID UtilsPriceCategory The important fields of this view are as follows: Field Name Description UtilsPriceID Price ID UtilsPriceCategory Price category UtilsPriceName Price name Division Division UtilsMeasurementUnit Unit of measurement UtilitiesBillingClass Billing class UtilsTimeBasis Time basis UtilsTimeCategory Time category UtilsPriceTierType Price tier type You can navigate from the I_UtilitiesPrice view to the following associated views (including detailed field and data type information), which are lower in the hierarchy: to_UtilsPriceItemHistory to_UtilsPriceFrequencyUnit to_UtilsPriceCategory to_UtilsChargeTierType to_UtilitiesPriceText to_UnitOfMeasure Measures and attributes Some important measures and attributes are: The Division attribute to indicate whether the division category of the utilities price key is electricity, gas, or water. The UtilitiesBillingClass attribute to indicate whether the billing class is residential or commercial. The PriceCategory attribute to indciate whether the price category of the price key is a quantity-based price, a flat rate, a rental price, or a time-dependent price.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_UtilsPriceHeader I_UtilsPriceHeader from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_UtilsPriceItemHistory _UtilsPriceItemHistory $projection.UtilsPriceID = _UtilsPriceItemHistory.UtilsPriceID and $projection.UtilsPriceCategory = _UtilsPriceItemHistory.UtilsPriceCategory and $projection.UtilsPriceLevel = _UtilsPriceItemHistory.UtilsPriceLevel

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEUILPRICE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE 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 UtilsPriceID view
EndUserText.label Utilities Price view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY UtilsPriceID UtilsPriceID Valuation Price
KEY UtilsPriceCategory UtilsPriceCategory Price category
KEY UtilsPriceLevel UtilsPriceLevel Price level
UtilsPriceName _UtilitiesPriceText UtilsPriceName
Division Division Internal Division ID
UtilsMeasurementUnit UtilsMeasurementUnit Unit of meas.
UtilitiesBillingClass UtilitiesBillingClass Billing Class
UtilsTimeBasis UtilsTimeBasis Time basis
UtilsTimeCategory UtilsTimeCategory Time Type
UtilsPriceTierType UtilsPriceTierType Price type
UtilsPriceOrigin UtilsPriceOrigin Price Origin
UtilitiesAuthorizationGroup UtilitiesAuthorizationGroup AuthorizGroup
_UtilsPriceItemHistory _UtilsPriceItemHistory
_UtilsChargeTierType _UtilsChargeTierType
_UtilsPriceFrequencyUnit _UtilsPriceFrequencyUnit
_UtilsPriceCategory _UtilsPriceCategory
_UtilitiesPriceText _UtilitiesPriceText
_UnitOfMeasure _UnitOfMeasure
_UtilsPriceOrigin _UtilsPriceOrigin

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_UtilitiesPrice.
-- 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: IEUILPRICE

CREATE VIEW I_UtilitiesPrice AS
SELECT
  UtilsPriceID,
  UtilsPriceCategory,
  UtilsPriceLevel,
  _UtilitiesPriceText.UtilsPriceName AS UtilsPriceName,
  Division,
  UtilsMeasurementUnit,
  UtilitiesBillingClass,
  UtilsTimeBasis,
  UtilsTimeCategory,
  UtilsPriceTierType,
  UtilsPriceOrigin,
  UtilitiesAuthorizationGroup
FROM I_UtilsPriceHeader
LEFT OUTER JOIN I_UtilsPriceItemHistory AS _UtilsPriceItemHistory ON UtilsPriceID = _UtilsPriceItemHistory.UtilsPriceID AND UtilsPriceCategory = _UtilsPriceItemHistory.UtilsPriceCategory AND UtilsPriceLevel = _UtilsPriceItemHistory.UtilsPriceLevel  -- association [1..*]
;

Learn More