I_UtilsBillgDocMtrgDataBase

DDL: I_UTILSBILLGDOCMTRGDATABASE SQL: IEBILLGDOCMDATAB Type: view COMPOSITE
32 Fields 4 Data Sources

Billing Document Metering Data Base

I_UtilsBillgDocMtrgDataBase is a Composite CDS View (Cube) that provides data about "Billing Document Metering Data Base" in SAP S/4HANA. It reads from 4 data sources (I_MeterReadingDocument, I_UtilsBillgDocAddlLineItem, I_UtilsBillgDocDvceLineItem, I_UtilsBillingDocumentLineItem) and exposes 32 fields with key fields UtilitiesBillingDocument, UtilitiesBillingDocLineItem.

Data Sources (4)

SourceAliasJoin Type
I_MeterReadingDocument MeterReadingDocument inner
I_UtilsBillgDocAddlLineItem UtilsBillgDocAddlLineItem left_outer
I_UtilsBillgDocDvceLineItem UtilsBillgDocDvceLineItem from
I_UtilsBillingDocumentLineItem UtilsBillingDocumentLineItem inner

Annotations (10)

NameValueLevelField
EndUserText.label Billing Document Metering Data Base view
Analytics.dataCategory #CUBE view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEBILLGDOCMDATAB view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument I_UtilsBillgDocDvceLineItem UtilitiesBillingDocument SD Document
KEY UtilitiesBillingDocLineItem I_UtilsBillgDocDvceLineItem UtilitiesBillingDocLineItem Line item
MeterReadingDocument I_UtilsBillgDocDvceLineItem MeterReadingDocument Int. MR doc. ID
Equipment I_MeterReadingDocument Equipment Equipment check
UtilitiesDeviceCategory I_UtilsBillgDocDvceLineItem UtilitiesDeviceCategory Vehicle Model
UtilitiesDevice I_MeterReadingDocument UtilitiesDevice Serial Number
UtilitiesRegister I_MeterReadingDocument UtilitiesRegister Register
UtilsBillgDocLineItemStartDate I_UtilsBillingDocumentLineItem UtilsBillgDocLineItemStartDate Valid From
UtilsBillgDocLineItemEndDate I_UtilsBillingDocumentLineItem UtilsBillgDocLineItemEndDate Value
MeterReadingReason I_UtilsBillgDocDvceLineItem MeterReadingReason MR reason
MeterReadingResultDecimals I_MeterReadingDocument MeterReadingResultDecimals Dec. Places in MR
MeterReadingResultPreDecimals I_MeterReadingDocument MeterReadingResultPreDecimals Predec. Places in MR
MeterReadingResultValue
MeterReadingMeasurementUnit I_MeterReadingDocument MeterReadingMeasurementUnit MeasUnit for MR
UtilsBillgQuantityDecimals I_UtilsBillingDocumentLineItem UtilsBillgQuantityDecimals Places after decimal point in billing quantity
UtilsBillgQuantityPreDecimals I_UtilsBillingDocumentLineItem UtilsBillgQuantityPreDecimals Places before decimal point in billing quantity
UtilsBillgDocMtrRdngQuantity
BillingMeasurementUnit I_UtilsBillingDocumentLineItem BillingMeasurementUnit Billing MUnit
ScheduledMeterReadingDate I_MeterReadingDocument ScheduledMeterReadingDate
MeterReadingDate I_MeterReadingDocument MeterReadingDate MR date
MeterReadingTime I_MeterReadingDocument MeterReadingTime
MeterReadingStatus I_MeterReadingDocument MeterReadingStatus MR Status
NmbrOfUtilsRegDigitsDcmls I_MeterReadingDocument NmbrOfUtilsRegDigitsDcmls Decimal places
NmbrOfUtilsRegDigitsPreDcmls I_MeterReadingDocument NmbrOfUtilsRegDigitsPreDcmls Predec. places
MeterReadingType I_MeterReadingDocument MeterReadingType MR type
UtilsBillgDocLineItemType I_UtilsBillingDocumentLineItem UtilsBillgDocLineItemType Line item type
MeterReadingResultDifference
_MeterReadingType I_MeterReadingDocument _MeterReadingType
_MeterReadingStatus I_MeterReadingDocument _MeterReadingStatus
_UnitOfMeasure I_MeterReadingDocument _UnitOfMeasure
_UnitOfMeasure_E I_UtilsBillingDocumentLineItem _UnitOfMeasure_E
_UtilitiesBillingDocument I_UtilsBillgDocDvceLineItem _UtilitiesBillingDocument

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_UtilsBillgDocMtrgDataBase.
-- 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: IEBILLGDOCMDATAB

