ESH_S_BUSINESSPARTNERS

Search view -BUSINESSPARTNERS | view: ESH_U_BUPARTNERS | Extraction: Not supported | Component: Business Partners
Tables used: ADCP, ADRC, ADR6, BUT0ID, BUT000, BUT020, BUT021_FS, BUT100
Column Name Description
BUSINESSPARTNER Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
BUSINESSPARTNERCATEGORY Business Partner Category Show values
ISBUSINESSPURPOSECOMPLETED Business Purpose Completed Flag Show values
Column Name Description Domain name
CITYNAME City TEXT40
EMAILADDRESS E-Mail Address AD_SMTPADR
FIRSTNAME First name of business partner (person) BU_NAME
LASTNAME Last name of business partner (person) BU_NAME
ORGANIZATIONBPNAME1 Name 1 of organization BU_NAME
ORGANIZATIONBPNAME2 Name 2 of organization BU_NAME
POSTALCODE City postal code CHAR10
SEARCHTERM1 Search Term 1 for Business Partner BU_SORT1
SEARCHTERM2 Search Term 2 for Business Partner BU_SORT1
STREETNAME Street TEXT60
Master Data Relations Join Conditions
Authorization Group
  • Client
  • ?
  • Authorization Group
  • ESH_S_BUSINESSPARTNERS.MANDT == TB037.CLIENT
  • ESH_S_BUSINESSPARTNERS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • ESH_S_BUSINESSPARTNERS.AUTHORIZATIONGROUP == TB037.AUGRP
Identification Type
  • Client
  • Identification Type
  • Business Partner Category
  • ESH_S_BUSINESSPARTNERS.MANDT == TB039A.CLIENT
  • ESH_S_BUSINESSPARTNERS.BPIDENTIFICATIONTYPE == TB039A.TYPE
  • ESH_S_BUSINESSPARTNERS.BUSINESSPARTNERCATEGORY == TB039A.TYPE
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • ESH_S_BUSINESSPARTNERS.MANDT == TB001.MANDT
  • ESH_S_BUSINESSPARTNERS.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
BP Role
  • BP Role
  • Client
  • ESH_S_BUSINESSPARTNERS.BUSINESSPARTNERROLE == TB003.ROLE
  • ESH_S_BUSINESSPARTNERS.MANDT == TB003.CLIENT
Country key
  • Client
  • Country/Region Key
  • ESH_S_BUSINESSPARTNERS.MANDT == T005.MANDT
  • ESH_S_BUSINESSPARTNERS.COUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • ESH_S_BUSINESSPARTNERS.MANDT == TSAD3.CLIENT
  • ESH_S_BUSINESSPARTNERS.FORMOFADDRESS == TSAD3.TITLE
Legal Entity of Organization
  • Client
  • Legal Entity of Organization
  • ESH_S_BUSINESSPARTNERS.MANDT == TB032.CLIENT
  • ESH_S_BUSINESSPARTNERS.LEGALENTITYOFORGANIZATION == TB032.LEGAL_ORG
BP: Legal form of organization
  • BP: Legal form of organization
  • Client
  • ESH_S_BUSINESSPARTNERS.LEGALFORM == TB019.LEGAL_ENTY
  • ESH_S_BUSINESSPARTNERS.MANDT == TB019.CLIENT
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • ESH_S_BUSINESSPARTNERS.MANDT == T005S.MANDT
  • ESH_S_BUSINESSPARTNERS.COUNTRY == T005S.LAND1
  • ESH_S_BUSINESSPARTNERS.REGION == T005S.BLAND