I_MDQltyBPCustCoCodeResult

DDL: I_MDQLTYBPCUSTCOCODERESULT SQL: CMDQBPCUSTCORES Type: view BASIC Package: MDQ_RULEMGMT_BUPA_EVAL

Customer Company Code Rule Results

I_MDQltyBPCustCoCodeResult is a Basic CDS View that provides data about "Customer Company Code Rule Results" in SAP S/4HANA. It reads from 2 data sources (mdc_d_prcroot, knb1_dq_res) and exposes 14 fields with key fields BusinessPartner, Customer, CompanyCode, MDQualityBusinessRuleUUID, MDQltyBusRuleEvalResultCode. It has 3 associations to related views. Part of development package MDQ_RULEMGMT_BUPA_EVAL.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
mdc_d_prcroot _MasterDataChangeProcess inner
knb1_dq_res knb1_dq_res from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MDQltyBusRuleEvalResult _MDQltyBusRuleEvalResult _MDQltyBusRuleEvalResult.MDQltyBusRuleEvalResultCode = $projection.MDQltyBusRuleEvalResultCode
[0..*] I_MDQltyBusRuleEvalResultText _MDQltyBusRuleEvalResultText _MDQltyBusRuleEvalResultText.MDQltyBusRuleEvalResultCode = $projection.MDQltyBusRuleEvalResultCode
[0..1] I_BPMultipleAssignment _MultipleAssignment _MultipleAssignment.BusinessPartner = $projection.BusinessPartner and _MultipleAssignment.BPAssignmentID = $projection.BPAssignmentID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMDQBPCUSTCORES view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer Company Code Rule Results view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey MasterDataChangeProcess view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner knb1_dq_res partner
KEY Customer
KEY CompanyCode knb1_dq_res bukrs
KEY MDQualityBusinessRuleUUID knb1_dq_res ruleuuid
KEY MDQltyBusRuleEvalResultCode knb1_dq_res resulttype
KEY MasterDataChangeProcess knb1_dq_res process_id
BPAssignmentID knb1_dq_res assignment_id
AddressNumber _MultipleAssignment AddressNumber
MDQltyNmbrOfBusRuleEvalResults knb1_dq_res result_count
clientNULLasMDChgProcessFinishDateTime
MDQltyBusinessRuleBaseTable knb1_dq_res basetable
MDQltyBusinessObjectTypeCode mdc_d_prcroot source_otc
_MDQltyBusRuleEvalResult _MDQltyBusRuleEvalResult
_MDQltyBusRuleEvalResultText _MDQltyBusRuleEvalResultText 
@AbapCatalog.sqlViewName: 'CMDQBPCUSTCORES'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customer Company Code Rule Results'
@ObjectModel.usageType: { sizeCategory: #L, dataClass: #MIXED, serviceQuality: #C }
@ObjectModel.representativeKey: 'MasterDataChangeProcess'
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking
@AbapCatalog.preserveKey:true

define view I_MDQltyBPCustCoCodeResult
  as select from knb1_dq_res
    inner join   mdc_d_prcroot as _MasterDataChangeProcess on  knb1_dq_res.process_id        = _MasterDataChangeProcess.id
                                                           and _MasterDataChangeProcess.goal = 'Q'

  association [0..1] to I_MDQltyBusRuleEvalResult     as _MDQltyBusRuleEvalResult     on  _MDQltyBusRuleEvalResult.MDQltyBusRuleEvalResultCode = $projection.MDQltyBusRuleEvalResultCode
  association [0..*] to I_MDQltyBusRuleEvalResultText as _MDQltyBusRuleEvalResultText on  _MDQltyBusRuleEvalResultText.MDQltyBusRuleEvalResultCode = $projection.MDQltyBusRuleEvalResultCode
  association [0..1] to I_BPMultipleAssignment        as _MultipleAssignment          on  _MultipleAssignment.BusinessPartner = $projection.BusinessPartner
                                                                                      and _MultipleAssignment.BPAssignmentID  = $projection.BPAssignmentID

{
       //  keys

  key  knb1_dq_res.partner                           as BusinessPartner,
  key  cast(_MultipleAssignment.BPObjectID as kunnr) as Customer,
  key  knb1_dq_res.bukrs                             as CompanyCode,
  key  knb1_dq_res.ruleuuid                          as MDQualityBusinessRuleUUID,
       @ObjectModel.foreignKey.association: '_MDQltyBusRuleEvalResult'
       @ObjectModel.text.association: '_MDQltyBusRuleEvalResultText'
  key  knb1_dq_res.resulttype                        as MDQltyBusRuleEvalResultCode,
  key  knb1_dq_res.process_id                        as MasterDataChangeProcess,

       knb1_dq_res.assignment_id                     as BPAssignmentID,
       _MultipleAssignment.AddressNumber             as AddressNumber,

       //  attributes

       knb1_dq_res.result_count                      as MDQltyNmbrOfBusRuleEvalResults,
       dats_tims_to_tstmp( _MasterDataChangeProcess.finish_date,
                           _MasterDataChangeProcess.finish_time,
                            abap_system_timezone( $session.client,'NULL' ),
                            $session.client,
                           'NULL' )                  as MDChgProcessFinishDateTime,
       knb1_dq_res.basetable                         as MDQltyBusinessRuleBaseTable,
       _MasterDataChangeProcess.source_otc           as MDQltyBusinessObjectTypeCode,

       // associations

       _MDQltyBusRuleEvalResult,
       _MDQltyBusRuleEvalResultText
}

Learn More