I_WORKASSIGNMENTBP

CDS View

BP Details of Work Assignment

I_WORKASSIGNMENTBP is a CDS View in S/4HANA. BP Details of Work Assignment. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'BP Details of Work Assignment'

define view entity I_WorkAssignmentBP 
  as select from I_WorkAssignmentKeyMapping as keymap
      inner join I_BuPaIdentification as BuPaIdentification on  BuPaIdentification.BPIdentificationNumber = keymap.WorkAssignment
                                                            and BuPaIdentification.BPIdentificationType   = 'HCM033'
{
  key keymap.WorkAssignment,
      keymap.WorkforcePersonExternalID,
      keymap.BusinessPartner              as BusinessPartner,               //Employee BP

      BuPaIdentification.BusinessPartner  as WorkAssignmentBusinessPartner, //Employment BP

      keymap.IsBlocked                    as IsBlocked
}
where
  keymap.BusinessPartner is not initial 

union select from I_WorkAssignmentKeyMapping as keymap
{
  key keymap.WorkAssignment,
      keymap.WorkforcePersonExternalID,
      keymap.BusinessPartner as BusinessPartner,                            //Employee BP

      keymap.BusinessPartner as WorkAssignmentBusinessPartner,              //Employment BP

      keymap.IsBlocked       as IsBlocked
}
where
      keymap.BusinessPartner is not initial
  and keymap.WorkforceBPModelType = 'O'                                     //Old

Learn More