I_UTILSDEVICERATEDATA

CDS View

Device Rate Data

I_UTILSDEVICERATEDATA is a CDS View in S/4HANA. Device Rate Data. It contains 13 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 13 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_IU_C_PODDEV view inner Point of Delivery by Device
I_UtilsInfoRecdHistAndInst view from COMPOSITE Information Record History And Installation
I_UtilsInstdDvceAndInst view from COMPOSITE Installed Device And Installation

Fields (13)

KeyField CDS FieldsUsed in Views
KEY UtilitiesInstallation UtilitiesInstallation 3
KEY UtilitiesLogicalDeviceNumber UtilitiesLogicalDeviceNumber 3
KEY UtilsDvceRateDataValdtyEndDte UtilsDvceRateDataValdtyEndDte 2
_UtilitiesInstallation _UtilitiesInstallation 1
_UtilsDevicePriceClass _UtilsDevicePriceClass 2
_UtilsDeviceRateFactGrp _UtilsDeviceRateFactGrp 2
_UtilsDeviceRateType _UtilsDeviceRateType 2
UtilsDevicePriceClass UtilsDevicePriceClass 2
UtilsDeviceRateFactGroup UtilsDeviceRateFactGroup 2
UtilsDeviceRateType UtilsDeviceRateType 2
UtilsDvceIsNotBillingRelevant UtilsDvceIsNotBillingRelevant 2
UtilsDvceIsRelevantForRntlPrc UtilsDvceIsRelevantForRntlPrc 2
UtilsDvceRateDataValdtyStrtDte UtilsDvceRateDataValdtyStrtDte 2 
@EndUserText.label: 'Device Rate Data' //same as DDL description

@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'UtilitiesLogicalDeviceNumber'
@AbapCatalog.sqlViewName: 'IEDVCERATEDATA'
@ObjectModel.usageType.serviceQuality: 'A'
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@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

define view I_UtilsDeviceRateData
  as select from eastl
  association [0..1] to I_UtilsDevicePriceClass  as _UtilsDevicePriceClass  on $projection.UtilsDevicePriceClass = _UtilsDevicePriceClass.UtilsDevicePriceClass
  association [0..1] to I_UtilsDeviceRateType    as _UtilsDeviceRateType    on $projection.UtilsDeviceRateType = _UtilsDeviceRateType.UtilsDeviceRateType
  association [0..1] to I_UtilsDeviceRateFactGrp as _UtilsDeviceRateFactGrp on $projection.UtilsDeviceRateFactGroup = _UtilsDeviceRateFactGrp.UtilsDeviceRateFactGroup
  association [1..1] to I_UtilitiesInstallation  as _UtilitiesInstallation  on $projection.UtilitiesInstallation = _UtilitiesInstallation.UtilitiesInstallation

{
  key logiknr                                         as UtilitiesLogicalDeviceNumber,
      @ObjectModel.foreignKey.association: '_UtilitiesInstallation'
  key anlage                                          as UtilitiesInstallation,
      @Semantics.businessDate.to: true
      //    key bis as UtilsDvceRateDataValdtyEndDte,

  key cast(bis as e_devrate_end_vdm preserving type)  as UtilsDvceRateDataValdtyEndDte,
      @Semantics.businessDate.from: true
      //    ab as UtilsDvceRateDataValdtyStrtDte,

      cast(ab as e_devrate_start_vdm preserving type) as UtilsDvceRateDataValdtyStrtDte,
      anlage                                          as UtilsInstallationDvceRateData,
      @ObjectModel.foreignKey.association: '_UtilsDevicePriceClass'
      preiskla                                        as UtilsDevicePriceClass,
      @Semantics.booleanIndicator:true
      gverrech                                        as UtilsDvceIsRelevantForRntlPrc,
      @ObjectModel.foreignKey.association: '_UtilsDeviceRateType'
      tarifart                                        as UtilsDeviceRateType,
      @ObjectModel.foreignKey.association: '_UtilsDeviceRateFactGrp'
      kondigr                                         as UtilsDeviceRateFactGroup,
      @Semantics.booleanIndicator:true
      device_nbr                                      as UtilsDvceIsNotBillingRelevant,

      _UtilsDevicePriceClass,
      _UtilsDeviceRateType,
      _UtilsDeviceRateFactGrp,
      _UtilitiesInstallation

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EASTL"
],
"ASSOCIATED":
[
"I_UTILITIESINSTALLATION",
"I_UTILSDEVICEPRICECLASS",
"I_UTILSDEVICERATEFACTGRP",
"I_UTILSDEVICERATETYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More