I_MDQltyBPCustCoCodeResult

DDL: I_MDQLTYBPCUSTCOCODERESULT SQL: CMDQBPCUSTCORES Type: view BASIC

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 13 fields with key fields BusinessPartner, Customer, CompanyCode, MDQualityBusinessRuleUUID, MDQltyBusRuleEvalResultCode. It has 3 associations to related views.

2 data source(s) 13 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 (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner partner
KEY Customer
KEY CompanyCode knb1_dq_res bukrs
KEY MDQualityBusinessRuleUUID ruleuuid
KEY MDQltyBusRuleEvalResultCode resulttype
KEY MasterDataChangeProcess knb1_dq_res process_id
BPAssignmentID assignment_id
AddressNumber _MultipleAssignment AddressNumber
MDQltyNmbrOfBusRuleEvalResults result_count
clientNULLasMDChgProcessFinishDateTime
MDQltyBusinessRuleBaseTable basetable
_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

  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  partner                                                                                           as   BusinessPartner,
  key  cast(_MultipleAssignment.BPObjectID as kunnr)                                                     as   Customer,  
  key  knb1_dq_res.bukrs                                                                                 as   CompanyCode,
  key  ruleuuid                                                                                          as   MDQualityBusinessRuleUUID,
       @ObjectModel.foreignKey.association: '_MDQltyBusRuleEvalResult'
       @ObjectModel.text.association: '_MDQltyBusRuleEvalResultText'
  key  resulttype                                                                                        as   MDQltyBusRuleEvalResultCode,
  key  knb1_dq_res.process_id                                                                            as   MasterDataChangeProcess,

  assignment_id                                                                                          as   BPAssignmentID,
  _MultipleAssignment.AddressNumber                                                                      as   AddressNumber,
  
       //  attributes

       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,
       basetable as MDQltyBusinessRuleBaseTable,
       // associations

       _MDQltyBusRuleEvalResult,
       _MDQltyBusRuleEvalResultText      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPMULTIPLEASSIGNMENT",
"KNB1_DQ_RES",
"MDC_D_PRCROOT"
],
"ASSOCIATED":
[
"I_BPMULTIPLEASSIGNMENT",
"I_MDQLTYBUSRULEEVALRESULT",
"I_MDQLTYBUSRULEEVALRESULTTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More