P_WorkforcePersonImageURL

DDL: P_WORKFORCEPERSONIMAGEURL SQL: PWFPERSIMG Type: view BASIC

P_WorkforcePersonImageURL is a Basic CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 5 fields. It has 1 association to related views.

6 data source(s) 5 fields

Data Sources (6)

SourceAliasJoin Type
I_HrRelation HrRelation inner
P_HrRelation HrRelation inner
/shcm/hrp5092 ImageURL from
/shcm/hrp5092 ImageURL union_all
wfd_d_new_pers switch left_outer
wfd_d_new_pers switch inner

Associations (1)

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

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PWFPERSIMG view
VDM.viewType #BASIC view
VDM.private true 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
AbapCatalog.compiler.compareFilter true view

Fields (5)

KeyFieldSource TableSource FieldDescription
Person P_HrRelation HumRsceRelatedObjectId
WorkforcePersonImageURL /shcm/hrp5092 employee_image_url
HumRsceRelatedObjectIdasPerson
WorkforcePersonImageURL
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'PWFPERSIMG'
@VDM.viewType: #BASIC
@VDM.private: true
@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'

@AbapCatalog.compiler.compareFilter:true
define view P_WorkforcePersonImageURL
  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'
    left outer join wfd_d_new_pers as switch     on HrRelation.mandt = switch.mandt
  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'
  and switch.switch  is null
  or  switch.switch  <> 'NEW'

union all select from /shcm/hrp5092  as ImageURL
  inner join          P_HrRelation   as HrRelation on HrRelation.HumRsceObjectId = ImageURL.objid
  inner join          wfd_d_new_pers as switch     on HrRelation.mandt = switch.mandt
association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner = $projection.Person
{
  HrRelation.HumRsceRelatedObjectId as Person,
  ''                                as WorkforcePersonImageURL,
  _BusinessPartner

}
where
      ImageURL.otype = 'CP'
  and switch.switch  = 'NEW'

Learn More