CREATE VIEW I_UtilsBillgDocMtrgDataBase AS
SELECT
  UtilsBillgDocDvceLineItem.UtilitiesBillingDocument AS UtilitiesBillingDocument,
  UtilsBillgDocDvceLineItem.UtilitiesBillingDocLineItem AS UtilitiesBillingDocLineItem,
  UtilsBillgDocDvceLineItem.MeterReadingDocument AS MeterReadingDocument,
  MeterReadingDocument.Equipment AS Equipment,
  UtilsBillgDocDvceLineItem.UtilitiesDeviceCategory AS UtilitiesDeviceCategory,
  MeterReadingDocument.UtilitiesDevice AS UtilitiesDevice,
  MeterReadingDocument.UtilitiesRegister AS UtilitiesRegister,
  UtilsBillingDocumentLineItem.UtilsBillgDocLineItemStartDate AS UtilsBillgDocLineItemStartDate,
  UtilsBillingDocumentLineItem.UtilsBillgDocLineItemEndDate AS UtilsBillgDocLineItemEndDate,
  UtilsBillgDocDvceLineItem.MeterReadingReason AS MeterReadingReason,
  MeterReadingDocument.MeterReadingResultDecimals AS MeterReadingResultDecimals,
  MeterReadingDocument.MeterReadingResultPreDecimals AS MeterReadingResultPreDecimals,
  cast(MeterReadingDocument.MeterReadingResultDecimals + MeterReadingDocument.MeterReadingResultPreDecimals as e_mtrrdngrsltval_vdm) AS MeterReadingResultValue,
  MeterReadingDocument.MeterReadingMeasurementUnit AS MeterReadingMeasurementUnit,
  UtilsBillingDocumentLineItem.UtilsBillgQuantityDecimals AS UtilsBillgQuantityDecimals,
  UtilsBillingDocumentLineItem.UtilsBillgQuantityPreDecimals AS UtilsBillgQuantityPreDecimals,
  cast(UtilsBillingDocumentLineItem.UtilsBillgQuantityDecimals + UtilsBillingDocumentLineItem.UtilsBillgQuantityPreDecimals as e_mtrrdngquantity_vdm) AS UtilsBillgDocMtrRdngQuantity,
  UtilsBillingDocumentLineItem.BillingMeasurementUnit AS BillingMeasurementUnit,
  MeterReadingDocument.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  MeterReadingDocument.MeterReadingDate AS MeterReadingDate,
  MeterReadingDocument.MeterReadingTime AS MeterReadingTime,
  MeterReadingDocument.MeterReadingStatus AS MeterReadingStatus,
  MeterReadingDocument.NmbrOfUtilsRegDigitsDcmls AS NmbrOfUtilsRegDigitsDcmls,
  MeterReadingDocument.NmbrOfUtilsRegDigitsPreDcmls AS NmbrOfUtilsRegDigitsPreDcmls,
  MeterReadingDocument.MeterReadingType AS MeterReadingType,
  UtilsBillingDocumentLineItem.UtilsBillgDocLineItemType AS UtilsBillgDocLineItemType,
  cast(UtilsBillgDocDvceLineItem.MeterRdngResultDiffPreDecimals + UtilsBillgDocDvceLineItem.MeterRdngResultDiffDecimals as i_zwstdiff preserving type) AS MeterReadingResultDifference,
  MeterReadingDocument._MeterReadingType AS _MeterReadingType,
  MeterReadingDocument._MeterReadingStatus AS _MeterReadingStatus,
  MeterReadingDocument._UnitOfMeasure AS _UnitOfMeasure,
  UtilsBillingDocumentLineItem._UnitOfMeasure_E AS _UnitOfMeasure_E,
  UtilsBillgDocDvceLineItem._UtilitiesBillingDocument AS _UtilitiesBillingDocument
FROM I_UtilsBillgDocDvceLineItem AS UtilsBillgDocDvceLineItem
INNER JOIN I_UtilsBillingDocumentLineItem AS UtilsBillingDocumentLineItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_MeterReadingDocument AS MeterReadingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UtilsBillgDocAddlLineItem AS UtilsBillgDocAddlLineItem ON /* join condition not captured in parsed metadata */
;

Learn More