C_MDQltyBPCustCoCodeResult

Customer Company Code Rule Results | view: CMDQBPCUSTCORSLT | Extraction: Not supported | Component: Analysis and Remediation of Data Quality.
Tables used: MDC_D_PRCROOT, MDQ_RULE_DEF_D, T052U, TSAD2T, ADCP, ADRC, ADR6, ADR3, ADR2, BUT020, BUT021_FS, MDG_MLT_ASSGMNT, BUT000, TB002, TB003, BUT100, T004T, T001, TKA02, T005, T005T, KNA1, T077X, TKUKL, TKUKT, KNB1, KNB5, CVI_CUST_LINK, KNB1_DQ_RES, MDQ_BUSRUL_USG, MDQ_EVALDETAIL, MDQ_SCORERULERES, MDQ_RULE_MDG_INT, MDQ_RLMSG_ASSG, MDQ_DIM_R_ASSG, MDQ_RES_RECORDS, MDQ_MNDRUL_LNK, MDC_MODEL_TABLES, MDC_MODEL_TABLET, MDQ_RULE_DEF, MDQ_BRF_RULE_MAP, MDQ_BRF_RULE_USG, MDQ_RULEUSAGE, CVI_VEND_LINK, USR21, TB008S, TB008U, SKAT, T004, BPU_ROLECAT_WHL
Column Name Description
BusinessPartner Business Partner Number
Customer Customer Number
CompanyCode Company Code
MasterDataChangeProcess Master Data Change Process Identifier
MDQualityBusinessRuleUUID MDQ Rule Definition UUID
MDQltyBusRuleEvalResultCode Master Data Quality Rule Evaluation Result Type
Column Name Description
Column Name Description
Column Name Description
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
MDQltyBusinessObjectTypeCode Business Object Type MDG_OBJECT_TYPE_CODE_BS
MDQltyNmbrOfBusRuleEvalResults Master Data Quality Counter Total Records
MDQualityBusinessRule Master Data Quality Rule Definition ID MDQ_RULE_DEFINITION_ID
MDQltyBusinessRuleBaseTable Master Data Quality Base Table AS4TAB
MDQltyTechnicalRuleScopeUUID Master Data Quality: UUID for BRFplus
MDQltyTechnicalRuleCndnUUID Master Data Quality: UUID for BRFplus
MDQltyMDGovBRFPlusObjectUUID Master Data Quality: UUID for BRFplus
MDChgProcessFinishDateTime Master Data Quality Evaluation Finished Date & Time TZNTSTMPL
BusinessPartnerForEdit Business Partner Number BU_PARTNER
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
OrganizationBPName1 Name 1 of organization BU_NAME
OrganizationBPName2 Name 2 of organization BU_NAME
OrganizationBPName3 Name 3 of organization BU_NAME
OrganizationBPName4 Name 4 of organization BU_NAME
CustomerAuthznGrp Authorization Group BRGRU
CustomerCorporateGroup Group key KONZS
PostalCode Postal Code PSTLZ
CityName City TEXT35
PaymentTerms Terms of payment key ZTERM
PhysicalInventoryBlockInd Posting block for company code
DeletionIndicator Deletion Flag for Master Record (Company Code Level)
AuthorizationGroup Authorization Group BRGRU
MDQualityBusinessRuleName Master Data Quality Rule Definition Name MDQ_RULE_DEFINITION_NAME
FullName null
CompanyCodeName Name of Company Code or Company TEXT25
GLAccountLongName G/L Account Long Text TEXT50
PaymentTermsName Character 1024 CHARA1024
CustomerClassificationDesc Customer Classification Description TEXT20
AccountGroupName Account Group Name TEXT30
CountryName Country/Region Name TEXT50
BusinessPartnerGroupingText Description BU_TEXT40
BusinessPartnerCategoryText Short Text for Fixed Values DDTEXT
MDQltyBusinessRuleBaseTabName Alias of a table MDC_TABLE_ALIAS
MDQltyBusRuleCheckedFieldTable Maste Data Quality Table Name of Checked Field AS4TAB
MDQltyBusRuleCheckedField Master Data Quality Fieldname of the Checked Field FDNAME
MDQltyBusRuleChkdFieldAndTable Master Data Quality Table and Field Name of Checked Field MDQ_CHKFLD_TABANDFIELDNAME
Master Data Relations Join Conditions
Authorization Group
  • ?
  • Authorization Group
  • Client
  • C_MDQLTYBPCUSTCOCODERESULT.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_MDQLTYBPCUSTCOCODERESULT.AUTHORIZATIONGROUPOBJECT == TB037.AUGRP
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == TB037.CLIENT
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == TB001.MANDT
  • C_MDQLTYBPCUSTCOCODERESULT.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
Country/Region Key
  • Country/Region Key
  • Client
  • C_MDQLTYBPCUSTCOCODERESULT.COUNTRY == T005.LAND1
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == T005.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_MDQLTYBPCUSTCOCODERESULT.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • C_MDQLTYBPCUSTCOCODERESULT.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == TKUKL.MANDT
Nielsen ID
  • Client
  • Nielsen ID
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == TNLS.MANDT
  • C_MDQLTYBPCUSTCOCODERESULT.NIELSENREGION == TNLS.NIELS
Central order block for customer
  • ?
  • Central order block for customer
  • Client
  • C_MDQLTYBPCUSTCOCODERESULT.[column in domain "SPRAS"] == TVAST.SPRAS
  • C_MDQLTYBPCUSTCOCODERESULT.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == TVAST.MANDT
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Company Code
  • Client
  • C_MDQLTYBPCUSTCOCODERESULT.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • C_MDQLTYBPCUSTCOCODERESULT.COMPANYCODE == SKB1.BUKRS
  • C_MDQLTYBPCUSTCOCODERESULT.MANDT == SKB1.MANDT