I_SecuritiesClassRating

DDL: I_SECURITIESCLASSRATING SQL: ICLASSRATING Type: view BASIC Package: FTR_SECURITIES_CORE

Securities rating for class data

I_SecuritiesClassRating is a Basic CDS View that provides data about "Securities rating for class data" in SAP S/4HANA. It reads from 1 data source (rtgt_class) and exposes 11 fields with key fields SecurityClass, SecuritiesClassRatingProcedure, SecuritiesClRatgValdtyStrtDate. It has 3 associations to related views. Part of development package FTR_SECURITIES_CORE.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
rtgt_class ClassRating from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BPRatingProcedureGrade _SecurityClassRating ClassRating.grade = _SecurityClassRating.BusinessPartnerRatingGrade and ClassRating.grade_method = _SecurityClassRating.BusinessPartnerRatingProcedure
[1..1] I_BPRatingProcedure _SecurityClassRatingProcedure ClassRating.grade_method = _SecurityClassRatingProcedure.BusinessPartnerRatingProcedure
[1..1] I_SecurityClass _SecurityClass $projection.SecurityClass = _SecurityClass.SecurityClass

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICLASSRATING view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Securities rating for class data view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SecurityClass rtgt_class security_id_number
KEY SecuritiesClassRatingProcedure rtgt_class grade_method
KEY SecuritiesClRatgValdtyStrtDate
SecuritiesClRatgValdtyEndDate
ScrtyClRatingEnteredOnDate
SecuritiesClassRating
SecuritiesClassRatingTrend
SecuritiesClassRatingDesc
_SecurityClassRating _SecurityClassRating
_SecurityClassRatingProcedure _SecurityClassRatingProcedure
_SecurityClass _SecurityClass 
@AbapCatalog.sqlViewName: 'ICLASSRATING'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Securities rating for class data'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
define view I_SecuritiesClassRating
  as select from rtgt_class as ClassRating
  association [1..1] to I_BPRatingProcedureGrade as _SecurityClassRating          on  ClassRating.grade        = _SecurityClassRating.BusinessPartnerRatingGrade
                                                                                  and ClassRating.grade_method = _SecurityClassRating.BusinessPartnerRatingProcedure
  association [1..1] to I_BPRatingProcedure      as _SecurityClassRatingProcedure on  ClassRating.grade_method = _SecurityClassRatingProcedure.BusinessPartnerRatingProcedure
  association [1..1] to I_SecurityClass     as _SecurityClass           on  $projection.SecurityClass = _SecurityClass.SecurityClass
{
  key ClassRating.security_id_number                                                 as SecurityClass,

      @ObjectModel.foreignKey.association: '_SecurityClassRatingProcedure'
  key ClassRating.grade_method                                                       as SecuritiesClassRatingProcedure,

  key cast(ClassRating.valid_from as sec_cl_ratg_valdty_start_date preserving type ) as SecuritiesClRatgValdtyStrtDate,

      cast(ClassRating.valid_to as sec_cl_ratg_valdty_end_date preserving type )     as SecuritiesClRatgValdtyEndDate,

      cast(ClassRating.entered_on as fsbp_rating_date_entered preserving type )      as ScrtyClRatingEnteredOnDate,

      @ObjectModel.foreignKey.association: '_SecurityClassRating'
      cast(ClassRating.grade as security_class_rating preserving type )              as SecuritiesClassRating,

      cast(ClassRating.tendency as  security_class_rating_trend preserving type )    as SecuritiesClassRatingTrend,

      cast(ClassRating.text as security_class_rating_desc preserving type )          as SecuritiesClassRatingDesc,

      _SecurityClassRating,
      _SecurityClassRatingProcedure,
      
      @Consumption.hidden: true
      _SecurityClass
}

Learn More