I_BPRatingProcessTP

DDL: I_BPRATINGPROCESSTP Type: view_entity Package: MDC_BUPA_GOV_BO

Rating of Business Partner (Process)

I_BPRatingProcessTP is a CDS View that provides data about "Rating of Business Partner (Process)" in SAP S/4HANA. It reads from 1 data source (I_BPRatingProcess) and exposes 27 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BusinessPartnerRatingProcedure. It has 3 associations to related views. Part of development package MDC_BUPA_GOV_BO.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_BPRatingProcess BPRating from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_BPProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..*] I_MDChgProcRecordMessages _RecordMessages $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordMessages.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordMessages.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordMessages.MDChgProcessSrceObject

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Rating of Business Partner (Process) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY BusinessPartnerRatingProcedure BusinessPartnerRatingProcedure
KEY BPRatingValidityEndDate BPRatingValidityEndDate
BusinessPartnerRatingGrade BusinessPartnerRatingGrade
BusinessPartnerRatingTrend BusinessPartnerRatingTrend
BPRatingValidityStartDate BPRatingValidityStartDate
BPRatingCreationDate BPRatingCreationDate
BusinessPartnerRatingComment BusinessPartnerRatingComment
BusinessPartnerRatingIsAllowed BusinessPartnerRatingIsAllowed
BPRatingLongComment BPRatingLongComment
BPRatingIsValidOnKeyDate BPRatingIsValidOnKeyDate
BusinessPartnerRatingKeyDate BusinessPartnerRatingKeyDate
BusinessPartnerRatingIsExpired BusinessPartnerRatingIsExpired
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
AddressLine1Text
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_RecordMessages _RecordMessages
_BPRatingProcedure _BPRatingProcedure
_BPRatingProcedureGrade _BPRatingProcedureGrade
_BusinessPartner _BusinessPartner
_BPFinServicesDetail _BPFinServicesDetail 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Rating of Business Partner (Process)'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPRatingProcessTP
  as select from I_BPRatingProcess as BPRating
  association        to parent I_BusinessPartnerProcessTP as _BusinessPartner     on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject

  association [0..1] to I_BPProcessKPIRecordType          as _RecordType          on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH         as _KPIUpdateStatusText on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..*] to I_MDChgProcRecordMessages         as _RecordMessages      on  $projection.MasterDataChangeProcess = _RecordMessages.MasterDataChangeProcess
                                                                                  and $projection.MDChgProcessStep        = _RecordMessages.MDChgProcessStep
                                                                                  and $projection.MDChgProcessSrceSystem  = _RecordMessages.MDChgProcessSrceSystem
                                                                                  and $projection.MDChgProcessSrceObject  = _RecordMessages.MDChgProcessSrceObject
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key BusinessPartnerRatingProcedure,
  key BPRatingValidityEndDate,
      BusinessPartnerRatingGrade,
      BusinessPartnerRatingTrend,
      BPRatingValidityStartDate,
      BPRatingCreationDate,
      BusinessPartnerRatingComment,
      BusinessPartnerRatingIsAllowed,
      BPRatingLongComment,
      BPRatingIsValidOnKeyDate,
      BusinessPartnerRatingKeyDate,
      BusinessPartnerRatingIsExpired,

      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,

      cast( '' as abap.char(209) )                                   as AddressLine1Text,
      cast( case
        when MDChgProcessSourceModified = '' then 'N'
        when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified ) as MDChgProcKPIUpdateStatus,


      _RecordType,
      _KPIUpdateStatusText,
      _RecordMessages,

      /* Associations */
      _BPRatingProcedure,
      _BPRatingProcedureGrade,
      _BusinessPartner,
      _BPFinServicesDetail
}

Learn More