I_WORKFORCEASSIGNMENTDETAILS

CDS View

Workforce Assignment Details

I_WORKFORCEASSIGNMENTDETAILS is a CDS View in S/4HANA. Workforce Assignment Details. It contains 13 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 13 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_WorkerSearch view inner COMPOSITE Workforce CDS view for OP
I_WorkForcePersonSearch view inner COMPOSITE Workforce Person basic details
P_PrimaryCostAssignments view from COMPOSITE
R_WorkAssignmentDetailsTP view_entity from TRANSACTIONAL Work Assignment Details TP

Fields (13)

KeyField CDS FieldsUsed in Views
KEY WorkforceAssgmtStartDate StartDate,WorkforceAssgmtStartDate 2
KEY WorkforceAssignment WorkAssignment 2
CompanyCode CompanyCode 2
CostCenter CostCenter 3
EmploymentPercent EmploymentPercent 1
ManagerAssignmentExternalID ManagerEmployee 1
ManagerAssignmentID ManagerAssignmentID 1
WeeklyWorkingDays WeeklyWorkingDays 1
WeeklyWorkingHours WeeklyWorkingHours 1
WorkforceAssgmtEndDate EndDate,WorkforceAssgmtEndDate 2
WorkforceAssignmentStatus WorkforceAssignmentStatus 1
WorkforcePersonJobCode Job,WorkforcePersonJobCode 2
WorkforcePersonJobTitle WorkforcePersonJobTitle 1 
@AbapCatalog.sqlViewName: 'IWRKFCASSGMTDETS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC
}
@ObjectModel: {
   semanticKey: ['WorkforceAssignment', 'WorkforceAssgmtStartDate'],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #M
   }
}
@EndUserText.label: 'Workforce Assignment Details'
define view I_WorkforceAssignmentDetails
  as select from wfd_d_assgmtdets
  association [1..1] to I_WorkforceAssignment        as _WorkforceAssignment       on  $projection.WorkforceAssignment = _WorkforceAssignment.WorkforceAssignment
  association [0..1] to I_WorkforceAssignmentStatus  as _WorkforceAssignmentStatus on  $projection.WorkforceAssignmentStatus = _WorkforceAssignmentStatus.WorkforceAssignmentStatus
  association [1]    to I_CompanyCode                as _CompanyCode   on $projection.CompanyCode  = _CompanyCode.CompanyCode
  association [1]    to I_CostCenter  as _CostCenter on  $projection.CostCenter  = _CostCenter.CostCenter
                                                    and $projection.CompanyCode     = _CostCenter.CompanyCode
                                                    and _CostCenter.ValidityStartDate   <= $projection.WorkforceAssgmtEndDate
                                                    and _CostCenter.ValidityEndDate     >= $projection.WorkforceAssgmtEndDate
  association [1]    to E_WorkforceAssignmentDetails as _Extension                 on  $projection.WorkforceAssignment      = _Extension.WorkforceAssignment
                                                                                   and $projection.WorkforceAssgmtStartDate = _Extension.WorkforceAssgmtStartDate
{
  key workforce_assgmt_id            as WorkforceAssignment,
  key start_date                     as WorkforceAssgmtStartDate,
      end_date                       as WorkforceAssgmtEndDate,
      @ObjectModel.foreignKey.association: '_WorkforceAssignmentStatus'
      employment_status              as WorkforceAssignmentStatus,
      employment_percent             as EmploymentPercent,
      company_code                   as CompanyCode,
      cost_center                    as CostCenter,
      controlling_area               as ControllingArea,
      weekly_working_hours           as WeeklyWorkingHours,
      weekly_working_days            as WeeklyWorkingDays,
      job_title                      as WorkforcePersonJobTitle,
      job_code                       as WorkforcePersonJobCode,
      manager_work_assgmt            as ManagerAssignmentID,
      country                        as Country2DigitISOCode,
      manager_work_assignment_ext_id as ManagerAssignmentExternalID,
      main_employment_indicator      as WorkforceAssignmentIsPrimary,
//      _CompanyCode.CompanyCodeName  as CompanyCodeName,

      _CompanyCode,
//      _CostCenter._Text[1: Language = $session.system_language ].CostCenterName  as CostCenterName, 

      _CostCenter,
//      _WorkforceAssignmentStatus._Text[1: Language = $session.system_language ].AssignmentStatusText as AssignmentStatusText,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
                                      #TO_COMPOSITION_ROOT]
      _WorkforceAssignment,
      _WorkforceAssignmentStatus
}  
where
//      company_code is not initial and   

  block_ind    = ' ' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMTDETS"
],
"ASSOCIATED":
[
"E_WORKFORCEASSIGNMENTDETAILS",
"I_COMPANYCODE",
"I_COSTCENTER",
"I_WORKFORCEASSIGNMENT",
"I_WORKFORCEASSIGNMENTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More