C_ESJICustomerQuery

Customer | view: CESJICUSTQUERY | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: ADCPADRCADR6ADR2T005T005TKNA1T005ST005U
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ObjectType null
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
PhoneNumber Telephone no.: dialling code+number CHAR30
Location Street 5 TEXT40
HouseNumber House Number TEXT10
StreetName Street TEXT60
CityName City TEXT40
PostalCode City postal code CHAR10
EmailAddress E-Mail Address AD_SMTPADR
RegionName Description TEXT20
CountryName Country/Region Name TEXT50
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • C_ESJICUSTOMERQUERY.COUNTRY == T005.LAND1
  • C_ESJICUSTOMERQUERY.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • C_ESJICUSTOMERQUERY.INDUSTRY == T016.BRSCH
  • C_ESJICUSTOMERQUERY.MANDT == T016.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_ESJICUSTOMERQUERY.COUNTRY == T005S.LAND1
  • C_ESJICUSTOMERQUERY.MANDT == T005S.MANDT
  • C_ESJICUSTOMERQUERY.REGION == T005S.BLAND