BUTADRSEARCH

Mass Search Help: Business Partner | #masterdata | Component: Business Partner Foundation
Column Name Description
CLIENT Client
PARTNER Business Partner Number
ADDRNUMBER Address Number
Column Name Description
Column Name Description
Column Name Description
BIRTHDT Date of Birth of Business Partner
Column Name Description
XDELE Central Archiving Flag Show values
XBLCK Central Block for Business Partner Show values
TYPE Business Partner Category Show values
Column Name Description Domain name
MC_NAME1 Search Help Field 1 (Name 1/Last Name) CHAR35
MC_NAME2 Search Help Field 2 (Name 2/First Name) CHAR35
BU_SORT1 Search Term 1 for Business Partner BU_SORT1
BU_SORT2 Search Term 2 for Business Partner BU_SORT1
MC_CITY1 City name in Uppercase for Search Help CHAR25
POST_CODE1 City postal code CHAR10
MC_STREET Street Name in Uppercase for Search Help CHAR25
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
BUILDING Building (Number or Code) TEXT20
FLOOR Floor in building TEXT10
ROOMNUMBER Room or Apartment Number TEXT10
ADDR_VALID_FROM Validity Start of a Business Partner Address TZNTSTMPS
ADDR_VALID_TO Validity End of a Business Partner Address TZNTSTMPS
CITY2 District TEXT40
MC_COUNTY County name in upper case for search help CHAR25
MC_TOWNSHIP Township name in upper case for search help CHAR25
PHONSTRING Phonetic Search Term CHAR80
PARTNER_GUID Business Partner GUID SYSUUID
BUTADR_DUMMY Dummy function in length 1 DUMMY
Master Data Relations Join Conditions
Authorization Group
  • Authorization Group
  • ?
  • BUTADRSEARCH.CLIENT == TB037.CLIENT
  • BUTADRSEARCH.AUGRP == TB037.AUGRP
  • BUTADRSEARCH.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Country/Region Key
  • Country/Region Key
  • Client
  • BUTADRSEARCH.COUNTRY == T005.LAND1
  • BUTADRSEARCH.CLIENT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • BUTADRSEARCH.CLIENT == T005S.MANDT
  • BUTADRSEARCH.COUNTRY == T005S.LAND1
  • BUTADRSEARCH.REGION == T005S.BLAND