I_WorkAssgmtToExtIDDEX

DDL: I_WORKASSGMTTOEXTIDDEX Type: view_entity BASIC Package: VDM_WFD_WORK_FORCE

Ext IDs of Work Assgmt and Wrkfrc Person

I_WorkAssgmtToExtIDDEX is a Basic CDS View that provides data about "Ext IDs of Work Assgmt and Wrkfrc Person" in SAP S/4HANA. It reads from 2 data sources (wfd_d_assgmt, wfd_d_keymap) and exposes 5 fields with key field WorkAssignment. Part of development package VDM_WFD_WORK_FORCE.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
wfd_d_assgmt assgmt inner
wfd_d_keymap keymap from

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 #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name WorkAssignment view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Ext IDs of Work Assgmt and Wrkfrc Person view

Fields (5)

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 
@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: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.sapObjectNodeType.name:'WorkAssignment'

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Ext IDs of Work Assgmt and Wrkfrc Person'

define view entity I_WorkAssgmtToExtIDDEX
  as select from wfd_d_keymap as keymap
    inner join   wfd_d_assgmt as assgmt on keymap.workforce_assgmt_id = assgmt.workforce_assgmt_id
{
  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
}
where
      keymap.block_ind = ''
  and assgmt.block_ind = ''

Learn More