I_WORKASSIGNMENTDETAILSALL

CDS View

Work Assignment Details

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

Used by 14 CDS view(s) 16 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_WorkAssgmtDetsDEX_1 view_entity from BASIC Workforce Person Assignment Details
I_WorkAssignmentDetail view_entity from BASIC Work Assignment Details
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person
P_PERSONWORKAGRMTORGLDETAILS1 view_entity from COMPOSITE ZI_PersonWorkAgrmtOrglDetails1
P_PERSONWORKAGRMTORGLDETAILS1 view_entity union_all COMPOSITE ZI_PersonWorkAgrmtOrglDetails1
P_WFD_EMPLOYMENT view_entity inner COMPOSITE Get minimum Active employment
P_WFD_GET_MINEPERNR_MAIN_EMP view_entity inner COMPOSITE Get min. Active pernr with Main Emp
P_WFD_GET_MINEPERNR_NMAIN_EMP view_entity inner COMPOSITE Get minimum Active pernr with Main Employment flag
P_WorkAssignmentActiveJobDets view_entity inner COMPOSITE Work Assignment Active Job Details
P_WorkAssignmentCostCenterDets view_entity from COMPOSITE Work Assignment Details with Cost Center
P_WorkAssignmentCostCenterDets view_entity union_all COMPOSITE Work Assignment Details with Cost Center
P_WRKASSGMTDETSCOSTCENTER view_entity from COMPOSITE P_WRKASSGMTDETSCOSTCENTER
R_WorkAssgmtAltCostAssgmt view_entity inner BASIC Alternate Cost Object for Wrk Assignment
R_WorkAssignmentListSummary view_entity inner COMPOSITE Work Assignment Summary List

Fields (16)

KeyField CDS FieldsUsed in Views
KEY WorkAssignment EmploymentInternalID,WorkAssignment 3
KEY WorkAssignmentStartDate StartDate,WorkAssignmentStartDate 7
CompanyCode CompanyCode 8
ControllingArea ControllingArea 1
CostCenter CostCenter 7
Country2DigitISOCode Country2DigitISOCode 1
EmploymentPercent EmploymentPercent 3
SupervisorWorkAssignmentExtID ManagerEmployee,SupervisorWorkAssignmentExtID 4
SupervisorWorkAssignmentID ManagerAssignmentID 1
WeeklyWorkingDays WeeklyWorkingDays 3
WeeklyWorkingHours WeeklyWorkingHours 3
WorkAssignmentEndDate EndDate,WorkAssignmentEndDate 7
WorkAssignmentStatus WorkAssignmentStatus 2
WorkforceAssignmentIsPrimary WorkforceAssignmentIsPrimary 1
WorkforcePersonJobCode Job,WorkforcePersonJobCode 3
WorkforcePersonJobTitle WorkforcePersonJobTitle 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 and technical_inactive_ind is initial

Learn More