SAP ABAP Table BUTADRSEARCH (Mass Search Help: Business Partner)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-BP (Application Component) Business Partner Foundation
     ⤷ S_BUPA_GENERAL (Package) SAP Business Partner: Basic Components

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BUTADRSEARCH	Table Relationship Diagram
Short Description	Mass Search Help: Business Partner

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	ADDRNUMBER	☑	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
4	.INCLUDE	☐				0	0	Include Structure for BUT000 Part of Table BUTADRSEARCH
5	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
6	MC_NAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
7	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
8	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
9	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
10	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
11	XDELE	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
12	XBLCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
13	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
14	.INCLUDE	☐				0	0	Include Structure for ADRC Part of Table BUTADRSEARCH
15	MC_CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
16	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
17	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
18	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
19	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
20	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
21	ADDR_VALID_FROM	☐	BU_ADDR_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of a Business Partner Address
22	ADDR_VALID_TO	☐	BU_ADDR_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of a Business Partner Address
23	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
24	MC_COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
25	MC_TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
26	PHONSTRING	☐	BP_PHONSTRING	CHAR80	CHAR	80	0	Phonetic Search Term
27	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
28	.INCLU--AP	☐				0	0	append structure for BUTADRSEARCH
29	.INCLUDE	☐				0	0	EEW Extension for BUTADRSEARCH
30	BUTADR_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BUTADRSEARCH	AUGRP	TB037	AUGRP	REF	1	CN
2	BUTADRSEARCH	COUNTRY	T005	LAND1	REF	1	CN
3	BUTADRSEARCH	REGION	T005S	BLAND	REF	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	640