R_CrdtMBusPartnerRatingTP

DDL: R_CRDTMBUSPARTNERRATINGTP Type: view_entity TRANSACTIONAL Package: ODATA_CREDIT_MGMT_MASTER

Credit Rating of a Business Partner

R_CrdtMBusPartnerRatingTP is a Transactional CDS View that provides data about "Credit Rating of a Business Partner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRating) and exposes 16 fields with key fields BusinessPartner, BPRatingValidityEndDate, BusinessPartnerRatingProcedure. Part of development package ODATA_CREDIT_MGMT_MASTER.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRating I_BusinessPartnerRating from

Annotations (8)

NameValueLevelField
EndUserText.label Credit Rating of a Business Partner view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY BPRatingValidityEndDate BPRatingValidityEndDate
KEY BusinessPartnerRatingProcedure BusinessPartnerRatingProcedure
BPRatingValidityStartDate BPRatingValidityStartDate
BusinessPartnerRatingGrade BusinessPartnerRatingGrade
BusinessPartnerRatingTrend BusinessPartnerRatingTrend
BPRatingCreationDate BPRatingCreationDate
BusinessPartnerRatingComment BusinessPartnerRatingComment
BPRatingValidityEndDateForEdit BPRatingValidityEndDate
BusinessPartnerRatingIsExpired BusinessPartnerRatingIsExpired
_CrdtMBusinessPartnerTP _CrdtMBusinessPartnerTP
_BPRatingProcedure _BPRatingProcedure
_BPRatingProcedureGrade _BPRatingProcedureGrade
_BPRatingTrend _BPRatingTrend
_BusinessPartner _BusinessPartner
_BPFinancialServicesExtn _BPFinancialServicesExtn 
@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