I_WorkAssignmentDetail

DDL: I_WORKASSIGNMENTDETAIL Type: view_entity BASIC Package: VDM_WFD_WORK_FORCE

Work Assignment Details

I_WorkAssignmentDetail is a Basic CDS View that provides data about "Work Assignment Details" in SAP S/4HANA. It reads from 2 data sources (I_WorkAssignmentDetailsAll, I_WorkAssignmentKeyMapping) and exposes 15 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode, WorkAssignmentStartDate. It has 2 associations to related views. Part of development package VDM_WFD_WORK_FORCE.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkAssignmentDetailsAll WorkAssignmentDetails from
I_WorkAssignmentKeyMapping WorkAssignmentKeymap inner

Associations (2)

CardinalityTargetAliasCondition
[1] I_WorkAssignment_1 _WorkAssignment $projection.WorkAssignmentExternalID = _WorkAssignment.WorkAssignmentExternalID and $projection.Country2DigitISOCode = _WorkAssignment.Country2DigitISOCode
[0..1] I_WorkforcePerson_1 _WorkforcePerson $projection.WorkforcePersonExternalID = _WorkforcePerson.WorkforcePersonExternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Work Assignment Details view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #NONE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
KEY Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
KEY WorkAssignmentStartDate I_WorkAssignmentDetailsAll WorkAssignmentStartDate
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
WorkAssignmentEndDate I_WorkAssignmentDetailsAll WorkAssignmentEndDate
CompanyCode I_WorkAssignmentDetailsAll CompanyCode
CostCenter I_WorkAssignmentDetailsAll CostCenter
SupervisorWorkAssignmentExtID I_WorkAssignmentDetailsAll SupervisorWorkAssignmentExtID
WeeklyWorkingHours I_WorkAssignmentDetailsAll WeeklyWorkingHours
WeeklyWorkingDays I_WorkAssignmentDetailsAll WeeklyWorkingDays
WorkAssignmentStatus I_WorkAssignmentDetailsAll WorkAssignmentStatus
EmploymentPercent I_WorkAssignmentDetailsAll EmploymentPercent
IsBlocked I_WorkAssignmentKeyMapping IsBlocked
_WorkAssignment _WorkAssignment
_WorkforcePerson _WorkforcePerson 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Work Assignment Details'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L
}
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,#CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern:#NONE
define view entity I_WorkAssignmentDetail
  as select from I_WorkAssignmentDetailsAll as WorkAssignmentDetails
    inner join   I_WorkAssignmentKeyMapping as WorkAssignmentKeymap on WorkAssignmentDetails.WorkAssignment = WorkAssignmentKeymap.WorkAssignment

  association [1]    to I_WorkAssignment_1  as _WorkAssignment  on  $projection.WorkAssignmentExternalID = _WorkAssignment.WorkAssignmentExternalID
                                                                and $projection.Country2DigitISOCode     = _WorkAssignment.Country2DigitISOCode
  association [0..1] to I_WorkforcePerson_1 as _WorkforcePerson on  $projection.WorkforcePersonExternalID = _WorkforcePerson.WorkforcePersonExternalID

{
  key WorkAssignmentKeymap.WorkAssignmentExternalID,
  key WorkAssignmentKeymap.Country2DigitISOCode,
  key WorkAssignmentDetails.WorkAssignmentStartDate,
      WorkAssignmentKeymap.WorkforcePersonExternalID,
      WorkAssignmentDetails.WorkAssignmentEndDate,
      WorkAssignmentDetails.CompanyCode,
      WorkAssignmentDetails.CostCenter,
      WorkAssignmentDetails.SupervisorWorkAssignmentExtID,
      WorkAssignmentDetails.WeeklyWorkingHours,
      WorkAssignmentDetails.WeeklyWorkingDays,
      @Semantics.booleanIndicator: true
      WorkAssignmentDetails.WorkAssignmentStatus,
      WorkAssignmentDetails.EmploymentPercent,
      @Semantics.booleanIndicator: true
      @UI.hidden: true
      WorkAssignmentKeymap.IsBlocked,

      // Associations //

      _WorkAssignment,
      _WorkforcePerson
}
where
  WorkAssignmentDetails.CompanyCode is not initial

Learn More