C_ExternalContacts

DDL: C_EXTERNALCONTACTS SQL: CEXTCNTCS Type: view CONSUMPTION

External Contacts

C_ExternalContacts is a Consumption CDS View that provides data about "External Contacts" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentContactPerson) and exposes 14 fields with key fields SDDocument, PartnerFunction. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentContactPerson ContactPerson from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PartnerFunctionText _PartnerFunctionText $projection.PartnerFunction = _PartnerFunctionText.PartnerFunction
[0..1] I_CustomerReturn _CustomerReturn $projection.SDDocument = _CustomerReturn.CustomerReturn

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CEXTCNTCS view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label External Contacts view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SDDocument SDDocument
KEY PartnerFunction PartnerFunction
ContactPerson ContactPerson
FullName _PersonWorkplaceAddrDfltRprstn PersonFullName
GivenName _PersonWorkplaceAddrDfltRprstn GivenName
FamilyName _PersonWorkplaceAddrDfltRprstn FamilyName
InternationalPhoneNumber
InternationalMobilePhoneNumber
EmailAddress
CustomerReturnType _CustomerReturn CustomerReturnType
SalesOrganization _CustomerReturn SalesOrganization
DistributionChannel _CustomerReturn DistributionChannel
OrganizationDivision _CustomerReturn OrganizationDivision
_PartnerFunctionText _PartnerFunctionText 
@AbapCatalog.sqlViewName: 'CEXTCNTCS'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'External Contacts'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

define view C_ExternalContacts
as select from I_SDDocumentContactPerson    as ContactPerson 

// Associations

association [0..*] to I_PartnerFunctionText as _PartnerFunctionText on $projection.PartnerFunction = _PartnerFunctionText.PartnerFunction
association [0..1] to I_CustomerReturn      as _CustomerReturn      on $projection.SDDocument = _CustomerReturn.CustomerReturn
{
    key SDDocument,
    @ObjectModel.text.association: '_PartnerFunctionText'
    key PartnerFunction,
    
    ContactPerson,
     
    _PersonWorkplaceAddrDfltRprstn.PersonFullName as FullName,
    _PersonWorkplaceAddrDfltRprstn.GivenName,
    _PersonWorkplaceAddrDfltRprstn.FamilyName,
          
    _PersonWorkplaceAddrDfltRprstn._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber as InternationalPhoneNumber,
     _PersonWorkplaceAddrDfltRprstn._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as InternationalMobilePhoneNumber,
    _PersonWorkplaceAddrDfltRprstn._CurrentDfltEmailAddress.EmailAddress as EmailAddress,
    
    // For Access Control

    @Consumption.hidden: true
    @UI.hidden: true
    _CustomerReturn.CustomerReturnType,
    @Consumption.hidden: true
    @UI.hidden: true
    _CustomerReturn.SalesOrganization,
    @Consumption.hidden: true
    @UI.hidden: true
    _CustomerReturn.DistributionChannel,
    @Consumption.hidden: true
    @UI.hidden: true
    _CustomerReturn.OrganizationDivision,

    _PartnerFunctionText
}                                                
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRCURDEFAULTEMAILADDRESS",
"I_ADDRCURDFLTLANDLINEPHONENMBR",
"I_ADDRCURDFLTMOBILEPHONENUMBER",
"I_CUSTOMERRETURN",
"I_PERSONWORKPLACEADDRESS",
"I_SDDOCUMENTCONTACTPERSON"
],
"ASSOCIATED":
[
"I_CUSTOMERRETURN",
"I_PARTNERFUNCTIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More