What is I_MeterReadingDocumentCube in SAP S/4HANA?

I_MeterReadingDocumentCube is a composite CDS view in SAP S/4HANA. Meter Reading Document Cube It contains 80 fields.

Which tables does I_MeterReadingDocumentCube read from?

I_MeterReadingDocumentCube reads data from: I_MeterReadingDocument.

What VDM layer is I_MeterReadingDocumentCube?

I_MeterReadingDocumentCube is classified as a Composite view that combines data from multiple basic views.

I_MeterReadingDocumentCube

DDL: I_METERREADINGDOCUMENTCUBE SQL: IEMTRRDNGDOCC Type: view COMPOSITE

80 Fields 1 Data Sources

Meter Reading Document Cube

Meter Reading Document - Cube

I_MeterReadingDocumentCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Utilities

I_MeterReadingDocumentCube is a Composite CDS View (Cube) that provides data about "Meter Reading Document Cube" in SAP S/4HANA. It reads from 1 data source (I_MeterReadingDocument) and exposes 80 fields with key fields MeterReadingDocument, UtilitiesInstallation, MeterReadingReason.

SAP API Hub

State	C1
Line of Business	Utilities
Application Component	IS-U-DM-MR
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Utilities for SAP S/4HANA
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>How many meter reading results are missing?</p></li> <li><p>How many plausible meter reading results exist?</p></li> <li><p>How many implausible meter reading results exist?</p></li> <li><p>How many meter reading documents exist?</p></li> </ul> <p>You can also use this view to analyze your data and answer a number of additional questions, such as:</p> <ul> <li><p>How many meter reading requests were sent to the external system (for example, MDUS)?</p></li> <li><p>How many meters were read by a certain meter reader?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA, onpremise edition — Explore SAP S/4HANA Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_MeterReadingDocument	MeterReadingDocument	from

Annotations (10)

Name	Value	Level
EndUserText.label	Meter Reading Document Cube	view
Analytics.dataCategory	#CUBE	view
VDM.viewType	#COMPOSITE	view
AbapCatalog.sqlViewName	IEMTRRDNGDOCC	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.allowExtensions	true	view

Fields (80)

