P_PERSONWORKAGRMTTOECID

CDS View

P_PERSONWORKAGRMTTOECID is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PersonWorkAgrmtToExternalID view left_outer BASIC 
@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