P_MeterReadingDocumentAndRsn

DDL: P_METERREADINGDOCUMENTANDRSN SQL: PEMTRRDNGDOCRSN Type: view COMPOSITE

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.

3 data source(s) 14 fields

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
KEY MeterReadingReason I_MeterReadingDocumentReason MeterReadingReason
KEY UtilitiesInstallation I_MeterReadingDocumentReason UtilitiesInstallation
Equipment I_MeterReadingDocument Equipment
MeterReadingUnit I_MeterReadingDocumentReason MeterReadingUnit
MeterReadingRsnScheduledDate I_MeterReadingDocumentReason MeterReadingRsnScheduledDate
MeterReadingStatus I_MeterReadingDocument MeterReadingStatus
UtilitiesPortion I_MeterReadingUnit UtilitiesPortion
_MeterReadingDocumentReason _MeterReadingDocumentReason
_MeterReadingReason _MeterReadingReason
_MeterReadingUnit _MeterReadingUnit
_MeterReadingStatus _MeterReadingStatus
_MeterReadingValdtnInfo _MeterReadingValdtnInfo
_UtilitiesInstallation _UtilitiesInstallation 
@AbapCatalog.sqlViewName: 'PEMTRRDNGDOCRSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Meter Reading Document and Reason'



define view P_MeterReadingDocumentAndRsn
  as select from I_MeterReadingDocument
    inner join   I_MeterReadingDocumentReason on I_MeterReadingDocument.MeterReadingDocument = I_MeterReadingDocumentReason.MeterReadingDocument
    inner join   I_MeterReadingUnit           on I_MeterReadingDocumentReason.MeterReadingUnit = I_MeterReadingUnit.MeterReadingUnit
{

  key I_MeterReadingDocument.MeterReadingDocument,
      @ObjectModel.foreignKey.association: '_MeterReadingReason'
  key I_MeterReadingDocumentReason.MeterReadingReason,
      @ObjectModel.foreignKey.association: '_UtilitiesInstallation'
  key I_MeterReadingDocumentReason.UtilitiesInstallation,
      I_MeterReadingDocument.Equipment,
      @ObjectModel.foreignKey.association: '_MeterReadingUnit'
      I_MeterReadingDocumentReason.MeterReadingUnit,
      I_MeterReadingDocumentReason.MeterReadingRsnScheduledDate,
      @ObjectModel.foreignKey.association: '_MeterReadingStatus'
      I_MeterReadingDocument.MeterReadingStatus,

      I_MeterReadingUnit.UtilitiesPortion,

      /* Associations */
      _MeterReadingDocumentReason,
      _MeterReadingReason,
      _MeterReadingUnit,
      _MeterReadingStatus,
      _MeterReadingValdtnInfo,
      _UtilitiesInstallation

}
where
  MeterReadingReason = '01'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_METERREADINGDOCUMENT",
"I_METERREADINGDOCUMENTREASON",
"I_METERREADINGUNIT"
],
"ASSOCIATED":
[
"I_METERREADINGDOCUMENTREASON",
"I_METERREADINGREASON",
"I_METERREADINGSTATUS",
"I_METERREADINGUNIT",
"I_METERREADINGVALDTNINFO",
"I_UTILITIESINSTALLATION"
],
"BASE":
[
"I_METERREADINGDOCUMENT",
"I_METERREADINGDOCUMENTREASON"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More