C_ESJIContactPersonQuery

Contact Persons for a Customer | view: CESJICNCTPRSN | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ObjectType null
FormOfAddress null
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
EmailAddress E-Mail Address AD_SMTPADR
PhoneNumber Telephone no.: dialling code+number CHAR30
HouseNumber House Number TEXT10
StreetName Street TEXT60
CityName City TEXT40
RegionName Description TEXT20
CountryName Country/Region Name TEXT50
PostalCode City postal code CHAR10
ContactPersonDepartment Department BU_ABTNR
ContactPersonDepartmentName Description TEXT20
ContactPersonFunctionName Description TEXT30
FullName null
Master Data Relations Join Conditions
Function of partner
  • Client
  • Function of partner
  • C_ESJICONTACTPERSONQUERY.MANDT == TB912.CLIENT
  • C_ESJICONTACTPERSONQUERY.CONTACTPERSONFUNCTION == TB912.PAFKT
Country key
  • Client
  • Country/Region Key
  • C_ESJICONTACTPERSONQUERY.MANDT == T005.MANDT
  • C_ESJICONTACTPERSONQUERY.COUNTRY == T005.LAND1
Business Partner Number
  • Client
  • Business Partner Number
  • C_ESJICONTACTPERSONQUERY.MANDT == BUT000.CLIENT
  • C_ESJICONTACTPERSONQUERY.CUSTOMER == BUT000.PARTNER
Business Partner Number
  • Client
  • Business Partner Number
  • C_ESJICONTACTPERSONQUERY.MANDT == BUT000.CLIENT
  • C_ESJICONTACTPERSONQUERY.CUSTOMERCONTACT == BUT000.PARTNER
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_ESJICONTACTPERSONQUERY.MANDT == T005S.MANDT
  • C_ESJICONTACTPERSONQUERY.COUNTRY == T005S.LAND1
  • C_ESJICONTACTPERSONQUERY.REGION == T005S.BLAND