I_WorkAssignmentBP

DDL: I_WORKASSIGNMENTBP Type: view_entity COMPOSITE

BP Details of Work Assignment

I_WorkAssignmentBP is a Composite CDS View that provides data about "BP Details of Work Assignment" in SAP S/4HANA. It reads from 3 data sources (I_BuPaIdentification, I_WorkAssignmentKeyMapping, I_WorkAssignmentKeyMapping) and exposes 9 fields with key field WorkAssignment.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_BuPaIdentification BuPaIdentification inner
I_WorkAssignmentKeyMapping keymap from
I_WorkAssignmentKeyMapping keymap union

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label BP Details of Work Assignment view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment I_WorkAssignmentKeyMapping WorkAssignment
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
BusinessPartner I_WorkAssignmentKeyMapping BusinessPartner
WorkAssignmentBusinessPartner I_BuPaIdentification BusinessPartner
WorkAssignment
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
BusinessPartner I_WorkAssignmentKeyMapping BusinessPartner
WorkAssignmentBusinessPartner I_WorkAssignmentKeyMapping BusinessPartner
IsBlocked I_WorkAssignmentKeyMapping IsBlocked 
@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