I_WORKASSIGNMENTVALIDITY

CDS View

Work Assignment Validity for the Worker

I_WORKASSIGNMENTVALIDITY is a CDS View in S/4HANA. Work Assignment Validity for the Worker. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkAssignment view_entity inner COMPOSITE Work Assignment for Worker Factsheet
R_WorkAssignmentListSummary view_entity inner COMPOSITE Work Assignment Summary List

Fields (6)

KeyField CDS FieldsUsed in Views
BasicRoleCategory BasicRoleCategory 2
BusinessPartner WorkAssignmentBusinessPartner 1
BusinessPartnerRole BusinessPartnerRole 2
EndDate EndDate 1
RoleCategory RoleCategory 1
StartDate StartDate 1 
@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