P_MeterReadingDocumentAndRsn

DDL: P_METERREADINGDOCUMENTANDRSN SQL: PEMTRRDNGDOCRSN Type: view COMPOSITE
14 Fields 3 Data Sources

P_MeterReadingDocumentAndRsn is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_MeterReadingDocument, I_MeterReadingDocumentReason, I_MeterReadingUnit) and exposes 14 fields with key fields MeterReadingDocument, MeterReadingReason, UtilitiesInstallation.

Data Sources (3)

SourceAliasJoin Type
I_MeterReadingDocument I_MeterReadingDocument from
I_MeterReadingDocumentReason I_MeterReadingDocumentReason inner
I_MeterReadingUnit I_MeterReadingUnit inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PEMTRRDNGDOCRSN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MeterReadingDocument I_MeterReadingDocument MeterReadingDocument Int. MR doc. ID
KEY MeterReadingReason I_MeterReadingDocumentReason MeterReadingReason MR reason
KEY UtilitiesInstallation I_MeterReadingDocumentReason UtilitiesInstallation Installation
Equipment I_MeterReadingDocument Equipment Equipment check
MeterReadingUnit I_MeterReadingDocumentReason MeterReadingUnit Portion
MeterReadingRsnScheduledDate I_MeterReadingDocumentReason MeterReadingRsnScheduledDate Scheduled MRD
MeterReadingStatus I_MeterReadingDocument MeterReadingStatus MR Status
UtilitiesPortion I_MeterReadingUnit UtilitiesPortion Portion
_MeterReadingDocumentReason _MeterReadingDocumentReason
_MeterReadingReason _MeterReadingReason
_MeterReadingUnit _MeterReadingUnit
_MeterReadingStatus _MeterReadingStatus
_MeterReadingValdtnInfo _MeterReadingValdtnInfo
_UtilitiesInstallation _UtilitiesInstallation

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 P_MeterReadingDocumentAndRsn.
-- 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: PEMTRRDNGDOCRSN

CREATE VIEW P_MeterReadingDocumentAndRsn AS
SELECT
  I_MeterReadingDocument.MeterReadingDocument AS MeterReadingDocument,
  I_MeterReadingDocumentReason.MeterReadingReason AS MeterReadingReason,
  I_MeterReadingDocumentReason.UtilitiesInstallation AS UtilitiesInstallation,
  I_MeterReadingDocument.Equipment AS Equipment,
  I_MeterReadingDocumentReason.MeterReadingUnit AS MeterReadingUnit,
  I_MeterReadingDocumentReason.MeterReadingRsnScheduledDate AS MeterReadingRsnScheduledDate,
  I_MeterReadingDocument.MeterReadingStatus AS MeterReadingStatus,
  I_MeterReadingUnit.UtilitiesPortion AS UtilitiesPortion
FROM I_MeterReadingDocument
INNER JOIN I_MeterReadingDocumentReason ON /* join condition not captured in parsed metadata */
INNER JOIN I_MeterReadingUnit ON /* join condition not captured in parsed metadata */
;

Learn More