CRMS4_IU_I_MRD

DDL: CRMS4_IU_I_MRD Type: view_entity
77 Fields 2 Data Sources

Utilities Meter Reading Document

CRMS4_IU_I_MRD is a CDS View that provides data about "Utilities Meter Reading Document" in SAP S/4HANA. It reads from 2 data sources (eabl, I_MeterReadingDocument) and exposes 77 fields with key field MeterReadingDocument.

Data Sources (2)

SourceAliasJoin Type
eabl _eabl inner
I_MeterReadingDocument I_MeterReadingDocument from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Meter Reading Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY MeterReadingDocument I_MeterReadingDocument MeterReadingDocument Int. MR doc. ID
UtilitiesDevice I_MeterReadingDocument UtilitiesDevice Serial Number
SerialNumber I_MeterReadingDocument SerialNumber Serial Number
Equipment I_MeterReadingDocument Equipment Equipment check
UtilitiesRegister I_MeterReadingDocument UtilitiesRegister Register
MeterReadingDate I_MeterReadingDocument MeterReadingDate MR date
MeterReadingTime I_MeterReadingDocument MeterReadingTime
MeterReadingResultPreDecimals I_MeterReadingDocument MeterReadingResultPreDecimals Predec. Places in MR
MeterReadingResultDecimals I_MeterReadingDocument MeterReadingResultDecimals Dec. Places in MR
MeterReadingMeasurementUnit I_MeterReadingDocument MeterReadingMeasurementUnit MeasUnit for MR
BlldMeterReadingResultPreDcmls I_MeterReadingDocument BlldMeterReadingResultPreDcmls Predec. Billed MR
BlldMeterReadingResultDcmls I_MeterReadingDocument BlldMeterReadingResultDcmls DP Billed MR
BillingMeasurementUnit I_MeterReadingDocument BillingMeasurementUnit Billing MUnit
NmbrOfUtilsRegDigitsPreDcmls I_MeterReadingDocument NmbrOfUtilsRegDigitsPreDcmls Predec. places
NmbrOfUtilsRegDigitsDcmls I_MeterReadingDocument NmbrOfUtilsRegDigitsDcmls Decimal places
MeterReadingStatus I_MeterReadingDocument MeterReadingStatus MR Status
MeterReadingType I_MeterReadingDocument MeterReadingType MR type
MeterReadingCategory I_MeterReadingDocument MeterReadingCategory MR category
SchedldMtrReadingCategory I_MeterReadingDocument SchedldMtrReadingCategory Scheduled MRC
ScheduledMeterReadingDate I_MeterReadingDocument ScheduledMeterReadingDate
ActualMeterReadingDate I_MeterReadingDocument ActualMeterReadingDate Actual MR date
ActualMeterReadingTime I_MeterReadingDocument ActualMeterReadingTime
MaximumMeterReadingDate I_MeterReadingDocument MaximumMeterReadingDate Date of max. MR
MaximumMeterReadingTime I_MeterReadingDocument MaximumMeterReadingTime
MeterReadingAllocationDate I_MeterReadingDocument MeterReadingAllocationDate MR alloc. date
UtilitiesGasAllocationDate I_MeterReadingDocument UtilitiesGasAllocationDate Gas alloc. date
CtrlMtrReadingOrderSchedldDate I_MeterReadingDocument CtrlMtrReadingOrderSchedldDate IR date
CtrlMtrReadingOrderSchedldTime I_MeterReadingDocument CtrlMtrReadingOrderSchedldTime
ControlMeterReadingIsPrinted I_MeterReadingDocument ControlMeterReadingIsPrinted MROrder Printed
MtrRdngActiveStatus I_MeterReadingDocument MtrRdngActiveStatus MR active
IndepMtrRdngValidationChk I_MeterReadingDocument IndepMtrRdngValidationChk Indep. valid.
DepdntMtrRdngValidationChk I_MeterReadingDocument DepdntMtrRdngValidationChk Dep. validation
MeterReaderNoteCode I_MeterReadingDocument MeterReaderNoteCode MR note
MeterReaderNoteFllwUpActn I_MeterReadingDocument MeterReaderNoteFllwUpActn MR note control
MeterReaderCode I_MeterReadingDocument MeterReaderCode Meter reader
MeterReadingBasePeriodCat I_MeterReadingDocument MeterReadingBasePeriodCat Base per. cat.
MeterReadingCreationDate I_MeterReadingDocument MeterReadingCreationDate Entered On
MeterReadingCreatedByUser I_MeterReadingDocument MeterReadingCreatedByUser User Name
MeterReadingLastChangeDate I_MeterReadingDocument MeterReadingLastChangeDate Obsolete
MeterReadingLastChangedByUser I_MeterReadingDocument MeterReadingLastChangedByUser User Name
AdvancedMeteringSystem I_MeterReadingDocument AdvancedMeteringSystem AMS
MeterReadingTransferStatus I_MeterReadingDocument MeterReadingTransferStatus
MeterReadingTransferDateTime I_MeterReadingDocument MeterReadingTransferDateTime
AdvncdMeteringDataOrignType I_MeterReadingDocument AdvncdMeteringDataOrignType Source System
MobileMeterReadingEntrySystem I_MeterReadingDocument MobileMeterReadingEntrySystem MDE number
MeterReadingOrderIsOutputted I_MeterReadingDocument MeterReadingOrderIsOutputted Order output
MeterReadingCheckDigit I_MeterReadingDocument MeterReadingCheckDigit Check number
MeterReadingFastEntryNumber I_MeterReadingDocument MeterReadingFastEntryNumber Entry number
MeterReadingIsRecaptured I_MeterReadingDocument MeterReadingIsRecaptured Subseq. entry
MeterReadingAutomMntrgStatus I_MeterReadingDocument MeterReadingAutomMntrgStatus Monit. status
MtrRdngIsSchdlForMltplOrdCrtn I_MeterReadingDocument MtrRdngIsSchdlForMltplOrdCrtn Multiple MROC
MltplMtrRdngOrdCrtnCntrlGroup I_MeterReadingDocument MltplMtrRdngOrdCrtnCntrlGroup Control Group
MltplMtrRdngRefSchedldDate I_MeterReadingDocument MltplMtrRdngRefSchedldDate Ref. MR date
OrderType I_MeterReadingDocument OrderType Order Type
ServiceOrder I_MeterReadingDocument ServiceOrder Transaction ID
UtilsQuantityDetnProcedure I_MeterReadingDocument UtilsQuantityDetnProcedure Qty Det.Proced.
prev_mrdoc eabl prev_mrdoc Int.ID PrMRRstD
_AdvancedMeteringSystem I_MeterReadingDocument _AdvancedMeteringSystem
_CreatedByUser I_MeterReadingDocument _CreatedByUser
_DepdntMtrRdngValidationChk I_MeterReadingDocument _DepdntMtrRdngValidationChk
_IndepMtrRdngValidationChk I_MeterReadingDocument _IndepMtrRdngValidationChk
_LastChangedByUser I_MeterReadingDocument _LastChangedByUser
_MeterReaderCode I_MeterReadingDocument _MeterReaderCode
_MeterReaderNote I_MeterReadingDocument _MeterReaderNote
_MeterReaderNoteFllwUpActn I_MeterReadingDocument _MeterReaderNoteFllwUpActn
_MeterReadingBasePeriodCat I_MeterReadingDocument _MeterReadingBasePeriodCat
_MeterReadingCategory I_MeterReadingDocument _MeterReadingCategory
_MeterReadingDocumentReason I_MeterReadingDocument _MeterReadingDocumentReason
_MeterReadingStatus I_MeterReadingDocument _MeterReadingStatus
_MeterReadingType I_MeterReadingDocument _MeterReadingType
_MeterReadingValdtnInfo I_MeterReadingDocument _MeterReadingValdtnInfo
_MtrRdngActiveStatus I_MeterReadingDocument _MtrRdngActiveStatus
_SchedldMtrReadingCategory I_MeterReadingDocument _SchedldMtrReadingCategory
_SystemStatus I_MeterReadingDocument _SystemStatus
_UnitOfMeasure I_MeterReadingDocument _UnitOfMeasure
_UnitOfMeasure_E I_MeterReadingDocument _UnitOfMeasure_E
_UtilsQuantityDetnProcedure I_MeterReadingDocument _UtilsQuantityDetnProcedure

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 CRMS4_IU_I_MRD.
-- 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.

