SEPMRA_P_ProductRatingValues

DDL: SEPMRA_P_PRODUCTRATINGVALUES Type: view

SEPMRA_P_ProductRatingValues is a CDS View in SAP S/4HANA. It reads from 1 data source (dd07l).

1 data source(s)

Data Sources (1)

SourceAliasJoin Type
dd07l Value from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRAPPDRATVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_INDEPENDENT view
ClientHandling.algorithm #NONE view
ObjectModel.usageType.serviceQuality #P view
AccessControl.authorizationCheck #NOT_REQUIRED view 
@AbapCatalog: {
  sqlViewName: 'SEPMRAPPDRATVAL',
  compiler.compareFilter: true,
  preserveKey: true
}

@ClientHandling: {
  type:      #CLIENT_INDEPENDENT,
  algorithm: #NONE
}

@ObjectModel.usageType: {
  serviceQuality: #P
}

@AccessControl.authorizationCheck: #NOT_REQUIRED
define view SEPMRA_P_ProductRatingValues
  as select from dd07l as Value
{
      -- using DEC(4,2) is important for performance!
  key cast( cast( cast( left(Value.domvalue_l, 1) as abap.numc(1) ) as abap.dec(4,2) ) as sepmra_ratingvalue preserving type ) as Value
}
where
      Value.domname = 'SEPMRA_RATINGVALUE'
  and as4local      = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More