Key	Field	Source Table	Source Field	Description
KEY	MeterReadingDocument	I_MeterReadingDocument	MeterReadingDocument	Internal ID for meter reading document
KEY	UtilitiesInstallation			Installation
KEY	MeterReadingReason			Meter Reading Reason
	UtilitiesDevice	I_MeterReadingDocument	UtilitiesDevice	Serial Number
	SerialNumber	I_MeterReadingDocument	UtilitiesDevice	Serial Number
	Equipment	I_MeterReadingDocument	Equipment	Equipment Number
	UtilitiesRegister	I_MeterReadingDocument	UtilitiesRegister	Register
	MeterReadingDate	I_MeterReadingDocument	MeterReadingDate	Meter Reading Date Relevant to Billing
	MeterReadingTime	I_MeterReadingDocument	MeterReadingTime	Meter Reading Time (Relevant to Billing)
	MeterReadingMeasurementUnit	I_MeterReadingDocument	MeterReadingMeasurementUnit	Unit of measurement for meter reading
	BillingMeasurementUnit	I_MeterReadingDocument	BillingMeasurementUnit	Unit of measurement for billing
	NmbrOfUtilsRegDigitsPreDcmls	I_MeterReadingDocument	NmbrOfUtilsRegDigitsPreDcmls	Number of predecimal places for register
	NmbrOfUtilsRegDigitsDcmls	I_MeterReadingDocument	NmbrOfUtilsRegDigitsDcmls	Number of decimal places for register
	MeterReadingStatus	I_MeterReadingDocument	MeterReadingStatus	Meter Reading Status
	MeterReadingType	I_MeterReadingDocument	MeterReadingType	Meter Reading Type
	MeterReadingCategory	I_MeterReadingDocument	MeterReadingCategory	Meter reading category
	ScheduledMeterReadingDate	I_MeterReadingDocument	ScheduledMeterReadingDate	Scheduled Meter Reading Date
	ActualMeterReadingDate	I_MeterReadingDocument	ActualMeterReadingDate	Actual meter reading date
	ActualMeterReadingTime	I_MeterReadingDocument	ActualMeterReadingTime	Actual Meter Reading Time
	MaximumMeterReadingDate	I_MeterReadingDocument	MaximumMeterReadingDate	Date of maximum meter reading
	MaximumMeterReadingTime	I_MeterReadingDocument	MaximumMeterReadingTime	Time of Maximum Meter Reading
	UtilitiesGasAllocationDate	I_MeterReadingDocument	UtilitiesGasAllocationDate	Gas allocation date
	CtrlMtrReadingOrderSchedldDate	I_MeterReadingDocument	CtrlMtrReadingOrderSchedldDate	Meter reading date of implausible meter reading result
	CtrlMtrReadingOrderSchedldTime	I_MeterReadingDocument	CtrlMtrReadingOrderSchedldTime	Meter Reading Time of Implausible Meter Reading Result
	ControlMeterReadingIsPrinted	I_MeterReadingDocument	ControlMeterReadingIsPrinted	Control Meter Reading Order ID Printed
	IndepMtrRdngValidationChk	I_MeterReadingDocument	IndepMtrRdngValidationChk	Independent Validation
	DepdntMtrRdngValidationChk	I_MeterReadingDocument	DepdntMtrRdngValidationChk	Dependent Validation
	MeterReaderNoteCode	I_MeterReadingDocument	MeterReaderNoteCode	Meter Reading Note from Meter Reader
	MeterReaderNoteFllwUpActn	I_MeterReadingDocument	MeterReaderNoteFllwUpActn	Control of follow-up action for MR result with MR note
	MeterReaderCode	I_MeterReadingDocument	MeterReaderCode	Meter reader number
	MeterReadingBasePeriodCat	I_MeterReadingDocument	MeterReadingBasePeriodCat	Base period category
	MeterReadingCreationDate	I_MeterReadingDocument	MeterReadingCreationDate	Record Created On
	MeterReadingCreatedByUser	I_MeterReadingDocument	MeterReadingCreatedByUser	Name of Person Responsible for Creating the Object
	MeterReadingLastChangeDate	I_MeterReadingDocument	MeterReadingLastChangeDate	Last Changed On
	MeterReadingLastChangedByUser	I_MeterReadingDocument	MeterReadingLastChangedByUser	Name of Person Who Changed Object
	AdvancedMeteringSystem	I_MeterReadingDocument	AdvancedMeteringSystem	Advanced Metering System
	MeterReadingTransferStatus	I_MeterReadingDocument	MeterReadingTransferStatus	Meter Reading Transfer Status
	MeterReadingTransferDateTime	I_MeterReadingDocument	MeterReadingTransferDateTime	Meter Reading Transfer DateTime
	AdvncdMeteringDataOrignType	I_MeterReadingDocument	AdvncdMeteringDataOrignType	Source System From Which Data is Requested
	MobileMeterReadingEntrySystem	I_MeterReadingDocument	MobileMeterReadingEntrySystem	Number for mobile data entry (MDE)
	MeterReadingOrderIsOutputted	I_MeterReadingDocument	MeterReadingOrderIsOutputted	Order has been output
	MeterReadingCheckDigit	I_MeterReadingDocument	MeterReadingCheckDigit	Check number
	MeterReadingFastEntryNumber	I_MeterReadingDocument	MeterReadingFastEntryNumber	Entry number for fast entry
	MeterReadingIsRecaptured	I_MeterReadingDocument	MeterReadingIsRecaptured	Meter reading result inserted or modified
	MeterReadingAutomMntrgStatus	I_MeterReadingDocument	MeterReadingAutomMntrgStatus	Status for automatic monitoring of meter reading order
	MtrRdngIsSchdlForMltplOrdCrtn	I_MeterReadingDocument	MtrRdngIsSchdlForMltplOrdCrtn	Multiple meter reading order creation
	MltplMtrRdngOrdCrtnCntrlGroup	I_MeterReadingDocument	MltplMtrRdngOrdCrtnCntrlGroup	Control group for multiple meter reading order creation
	MltplMtrRdngRefSchedldDate	I_MeterReadingDocument	MltplMtrRdngRefSchedldDate	Scheduled meter reading date for base meter reading
	ServiceOrder	I_MeterReadingDocument	ServiceOrder	Service order or notification
	OrderType	I_MeterReadingDocument	OrderType	Document category for plant maintenance and customer service
	MeterReadingUnit			Meter Reading Unit
	MeterReadingIsSuppressed			Suppressed Indicator
	SchedldMtrReadingCategory	I_MeterReadingDocument	SchedldMtrReadingCategory	Scheduled meter reading category
	MeterReadingAllocationDate	I_MeterReadingDocument	MeterReadingAllocationDate	Meter reading allocation date
	ScheduledUtilitiesBillingDate			Scheduled Billing Date
	MtrRdngActiveStatus	I_MeterReadingDocument	MtrRdngActiveStatus	Meter reading active
	UtilitiesPortion			Portion
	NumberOfMeterReadingDocuments			Number of Meter Reading Documents
	NmbrOfPlausibleMtrRdngRslts			Number of Plausible Meter Reading Results
	NmbrOfImplausibleMtrRdngRslts			Number of Implausible Meter Reading Results
	NmbrOfMissingMtrRdngRslts			Number of Missing Meter Reading Results
	_UtilitiesInstallation
	_MeterReadingReason
	_UnitOfMeasure	I_MeterReadingDocument	_UnitOfMeasure
	_UnitOfMeasure_E	I_MeterReadingDocument	_UnitOfMeasure_E
	_MeterReadingStatus	I_MeterReadingDocument	_MeterReadingStatus
	_MeterReadingType	I_MeterReadingDocument	_MeterReadingType
	_MeterReadingCategory	I_MeterReadingDocument	_MeterReadingCategory
	_IndepMtrRdngValidationChk	I_MeterReadingDocument	_IndepMtrRdngValidationChk
	_DepdntMtrRdngValidationChk	I_MeterReadingDocument	_DepdntMtrRdngValidationChk
	_MeterReaderNote	I_MeterReadingDocument	_MeterReaderNote
	_MeterReaderNoteFllwUpActn	I_MeterReadingDocument	_MeterReaderNoteFllwUpActn
	_MeterReaderCode	I_MeterReadingDocument	_MeterReaderCode
	_MeterReadingBasePeriodCat	I_MeterReadingDocument	_MeterReadingBasePeriodCat
	_AdvancedMeteringSystem	I_MeterReadingDocument	_AdvancedMeteringSystem
	_SystemStatus	I_MeterReadingDocument	_SystemStatus
	_MeterReadingUnit
	_SchedldMtrReadingCategory	I_MeterReadingDocument	_SchedldMtrReadingCategory
	_MtrRdngActiveStatus	I_MeterReadingDocument	_MtrRdngActiveStatus
	_UtilitiesPortion

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_MeterReadingDocumentCube.
-- 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: IEMTRRDNGDOCC

