I_WorkAssignment_1

DDL: I_WORKASSIGNMENT_1 Type: view_entity BASIC Package: VDM_WFD_WORK_FORCE

Work Assignments

I_WorkAssignment_1 is a Basic CDS View that provides data about "Work Assignments" in SAP S/4HANA. It reads from 1 data source (I_WorkAssignmentKeyMapping) and exposes 9 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode. It has 2 associations to related views. Part of development package VDM_WFD_WORK_FORCE.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkAssignmentKeyMapping WorkAssignmentKeymap from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_WorkAssignmentDetail _WorkAssignmentDetail $projection.WorkAssignmentExternalID = _WorkAssignmentDetail.WorkAssignmentExternalID and $projection.Country2DigitISOCode = _WorkAssignmentDetail.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 Assignments 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 (9)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
KEY Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
WorkAssignmentStartDate I_WorkAssignmentKeyMapping WorkAssignmentStartDate
WorkAssignmentEndDate I_WorkAssignmentKeyMapping WorkAssignmentEndDate
IsContingentWorker I_WorkAssignmentKeyMapping IsContingentWorker
IsBlocked I_WorkAssignmentKeyMapping IsBlocked
_WorkAssignmentDetail _WorkAssignmentDetail
_WorkforcePerson _WorkforcePerson 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Work Assignments'
@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_WorkAssignment_1
  as select from I_WorkAssignmentKeyMapping as WorkAssignmentKeymap

  association [1..*] to I_WorkAssignmentDetail as _WorkAssignmentDetail on  $projection.WorkAssignmentExternalID = _WorkAssignmentDetail.WorkAssignmentExternalID
                                                                        and $projection.Country2DigitISOCode     = _WorkAssignmentDetail.Country2DigitISOCode
  association [0..1] to I_WorkforcePerson_1    as _WorkforcePerson      on  $projection.WorkforcePersonExternalID = _WorkforcePerson.WorkforcePersonExternalID
{
  key WorkAssignmentKeymap.WorkAssignmentExternalID,
  key WorkAssignmentKeymap.Country2DigitISOCode,
      WorkAssignmentKeymap.WorkforcePersonExternalID,
      WorkAssignmentKeymap.WorkAssignmentStartDate,
      WorkAssignmentKeymap.WorkAssignmentEndDate,
//      WorkAssignmentKeymap.BusinessPartner,

      WorkAssignmentKeymap.IsContingentWorker,
      @Semantics.booleanIndicator: true
      @UI.hidden: true
      WorkAssignmentKeymap.IsBlocked,

      // Associations //

      _WorkAssignmentDetail,
      _WorkforcePerson
}

Learn More