1. Home
  2. Resources
  3. SAP Tables
  4. BUS_JOEL_SEARCH - SAP BP Screen Structure for Locator Search Screens

SAP Table BUS_JOEL_SEARCH

SAP BP Screen Structure for Locator Search Screens

BUS_JOEL_SEARCH (SAP BP Screen Structure for Locator Search Screens) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUS_JOEL_SEARCH to other SAP tables.

BUS_JOEL_SEARCH table fields

Field Data element Checktable Datatype Length Decimals
PARTNER_NUMBER Business Partner Number BU_PARTNER CHAR 10 0
SEARCH1 Search term 1 for business partner BU_SORT1 CHAR 20 0
SEARCH2 Search term 2 for business partner BU_SORT2 CHAR 20 0
EXTERNAL_NUMBER Business Partner Number in External System BU_BPEXT CHAR 20 0
CITY City name in upper case for search help AD_MC_CITY CHAR 25 0
STREET Street name in upper case for search help AD_MC_STRT CHAR 25 0
HOUSE_NUMBER House Number AD_HSNM1 CHAR 10 0
PARTNER_ROLE BP role BU_ROLE CHAR 6 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
NATION Version ID for International Addresses AD_NATION CHAR 1 0
CITY_MC City AD_CITY1 CHAR 40 0
STREET_MC Street AD_STREET CHAR 60 0
COUNTY County name in upper case for search help AD_MC_COUNTY CHAR 25 0
TOWNSHIP Township name in upper case for search help AD_MC_TWSHP CHAR 25 0
COUNTY_MC County AD_COUNTY CHAR 40 0
TOWNSHIP_MC Township AD_TOWNSHIP CHAR 40 0
IDTYPE Identification Type BU_IDENT_TYPE CHAR 6 0
IDNUMBER Identification Number BU_ID_NUMBER CHAR 60 0
FIRST_NAME First name of business partner (person) BU_NAMEP_F CHAR 40 0
LAST_NAME Last name of business partner (person) BU_NAMEP_L CHAR 40 0
BIRTH_DATE Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
BIRTH_PLACE Birthplace of business partner BU_BIRTHPL CHAR 40 0
ORG_NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
ORG_NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
ORG_NAME3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
ORG_NAME4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
LOCATION1 Business partner: International location number part 1 (DI) BU_LOCATION1STR CHAR 7 0
LOCATION2 Business partner: International location number part 2 (DI) BU_LOCATION2STR CHAR 5 0
LOCATION3 Business partner: International location number part 3 (DI) BU_LOCATION3STR CHAR 1 0
NAME_GRP1 Name 1 (group) BU_NAMEGR1 CHAR 40 0
NAME_GRP2 Name 2 (group) BU_NAMEGR2 CHAR 40 0
NAME1 Partner name1 PARTNER_NAME1 CHAR 40 0
NAME2 Partner Name2 PARTNER_NAME2 CHAR 40 0

BUS_JOEL_SEARCH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUS_JOEL_SEARCH COUNTRY * T005 Countries MANDT
BUS_JOEL_SEARCH COUNTRY BUS_JOEL_SEARCH COUNTRY T005 Countries LAND1