SAP BUS_JOEL_SEARCH_FIELDS table - Screen Structure for Search Fields details in SAP

SAP BUS_JOEL_SEARCH_FIELDS table summary

Object Name: BUS_JOEL_SEARCH_FIELDS
Dictionary Type: Structure
Description: Screen Structure for Search Fields

Field list for BUS_JOEL_SEARCH_FIELDS table on an S/4 SAP system

Details

BUS_JOEL_SEARCH_FIELDS-PARTNER_NUMBER table field - Business Partner Number ▼

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

BUS_JOEL_SEARCH_FIELDS-SEARCH1 table field - Search Term 1 for Business Partner ▼

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

BUS_JOEL_SEARCH_FIELDS-SEARCH2 table field - Search Term 2 for Business Partner ▼

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

BUS_JOEL_SEARCH_FIELDS-EXTERNAL_NUMBER table field - Business Partner Number in External System ▼

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

BUS_JOEL_SEARCH_FIELDS-CITY table field - City name in Uppercase for Search Help ▼

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

BUS_JOEL_SEARCH_FIELDS-STREET table field - Street Name in Uppercase for Search Help ▼

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

BUS_JOEL_SEARCH_FIELDS-HOUSE_NUMBER table field - House Number ▼

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

BUS_JOEL_SEARCH_FIELDS-PARTNER_ROLE table field - BP role ▼

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

BUS_JOEL_SEARCH_FIELDS-POST_CODE1 table field - City postal code ▼

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

BUS_JOEL_SEARCH_FIELDS-COUNTRY table field - Country/Region Key ▼

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

BUS_JOEL_SEARCH_FIELDS-NATION table field - Version ID for International Addresses ▼

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

BUS_JOEL_SEARCH_FIELDS-CITY_MC table field - City ▼

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

BUS_JOEL_SEARCH_FIELDS-STREET_MC table field - Street ▼

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

BUS_JOEL_SEARCH_FIELDS-COUNTY table field - County name in upper case for search help ▼

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

BUS_JOEL_SEARCH_FIELDS-TOWNSHIP table field - Township name in upper case for search help ▼

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

BUS_JOEL_SEARCH_FIELDS-COUNTY_MC table field - County ▼

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

BUS_JOEL_SEARCH_FIELDS-TOWNSHIP_MC table field - Township ▼

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

BUS_JOEL_SEARCH_FIELDS-IDTYPE table field - Identification Type ▼

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

BUS_JOEL_SEARCH_FIELDS-IDNUMBER table field - Identification Number ▼

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

BUS_JOEL_SEARCH_FIELDS-.INCLU--AP table field - ▼

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

BUS_JOEL_SEARCH_FIELDS-CUSTOMER_NUMBER table field - Customer Number ▼

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

BUS_JOEL_SEARCH_FIELDS-FIRST_NAME table field - First name of business partner (person) ▼

Description: First name of business partner (person)
Field Name: FIRST_NAME
Data Element: BU_NAMEP_F
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIRST_NAME

BUS_JOEL_SEARCH_FIELDS-LAST_NAME table field - Last name of business partner (person) ▼

Description: Last name of business partner (person)
Field Name: LAST_NAME
Data Element: BU_NAMEP_L
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_NAME

BUS_JOEL_SEARCH_FIELDS-BIRTH_DATE table field - Date of Birth of Business Partner ▼

Description: Date of Birth of Business Partner
Field Name: BIRTH_DATE
Data Element: BU_BIRTHDT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIRTH_DATE

BUS_JOEL_SEARCH_FIELDS-BIRTH_PLACE table field - Birthplace of business partner ▼

Description: Birthplace of business partner
Field Name: BIRTH_PLACE
Data Element: BU_BIRTHPL
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: TEXT40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BIRTH_PLACE

BUS_JOEL_SEARCH_FIELDS-.INCLU--AP table field - ▼

BUS_JOEL_SEARCH_FIELDS-CONTACT_NUMBER table field - Contact Person Number ▼

Description: Contact Person Number
Field Name: CONTACT_NUMBER
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 CONTACT_NUMBER

BUS_JOEL_SEARCH_FIELDS-ORG_NAME1 table field - Name 1 of organization ▼

Description: Name 1 of organization
Field Name: ORG_NAME1
Data Element: BU_NAMEOR1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORG_NAME1

BUS_JOEL_SEARCH_FIELDS-ORG_NAME2 table field - Name 2 of organization ▼

Description: Name 2 of organization
Field Name: ORG_NAME2
Data Element: BU_NAMEOR2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORG_NAME2

BUS_JOEL_SEARCH_FIELDS-ORG_NAME3 table field - Name 3 of organization ▼

Description: Name 3 of organization
Field Name: ORG_NAME3
Data Element: BU_NAMEOR3
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORG_NAME3

BUS_JOEL_SEARCH_FIELDS-ORG_NAME4 table field - Name 4 of organization ▼

Description: Name 4 of organization
Field Name: ORG_NAME4
Data Element: BU_NAMEOR4
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORG_NAME4

BUS_JOEL_SEARCH_FIELDS-LOCATION1 table field - Business partner: International location number part 1 (DI) ▼

Description: Business partner: International location number part 1 (DI)
Field Name: LOCATION1
Data Element: BU_LOCATION1STR
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: CHAR7
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATION1

BUS_JOEL_SEARCH_FIELDS-LOCATION2 table field - Business partner: International location number part 2 (DI) ▼

Description: Business partner: International location number part 2 (DI)
Field Name: LOCATION2
Data Element: BU_LOCATION2STR
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: CHAR5
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATION2

BUS_JOEL_SEARCH_FIELDS-LOCATION3 table field - Business partner: International location number part 3 (DI) ▼

Description: Business partner: International location number part 3 (DI)
Field Name: LOCATION3
Data Element: BU_LOCATION3STR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCATION3

BUS_JOEL_SEARCH_FIELDS-NAME_GRP1 table field - Name 1 (group) ▼

Description: Name 1 (group)
Field Name: NAME_GRP1
Data Element: BU_NAMEGR1
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_GRP1

BUS_JOEL_SEARCH_FIELDS-NAME_GRP2 table field - Name 2 (group) ▼

Description: Name 2 (group)
Field Name: NAME_GRP2
Data Element: BU_NAMEGR2
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: BU_NAME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME_GRP2

View list of all SAP tables(S4H/ECC)

Select data from SAP table