P_WorkAssignmentActiveJobDets

DDL: P_WORKASSIGNMENTACTIVEJOBDETS Type: view_entity COMPOSITE Package: VDM_WFD_WORK_FORCE

Work Assignment Active Job Details

P_WorkAssignmentActiveJobDets is a Composite CDS View that provides data about "Work Assignment Active Job Details" in SAP S/4HANA. It reads from 2 data sources (I_WorkAssignmentDetailsAll, I_WorkAssignmentKeyMapping) and exposes 16 fields with key fields WorkAssignment, WorkAssignmentStartDate. Part of development package VDM_WFD_WORK_FORCE.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkAssignmentDetailsAll dets inner
I_WorkAssignmentKeyMapping keymap from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment I_WorkAssignmentKeyMapping WorkAssignment
KEY WorkAssignmentStartDate I_WorkAssignmentDetailsAll WorkAssignmentStartDate
WorkAssignmentEndDate I_WorkAssignmentDetailsAll WorkAssignmentEndDate
BusinessPartner I_WorkAssignmentKeyMapping BusinessPartner
WorkAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
CompanyCode I_WorkAssignmentDetailsAll CompanyCode
CompanyCodeName CompanyCode CompanyCodeName
CostCenter I_WorkAssignmentDetailsAll CostCenter
Job I_WorkAssignmentDetailsAll WorkforcePersonJobCode
JobName JobText JobName
EmploymentPercent I_WorkAssignmentDetailsAll EmploymentPercent
WeeklyWorkingDays I_WorkAssignmentDetailsAll WeeklyWorkingDays
WeeklyWorkingHours I_WorkAssignmentDetailsAll WeeklyWorkingHours
SupervisorWorkAssignmentExtID I_WorkAssignmentDetailsAll SupervisorWorkAssignmentExtID 
/***Only for Private Consumption in I_ActiveWorkAssignmentsVH***/
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MASTER
}
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_WorkAssignmentActiveJobDets 
   as select from  I_WorkAssignmentKeyMapping as keymap
        inner join I_WorkAssignmentDetailsAll  as dets on keymap.WorkAssignment = dets.WorkAssignment
        left outer to one join I_CompanyCode as CompanyCode on dets.CompanyCode = CompanyCode.CompanyCode
        left outer to one join I_PersonWorkAgrmtJobText as JobText          on JobText.Job        = dets.WorkforcePersonJobCode
                                                                           and JobText.EndDate   >= dets.WorkAssignmentEndDate
                                                                           and JobText.StartDate <= dets.WorkAssignmentEndDate
                                                                           and JobText.Language   = $session.system_language 
 {
   key keymap.WorkAssignment,
   key dets.WorkAssignmentStartDate,
       dets.WorkAssignmentEndDate,
       keymap.BusinessPartner,
       keymap.WorkAssignmentExternalID,
       keymap.Country2DigitISOCode,
       keymap.WorkforcePersonExternalID,
       dets.CompanyCode,
       CompanyCode.CompanyCodeName,
       dets.CostCenter,
       dets.WorkforcePersonJobCode as Job,  
       JobText.JobName,    
       dets.EmploymentPercent,
       dets.WeeklyWorkingDays,
       dets.WeeklyWorkingHours,
       dets.SupervisorWorkAssignmentExtID       
 }
where 
  dets.WorkAssignmentStatus   = '1' and 
  dets.WorkAssignmentEndDate >= $session.system_date and
  keymap.IsBlocked  = ' ' and 
  dets.IsBlocked    = ' '

Learn More