I_WORKASSIGNMENTDETAILSALL

CDS View

Work Assignment Details

I_WORKASSIGNMENTDETAILSALL is a CDS View in S/4HANA. Work Assignment Details. It contains 6 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 6 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person

Fields (6)

KeyField CDS FieldsUsed in Views
KEY WorkAssignmentStartDate WorkAssignmentStartDate 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
Country2DigitISOCode Country2DigitISOCode 1
WorkAssignmentEndDate WorkAssignmentEndDate 1
WorkforcePersonJobCode Job 1 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Assignment Details'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MASTER
}
define view entity I_WorkAssignmentDetailsAll as select from wfd_d_assgmtdets
{

  key workforce_assgmt_id            as WorkAssignment,
  key start_date                     as WorkAssignmentStartDate,
      end_date                       as WorkAssignmentEndDate,
      @Semantics.booleanIndicator      
      employment_status              as WorkAssignmentStatus,
      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 SupervisorWorkAssignmentID,
      country                        as Country2DigitISOCode,
      manager_work_assignment_ext_id as SupervisorWorkAssignmentExtID,
      @Semantics.booleanIndicator
      main_employment_indicator      as WorkforceAssignmentIsPrimary,
      block_ind                      as IsBlocked   
}
where company_code is not initial

Learn More