SAP ABAP Table BUS000SEARCH (Structure for New Search Help 'Partner Acc. to Address')

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ AP-MD-BP (Application Component) SAP Business Partner
     ⤷ BUPA (Package) SAP Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	BUS000SEARCH	Table Relationship Diagram
Short Description	Structure for New Search Help 'Partner Acc. to Address'

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	BP: General data I
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - External)
5	.INCLUDE	☐				0	0	CBP: General data (independent of partner cat.)
6	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Initial Screen
7	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
8	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	TB004
9	BU_GROUP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
10	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
11	.INCLUDE	☐				0	0	CBP: General Data (not dep. on Part. Cat.), Data Screens
12	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
13	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
14	SOURCE	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	TB005
15	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
16	XDELE	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
17	XBLCK	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
18	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	TB037
19	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
20	BU_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
21	CONTACT	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
22	NOT_RELEASED	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
23	NOT_LG_COMPETENT	☐	BU_NOT_LEG_COMPETENT	BOOLE	CHAR	1	0	Indicator: Not Legally Competent
24	PRINT_MODE	☐	BU_PRINT_MODE	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
25	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
26	BP_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
27	.INCLUDE	☐				0	0
28	.INCLUDE	☐				0	0	CBP: General data (Organization)
29	.INCLUDE	☐				0	0	CBP: General Data, Organization (CHAR Fields)
30	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
31	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
32	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
33	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
34	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	TB019
35	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
36	LEGAL_ORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
37	.INCLUDE	☐				0	0	CBP: General Data, Organization (Non CHAR Fields)
38	FOUND_DAT	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
39	LIQUID_DAT	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
40	LOCATION_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
41	LOCATION_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
42	LOCATION_3	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
43	.INCLUDE	☐				0	0	CBP: General Data, Person
44	.INCLUDE	☐				0	0	CBP: General Data, Person (CHAR Fields)
45	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
46	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
47	NAME_LST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
48	NAME_LAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
49	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
50	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
51	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
52	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
53	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
54	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
55	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
56	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
57	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
58	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
59	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
60	LANGU_CORR	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	T002
61	XSEXM	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
62	XSEXF	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
63	BIRTHPL	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
64	MARST	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	TB027
65	EMPLO	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
66	JOBGR	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	TB028
67	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	T005
68	CNTAX	☐	BU_CNTAX	LAND1	CHAR	3	0	Obsolete Field	*
69	CNDSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	T005
70	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
71	XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
72	XUBNAME	☐	BU_XUBNAME	XUBNAME	CHAR	12	0	Obsolete Field	USR02
73	BU_LANGU	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	T002
74	.INCLUDE	☐				0	0	CBP: General Data, Person (Non CHAR Fields)
75	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
76	DEATHDT	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
77	PERNO	☐	BU_PERNO	PERSONID	NUMC	8	0	Personnel Number
78	CHILDREN	☐	BU_CHILDREN	NUMC2	NUMC	2	0	Obsolete Field
79	MEM_HOUSE	☐	BU_MEM_HOUSE	DEC2	DEC	2	0	Obsolete Field
80	.INCLUDE	☐				0	0	CBP: General data (group of people)
81	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	TB025
82	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
83	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
84	.INCLUDE	☐				0	0	BP: General Data I (Data Fields - Internal)
85	.INCLUDE	☐				0	0	CBP: Internal general data (not dependent on partner cat.)
86	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
87	MC_NAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
88	CRUSR	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
89	CRDAT	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
90	CRTIM	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
91	CHUSR	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
92	CHDAT	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
93	CHTIM	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed
94	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
95	ADDRCOMM	☐	BU_ADDRCOMM	AD_ADDRNUM	CHAR	10	0	Address Number	*
96	TD_SWITCH	☐	BU_TD_SWITCH	CHAR1	CHAR	1	0	Planned Change Documents for Partner Were Converted
97	IS_ORG_CENTRE	☐	BU_IS_ORG_CENTRE	BU_IS_ORG_CENTRE	CHAR	1	0	Indicator: Business Partner Is Also an Organizational Center
98	DB_KEY	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
99	VALID_FROM	☐	BU_BP_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start BUT000 BP Data
100	VALID_TO	☐	BU_BP_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End BUT000 BP Data
101	XPCPT	☐	BU_XPCPT	BU_XPCPT	CHAR	1	0	Business Purpose Completed Flag
102	.INCLU--AP	☐				0	0	Append BUT000: Indicator Natural Person for Taxes
103	NATPERS	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
104	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	BUS000SEARCH	AUGRP	TB037	AUGRP	REF	1	CN
2	BUS000SEARCH	BPKIND	TB004	BPKIND	KEY	1	CN
3	BUS000SEARCH	BU_GROUP	TB001	BU_GROUP	REF	1	CN
4	BUS000SEARCH	BU_LANGU	T002	SPRAS	REF	C	CN
5	BUS000SEARCH	BU_LOGSYS	TBDLS	LOGSYS		1	CN
6	BUS000SEARCH	CLIENT	T000	MANDT	KEY	1	CN
7	BUS000SEARCH	CNDSC	T005	LAND1	REF	1	CN
8	BUS000SEARCH	IND_SECTOR	TB023	IND_SECTOR	REF	1	CN
9	BUS000SEARCH	JOBGR	TB028	JOBGR	REF	1	CN
10	BUS000SEARCH	LANGU_CORR	T002	SPRAS	REF	C	CN
11	BUS000SEARCH	LEGAL_ENTY	TB019	LEGAL_ENTY	KEY	1	CN
12	BUS000SEARCH	LEGAL_ORG	TB032	LEGAL_ORG	REF	1	CN
13	BUS000SEARCH	MARST	TB027	MARST		1	CN
14	BUS000SEARCH	NAMCOUNTRY	T005	LAND1	REF	C	CN
15	BUS000SEARCH	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
16	BUS000SEARCH	NATIO	T005	LAND1		1	CN
17	BUS000SEARCH	PARTGRPTYP	TB025	PARTGRPTYP	KEY	1	CN
18	BUS000SEARCH	PREFIX1	TSAD4	PREFIX_KEY
19	BUS000SEARCH	PREFIX2	TSAD4	PREFIX_KEY
20	BUS000SEARCH	SOURCE	TB005	SOURCE	KEY	1	CN
21	BUS000SEARCH	TITLE	TSAD3	TITLE	REF
22	BUS000SEARCH	TITLE_ACA1	TSAD2	TITLE_KEY
23	BUS000SEARCH	TITLE_ACA2	TSAD2	TITLE_KEY
24	BUS000SEARCH	TITLE_ROYL	TSAD5	TITLE_KEY
25	BUS000SEARCH	XUBNAME	USR02	BNAME	KEY	1	CN

History

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