SAP Table BUTADRSEARCH
Mass Search Help: Business Partner
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
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 | ||