I_MeterReadingDocumentReasonTP

DDL: I_METERREADINGDOCUMENTREASONTP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 1 Associations

Meter Reading Document Reason TP

I_MeterReadingDocumentReasonTP is a Transactional CDS View that provides data about "Meter Reading Document Reason TP" in SAP S/4HANA. It reads from 1 data source (I_MeterReadingDocumentReason) and exposes 18 fields with key fields MeterReadingDocument, MeterReadingReason, UtilitiesInstallation. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MeterReadingDocumentReason I_MeterReadingDocumentReason from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UtilitiesContract _UtilitiesContract $projection.UtilitiesInstallation = _UtilitiesContract.UtilitiesInstallation and $projection.meterreadingdate >= _UtilitiesContract.UtilitiesMoveInDate and $projection.meterreadingdate <= _UtilitiesContract.UtilitiesMoveOutDate

Annotations (7)

NameValueLevelField
EndUserText.label Meter Reading Document Reason TP view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MeterReadingDocument I_MeterReadingDocumentReason MeterReadingDocument Int. MR doc. ID
KEY MeterReadingReason I_MeterReadingDocumentReason MeterReadingReason MR reason
KEY UtilitiesInstallation I_MeterReadingDocumentReason UtilitiesInstallation Installation
MeterReadingUnit I_MeterReadingDocumentReason MeterReadingUnit
MeterReadingIsSuppressed I_MeterReadingDocumentReason MeterReadingIsSuppressed
MeterReadingRsnScheduledDate I_MeterReadingDocumentReason MeterReadingRsnScheduledDate Scheduled MRD
ScheduledUtilitiesBillingDate I_MeterReadingDocumentReason ScheduledUtilitiesBillingDate
MeterReadingDate _MeterReadingDocumentTP MeterReadingDate
MeterReadingStatus _MeterReadingDocumentTP MeterReadingStatus
UtilitiesPortion
_MeterReadingDocumentTP _MeterReadingDocumentTP
_MeterReadingStatus _MeterReadingDocumentTP _MeterReadingStatus
_MeterReadingReason I_MeterReadingDocumentReason _MeterReadingReason
_MeterReadingUnit I_MeterReadingDocumentReason _MeterReadingUnit
_UtilitiesPortion
_MtrReadingDocument I_MeterReadingDocumentReason _MtrReadingDocument
_UtilitiesInstallation I_MeterReadingDocumentReason _UtilitiesInstallation
_UtilitiesContract _UtilitiesContract

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_MeterReadingDocumentReasonTP.
-- 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 I_MeterReadingDocumentReasonTP AS
SELECT
  I_MeterReadingDocumentReason.MeterReadingDocument AS MeterReadingDocument,
  I_MeterReadingDocumentReason.MeterReadingReason AS MeterReadingReason,
  I_MeterReadingDocumentReason.UtilitiesInstallation AS UtilitiesInstallation,
  I_MeterReadingDocumentReason.MeterReadingUnit AS MeterReadingUnit,
  I_MeterReadingDocumentReason.MeterReadingIsSuppressed AS MeterReadingIsSuppressed,
  I_MeterReadingDocumentReason.MeterReadingRsnScheduledDate AS MeterReadingRsnScheduledDate,
  I_MeterReadingDocumentReason.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  _MeterReadingDocumentTP.MeterReadingDate AS MeterReadingDate,
  _MeterReadingDocumentTP.MeterReadingStatus AS MeterReadingStatus,
  I_MeterReadingDocumentReason._MeterReadingUnit.UtilitiesPortion AS UtilitiesPortion,
  _MeterReadingDocumentTP._MeterReadingStatus AS _MeterReadingStatus,
  I_MeterReadingDocumentReason._MeterReadingReason AS _MeterReadingReason,
  I_MeterReadingDocumentReason._MeterReadingUnit AS _MeterReadingUnit,
  I_MeterReadingDocumentReason._MeterReadingUnit._UtilitiesPortion AS _UtilitiesPortion,
  I_MeterReadingDocumentReason._MtrReadingDocument AS _MtrReadingDocument,
  I_MeterReadingDocumentReason._UtilitiesInstallation AS _UtilitiesInstallation
FROM I_MeterReadingDocumentReason
LEFT OUTER JOIN I_UtilitiesContract AS _UtilitiesContract ON UtilitiesInstallation = _UtilitiesContract.UtilitiesInstallation AND meterreadingdate >= _UtilitiesContract.UtilitiesMoveInDate AND meterreadingdate <= _UtilitiesContract.UtilitiesMoveOutDate  -- association [0..1]
;

Learn More