I_MeterReadingDocument

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_MeterReadingDocument.
-- 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: IEMTRRDNGDOC

CREATE VIEW I_MeterReadingDocument AS
SELECT
  eabl.ablbelnr AS MeterReadingDocument,
  eabl.gernr AS UtilitiesDevice,
  eabl.gernr AS SerialNumber,
  eabl.equnr AS Equipment,
  eabl.zwnummer AS UtilitiesRegister,
  eabl.adat AS MeterReadingDate,
  cast (eabl.atim as e_atim_vdm preserving type ) AS MeterReadingTime,
  eabl.v_zwstand AS MeterReadingResultPreDecimals,
  eabl.n_zwstand AS MeterReadingResultDecimals,
  eabl.massread AS MeterReadingMeasurementUnit,
  eabl.v_zwstndab AS BlldMeterReadingResultPreDcmls,
  eabl.n_zwstndab AS BlldMeterReadingResultDcmls,
  eabl.massbill AS BillingMeasurementUnit,
  eabl.stanzvor AS NmbrOfUtilsRegDigitsPreDcmls,
  eabl.stanznac AS NmbrOfUtilsRegDigitsDcmls,
  eabl.ablstat AS MeterReadingStatus,
  eabl.istablart AS MeterReadingType,
  eabl.ablestyp AS MeterReadingCategory,
  eabl.ablesart AS SchedldMtrReadingCategory,
  cast(eabl.adatsoll as e_schedld_mtrrdng_dte_vdm preserving type) AS ScheduledMeterReadingDate,
  eabl.adattats AS ActualMeterReadingDate,
  cast (eabl.atimtats as e_atimtats_vdm preserving type ) AS ActualMeterReadingTime,
  eabl.adatmax AS MaximumMeterReadingDate,
  cast (eabl.atimmax as e_atimmax_vdm preserving type ) AS MaximumMeterReadingTime,
  eabl.zuorddat AS MeterReadingAllocationDate,
  eabl.thgdatum AS UtilitiesGasAllocationDate,
  eabl.adaterz AS CtrlMtrReadingOrderSchedldDate,
  cast (eabl.atimerz as e_atimerz_vdm preserving type ) AS CtrlMtrReadingOrderSchedldTime,
  eabl.arbauf AS ControlMeterReadingIsPrinted,
  eabl.aktiv AS MtrRdngActiveStatus,
  eabl.pruefpkt AS IndepMtrRdngValidationChk,
  eabl.popcode AS DepdntMtrRdngValidationChk,
  eabl.ablhinw AS MeterReaderNoteCode,
  eabl.stablhw AS MeterReaderNoteFllwUpActn,
  eabl.ableser AS MeterReaderCode,
  eabl.bapertyp AS MeterReadingBasePeriodCat,
  eabl.erdat AS MeterReadingCreationDate,
  eabl.ernam AS MeterReadingCreatedByUser,
  eabl.aedat AS MeterReadingLastChangeDate,
  eabl.aenam AS MeterReadingLastChangedByUser,
  eabl.ams AS AdvancedMeteringSystem,
  cast(eabl.transstat as e_mrtransstat_vdm) AS MeterReadingTransferStatus,
  cast(eabl.tranststamp as e_mrtrans_tmstmp_vdm) AS MeterReadingTransferDateTime,
  eabl.sourcesyst AS AdvncdMeteringDataOrignType,
  eabl.mdenr AS MobileMeterReadingEntrySystem,
  eabl.mdeupl AS MeterReadingOrderIsOutputted,
  eabl.pruefzahl AS MeterReadingCheckDigit,
  eabl.entrynumb AS MeterReadingFastEntryNumber,
  eabl.nacherf AS MeterReadingIsRecaptured,
  eabl.kstatus AS MeterReadingAutomMntrgStatus,
  eabl.e_zeitvbl AS MtrRdngIsSchdlForMltplOrdCrtn,
  eabl.steuergrp AS MltplMtrRdngOrdCrtnCntrlGroup,
  eabl.e_zvbl_bezdat AS MltplMtrRdngRefSchedldDate,
  eabl.doc_type AS OrderType,
  eabl.sm_aufnr AS ServiceOrder,
  eabl.qdproc AS UtilsQuantityDetnProcedure
