I_WorkforcePersonImageURL

DDL: I_WORKFORCEPERSONIMAGEURL SQL: IWFPERSIMG Type: view BASIC

Workforce person Image URL

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

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
WFD_TF_I_WorkforcePersonImgURL WFD_TF_I_WorkforcePersonImgURL from

Associations (1)

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

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IWFPERSIMG view
VDM.viewType #BASIC 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 Person
WorkforcePersonImageURL WorkforcePersonImageURL
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IWFPERSIMG'
@VDM.viewType: #BASIC
@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'
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'

/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More