I_WORKASSIGNMENTBP

CDS View

BP Details of Work Assignment

I_WORKASSIGNMENTBP is a CDS View in S/4HANA. BP Details of Work Assignment. It contains 3 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 3 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_ActiveWorkAssignmentsVH view_entity inner COMPOSITE Current active and future work assgmts
I_WorkAssgmtAddressDEX view_entity inner COMPOSITE Work Assignment Address Details
I_WorkAssgmtPaymentDEX view_entity inner COMPOSITE Work Assignment Payment Details
I_WorkAssgmtWorkOrderDEX view_entity inner COMPOSITE Assignment Work Order Details
I_WorkAssignmentAddress view_entity inner COMPOSITE Work Assignment Address Details
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person
I_WrkAssgmtPaymentDetail view_entity inner COMPOSITE Work Assignment Payment Details
I_WrkAssgmtWrkOrderDetail view_entity inner COMPOSITE Assignment Work Order Details
R_WorkAssignmentAddress view_entity inner TRANSACTIONAL Work Assignment Address Details

Fields (3)

KeyField CDS FieldsUsed in Views
KEY WorkAssignmentBusinessPartner WorkAssignmentBusinessPartner 1
BusinessPartner BusinessPartner 2
WorkforcePersonExternalID WorkforcePersonExternalID 4 
@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