CREATE VIEW I_MeterReadingDocumentCube AS
SELECT
  MeterReadingDocument.MeterReadingDocument AS MeterReadingDocument,
  MeterReadingDocument._MeterReadingDocumentReason.UtilitiesInstallation AS UtilitiesInstallation,
  MeterReadingDocument._MeterReadingDocumentReason.MeterReadingReason AS MeterReadingReason,
  MeterReadingDocument.UtilitiesDevice AS UtilitiesDevice,
  MeterReadingDocument.UtilitiesDevice AS SerialNumber,
  MeterReadingDocument.Equipment AS Equipment,
  MeterReadingDocument.UtilitiesRegister AS UtilitiesRegister,
  MeterReadingDocument.MeterReadingDate AS MeterReadingDate,
  MeterReadingDocument.MeterReadingTime AS MeterReadingTime,
  MeterReadingDocument.MeterReadingMeasurementUnit AS MeterReadingMeasurementUnit,
  MeterReadingDocument.BillingMeasurementUnit AS BillingMeasurementUnit,
  MeterReadingDocument.NmbrOfUtilsRegDigitsPreDcmls AS NmbrOfUtilsRegDigitsPreDcmls,
  MeterReadingDocument.NmbrOfUtilsRegDigitsDcmls AS NmbrOfUtilsRegDigitsDcmls,
  MeterReadingDocument.MeterReadingStatus AS MeterReadingStatus,
  MeterReadingDocument.MeterReadingType AS MeterReadingType,
  MeterReadingDocument.MeterReadingCategory AS MeterReadingCategory,
  MeterReadingDocument.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  MeterReadingDocument.ActualMeterReadingDate AS ActualMeterReadingDate,
  MeterReadingDocument.ActualMeterReadingTime AS ActualMeterReadingTime,
  MeterReadingDocument.MaximumMeterReadingDate AS MaximumMeterReadingDate,
  MeterReadingDocument.MaximumMeterReadingTime AS MaximumMeterReadingTime,
  MeterReadingDocument.UtilitiesGasAllocationDate AS UtilitiesGasAllocationDate,
  MeterReadingDocument.CtrlMtrReadingOrderSchedldDate AS CtrlMtrReadingOrderSchedldDate,
  MeterReadingDocument.CtrlMtrReadingOrderSchedldTime AS CtrlMtrReadingOrderSchedldTime,
  MeterReadingDocument.ControlMeterReadingIsPrinted AS ControlMeterReadingIsPrinted,
  MeterReadingDocument.IndepMtrRdngValidationChk AS IndepMtrRdngValidationChk,
  MeterReadingDocument.DepdntMtrRdngValidationChk AS DepdntMtrRdngValidationChk,
  MeterReadingDocument.MeterReaderNoteCode AS MeterReaderNoteCode,
  MeterReadingDocument.MeterReaderNoteFllwUpActn AS MeterReaderNoteFllwUpActn,
  MeterReadingDocument.MeterReaderCode AS MeterReaderCode,
  MeterReadingDocument.MeterReadingBasePeriodCat AS MeterReadingBasePeriodCat,
  MeterReadingDocument.MeterReadingCreationDate AS MeterReadingCreationDate,
  MeterReadingDocument.MeterReadingCreatedByUser AS MeterReadingCreatedByUser,
  MeterReadingDocument.MeterReadingLastChangeDate AS MeterReadingLastChangeDate,
  MeterReadingDocument.MeterReadingLastChangedByUser AS MeterReadingLastChangedByUser,
  MeterReadingDocument.AdvancedMeteringSystem AS AdvancedMeteringSystem,
  MeterReadingDocument.MeterReadingTransferStatus AS MeterReadingTransferStatus,
  MeterReadingDocument.MeterReadingTransferDateTime AS MeterReadingTransferDateTime,
  MeterReadingDocument.AdvncdMeteringDataOrignType AS AdvncdMeteringDataOrignType,
  MeterReadingDocument.MobileMeterReadingEntrySystem AS MobileMeterReadingEntrySystem,
  MeterReadingDocument.MeterReadingOrderIsOutputted AS MeterReadingOrderIsOutputted,
  MeterReadingDocument.MeterReadingCheckDigit AS MeterReadingCheckDigit,
  MeterReadingDocument.MeterReadingFastEntryNumber AS MeterReadingFastEntryNumber,
  MeterReadingDocument.MeterReadingIsRecaptured AS MeterReadingIsRecaptured,
  MeterReadingDocument.MeterReadingAutomMntrgStatus AS MeterReadingAutomMntrgStatus,
  MeterReadingDocument.MtrRdngIsSchdlForMltplOrdCrtn AS MtrRdngIsSchdlForMltplOrdCrtn,
  MeterReadingDocument.MltplMtrRdngOrdCrtnCntrlGroup AS MltplMtrRdngOrdCrtnCntrlGroup,
  MeterReadingDocument.MltplMtrRdngRefSchedldDate AS MltplMtrRdngRefSchedldDate,
  MeterReadingDocument.ServiceOrder AS ServiceOrder,
  MeterReadingDocument.OrderType AS OrderType,
  MeterReadingDocument._MeterReadingDocumentReason.MeterReadingUnit AS MeterReadingUnit,
  MeterReadingDocument._MeterReadingDocumentReason.MeterReadingIsSuppressed AS MeterReadingIsSuppressed,
  MeterReadingDocument.SchedldMtrReadingCategory AS SchedldMtrReadingCategory,
  MeterReadingDocument.MeterReadingAllocationDate AS MeterReadingAllocationDate,
  MeterReadingDocument._MeterReadingDocumentReason.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  MeterReadingDocument.MtrRdngActiveStatus AS MtrRdngActiveStatus,
  MeterReadingDocument._MeterReadingDocumentReason._MeterReadingUnit.UtilitiesPortion AS UtilitiesPortion,
  cast (1 as e_num_mrdocuments_vdm) AS NumberOfMeterReadingDocuments,
  cast (1 as e_num_plsbl_mrr_vdm) AS NmbrOfPlausibleMtrRdngRslts,
  cast (1 as e_num_implslbl_mrr_vdm) AS NmbrOfImplausibleMtrRdngRslts,
  cast (1 as e_num_missing_mrr_vdm) AS NmbrOfMissingMtrRdngRslts,
  MeterReadingDocument._MeterReadingDocumentReason._UtilitiesInstallation AS _UtilitiesInstallation,
  MeterReadingDocument._MeterReadingDocumentReason._MeterReadingReason AS _MeterReadingReason,
  MeterReadingDocument._UnitOfMeasure AS _UnitOfMeasure,
  MeterReadingDocument._UnitOfMeasure_E AS _UnitOfMeasure_E,
  MeterReadingDocument._MeterReadingStatus AS _MeterReadingStatus,
  MeterReadingDocument._MeterReadingType AS _MeterReadingType,
  MeterReadingDocument._MeterReadingCategory AS _MeterReadingCategory,
  MeterReadingDocument._IndepMtrRdngValidationChk AS _IndepMtrRdngValidationChk,
  MeterReadingDocument._DepdntMtrRdngValidationChk AS _DepdntMtrRdngValidationChk,
  MeterReadingDocument._MeterReaderNote AS _MeterReaderNote,
  MeterReadingDocument._MeterReaderNoteFllwUpActn AS _MeterReaderNoteFllwUpActn,
  MeterReadingDocument._MeterReaderCode AS _MeterReaderCode,
  MeterReadingDocument._MeterReadingBasePeriodCat AS _MeterReadingBasePeriodCat,
  MeterReadingDocument._AdvancedMeteringSystem AS _AdvancedMeteringSystem,
  MeterReadingDocument._SystemStatus AS _SystemStatus,
  MeterReadingDocument._MeterReadingDocumentReason._MeterReadingUnit AS _MeterReadingUnit,
  MeterReadingDocument._SchedldMtrReadingCategory AS _SchedldMtrReadingCategory,
  MeterReadingDocument._MtrRdngActiveStatus AS _MtrRdngActiveStatus,
  MeterReadingDocument._MeterReadingDocumentReason._MeterReadingUnit._UtilitiesPortion AS _UtilitiesPortion
FROM I_MeterReadingDocument AS MeterReadingDocument
;

Depth:

I_MeterReadingDocumentCube view

I_MeterReadingDocument view

C_MeterReadingDocumentQuery view
I_MissingMtrRdngOrderCube view