SAP BUS_JOEL_SEARCH_FIELDS_ALL table - Screen Structure for Search Fields: All Partner Categories details in SAP

Description: Business Partner Number
Field Name: PARTNER_NUMBER
Data Element: BU_PARTNER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BU_PARTNER
MemoryID: BPA
AppClass:
SHLP: BUPA
SHLP Field: PARTNER
ConvExit: ALPHA

See all SAP tables containing field PARTNER_NUMBER

Description: Search Term 1 for Business Partner
Field Name: SEARCH1
Data Element: BU_SORT1
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: BU_SORT1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH1

Description: Search Term 2 for Business Partner
Field Name: SEARCH2
Data Element: BU_SORT2
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: BU_SORT1
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCH2

Description: Business Partner Number in External System
Field Name: EXTERNAL_NUMBER
Data Element: BU_BPEXT
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXTERNAL_NUMBER

Description: City name in Uppercase for Search Help
Field Name: CITY
Data Element: AD_MC_CITY
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CITY

Description: Street Name in Uppercase for Search Help
Field Name: STREET
Data Element: AD_MC_STRT
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STREET

Description: House Number
Field Name: HOUSE_NUMBER
Data Element: AD_HSNM1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOUSE_NUMBER

Description: BP role
Field Name: PARTNER_ROLE
Data Element: BU_ROLE
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: BU_RLTYP
MemoryID:
AppClass:
SHLP: BUPA_ROLE
SHLP Field: RLTYP
ConvExit:

See all SAP tables containing field PARTNER_ROLE

Description: City postal code
Field Name: POST_CODE1
Data Element: AD_PSTCD1
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POST_CODE1

Description: Country/Region Key
Field Name: COUNTRY
Data Element: LAND1
Data Type: CHAR
length (Dec): 3(0)
Check table: T005
Conversion Routine:
Domain Name: LAND1
MemoryID: LND
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTRY

Description: Version ID for International Addresses
Field Name: NATION
Data Element: AD_NATION
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: AD_NATION
MemoryID: ADDRESS_NATION
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NATION

Description: City
Field Name: CITY_MC
Data Element: AD_CITY1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLCITYNAME
SHLP Field: CITY_NAME
ConvExit:

See all SAP tables containing field CITY_MC

Description: Street
Field Name: STREET_MC
Data Element: AD_STREET
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: TEXT60
MemoryID:
AppClass: SAP
SHLP: CLSTRTNAME
SHLP Field: STREET
ConvExit:

See all SAP tables containing field STREET_MC

Description: County name in upper case for search help
Field Name: COUNTY
Data Element: AD_MC_COUNTY
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COUNTY

Description: Township name in upper case for search help
Field Name: TOWNSHIP
Data Element: AD_MC_TWSHP
Data Type: CHAR
length (Dec): 25(0)
Check table:
Conversion Routine:
Domain Name: CHAR25
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOWNSHIP

Description: County
Field Name: COUNTY_MC
Data Element: AD_COUNTY
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTCNTYNAME
SHLP Field: COUNTY
ConvExit:

See all SAP tables containing field COUNTY_MC

Description: Township
Field Name: TOWNSHIP_MC
Data Element: AD_TOWNSHIP
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP: CLTWSHPNAME
SHLP Field: TOWNSHIP
ConvExit:

See all SAP tables containing field TOWNSHIP_MC

Description: Identification Type
Field Name: IDTYPE
Data Element: BU_IDENT_TYPE
Data Type: CHAR
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: BU_ID_TYPE
MemoryID:
AppClass:
SHLP: BUPA_ALL_IDENTIFICATION_NUMBER
SHLP Field: TYPE
ConvExit:

See all SAP tables containing field IDTYPE

Description: Identification Number
Field Name: IDNUMBER
Data Element: BU_ID_NUMBER
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IDNUMBER

Description:
Field Name: .INCLU--AP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field .INCLU--AP

Description: Customer Number
Field Name: CUSTOMER_NUMBER
Data Element: KUNNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: KUNNR
MemoryID: KUN
AppClass: V
SHLP: C_KUNNR
SHLP Field: KUNNR
ConvExit: ALPHA

See all SAP tables containing field CUSTOMER_NUMBER