I_UtilsPriceItemHistory

DDL: I_UTILSPRICEITEMHISTORY SQL: IEUILPRICEITEM Type: view BASIC
15 Fields 1 Data Sources 3 Associations

Utilities Price Blocks/Items History

I_UtilsPriceItemHistory is a Basic CDS View that provides data about "Utilities Price Blocks/Items History" in SAP S/4HANA. It reads from 1 data source (epreih) and exposes 15 fields with key fields UtilsPriceID, UtilsPriceLevel, UtilsPriceCategory, UtilsPriceItemEndDate, UtilsPriceCurrency. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for the Utilities Product Integration Layer
StatusNot Released
Purpose
This CDS view retrieves the item-level information such as amount, currency, and price block details if applicable of all the existing price IDs. This view provides the data to answer the following business questions: What is the amount that is set to a price ID? What is the currency that is set to a price ID? What is the validity of the amount of a price ID?

Prerequisites
You have authorization to access the utilities price object.

Structure
Main parameters and filters of the CDS view The main parameters are as follows: UtilsPriceID UtilsPriceCategory UtilsPriceItemEndDate UtilsPriceCurrency UtilsPriceFromBlock The important fields of this view are as follows: Field Name Description Preis UtilsPriceID Preistyp UtilsPriceCategory Bisdatum UtilsPriceItemEndDate Twaers UtilsPriceCurrency Vonzone UtilsPriceFromBlock Biszone UtilsPriceToBlock Abdatum UtilsPriceItemStartDate Preisbtr UtilsPriceAmount 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: Currency UtilsPriceCategory

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
epreih epreih from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.UtilsPriceCurrency = _Currency.Currency
[1..1] I_UtilsPriceCategoryVH _UtilsPriceCategory $projection.UtilsPriceCategory = _UtilsPriceCategory.UtilsPriceCategory
[1..1] I_UtilsPriceHeader _UtilsPriceHeader $projection.UtilsPriceID = _UtilsPriceHeader.UtilsPriceID and $projection.UtilsPriceCategory = _UtilsPriceHeader.UtilsPriceCategory and $projection.UtilsPriceLevel = _UtilsPriceHeader.UtilsPriceLevel

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEUILPRICEITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK 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 UtilsPriceID view
EndUserText.label Utilities Price Blocks/Items History view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY UtilsPriceID epreih preis Valuation Price
KEY UtilsPriceLevel epreih preistuf Price level
KEY UtilsPriceCategory epreih preistyp Price category
KEY UtilsPriceItemEndDate epreih bisdatum Valid to
KEY UtilsPriceCurrency epreih twaers Trans. currency
KEY UtilsPriceFromBlock epreih vonzone From-block
UtilsPriceToBlock epreih biszone To-block
UtilsPriceItemStartDate epreih abdatum Valid From
UtilitiesBaseQuantity epreih mngbasis Quantity base
UtilsPriceAmount epreih preisbtr Price amount
UtilitiesAuthorizationGroup _UtilsPriceHeader UtilitiesAuthorizationGroup
Division _UtilsPriceHeader Division Internal Division ID
UtilitiesBillingClass _UtilsPriceHeader UtilitiesBillingClass
_UtilsPriceCategory _UtilsPriceCategory
_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_UtilsPriceItemHistory.
-- 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: IEUILPRICEITEM

CREATE VIEW I_UtilsPriceItemHistory AS
SELECT
  epreih.preis AS UtilsPriceID,
  epreih.preistuf AS UtilsPriceLevel,
  epreih.preistyp AS UtilsPriceCategory,
  epreih.bisdatum AS UtilsPriceItemEndDate,
  epreih.twaers AS UtilsPriceCurrency,
  epreih.vonzone AS UtilsPriceFromBlock,
  epreih.biszone AS UtilsPriceToBlock,
  epreih.abdatum AS UtilsPriceItemStartDate,
  epreih.mngbasis AS UtilitiesBaseQuantity,
  epreih.preisbtr AS UtilsPriceAmount,
  _UtilsPriceHeader.UtilitiesAuthorizationGroup AS UtilitiesAuthorizationGroup,
  _UtilsPriceHeader.Division AS Division,
  _UtilsPriceHeader.UtilitiesBillingClass AS UtilitiesBillingClass
FROM epreih
LEFT OUTER JOIN I_Currency AS _Currency ON UtilsPriceCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UtilsPriceCategoryVH AS _UtilsPriceCategory ON UtilsPriceCategory = _UtilsPriceCategory.UtilsPriceCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsPriceHeader AS _UtilsPriceHeader ON UtilsPriceID = _UtilsPriceHeader.UtilsPriceID AND UtilsPriceCategory = _UtilsPriceHeader.UtilsPriceCategory AND UtilsPriceLevel = _UtilsPriceHeader.UtilsPriceLevel  -- association [1..1]
;

Learn More