I_MDQltyBusinessPartner

MDQuality for Business Partner | view: IMDQBUPA | TRAN | Extraction: Not supported | Component: Analysis and Remediation of Data Quality.
Tables used: BUT020, BUT021_FS, BUT000, BUT100, BUT021_FS, TB008S, TB008U
Column Name Description
BusinessPartner Business Partner Number
BusinessPartnerRole FK BP Role
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the object was created
CreationTime Time at which the object was created
LastChangeDate Date when object was last changed
LastChangeTime Time at which object was last changed
OrganizationFoundationDate Date organization founded
OrganizationLiquidationDate Liquidation date of organization
BirthDate Date of Birth of Business Partner
BusinessPartnerDeathDate Date of death of business partner
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
BusinessPartnerIsBlocked Central Block for Business Partner Show values
IsMarkedForArchiving Central Archiving Flag Show values
BusinessPartnerIsNotReleased Indicator: Not Released Show values
ContactPermission Business Partner: Contact Permission Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
BusinessPartnerPrintFormat Business Partner Print Format Show values
BusPartPersonDataIsHidden Truth Value: True/False Show values
BusPartOrgDataIsHidden Truth Value: True/False Show values
BusPartGroupDataIsHidden Truth Value: True/False Show values
BusPartAddrLanguageIsHidden Truth Value: True/False Show values
IsFemale Selection: Business partner is female Show values
IsMale Selection: Business partner is male Show values
IsSexUnknown Selection: Sex of business partner is not known Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
BusinessPartnerBirthDateStatus Date of Birth: Status Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
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
ETag null
Name Name 1 of organization BU_NAME
AdditionalName Name 2 of organization BU_NAME
FullName null
BusinessPartnerName null
PersonNumber Person Number AD_PERSNUM
GenderCodeName Sex of business partner (person) BU_SEXID
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
BusinessPartnerBirthName Name at birth of business partner BU_NAME
MiddleName Middle name or second forename of a person BU_NAME
PersonFullName Full Name TEXT80
BusinessPartnerNicknameLabel Nickname of Business Partner (Person) BU_NAME
Initials "Middle Initial" or personal initials CHAR10
NaturalPersonEmployerName Name of Employer of a Natural Person BU_EMPLO
BusinessPartnerBirthplaceName Birthplace of business partner TEXT40
BusinessPartnerIDByExtSystem Business Partner Number in External System CHAR20
BusinessPartnerSalutation Salutation TEXT50
GroupBusinessPartnerName1 Name 1 (group) BU_NAME
GroupBusinessPartnerName2 Name 2 (group) BU_NAME
SearchTerm1 Search Term 1 for Business Partner BU_SORT1
SearchTerm2 Search Term 2 for Business Partner BU_SORT1
BPFirstNameSearchHelp Search Help Field 2 (Name 2/First Name) CHAR35
BPLastNameSearchHelp Search Help Field 1 (Name 1/Last Name) CHAR35
Master Data Relations Join Conditions
Academic Title: Key
  • Academic Title: Key
  • Client
  • I_MDQLTYBUSINESSPARTNER.ACADEMICTITLE == TSAD2.TITLE_KEY
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD2.CLIENT
Second academic title (key)
  • Second academic title (key)
  • Client
  • I_MDQLTYBUSINESSPARTNER.ACADEMICTITLE2 == TSAD2.TITLE_KEY
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD2.CLIENT
Address Number
  • ?
  • ?
  • Address Number
  • Client
  • I_MDQLTYBUSINESSPARTNER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_MDQLTYBUSINESSPARTNER.[column in domain "AD_NATION"] == ADRC.NATION
  • I_MDQLTYBUSINESSPARTNER.ADDRESSID == ADRC.ADDRNUMBER
  • I_MDQLTYBUSINESSPARTNER.MANDT == ADRC.CLIENT
Authorization Group
  • Authorization Group
  • ?
  • Client
  • I_MDQLTYBUSINESSPARTNER.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_MDQLTYBUSINESSPARTNER.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB037.CLIENT
Business Partner Grouping
  • Business Partner Grouping
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB001.MANDT
Group type
  • Client
  • Group type
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB025.CLIENT
  • I_MDQLTYBUSINESSPARTNER.BUSINESSPARTNERGROUPTYPE == TB025.PARTGRPTYP
Occupation/group
  • Occupation/group
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSINESSPARTNEROCCUPATION == TB028.JOBGR
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB028.CLIENT
BP Role
  • BP Role
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSINESSPARTNERROLE == TB003.ROLE
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB003.CLIENT
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSINESSPARTNERSUPPLEMENTNAME == TSAD5.TITLE_KEY
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD5.CLIENT
Business Partner Type
  • Business Partner Type
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSINESSPARTNERTYPE == TB004.BPKIND
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB004.CLIENT
Marital Status of Business Partner
  • Marital Status of Business Partner
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSPARTMARITALSTATUS == TB027.MARST
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB027.CLIENT
Nationality
  • Nationality
  • Client
  • I_MDQLTYBUSINESSPARTNER.BUSPARTNATIONALITY == T005.LAND1
  • I_MDQLTYBUSINESSPARTNER.MANDT == T005.MANDT
Correspondence Language I_MDQLTYBUSINESSPARTNER.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSORGANIZATION == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSPERSON == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESS == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSGROUP == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD3.CLIENT
Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSORGANIZATION == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSPERSON == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESS == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSGROUP == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD3.CLIENT
Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSORGANIZATION == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSPERSON == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESS == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSGROUP == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD3.CLIENT
Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSORGANIZATION == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSPERSON == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESS == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.FORMOFADDRESSGROUP == TSAD3.TITLE
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD3.CLIENT
Language I_MDQLTYBUSINESSPARTNER.LANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • I_MDQLTYBUSINESSPARTNER.LASTNAMEPREFIX == TSAD4.PREFIX_KEY
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • I_MDQLTYBUSINESSPARTNER.LASTNAMESECONDPREFIX == TSAD4.PREFIX_KEY
  • I_MDQLTYBUSINESSPARTNER.MANDT == TSAD4.CLIENT
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • I_MDQLTYBUSINESSPARTNER.LEGALFORM == TB019.LEGAL_ENTY
  • I_MDQLTYBUSINESSPARTNER.MANDT == TB019.CLIENT
Country/Region for Name Format Rule
  • Country/Region for Name Format Rule
  • Client
  • I_MDQLTYBUSINESSPARTNER.NAMECOUNTRY == T005.LAND1
  • I_MDQLTYBUSINESSPARTNER.MANDT == T005.MANDT
Country/Region of Origin: Non-Resident Companies
  • Client
  • Country/Region of Origin: Non-Resident Companies
  • I_MDQLTYBUSINESSPARTNER.MANDT == T005.MANDT
  • I_MDQLTYBUSINESSPARTNER.NONRESIDENTCOMPANYORIGINCNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Country/Region for Name Format Rule
  • Name format
  • Client
  • I_MDQLTYBUSINESSPARTNER.NAMECOUNTRY == T005N.LAND1
  • I_MDQLTYBUSINESSPARTNER.NAMEFORMAT == T005N.NAMEFORMAT
  • I_MDQLTYBUSINESSPARTNER.MANDT == T005N.MANDT