I_UtilsPriceHeader

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_UtilsPriceHeader.
-- 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: IEUILPRICEHEADR

CREATE VIEW I_UtilsPriceHeader AS
SELECT
  preis AS UtilsPriceID,
  preistyp AS UtilsPriceCategory,
  preistuf AS UtilsPriceLevel,
  sparte AS Division,
  mass AS UtilsMeasurementUnit,
  aklasse AS UtilitiesBillingClass,
  timbasis AS UtilsTimeBasis,
  timtyp AS UtilsTimeCategory,
  preisart AS UtilsPriceTierType,
  begru AS UtilitiesAuthorizationGroup,
  priceorigin AS UtilsPriceOrigin
FROM eprei
LEFT OUTER JOIN I_UtilitiesPriceText AS _UtilitiesPriceText ON UtilsPriceID = _UtilitiesPriceText.UtilsPriceID AND UtilsPriceCategory = _UtilitiesPriceText.UtilsPriceCategory AND UtilsPriceLevel = _UtilitiesPriceText.UtilsPriceLevel AND _UtilitiesPriceText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UtilsChargeTierTypeVH AS _UtilsChargeTierType ON UtilsPriceTierType = _UtilsChargeTierType.UtilsPriceTierType  -- association [1..1]
LEFT OUTER JOIN I_UtilsPriceCategoryVH AS _UtilsPriceCategory ON UtilsPriceCategory = _UtilsPriceCategory.UtilsPriceCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsTimeCategoryVH AS _UtilsPriceFrequencyUnit ON UtilsTimeCategory = _UtilsPriceFrequencyUnit.UtilsTimeCategory  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UtilsMeasurementUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UtilsPriceOriginVH AS _UtilsPriceOrigin ON UtilsPriceOrigin = _UtilsPriceOrigin.UtilsPriceOrigin  -- association [1..1]
;