R_WORKASSIGNMENTBP_1

CDS View

Work Assignment

R_WORKASSIGNMENTBP_1 is a CDS View in S/4HANA. Work Assignment. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WorkAssignmentPayment view_entity from COMPOSITE Payment for Workforce Person

Fields (3)

KeyField CDS FieldsUsed in Views
WorkAssignmentBusinessPartner EmployeeInternalID 1
WorkforceAssignment EmploymentInternalID 1
WorkforcePersonExternalID WorkforcePersonExternalID 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Work Assignment'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking :#NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel:{
  usageType.dataClass: #MASTER,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L
}
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern:#NONE
define view entity R_WorkAssignmentBP_1
  as select distinct from R_WorkAssignmentKeyMap as keymap
    inner join            I_BuPaIdentification   as _BuPaIdentification on  _BuPaIdentification.BPIdentificationNumber = keymap.WorkforceAssignment
                                                                        and _BuPaIdentification.BPIdentificationType   = 'HCM033'

{
  key keymap.WorkforceAssignment,
      keymap.WorkforcePersonExternalID,
      keymap.BusinessPartner              as BusinessPartner, //Employee BP - To be Added

      _BuPaIdentification.BusinessPartner as WorkAssignmentBusinessPartner, //Employment BP

      'C'                                 as BPRoleCategoryUsageCode //Contract

}
where
  keymap.BusinessPartner is not initial
//  and keymap.WorkforceBPModelType = 'N' //New

union all select from R_WorkAssignmentKeyMap as keymap
{
  key keymap.WorkforceAssignment,
      keymap.WorkforcePersonExternalID,
      keymap.BusinessPartner as BusinessPartner, //Employee BP - To be Added

      keymap.BusinessPartner as WorkAssignmentBusinessPartner, //Employment BP


      'B'                    as BPRoleCategoryUsageCode //Business

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

Learn More