SAP ABAP Table VBUTADRSEARCH (Update Structure for Table BUTADRSEARCH)

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	INTTAB	Structure
Structure	VBUTADRSEARCH	Table Relationship Diagram
Short Description	Update Structure for Table BUTADRSEARCH

Delivery and Maintenance

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

Foreign Keys

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

History

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