BUTADRSEARCH is a standard Use AP-MD-BP* Components Transparent Table in SAP Basis application, which stores Mass Search Help: Business Partner data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BUTADRSEARCH. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

BUTADRSEARCH — Meta Data

Description: Mass Search Help: Business Partner
Main Category: Basis
Sub Category: Use AP-MD-BP* Components
Table type: Transparent Table (TRANSP)

BUTADRSEARCH — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 CLIENT Client X CLNT 3 *
    2 PARTNER Partner vendor X CHAR 10 *
    3 ADDRNUMBER Address number X CHAR 10 *
    4 .INCLUDE 0
    5 MC_NAME1 Matchcode field 1 (name 1/last name) CHAR 35
    6 MC_NAME2 Matchcode field 2 (name2/first name) CHAR 35
    7 BU_SORT1 Search term 1 for business partner CHAR 20
    8 BU_SORT2 Search term 2 for business partner CHAR 20
    9 BIRTHDT Date of Birth of Business Partner DATS 8
    10 AUGRP Business Partner Authorization Group CHAR 4 TB037
    11 XDELE Central Archiving Flag CHAR 1
    12 XBLCK Central Block for Business Partner CHAR 1
    13 TYPE Message type: S Success CHAR 1
    14 .INCLUDE 0
    15 MC_CITY1 City name in Uppercase for Search Help CHAR 25
    16 POST_CODE1 City postal code CHAR 10
    17 MC_STREET Street Name in Uppercase for Search Help CHAR 25
    18 HOUSE_NUM1 House Number CHAR 10
    19 HOUSE_NUM2 House number supplement CHAR 10
    20 BUILDING Building Number CHAR 20
    21 FLOOR Floor in Building CHAR 10
    22 ROOMNUMBER Apartment or Room Number CHAR 10
    23 COUNTRY Country CHAR 3 T005
    24 REGION Region CHAR 3 T005S
    25 ADDR_VALID_FROM Validity Start of a Business Partner Address DEC 15
    26 ADDR_VALID_TO Validity End of a Business Partner Address DEC 15
    27 CITY2 District CHAR 40
    28 MC_COUNTY County name in upper case for search help CHAR 25
    29 MC_TOWNSHIP Township name in upper case for search help CHAR 25
    30 PHONSTRING Phonetic Search Term CHAR 80
    31 PARTNER_GUID Business Partner GUID RAW 16

SAP Help, Wiki Resources, and Forum Discussions on BUTADRSEARCH

  • Extention of table BUTADRSEARCH

    we use the matchcode table BUTADRSEARCH for the business partner search due to performance reasons.

    https://answers.sap.com/message/14561007


Related Tables

TABLE Description Functional Area
BUT000 BP: General data I Basis - Use AP-MD-BP* Components
BUT100 BP: Roles Basis - Use AP-MD-BP* Components
BUT0BK BP: Bank Details Basis - Use AP-MD-BP* Components
BUT0IS BP: Industries Basis - Use AP-MD-BP* Components
BUT050_CD BP Rel./Role Determination:Index Table for Change Doc.Access Basis - Use AP-MD-BP* Components
BUT030T BP Object Usage: Application Table, Texts App. Platform - SAP Business Partner
BUT010 GP: old, do not use ==> BUT020 App. Platform - SAP Business Partner

Transaction Codes for SAP Table BUTADRSEARCH

TCODE Description Functional Area
BCA_US_OD_PLAN Maintain Overdraft Plan IS - Bank Customer Accounts
SM59 RFC Destinations (Display/Maintain) Basis - RFC
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
OPS Customizing for Project System PS - Project System
CATP CATS: Cross-Application Time CA - Arbeitszeitblatt
SE38 ABAP Editor Basis - ABAP Editor
CD IMG for FS-CD FS - Collections/Disbursements
SM13 Administrate Update Records Basis - Client/Server Technology

FMs for SAP Table BUTADRSEARCH

FM Description Functional Area
MEREP_DELTABO Delta BO (T51 Delta BO Receiver) Basis - SAP NetWeaver Mobile - Use subcomponents

ABAP Reports for SAP Table BUTADRSEARCH

ABAP REPORT Description Functional Area
ALSYSAL Program for Object Type SYSALERT: System Alert Basis - Monitoring
DSIG_BOOKING_EX Report DSIG_BOOKING_EX Cross Application - Digital Signature
RADDBDIF Control Program for Processing the DBDIFF Basis - Activation Program, Conversion Program, DB Utility, MC, SPDD
BDLIBUS Tool to maintain IBU entries Service - Service Data Download
SAPMH5A0 Module Pool for PD Transactions Basis - Organizational Management
J_1BLB09 Registro de Apura
J_1BLB08 Registro de Apura
RPUBTCU0 BSI Tax Calculation Test Program Payroll - BSI

Authorization Objects for SAP Table BUTADRSEARCH

AUTHORIZATION OBJECT Description Functional Area
CMS_CAG Authorization object for CAG
CMS_RBL Authorization object for receivable in CMS
CRM_CATT Authorization for CRM eCATT Based Unit Testing
ECM_VAL Change Management: Validity
J_1ITDS Authorization object for TDS transaction J1IN
J_1IRG23D Authorisation object for Depo Transactions
ECM_ORD Change Management: Change Order
J_1IEWT_HC health check for Migration to EWT

Most searched SAP Basis Components Tables