R_WorkAssgmtsBPIdentification

DDL: R_WORKASSGMTSBPIDENTIFICATION Type: view_entity COMPOSITE Package: WFD_WORKER_FACTSHEET_BL

Business Partner for Work Assignment

R_WorkAssgmtsBPIdentification is a Composite CDS View that provides data about "Business Partner for Work Assignment" in SAP S/4HANA. It reads from 3 data sources (I_WorkforceAssignment_1, R_WorkAssignmentBP, R_WorkAssignmentBP) and exposes 9 fields with key field WorkforceAssignment. Part of development package WFD_WORKER_FACTSHEET_BL.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_WorkforceAssignment_1 _WrkAssignment inner
R_WorkAssignmentBP _WrkAssignmentBP from
R_WorkAssignmentBP _WrkAssignmentBP union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Partner for Work Assignment 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_WorkAssignmentBP WorkforceAssignment
WorkforcePersonExternalID R_WorkAssignmentBP WorkforcePersonExternalID
BusinessPartner R_WorkAssignmentBP WorkAssignmentBusinessPartner
BPRoleCategoryUsageCode R_WorkAssignmentBP BPRoleCategoryUsageCode
WorkforceAssignment
WorkforcePersonExternalID R_WorkAssignmentBP WorkforcePersonExternalID
BusinessPartner R_WorkAssignmentBP WorkAssignmentBusinessPartner
BPRoleCategoryUsageCode R_WorkAssignmentBP BPRoleCategoryUsageCode
BPIdentificationType 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business Partner for Work Assignment'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity R_WorkAssgmtsBPIdentification as select from R_WorkAssignmentBP    as _WrkAssignmentBP
    inner join   I_WorkforceAssignment_1 as _WrkAssignment on _WrkAssignmentBP.WorkforceAssignment = _WrkAssignment.WorkforceAssignment
{
  key _WrkAssignmentBP.WorkforceAssignment,
      _WrkAssignmentBP.WorkforcePersonExternalID,
      _WrkAssignmentBP.WorkAssignmentBusinessPartner         as BusinessPartner,
      _WrkAssignmentBP.BPRoleCategoryUsageCode as BPRoleCategoryUsageCode,
//      _WrkAssignment.WorkforceAssgmtStartDate  as StartDate,

//      _WrkAssignment.WorkforceAssgmtEndDate    as EndDate,

      case  _WrkAssignment.IsContingentWorker
       when 'X'
        then 'HCM030'
       else
        'HCM001'
       end                                     as BPIdentificationType
}
where
  _WrkAssignmentBP.BPRoleCategoryUsageCode = 'B'  //Old BP model

union all select from R_WorkAssignmentBP    as _WrkAssignmentBP
//  inner join      I_WorkforceAssignment as _WrkAssignment on _WrkAssignmentBP.WorkforceAssignment = _WrkAssignment.WorkforceAssignment

{
  key _WrkAssignmentBP.WorkforceAssignment,
      _WrkAssignmentBP.WorkforcePersonExternalID,
      _WrkAssignmentBP.WorkAssignmentBusinessPartner      as BusinessPartner,
      _WrkAssignmentBP.BPRoleCategoryUsageCode as BPRoleCategoryUsageCode,
//      _WrkAssignment.WorkforceAssgmtStartDate  as StartDate,

//      _WrkAssignment.WorkforceAssgmtEndDate    as EndDate,

      'HCM033'                                 as BPIdentificationType
}
where
  _WrkAssignmentBP.BPRoleCategoryUsageCode = 'C'  //New BP model

Learn More