SAP ABAP Table REBPBUSSEARCH (RE Business Partner: Search Fields)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BP (Application Component) Business Partner
     ⤷ RE_BP_BP (Package) RE: Business Partner

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	600