I_WorkAssignmentValidity

DDL: I_WORKASSIGNMENTVALIDITY Type: view_entity COMPOSITE Package: WFD_WORKER_FACTSHEET_BL

Work Assignment Validity for the Worker

I_WorkAssignmentValidity is a Composite CDS View that provides data about "Work Assignment Validity for the Worker" in SAP S/4HANA. It reads from 3 data sources (R_BPUsrRole, I_WorkforceAssignment_1, R_WorkAssgmtsBPIdentification) and exposes 5 fields with key field WorkAssignment. Part of development package WFD_WORKER_FACTSHEET_BL.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
R_BPUsrRole _BPRole inner
I_WorkforceAssignment_1 _WrkAssignment inner
R_WorkAssgmtsBPIdentification _WrkAssignmentBP from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Assignment Validity for the Worker 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 (5)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment R_WorkAssgmtsBPIdentification WorkforceAssignment
BusinessPartner R_WorkAssgmtsBPIdentification BusinessPartner
RoleCategory R_BPUsrRole RoleCategory
BasicRoleCategoryendasBasicRoleCategory
BusinessPartnerRole R_BPUsrRole BusinessPartnerRole 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Work Assignment Validity for the Worker'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_WorkAssignmentValidity
//  as select  from R_WorkAssignmentBP    as _WrkAssignmentBP

  as select  from R_WorkAssgmtsBPIdentification    as _WrkAssignmentBP
    inner join   R_BPUsrRole           as _BPRole        on  _BPRole.BusinessPartner         = _WrkAssignmentBP.BusinessPartner
                                                         and _BPRole.BPRoleCategoryUsageCode = _WrkAssignmentBP.BPRoleCategoryUsageCode
                                                         and _BPRole.BPIdentificationCategory = _WrkAssignmentBP.BPIdentificationType
    inner join   I_WorkforceAssignment_1 as _WrkAssignment on _WrkAssignment.WorkforceAssignment = _WrkAssignmentBP.WorkforceAssignment



{
  key _WrkAssignmentBP.WorkforceAssignment as WorkAssignment,
      _WrkAssignmentBP.BusinessPartner     as BusinessPartner,
      _BPRole.RoleCategory                 as RoleCategory,
      case _BPRole.BasicRoleCategory
      when ''
      then _BPRole.RoleCategory
      else
      _BPRole.BasicRoleCategory
      end                                  as BasicRoleCategory,
      _BPRole.BusinessPartnerRole          as BusinessPartnerRole,

      case _WrkAssignmentBP.BPRoleCategoryUsageCode
             when  'C'
            then _BPRole.BPUsrRoleValidFromDate
             when 'B'
         then _WrkAssignment.WorkforceAssgmtStartDate
      else null
              end                          as StartDate,
      case _WrkAssignmentBP.BPRoleCategoryUsageCode
              when  'C'
             then _BPRole.BPUsrRoleValidToDate
              when  'B'
              then _WrkAssignment.WorkforceAssgmtEndDate
      else null
              end                          as EndDate

}

Learn More