I_WorkAssignmentDEX

DDL: I_WORKASSIGNMENTDEX Type: view_entity BASIC

Work Assignments

I_WorkAssignmentDEX is a Basic CDS View that provides data about "Work Assignments" in SAP S/4HANA. It reads from 2 data sources (wfd_d_assgmt, wfd_d_keymap) and exposes 8 fields with key field WorkAssignment. It has 2 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
wfd_d_assgmt assgmt inner
wfd_d_keymap keymap from

Associations (2)

CardinalityTargetAliasCondition
[1] I_WorkforcePersonDEX _WorkforcePerson $projection.BusinessPartner = _WorkforcePerson.BusinessPartner
[1..*] I_WorkAssgmtDetsDEX _WorkAssgmtDets $projection.BusinessPartner = _WorkAssgmtDets.BusinessPartner

Annotations (11)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment wfd_d_keymap workforce_assgmt_id
WorkAssignmentStartDate wfd_d_assgmt start_date
WorkAssignmentEndDate wfd_d_assgmt end_date
WorkforcePersonExternalID wfd_d_keymap person_id_external
WorkAssignmentExternalID wfd_d_keymap user_id
BusinessPartner wfd_d_keymap business_partner_id
_WorkforcePerson _WorkforcePerson
_WorkAssgmtDets _WorkAssgmtDets 
@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']
                }
            ]
        }
    }
@ObjectModel.supportedCapabilities:[ #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: #NONE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.sapObjectNodeType.name:'WorkAssignment'

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Work Assignments'

define view entity I_WorkAssignmentDEX
  as select from wfd_d_keymap as keymap
    inner join   wfd_d_assgmt as assgmt on keymap.workforce_assgmt_id = assgmt.workforce_assgmt_id
  association [1]    to I_WorkforcePersonDEX as _WorkforcePerson on $projection.BusinessPartner = _WorkforcePerson.BusinessPartner
  association [1..*] to I_WorkAssgmtDetsDEX  as _WorkAssgmtDets  on $projection.BusinessPartner = _WorkAssgmtDets.BusinessPartner

{
  key keymap.workforce_assgmt_id as WorkAssignment,

      assgmt.start_date          as WorkAssignmentStartDate,
      assgmt.end_date            as WorkAssignmentEndDate,
      keymap.person_id_external  as WorkforcePersonExternalID,
      keymap.user_id             as WorkAssignmentExternalID,
      keymap.business_partner_id as BusinessPartner,
      @EndUserText.label: 'Contingent Worker Flag'
      @Semantics.booleanIndicator:true
      case when assgmt.is_contingent_worker <> ''
      then 'X'
      else ''
      end                        as IsContingentWorker,
      _WorkforcePerson,
      _WorkAssgmtDets
}

where
      keymap.block_ind = ''
  and assgmt.block_ind = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMT",
"WFD_D_KEYMAP"
],
"ASSOCIATED":
[
"I_WORKASSGMTDETSDEX",
"I_WORKFORCEPERSONDEX"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More