I_MTRRDNGUNITSCHEDULERECORD

CDS View

Schedule Record For Meter Reading Unit

I_MTRRDNGUNITSCHEDULERECORD is a CDS View in S/4HANA. Schedule Record For Meter Reading Unit. It contains 10 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 10 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_MtrRdngUnitSchedRecdDteInfo view from COMPOSITE Date Information for Meter Reading Unit Schedule Record
I_MtrRdngUnitSchedRecdRlvt view from COMPOSITE Relevant Meter Reading Unit Schedule Record
I_SchedldRdngRelevantRegCube view from COMPOSITE Scheduled Reading-Relevant Register Cube
I_UtilsContractToBeBilled view inner COMPOSITE Contract To Be Billed
I_UtilsContrToBeBlldData view inner COMPOSITE Utilities Contract to Be Billed Data

Fields (10)

KeyField CDS FieldsUsed in Views
KEY MeterReadingUnit MeterReadingUnit 3
KEY MtrRdngUnitScheduleRecordDate MtrRdngUnitScheduleRecordDate 1
KEY ScheduledMeterReadingDate ScheduledMeterReadingDate 4
_MeterReadingReason _MeterReadingReason 3
_MeterReadingUnit _MeterReadingUnit 3
_SchedMeterReadCat _SchedMeterReadCat 2
MeterReadingAllocationDate MeterReadingAllocationDate 1
MeterReadingReason MeterReadingReason 3
SchedldMtrReadingCategory SchedldMtrReadingCategory 2
UtilsBillgPrevSchedRecdEndDate UtilsBillgPrevSchedRecdEndDate 1 
@EndUserText.label: 'Schedule Record For Meter Reading Unit'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IEMRUNITSCHEDREC'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MeterReadingUnit'
@Metadata.allowExtensions:true
@AbapCatalog.compiler.compareFilter:true
//@AbapCatalog.preserveKey:true

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

/*+[hideWarning] { "IDS" :
[ "KEY_CHECK" ] } */
define view I_MtrRdngUnitScheduleRecord
  as select from te418
  association [1..1] to I_MeterReadingUnit     as _MeterReadingUnit   on $projection.MeterReadingUnit = _MeterReadingUnit.MeterReadingUnit
  association [1..1] to I_MeterReadingReason   as _MeterReadingReason on $projection.MeterReadingReason = _MeterReadingReason.MeterReadingReason
  association [1..1] to I_SchedMeterReadingCat as _SchedMeterReadCat  on $projection.SchedldMtrReadingCategory = _SchedMeterReadCat.SchedldMtrReadingCategory

{
  key cast(termschl as ableinheit preserving type)                      as MeterReadingUnit,

      @Semantics.businessDate.to: true
  key termtdat                                                          as MtrRdngUnitScheduleRecordDate,

      @ObjectModel.foreignKey.association: '_SchedMeterReadCat'
      te418.ablesart                                                    as SchedldMtrReadingCategory,

      @Semantics.businessDate.at: true
      cast(te418.adatsoll as e_schedld_mtrrdng_dte_vdm preserving type) as ScheduledMeterReadingDate,

      @Semantics.businessDate.at: true
      te418.zuorddat                                                    as MeterReadingAllocationDate,

      @ObjectModel.foreignKey.association: '_MeterReadingReason'
      te418.ablesgr                                                     as MeterReadingReason,

      @Semantics.businessDate.from: true
      te418.endvoper                                                    as UtilsBillgPrevSchedRecdEndDate,

      /* Associations */
      _MeterReadingUnit,
      _MeterReadingReason,
      _SchedMeterReadCat
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TE418"
],
"ASSOCIATED":
[
"I_METERREADINGREASON",
"I_METERREADINGUNIT",
"I_SCHEDMETERREADINGCAT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More