C_CAInvcgUserContact

DDL: C_CAINVCGUSERCONTACT SQL: CCAUSERCONTACT Type: view COMPOSITE

Benutzerkontaktdaten

C_CAInvcgUserContact is a Composite CDS View that provides data about "Benutzerkontaktdaten" in SAP S/4HANA. It reads from 1 data source (I_UserContactCard) and exposes 6 fields with key field ContactCardID.

Data Sources (1)

SourceAliasJoin Type
I_UserContactCard _User from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCAUSERCONTACT view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Benutzerkontaktdaten view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ContactCardID view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID ContactCardID
FullName I_UserContactCard FullName
Department I_UserContactCard Department
FunctionalTitleName I_UserContactCard FunctionalTitleName
PhoneNumber I_UserContactCard PhoneNumber
EmailAddress I_UserContactCard EmailAddress
@AbapCatalog.sqlViewName: 'CCAUSERCONTACT'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
//@ClientDependent: true

@EndUserText.label: 'Benutzerkontaktdaten'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: 'C'
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY // never expose this view directly, only via associations

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ContactCardID'
//@AccessControl.privilegedAssociations: [ '_User' ]

define view C_CAInvcgUserContact
  as select from I_UserContactCard as _User
{
  key ContactCardID,

       @Semantics.name: {fullName: true}
       _User.FullName                      as FullName,

       @Semantics.organization.name: true
       _User.Department,

       @Semantics.organization.role: true
       _User.FunctionalTitleName,

       @Semantics: { telephone.type:  [ #WORK, #PREF, #HOME ] }
       _User.PhoneNumber                   as PhoneNumber,

       @Semantics: { eMail: { address: true, type:  [ #PREF, #WORK ] } }
       _User.EmailAddress                  as EmailAddress
}
 
 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/