I_WorkAssignmentDEX_1

DDL: I_WORKASSIGNMENTDEX_1 Type: view_entity BASIC Package: VDM_WFD_WORK_FORCE

Work Assignments

I_WorkAssignmentDEX_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 10 fields with key field WorkAssignment. It has 2 associations to related views. Part of development package VDM_WFD_WORK_FORCE.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkAssignmentKeyMapping WorkAssignmentKeymap from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_WorkAssgmtDetsDEX_1 _WorkAssignmentDetail WorkAssignmentKeymap.WorkAssignment = _WorkAssignmentDetail.WorkAssignment
[1] I_WorkforcePersonDEX_1 _WorkforcePerson $projection.WorkforcePersonExternalID = _WorkforcePerson.WorkforcePersonExternalID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #BASIC view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name WorkAssignment view
EndUserText.label Work Assignments view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment I_WorkAssignmentKeyMapping WorkAssignment
WorkAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
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

@VDM.viewType: #BASIC

@Analytics:{
    dataExtraction:{
        enabled: true,
        delta.changeDataCapture:{
        
            mapping:[
               {
                    table: 'WFD_D_KEYMAP',
                    role:#MAIN,
                    viewElement: ['WorkAssignment'],
                    tableElement: ['workforce_assgmt_id']
               },
                          {
                    table: 'WFD_D_ASSGMT',
                    role:#LEFT_OUTER_TO_ONE_JOIN,
                    viewElement: ['WorkAssignment'],
                    tableElement: ['workforce_assgmt_id']
               }
            
            ]
        
        }
      }
    }

@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities:[ #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: #NONE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.sapObjectNodeType.name:'WorkAssignment'

@EndUserText.label: 'Work Assignments'

define view entity I_WorkAssignmentDEX_1
  as select from I_WorkAssignmentKeyMapping as WorkAssignmentKeymap

  association [1..*] to I_WorkAssgmtDetsDEX_1  as _WorkAssignmentDetail on WorkAssignmentKeymap.WorkAssignment = _WorkAssignmentDetail.WorkAssignment
  association [1] to I_WorkforcePersonDEX_1 as _WorkforcePerson      on $projection.WorkforcePersonExternalID = _WorkforcePerson.WorkforcePersonExternalID 
{


  key WorkAssignmentKeymap.WorkAssignment,
      WorkAssignmentKeymap.WorkAssignmentExternalID ,
      WorkAssignmentKeymap.Country2DigitISOCode,

      upper( WorkAssignmentKeymap.WorkforcePersonExternalID ) as WorkforcePersonExternalID,
//      WorkAssignmentKeymap.BusinessPartner,


      WorkAssignmentKeymap.WorkAssignmentStartDate,
      WorkAssignmentKeymap.WorkAssignmentEndDate,
      WorkAssignmentKeymap.IsContingentWorker,
      @Semantics.booleanIndicator: true
      @UI.hidden: true
      WorkAssignmentKeymap.IsBlocked,
      
//      WorkAssignment,


      // Associations //

      _WorkAssignmentDetail,
      _WorkforcePerson
}

Learn More