SAP ABAP Table BUS_JOEL_SEARCH (SAP BP Screen Structure for Locator Search Screens)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ AP-MD-BP-UI (Application Component) Dialog SAP-GUI
     ⤷ BUPA_DIALOG (Package) SAP Business Partner: New Dialog Interface

Basic Data

Table Category	INTTAB	Structure
Structure	BUS_JOEL_SEARCH	Table Relationship Diagram
Short Description	SAP BP Screen Structure for Locator Search Screens

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	Screen Structure for Search Fields
2	.INCLUDE	☐				0	0	Screen Structure for Search Fields: All Partner Categories
3	PARTNER_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	SEARCH1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
5	SEARCH2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
6	EXTERNAL_NUMBER	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
7	CITY	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
8	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
9	HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
10	PARTNER_ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
11	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
12	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
14	CITY_MC	☐	AD_CITY1	TEXT40	CHAR	40	0	City
15	STREET_MC	☐	AD_STREET	TEXT60	CHAR	60	0	Street
16	COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
17	TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
18	COUNTY_MC	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
19	TOWNSHIP_MC	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
20	IDTYPE	☐	BU_IDENT_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
21	IDNUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
22	.INCLU--AP	☐				0	0	CRM BP Screen Structure for Search Fields: All Partner Cats.
23	CUSTOMER_NUMBER	☐	CRMT_BU_MAP_CUSTOMER_NUMBER	KUNNR	CHAR	10	0	ERP Customer Number of a Business Partner	*
24	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Persons
25	FIRST_NAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
26	LAST_NAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
27	BIRTH_DATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
28	BIRTH_PLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
29	.INCLU--AP	☐				0	0	CRM BP Screen Structure for Search Fields: Persons
30	CONTACT_NUMBER	☐			CHAR	10	0
31	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Organization
32	ORG_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
33	ORG_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
34	ORG_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
35	ORG_NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
36	LOCATION1	☐	BU_LOCATION1STR	CHAR7	CHAR	7	0	Business partner: International location number part 1 (DI)
37	LOCATION2	☐	BU_LOCATION2STR	CHAR5	CHAR	5	0	Business partner: International location number part 2 (DI)
38	LOCATION3	☐	BU_LOCATION3STR	CHAR1	CHAR	1	0	Business partner: International location number part 3 (DI)
39	.INCLUDE	☐				0	0	Screen Structure for Search Fields: Group
40	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
41	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
42	NAME1	☐	PARTNER_NAME1	BU_NAME	CHAR	40	0	Partner name1
43	NAME2	☐	PARTNER_NAME2	BU_NAME	CHAR	40	0	Partner Name2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BUS_JOEL_SEARCH	COUNTRY	T005	LAND1	REF	C	CN

History

Last changed by/on	SAP	20131122
SAP Release Created in	12A