C_ESJIContactPersonQuery

DDL: C_ESJICONTACTPERSONQUERY SQL: CESJICNCTPRSN Type: view CONSUMPTION

Contact Persons for a Customer

C_ESJIContactPersonQuery is a Consumption CDS View that provides data about "Contact Persons for a Customer" in SAP S/4HANA. It reads from 1 data source (I_CustomerContacts) and exposes 21 fields.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerContacts _Contacts from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CESJICNCTPRSN view
EndUserText.label Contact Persons for a Customer view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
ObjectType
CustomerContact CustomerContact
Customer Customer
FormOfAddress
FirstName FirstName
LastName LastName
EmailAddress EmailAddress
PhoneNumber _BPContact PhoneNumber
HouseNumber
StreetName
CityName
Region
RegionName
Country
CountryName
PostalCode
ContactPersonDepartment _BPContact ContactPersonDepartment
ContactPersonDepartmentName
ContactPersonFunction ContactPersonFunction
ContactPersonFunctionName
FullName 
@AbapCatalog.sqlViewName: 'CESJICNCTPRSN'
@EndUserText.label: 'Contact Persons for a Customer'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view C_ESJIContactPersonQuery
with parameters
    P_Language : sylangu
as select from I_CustomerContacts as _Contacts
association[0..1]    to     I_BusinessPartnerContact    as _BPContact on _BPContact.BusinessPartnerPerson  = $projection.CustomerContact and  _BPContact.BusinessPartnerCompany = $projection.Customer
{
    'KNA1_ESJI' as ObjectType,
    CustomerContact,
    Customer,
 // knvk.anred as Title,

    ' ' as FormOfAddress,
 // _BPContact.FormOfAddress,

    FirstName,
    LastName,  
    EmailAddress,
    _BPContact.PhoneNumber,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress.HouseNumber,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress.StreetName,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress.CityName,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress.Region,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress._Region._RegionText[1:Language = $parameters.P_Language].RegionName,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress.Country,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress._Country._Text[1:Language=$parameters.P_Language].CountryName,
    _BPContact._BusinessPartnerCompany._CurrentDefaultAddress._StandardAddress.PostalCode,
    _BPContact.ContactPersonDepartment,
    _BPContact._ContactPersonDepartment._Text[1: Language=$parameters.P_Language].ContactPersonDepartmentName,
    ContactPersonFunction,
    _ContactPersonFunction._Text[1: Language=$parameters.P_Language].ContactPersonFunctionName,        
    concat(FirstName, LastName) as FullName
    
}

Learn More