SAP Table BUTADRSEARCH
Mass Search Help: Business Partner
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table BUTADRSEARCH (Mass Search Help: Business Partner) is a standard table in SAP ERP. It belongs to the package BUPA.
Technical Information
| Table | BUTADRSEARCH |
| Short Text | Mass Search Help: Business Partner |
| Package | BUPA |
| Table Type | Transparent Table |
Fields for Table BUTADRSEARCH
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | ✔ | Client | MANDT | CLNT | 3 | * |
| PARTNER | ✔ | Business Partner Number | BU_PARTNER | CHAR | 10 | * |
| ADDRNUMBER | ✔ | Address number | AD_ADDRNUM | CHAR | 10 | * |
| MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | ||
| MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | ||
| BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | ||
| BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | ||
| BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | ||
| AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | TB037 | |
| XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | ||
| XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | ||
| TYPE | Business partner category | BU_TYPE | CHAR | 1 | ||
| Include Structure: BUTSEARCH_ADR | ||||||
| MC_CITY1 | City name in upper case for search help | AD_MC_CITY | CHAR | 25 | ||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | ||
| MC_STREET | Street name in upper case for search help | AD_MC_STRT | CHAR | 25 | ||
| HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | ||
| COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | |
| ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | ||
| ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | ||
| CITY2 | District | AD_CITY2 | CHAR | 40 | ||
| MC_COUNTY | County name in upper case for search help | AD_MC_COUNTY | CHAR | 25 | ||
| MC_TOWNSHIP | Township name in upper case for search help | AD_MC_TWSHP | CHAR | 25 | ||
| PHONSTRING | Phonetic Search Term | BP_PHONSTRING | CHAR | 80 | ||
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | ||