R_CRDTMBUSPARTNERRATINGTP

CDS View

Credit Rating of a Business Partner

R_CRDTMBUSPARTNERRATINGTP is a CDS View in S/4HANA. Credit Rating of a Business Partner. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CrdtMBusPartnerRatingTP view_entity projection CONSUMPTION Credit Rating of a Business Partner 
@EndUserText.label: 'Credit Rating of a Business Partner'

//@AbapCatalog: { sqlViewName:            'RBPCRDTRATINGTP',

//                compiler.compareFilter: true,

//                preserveKey:            true

//              }


@ObjectModel: { usageType: { dataClass:      #MASTER,
                             sizeCategory:   #L,      //we expecte to have less than 10.000.000 records

                             serviceQuality: #C       //intended for mass processing (building a list by SADL). Unfortunately the basic view promises only serviceQuality: #C

                           }
              }
              
@VDM: { viewType:                #TRANSACTIONAL,
        lifecycle.contract.type: #SAP_INTERNAL_API
      }

//@ClientHandling: { type:      #INHERITED,      //from the data source --> makes it client-dependent

//                   algorithm: #SESSION_VARIABLE

//                 }

                 
@AccessControl: { authorizationCheck:    #CHECK,
                  personalData.blocking: #BLOCKED_DATA_EXCLUDED //data privacy, hide data from blocked business partners

                }
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view entity R_CrdtMBusPartnerRatingTP 
    as select from I_BusinessPartnerRating 

  association        to parent R_CrdtMBusinessPartnerTP as _CrdtMBusinessPartnerTP on $projection.BusinessPartner = _CrdtMBusinessPartnerTP.BusinessPartner 

{
  key BusinessPartner,
  //key CrdtAcctDiffntnCriterion, //Field DIFTVAL is always empty in DB table BP1012 

  key BPRatingValidityEndDate,
  key BusinessPartnerRatingProcedure,
      BPRatingValidityStartDate,
      //BusinessPartnerRatingIsAllowed, //"Obsolete. Tx. UKM_BP either sets it to TRUE or doesn't save the record

      BusinessPartnerRatingGrade,
      BusinessPartnerRatingTrend,      
      BPRatingCreationDate,
      BusinessPartnerRatingComment,
      //Editable field for BPRatingValidityEndDate (updated by Delete+Insert)

      BPRatingValidityEndDate as BPRatingValidityEndDateForEdit, 
     
      BusinessPartnerRatingIsExpired, //For DCL: On-Premise systems can require special authorizations to see old ratings

//      BPRatingIsValidOnKeyDate,


  _CrdtMBusinessPartnerTP, // BO Root

      
  /* Associations */
  _BPRatingProcedure,
  _BPRatingProcedureGrade,
  _BPRatingTrend,
  _BusinessPartner,  
  
  _BPFinancialServicesExtn  //Needed for inherited DCL - includes authorization check to show old ratings

}

Learn More