P_WFPERSONIDENTIFICATION

CDS View

P_WFPERSONIDENTIFICATION is a CDS View in S/4HANA. It contains 1 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 1 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_EngmntProjectRoleAssgmt view inner COMPOSITE Role Assignment in Engagement Project
I_EngmntProjectWithRoleAssgmt view inner COMPOSITE Engagement Project With Roles
I_WorkforcePerson view inner COMPOSITE Workforce Person Details
P_WorkforcePerson view inner COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
BPIdentificationNumber PersonExternalID 4 
@AbapCatalog.sqlViewName: 'PPERSONID'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.preserveKey:true
define view P_WFPersonIdentification
  as select distinct from I_BuPaIdentification as BPIdentifier
{
  key    BPIdentifier.BusinessPartner,
         // key    BPIdentifier.BPIdentificationType,

  key    BPIdentifier.BPIdentificationNumber
}
where
     BPIdentifier.BPIdentificationType = 'HCM001' // HCM001 - Employee ID

  or BPIdentifier.BPIdentificationType = 'HCM030' // HCM030 - Service Agent

  or BPIdentifier.BPIdentificationType = 'HCM031' // HCM031 - Freelancer

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

Learn More