I_SECURITIESCLASSRATING

CDS View

Securities rating for class data

I_SECURITIESCLASSRATING is a CDS View in S/4HANA. Securities rating for class data. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SecuritiesClassRating view from COMPOSITE Private view for getting securities class new rating
R_SecurityClassRatingTP view_entity from TRANSACTIONAL Security Class Rating

Fields (5)

KeyField CDS FieldsUsed in Views
KEY SecuritiesClassRatingProcedure SecuritiesClassRatingProcedure 1
KEY SecuritiesClRatgValdtyStrtDate SecuritiesClRatgValdtyStrtDate 1
KEY SecurityClass SecurityClass 1
SecuritiesClassRating SecuritiesClassRating 1
SecuritiesClRatgValdtyEndDate SecuritiesClRatgValdtyEndDate 1 
@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