BUTADRSEARCH - Mass Search Help: Business Partner
Mass Search Help: Business Partner information is stored in SAP table BUTADRSEARCH.
It is part of development package S_BUPA_GENERAL in software component BC-SRV-BP. This development package consists of objects that can be grouped under "SAP Business Partner: Basic Components".
It is part of development package S_BUPA_GENERAL in software component BC-SRV-BP. This development package consists of objects that can be grouped under "SAP Business Partner: Basic Components".
Fields for table BUTADRSEARCH
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| PARTNER | Business Partner Number | X | BU_PARTNER | CHAR | 20 | |
| ADDRNUMBER | Address Number | X | AD_ADDRNUM | CHAR | 20 | |
| .INCLUDE | BUTSEARCH_BUT | 0 | ||||
| MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 70 | ||
| MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 70 | ||
| BU_SORT1 | Search Term 1 for Business Partner | BU_SORT1 | CHAR | 40 | ||
| BU_SORT2 | Search Term 2 for Business Partner | BU_SORT2 | CHAR | 40 | ||
| BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 16 | ||
| AUGRP | Authorization Group | BU_AUGRP | CHAR | 8 | TB037 | |
| XDELE | Central Archiving Flag | BU_XDELE | CHAR | 2 | ||
| XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 2 | ||
| TYPE | Business Partner Category | BU_TYPE | CHAR | 2 | ||
| .INCLUDE | BUTSEARCH_ADR | 0 | ||||
| MC_CITY1 | City name in Uppercase for Search Help | AD_MC_CITY | CHAR | 50 | ||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 20 | ||
| MC_STREET | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR | 50 | ||
| HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 20 | ||
| HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 20 | ||
| BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 40 | ||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 20 | ||
| ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | CHAR | 20 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | T005 | |
| REGION | Region (State, Province, County) | REGIO | CHAR | 6 | T005S | |
| ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 8 | ||
| ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 8 | ||
| CITY2 | District | AD_CITY2 | CHAR | 80 | ||
| MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR | 50 | ||
| MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | CHAR | 50 | ||
| PHONSTRING | Phonetic Search Term | BP_PHONSTRING | CHAR | 160 | ||
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | ||
| .INCLU--AP | CRMS_BUTADRSEARCH_APPEND | 0 | ||||
| .INCLUDE | ADR | INCL_EEW_BUTADRSEARCH | 0 | |||
| BUTADR_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 2 |