P_PersonWorkAgrmtToECId

DDL: P_PERSONWORKAGRMTTOECID SQL: PPERWKAGRECID Type: view BASIC

P_PersonWorkAgrmtToECId is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (wfd_d_new_pers, wfd_d_new_pers, wfd_d_keymap, wfd_d_keymap) and exposes 3 fields with key field PersonWorkAgreement.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
wfd_d_new_pers switch left_outer
wfd_d_new_pers switch inner
wfd_d_keymap wfd_d_keymap from
wfd_d_keymap wfd_d_keymap union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPERWKAGRECID view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement pa0105 pernr
workforce_assgmt_idasPersonWorkAgreement
PersonWorkAgreementExternalID wfd_d_keymap user_id 
@AbapCatalog.sqlViewName: 'PPERWKAGRECID'
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Internal view to get the ECUS ID'

@AbapCatalog.preserveKey:true
define view P_PersonWorkAgrmtToECId
  as select distinct from pa0105         as PA0105
    left outer join       wfd_d_new_pers as switch on pa0105.mandt = switch.mandt
{
  key pa0105.pernr      as PersonWorkAgreement,
      pa0105.usrid_long as PersonWorkAgreementExternalID
}
where
      pa0105.subty  =  'ECUS'
  and pa0105.sprps  <> 'X'

  and switch.switch is null
  or  switch.switch <> 'NEW'

union all select from wfd_d_keymap   as wfd_d_keymap
  inner join          wfd_d_new_pers as switch on wfd_d_keymap.client = switch.mandt
{
  key wfd_d_keymap.workforce_assgmt_id as PersonWorkAgreement,
      wfd_d_keymap.user_id            as PersonWorkAgreementExternalID
}
where
  switch.switch = 'NEW'
  and wfd_d_keymap.block_ind = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PA0105",
"WFD_D_KEYMAP",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More