SAP ABAP Table BUSSEARCH (CBP: Search Fields)

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	BUSSEARCH	Table Relationship Diagram
Short Description	CBP: Search Fields

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	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	.INCLUDE	☐				0	0	CBP: Default Fields
3	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
4	MC_NAME1	☐	BU_MCNAME1_GK	BU_MCNAME1_GK	CHAR	35	0	Search Help Field 1 (Name 1/Last Name Upper/Lower Case)
5	MC_NAME2	☐	BU_MCNAME2_GK	BU_MCNAME2_GK	CHAR	35	0	Search Help Field 2 (Name 2/First Name) Upper/Lower Case
6	LANGU	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	*
7	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
8	MC_CITY1	☐	BU_MC_CITY_GK	BU_MC_CITY_GK	CHAR	40	0	City Name in Upper/Lower Case for SAP BP Search Help
9	MC_STREET	☐	BU_MC_STRT_GK	BU_MC_STRT_GK	CHAR	60	0	Street Name in Upper/Lower Case for SAP BP Search Help
10	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	TELNR	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
13	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
14	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
15	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	*
16	FAXNR_CALL	☐	AD_FAXNRCL	CHAR30	CHAR	30	0	Fax number for finding sender
17	ADDR_VALID_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
18	ADDR_VALID_TO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
19	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
20	AUGRP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	*
21	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
22	RLTYP	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	*
23	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
24	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
25	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
26	CCINS	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
27	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
28	BIRTHDT	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
29	IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BUSSEARCH	BANKS	T005	LAND1
2	BUSSEARCH	CCINS	TB033	CCINS

History

Last changed by/on	SAP	20130604
SAP Release Created in