CREATE VIEW CRMS4_IU_I_MRD AS
SELECT
  I_MeterReadingDocument.MeterReadingDocument AS MeterReadingDocument,
  I_MeterReadingDocument.UtilitiesDevice AS UtilitiesDevice,
  I_MeterReadingDocument.SerialNumber AS SerialNumber,
  I_MeterReadingDocument.Equipment AS Equipment,
  I_MeterReadingDocument.UtilitiesRegister AS UtilitiesRegister,
  I_MeterReadingDocument.MeterReadingDate AS MeterReadingDate,
  I_MeterReadingDocument.MeterReadingTime AS MeterReadingTime,
  I_MeterReadingDocument.MeterReadingResultPreDecimals AS MeterReadingResultPreDecimals,
  I_MeterReadingDocument.MeterReadingResultDecimals AS MeterReadingResultDecimals,
  I_MeterReadingDocument.MeterReadingMeasurementUnit AS MeterReadingMeasurementUnit,
  I_MeterReadingDocument.BlldMeterReadingResultPreDcmls AS BlldMeterReadingResultPreDcmls,
  I_MeterReadingDocument.BlldMeterReadingResultDcmls AS BlldMeterReadingResultDcmls,
  I_MeterReadingDocument.BillingMeasurementUnit AS BillingMeasurementUnit,
  I_MeterReadingDocument.NmbrOfUtilsRegDigitsPreDcmls AS NmbrOfUtilsRegDigitsPreDcmls,
  I_MeterReadingDocument.NmbrOfUtilsRegDigitsDcmls AS NmbrOfUtilsRegDigitsDcmls,
  I_MeterReadingDocument.MeterReadingStatus AS MeterReadingStatus,
  I_MeterReadingDocument.MeterReadingType AS MeterReadingType,
  I_MeterReadingDocument.MeterReadingCategory AS MeterReadingCategory,
  I_MeterReadingDocument.SchedldMtrReadingCategory AS SchedldMtrReadingCategory,
  I_MeterReadingDocument.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  I_MeterReadingDocument.ActualMeterReadingDate AS ActualMeterReadingDate,
  I_MeterReadingDocument.ActualMeterReadingTime AS ActualMeterReadingTime,
  I_MeterReadingDocument.MaximumMeterReadingDate AS MaximumMeterReadingDate,
  I_MeterReadingDocument.MaximumMeterReadingTime AS MaximumMeterReadingTime,
  I_MeterReadingDocument.MeterReadingAllocationDate AS MeterReadingAllocationDate,
  I_MeterReadingDocument.UtilitiesGasAllocationDate AS UtilitiesGasAllocationDate,
  I_MeterReadingDocument.CtrlMtrReadingOrderSchedldDate AS CtrlMtrReadingOrderSchedldDate,
  I_MeterReadingDocument.CtrlMtrReadingOrderSchedldTime AS CtrlMtrReadingOrderSchedldTime,
  I_MeterReadingDocument.ControlMeterReadingIsPrinted AS ControlMeterReadingIsPrinted,
  I_MeterReadingDocument.MtrRdngActiveStatus AS MtrRdngActiveStatus,
  I_MeterReadingDocument.IndepMtrRdngValidationChk AS IndepMtrRdngValidationChk,
  I_MeterReadingDocument.DepdntMtrRdngValidationChk AS DepdntMtrRdngValidationChk,
  I_MeterReadingDocument.MeterReaderNoteCode AS MeterReaderNoteCode,
  I_MeterReadingDocument.MeterReaderNoteFllwUpActn AS MeterReaderNoteFllwUpActn,
  I_MeterReadingDocument.MeterReaderCode AS MeterReaderCode,
  I_MeterReadingDocument.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
  I_MeterReadingDocument.MeterReadingCreationDate AS MeterReadingCreationDate,
  I_MeterReadingDocument.MeterReadingCreatedByUser AS MeterReadingCreatedByUser,
  I_MeterReadingDocument.MeterReadingLastChangeDate AS MeterReadingLastChangeDate,
  I_MeterReadingDocument.MeterReadingLastChangedByUser AS MeterReadingLastChangedByUser,
  I_MeterReadingDocument.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  I_MeterReadingDocument.MeterReadingTransferStatus AS MeterReadingTransferStatus,
  I_MeterReadingDocument.MeterReadingTransferDateTime AS MeterReadingTransferDateTime,
  I_MeterReadingDocument.AdvncdMeteringDataOrignType AS AdvncdMeteringDataOrignType,
  I_MeterReadingDocument.MobileMeterReadingEntrySystem AS MobileMeterReadingEntrySystem,
  I_MeterReadingDocument.MeterReadingOrderIsOutputted AS MeterReadingOrderIsOutputted,
  I_MeterReadingDocument.MeterReadingCheckDigit AS MeterReadingCheckDigit,
  I_MeterReadingDocument.MeterReadingFastEntryNumber AS MeterReadingFastEntryNumber,
  I_MeterReadingDocument.MeterReadingIsRecaptured AS MeterReadingIsRecaptured,
  I_MeterReadingDocument.MeterReadingAutomMntrgStatus AS MeterReadingAutomMntrgStatus,
  I_MeterReadingDocument.MtrRdngIsSchdlForMltplOrdCrtn AS MtrRdngIsSchdlForMltplOrdCrtn,
  I_MeterReadingDocument.MltplMtrRdngOrdCrtnCntrlGroup AS MltplMtrRdngOrdCrtnCntrlGroup,
  I_MeterReadingDocument.MltplMtrRdngRefSchedldDate AS MltplMtrRdngRefSchedldDate,
  I_MeterReadingDocument.OrderType AS OrderType,
  I_MeterReadingDocument.ServiceOrder AS ServiceOrder,
  I_MeterReadingDocument.UtilsQuantityDetnProcedure AS UtilsQuantityDetnProcedure,
  _eabl.prev_mrdoc AS prev_mrdoc,
  I_MeterReadingDocument._AdvancedMeteringSystem AS _AdvancedMeteringSystem,
  I_MeterReadingDocument._CreatedByUser AS _CreatedByUser,
  I_MeterReadingDocument._DepdntMtrRdngValidationChk AS _DepdntMtrRdngValidationChk,
  I_MeterReadingDocument._IndepMtrRdngValidationChk AS _IndepMtrRdngValidationChk,
  I_MeterReadingDocument._LastChangedByUser AS _LastChangedByUser,
  I_MeterReadingDocument._MeterReaderCode AS _MeterReaderCode,
  I_MeterReadingDocument._MeterReaderNote AS _MeterReaderNote,
  I_MeterReadingDocument._MeterReaderNoteFllwUpActn AS _MeterReaderNoteFllwUpActn,
  I_MeterReadingDocument._MeterReadingBasePeriodCat AS _MeterReadingBasePeriodCat,
  I_MeterReadingDocument._MeterReadingCategory AS _MeterReadingCategory,
  I_MeterReadingDocument._MeterReadingDocumentReason AS _MeterReadingDocumentReason,
  I_MeterReadingDocument._MeterReadingStatus AS _MeterReadingStatus,
  I_MeterReadingDocument._MeterReadingType AS _MeterReadingType,
  I_MeterReadingDocument._MeterReadingValdtnInfo AS _MeterReadingValdtnInfo,
  I_MeterReadingDocument._MtrRdngActiveStatus AS _MtrRdngActiveStatus,
  I_MeterReadingDocument._SchedldMtrReadingCategory AS _SchedldMtrReadingCategory,
  I_MeterReadingDocument._SystemStatus AS _SystemStatus,
  I_MeterReadingDocument._UnitOfMeasure AS _UnitOfMeasure,
  I_MeterReadingDocument._UnitOfMeasure_E AS _UnitOfMeasure_E,
  I_MeterReadingDocument._UtilsQuantityDetnProcedure AS _UtilsQuantityDetnProcedure
FROM I_MeterReadingDocument
INNER JOIN eabl AS _eabl ON /* join condition not captured in parsed metadata */
;

Learn More