I_WorkerImageURL

DDL: I_WORKERIMAGEURL Type: view_entity BASIC Package: WFD_WORKER_FACTSHEET_BL

Image URL of Worker

I_WorkerImageURL is a Basic CDS View that provides data about "Image URL of Worker" in SAP S/4HANA. It reads from 2 data sources (wfd_d_keymap, wfd_d_photo) and exposes 4 fields with key field WorkforcePersonExternalID. It has 1 association to related views. Part of development package WFD_WORKER_FACTSHEET_BL.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
wfd_d_keymap keymap inner
wfd_d_photo photo from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = keymap.business_partner_id

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Image URL of Worker view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID wfd_d_keymap person_id_external
Person wfd_d_keymap business_partner_id
WorkforcePersonImageURL wfd_d_photo image_uri_internal
_BusinessPartner _BusinessPartner 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Image URL of Worker'
@VDM: { viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel:{
   usageType.dataClass: #MASTER,
  usageType.serviceQuality: #A,
  usageType.sizeCategory: #M
}
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view entity I_WorkerImageURL
  as select from wfd_d_photo  as photo
    inner join   wfd_d_keymap as keymap on keymap.worker_id = photo.worker_id
  association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner = keymap.business_partner_id
{
  key keymap.person_id_external  as WorkforcePersonExternalID,
      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   <> ' ';

Learn More