FROM eabl
LEFT OUTER JOIN I_MeterReadingStatus AS _MeterReadingStatus ON MeterReadingStatus = _MeterReadingStatus.MeterReadingStatus  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MeterReadingMeasurementUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure_E ON BillingMeasurementUnit = _UnitOfMeasure_E.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_SchedMeterReadingCat AS _SchedldMtrReadingCategory ON SchedldMtrReadingCategory = _SchedldMtrReadingCategory.SchedldMtrReadingCategory  -- association [1..1]
LEFT OUTER JOIN I_MeterReadingType AS _MeterReadingType ON MeterReadingType = _MeterReadingType.MeterReadingType  -- association [1..1]
LEFT OUTER JOIN I_MeterReadingCategory AS _MeterReadingCategory ON MeterReadingCategory = _MeterReadingCategory.MeterReadingCategory  -- association [1..1]
LEFT OUTER JOIN I_UtilsAdvncdMeteringSystem AS _AdvancedMeteringSystem ON AdvancedMeteringSystem = _AdvancedMeteringSystem.AdvancedMeteringSystem  -- association [0..1]
LEFT OUTER JOIN I_MeterReadingTransferSts AS _SystemStatus ON MeterReadingTransferStatus = _SystemStatus.MeterReadingTransferStatus  -- association [0..1]
LEFT OUTER JOIN I_UtilsMtrRdngBasePerdCat AS _MeterReadingBasePeriodCat ON MeterReadingBasePeriodCat = _MeterReadingBasePeriodCat.MeterReadingBasePeriodCat  -- association [0..1]
LEFT OUTER JOIN I_IndepMtrRdngValdtnChk AS _IndepMtrRdngValidationChk ON IndepMtrRdngValidationChk = _IndepMtrRdngValidationChk.IndepMtrRdngValidationChk  -- association [0..1]
LEFT OUTER JOIN I_DepdntMtrRdngValdtnChk AS _DepdntMtrRdngValidationChk ON DepdntMtrRdngValidationChk = _DepdntMtrRdngValidationChk.DepdntMtrRdngValidationChk  -- association [0..1]
LEFT OUTER JOIN I_MeterReaderNote AS _MeterReaderNote ON MeterReaderNoteCode = _MeterReaderNote.MeterReaderNoteCode  -- association [0..1]
LEFT OUTER JOIN I_MtrReaderNoteFllwUpActn AS _MeterReaderNoteFllwUpActn ON MeterReaderNoteFllwUpActn = _MeterReaderNoteFllwUpActn.MeterReaderNoteFllwUpActn  -- association [0..1]
LEFT OUTER JOIN I_MeterReader AS _MeterReaderCode ON MeterReaderCode = _MeterReaderCode.MeterReaderCode  -- association [1..1]
LEFT OUTER JOIN I_MeterReadingActvSts AS _MtrRdngActiveStatus ON MtrRdngActiveStatus = _MtrRdngActiveStatus.MtrRdngActiveStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON MeterReadingCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON MeterReadingLastChangedByUser = _LastChangedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_MeterReadingDocumentReason AS _MeterReadingDocumentReason ON MeterReadingDocument = _MeterReadingDocumentReason.MeterReadingDocument  -- association [1..*]
LEFT OUTER JOIN I_MeterReadingValdtnInfo AS _MeterReadingValdtnInfo ON MeterReadingDocument = _MeterReadingValdtnInfo.MeterReadingDocument  -- association [0..1]
LEFT OUTER JOIN I_UtilsQuantityDetnProcedure AS _UtilsQuantityDetnProcedure ON UtilsQuantityDetnProcedure = _UtilsQuantityDetnProcedure.UtilsQuantityDetnProcedure  -- association [0..1]
;