I_EmplContactCard

DDL: I_EMPLCONTACTCARD SQL: IEMPLCONTACTCARD Type: view COMPOSITE

Employee Contact Card for CATS Applications

I_EmplContactCard is a Composite CDS View that provides data about "Employee Contact Card for CATS Applications" in SAP S/4HANA. It reads from 1 data source (I_PersonWorkAgreement_1) and exposes 3 fields with key field PersonWorkAgreement. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_PersonWorkAgreement_1 _PersonWorkAgreement from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkforcePersonImageURL _WorkforcePersonImageURL _WorkforcePersonImageURL.Person = _PersonWorkAgreement.Person

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLCONTACTCARD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Employee Contact Card for CATS Applications view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement I_PersonWorkAgreement_1 PersonWorkAgreement
PersonExternalID
IsBusinessPurposeCompleted Name 
@AbapCatalog.sqlViewName: 'IEMPLCONTACTCARD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Employee Contact Card for CATS Applications'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality : #D
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.personalData.blocking: #REQUIRED
define view I_EmplContactCard
  as select from I_PersonWorkAgreement_1 as _PersonWorkAgreement
  association [0..1] to I_WorkforcePersonImageURL as _WorkforcePersonImageURL on _WorkforcePersonImageURL.Person = _PersonWorkAgreement.Person
{
      @Semantics.contact.type: #PERSON
      @UI.hidden: true
  key _PersonWorkAgreement.PersonWorkAgreement,

      @UI.hidden: true
      _PersonWorkAgreement._WorkforcePerson.PersonExternalID,

      @UI.hidden: true
      @Semantics.contact.photo: true
      case
      when _WorkforcePersonImageURL.WorkforcePersonImageURL is null
      then 'sap-icon://person-placeholder'

      else
      _WorkforcePersonImageURL.WorkforcePersonImageURL
      end as                                                            EmployeeImageURL,

      @Consumption.hidden: true
      _PersonWorkAgreement._WorkforcePerson.Person,

      @Semantics.text: true
      @Semantics.name.fullName: true
      @EndUserText.label: 'Name'
      _PersonWorkAgreement._WorkforcePerson.PersonFullName,

      @UI.hidden: true
      @Semantics.telephone.type:  [ #CELL ]
      _PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.MblNormalizedPhoneNumber,

      @UI.hidden: true
      @Semantics: { telephone.type:  [ #WORK, #PREF ] }
      _PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.NormalizedPhoneNumber,

      @UI.hidden: true
      @Semantics.eMail.address: true
      @Semantics:{ eMail.type:  [ #WORK ] }
      _PersonWorkAgreement._WorkforcePerson._WorkplaceAddress.DefaultEmailAddress,

      @UI.hidden: true
      @Semantics.name.jobTitle: true
      _PersonWorkAgreement._PersonWrkAgrmtForKeyDate(P_KeyDate: $session.system_date)._PersonWorkAgrmtJobText[1:Language = $session.system_language].JobName,

      @Consumption.hidden: true
      _PersonWorkAgreement.AuthorizationGroup,

      @Consumption.hidden: true
      _PersonWorkAgreement._PersonWrkAgrmtForKeyDate(P_KeyDate: $session.system_date).PersonWorkAgrmtAuthznGrpg,

      @Consumption.hidden: true
      _PersonWorkAgreement._WorkforcePerson.IsBusinessPurposeCompleted
      
// BP Data Controller logic commented for CE2308       

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataControllerSet                                      as DataControllerSet,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController1                                        as DataController1,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController2                                        as DataController2,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController3                                        as DataController3,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController4                                        as DataController4,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController5                                        as DataController5,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController6                                        as DataController6,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController7                                        as DataController7,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController8                                        as DataController8,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController9                                        as DataController9,

//      @Consumption.hidden: true

//      _PersonWorkAgreement._BusinessPartner.DataController10                                       as DataController10


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERSONWORKAGREEMENT_1",
"I_PERSONWORKAGRMTFORKEYDATE",
"I_PERSONWORKAGRMTJOBTEXT",
"I_WORKFORCEPERSON",
"I_WORKFORCEPERSONIMAGEURL",
"I_WORKPLACEADDRESS"
],
"ASSOCIATED":
[
"I_WORKFORCEPERSONIMAGEURL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More