I_WorkforcePersonImageURL

DDL: I_WORKFORCEPERSONIMAGEURL SQL: IWFPERSIMG Type: view COMPOSITE Package: VDM_SHCM_EMPLOYEE_V2

Workforce person Image URL

I_WorkforcePersonImageURL is a Composite CDS View that provides data about "Workforce person Image URL" in SAP S/4HANA. It reads from 1 data source (wfd_d_photo) and exposes 3 fields. It has 1 association to related views. Part of development package VDM_SHCM_EMPLOYEE_V2.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
wfd_d_photo photo inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.Person

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IWFPERSIMG view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Workforce person Image URL view

Fields (3)

KeyFieldSource TableSource FieldDescription
Person keymap business_partner_id
WorkforcePersonImageURL wfd_d_photo image_uri_internal
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IWFPERSIMG'
//@VDM.viewType: #BASIC

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Workforce person Image URL'
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view I_WorkforcePersonImageURL
  as select distinct from wfd_d_keymap as keymap
    inner join            wfd_d_photo  as photo on keymap.worker_id = photo.worker_id
  association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner = $projection.Person
{
  keymap.business_partner_id as Person,
  photo.image_uri_internal   as WorkforcePersonImageURL,
  _BusinessPartner

}
where
      photo.image_typecode       =  '1'
  and photo.block_ind            =  ' '
  and keymap.business_partner_id <> ' '
  and photo.image_uri_internal   <> ' ';
/*
define view I_WorkforcePersonImageURL
//  as select from P_WorkforcePersonImageURL

  as select from WFD_TF_I_WorkforcePersonImgURL( p_client : $session.client )
   association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner = $projection.Person
{
  Person,
  WorkforcePersonImageURL,
  _BusinessPartner

}*/

//define view I_WorkforcePersonImageURL

//  as select from P_WorkforcePersonImageURL

//{

//  Person,

//  WorkforcePersonImageURL,

//  _BusinessPartner

//

//}


// as select from /shcm/hrp5092 as ImageURL

//  inner join I_HrRelation as HrRelation on HrRelation.HumRsceObjectId = ImageURL.objid

//                                                             and HrRelation.ObjectType               = 'CP' //CP - Central person

//                                                             and HrRelation.HumRsceRelshpSpecification = 'B'

//                                                             and HrRelation.HumRsceRelationship             = '207' //207    Is identical to

//                                                             and HrRelation.RelatedObjectType         = 'BP'

//                                                             and HrRelation.EndDate = '99991231'

//   association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner = $projection.Person

//{

//    HrRelation.HumRsceRelatedObjectId as Person,

//    ImageURL.employee_image_url as WorkforcePersonImageURL,

//    _BusinessPartner

//

//}

//where ImageURL.otype = 'CP'

Learn More