I_UtilsBllbleItmMtrRdng

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_UtilsBllbleItmMtrRdng.
-- 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: IUMTRRDNGBIT

CREATE VIEW I_UtilsBllbleItmMtrRdng AS
SELECT
  extn_type AS CABllbleItmExtnType,
  extn_id AS CABllbleItmExtnID,
  extn_subid AS CABllbleItmExtnItmID,
  extn_uuid AS CABllbleItmExtnUUID,
  srctatype AS CABllbleItmSourceTransType,
  srctaid AS CABllbleItmSourceTransId,
  bitpackuuid AS CABllbleItmPackageUUID,
  device_number AS UtilsBllbleItmDevice,
  obis_code AS UtilsBllbleItmObjIdnSystCode,
  date_from AS CABllbleItmStartDate,
  date_to AS CABllbleItmEndDate,
  prev_meter_reading AS PrevMeterReadingResultValue,
  prev_meter_reading AS UtilsBllbleItmPrevMeterRdngQty,
  prev_meter_reading_msmt_unit AS PrevMeterRdngMeasurementUnit,
  meter_reading AS UtilsBllbleItmMeterRdngQty,
  meter_reading_category AS MeterReadingCategory,
  meter_reading_diff AS MeterReadingResultDifference,
  meter_reading_msmt_unit AS MeterReadingMeasurementUnit,
  mr_rslt_adjmt_fctr_value AS MeterReadingResultAdjmtFctrVal,
  quantity AS CABllbleItmQty,
  quantity_msmt_unit AS CABllbleItmQtyUnit,
  meter_id AS UtilsBllbleItmMeterID,
  metering_location AS UtilsBllbleItmMeteringLocation,
  vtref AS CAContract
FROM uti_bit_mtrrdng
LEFT OUTER JOIN I_UtilsBllbleItmMtrRdngCat AS _UtilsBllbleItmMtrRdngCat ON MeterReadingCategory = _UtilsBllbleItmMtrRdngCat.MeterReadingCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MtrRdngUnitOfMeasure ON MeterReadingMeasurementUnit = _MtrRdngUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrevMtrRdngUnitOfMeasure ON PrevMeterRdngMeasurementUnit = _PrevMtrRdngUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnitOfMeasure ON CABllbleItmQtyUnit = _QuantityUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;