I_UtilsOneTimeChargeVH

DDL: I_UTILSONETIMECHARGEVH SQL: IUILOTHCHGVH Type: view COMPOSITE
12 Fields 1 Data Sources 2 Associations

One Time Charge for Reference Utilities Product

I_UtilsOneTimeChargeVH is a Composite CDS View that provides data about "One Time Charge for Reference Utilities Product" in SAP S/4HANA. It reads from 1 data source (I_UtilsProdChar) and exposes 12 fields with key fields UtilitiesReferenceProduct, Characteristic. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilsProdChar I_UtilsProdChar from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristic _Characteristic $projection.Characteristic = _Characteristic.Characteristic
[1..*] I_UtilsAttributeValueVH _ValueVH $projection.Characteristic = _ValueVH.Characteristic and $projection.UtilitiesReferenceProduct = _ValueVH.UtilitiesReferenceProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUILOTHCHGVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label One Time Charge for Reference Utilities Product view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesReferenceProduct UtilitiesReferenceProduct Ref. Prod. Matl No.
KEY Characteristic Characteristic Field Name
UtilsOperandMappingID UtilsOperandMappingID Mapping ID
UtilsSemanticsName1 UtilsSemanticsName1 Semantics Name 1
UtilsSemanticsName2 UtilsSemanticsName2 Semantics Name 2
UtilsSemanticsDescription UtilsSemanticsDescription Well Code Des.
UtilsSemanticsTypeDescription UtilsSemanticsTypeDescription Short text
CharcValueUnit _Characteristic CharcValueUnit Internal UoM
Currency _Characteristic Currency Valuation Crcy
UtilsOperandCategory _UtilsOperand UtilsOperandCategory
EntryIsRequired _Characteristic EntryIsRequired
_ValueVH _ValueVH

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_UtilsOneTimeChargeVH.
-- 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: IUILOTHCHGVH

CREATE VIEW I_UtilsOneTimeChargeVH AS
SELECT
  UtilitiesReferenceProduct,
  Characteristic,
  UtilsOperandMappingID,
  UtilsSemanticsName1,
  UtilsSemanticsName2,
  UtilsSemanticsDescription,
  UtilsSemanticsTypeDescription,
  _Characteristic.CharcValueUnit AS CharcValueUnit,
  _Characteristic.Currency AS Currency,
  _UtilsOperand.UtilsOperandCategory AS UtilsOperandCategory,
  _Characteristic.EntryIsRequired AS EntryIsRequired
FROM I_UtilsProdChar
LEFT OUTER JOIN I_ClfnCharacteristic AS _Characteristic ON Characteristic = _Characteristic.Characteristic  -- association [1..1]
LEFT OUTER JOIN I_UtilsAttributeValueVH AS _ValueVH ON Characteristic = _ValueVH.Characteristic AND UtilitiesReferenceProduct = _ValueVH.UtilitiesReferenceProduct  -- association [1..*]
;

Learn More