I_UtilsProdBillingAttribute

DDL: I_UTILSPRODBILLINGATTRIBUTE SQL: IUILPRDBIATTR Type: view COMPOSITE
14 Fields 1 Data Sources

Billing Attributes for a Utilities Product

I_UtilsProdBillingAttribute is a Composite CDS View that provides data about "Billing Attributes for a Utilities Product" in SAP S/4HANA. It reads from 1 data source (I_UtilsProdAttributes) and exposes 14 fields with key fields UtilitiesProduct, Characteristic.

Data Sources (1)

SourceAliasJoin Type
I_UtilsProdAttributes _A from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDBIATTR 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 Billing Attributes for a Utilities Product view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct UtilitiesProduct
KEY Characteristic I_UtilsProdAttributes Characteristic Field Name
UtilsSemanticsName1 I_UtilsProdAttributes UtilsSemanticsName1
UtilsSemanticsName2 I_UtilsProdAttributes UtilsSemanticsName2
ValuePositionNumber I_UtilsProdAttributes CharcValuePositionNumber
CharcValueendasUtilsProductEntryValue
UtilsTimeSliceDurationFrom I_UtilsProdAttributes UtilsTimeSliceDurationFrom LowrBndry Nmrc
UtilsTimeSliceDurationTo I_UtilsProdAttributes UtilsTimeSliceDurationTo UprBndry Nmrc
UtilsTimeSliceDurationUoM I_UtilsProdAttributes UtilsTimeSliceDurationUoM Internal UoM
ProductType I_UtilsProdAttributes ProductType Product Type Group
ProductGroup I_UtilsProdAttributes ProductGroup Product Sold Group
ProductAuthorizationGroup I_UtilsProdAttributes ProductAuthorizationGroup
_ProductType I_UtilsProdAttributes _ProductType
_ProductGroup I_UtilsProdAttributes _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_UtilsProdBillingAttribute.
-- 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: IUILPRDBIATTR

CREATE VIEW I_UtilsProdBillingAttribute AS
SELECT
  UtilitiesProduct,
  _A.Characteristic AS Characteristic,
  _A.UtilsSemanticsName1 AS UtilsSemanticsName1,
  _A.UtilsSemanticsName2 AS UtilsSemanticsName2,
  _A.CharcValuePositionNumber AS ValuePositionNumber,
  case when _A.CharcDataType = 'NUM' then cast(_A.CharcFromDecimalValue as atwrt ) else _A.CharcValue end as UtilsProductEntryValue AS CharcValueendasUtilsProductEntryValue,
  _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
FROM I_UtilsProdAttributes AS _A
;

Learn More