R_WorkAssignmentBP

DDL: R_WORKASSIGNMENTBP Type: view_entity COMPOSITE

Work assignment all models

R_WorkAssignmentBP is a Composite CDS View that provides data about "Work assignment all models" in SAP S/4HANA. It reads from 3 data sources (I_BuPaIdentification, R_WorkAssignmentKeyMap, R_WorkAssignmentKeyMap) and exposes 9 fields with key field WorkforceAssignment.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_BuPaIdentification _BuPaIdentification inner
R_WorkAssignmentKeyMap keymap from
R_WorkAssignmentKeyMap keymap union

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work assignment all models view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignment R_WorkAssignmentKeyMap WorkforceAssignment
WorkforcePersonExternalID R_WorkAssignmentKeyMap WorkforcePersonExternalID
BusinessPartner R_WorkAssignmentKeyMap BusinessPartner
WorkAssignmentBusinessPartner I_BuPaIdentification BusinessPartner
WorkforceAssignment
WorkforcePersonExternalID R_WorkAssignmentKeyMap WorkforcePersonExternalID
BusinessPartner R_WorkAssignmentKeyMap BusinessPartner
WorkAssignmentBusinessPartner R_WorkAssignmentKeyMap BusinessPartner
BPRoleCategoryUsageCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Work assignment all models'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}


@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

define view entity R_WorkAssignmentBP
  as select 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 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