SAP ABAP Table BUS_JOEL_SEARCH_FIELDS (Screen Structure for Search Fields)

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

Foreign Keys

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

History

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