/dmbe/i_BusinessPartner_Search

Business Partner | view: /DMBE/IBUSPARTSE | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: BUT000
Column Name Description
BusinessPartner Business Partner Number
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
Column Name Description
BusinessPartnerCategory Business Partner Category Show values
isBusinessPartnerBlocked Business Purpose Completed Flag Show values
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws 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
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
PersonNumber Person Number AD_PERSNUM
BusinessPartnerName null
fullName First name of business partner (person) BU_NAME
fullName2 Last name of business partner (person) BU_NAME
fullNameOrg Name 1 of organization BU_NAME
fullNameOrg2 Name 2 of organization BU_NAME
fullNameGroup Name 1 (group) BU_NAME
fullNameGroup2 Name 2 (group) BU_NAME
BusinessPartnerFullName null
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
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
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
MiddleName Middle name or second forename of a person BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
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
IndependentAddressID Address Number AD_ADDRNUM
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == TSAD2.CLIENT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.ACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • Client
  • ?
  • Authorization Group
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == TB037.CLIENT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • /DMBE/I_BUSINESSPARTNER_SEARCH.AUTHORIZATIONGROUP == TB037.AUGRP
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == TB001.MANDT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
Business Partner Type
  • Client
  • Business Partner Type
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == TB004.CLIENT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.BUSINESSPARTNERTYPE == TB004.BPKIND
Correspondence Language /DMBE/I_BUSINESSPARTNER_SEARCH.CORRESPONDENCELANGUAGE == T002.SPRAS
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == TSAD3.CLIENT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.FORMOFADDRESS == TSAD3.TITLE
Language /DMBE/I_BUSINESSPARTNER_SEARCH.LANGUAGE == T002.SPRAS
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • /DMBE/I_BUSINESSPARTNER_SEARCH.LEGALFORM == TB019.LEGAL_ENTY
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == TB019.CLIENT
Country/Region for Name Format Rule
  • Client
  • Country/Region for Name Format Rule
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == T005.MANDT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.NAMECOUNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Client
  • Name format
  • Country/Region for Name Format Rule
  • /DMBE/I_BUSINESSPARTNER_SEARCH.MANDT == T005N.MANDT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.NAMEFORMAT == T005N.NAMEFORMAT
  • /DMBE/I_BUSINESSPARTNER_SEARCH.NAMECOUNTRY == T005N.LAND1