P_J_PDOBJECT

DDL: P_J_PDOBJECT SQL: PJPDOBJECT Type: view BASIC

P_J_PDOBJECT is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (wfd_d_jobcodet, hrp1000, wfd_d_new_pers, wfd_d_new_pers) and exposes 15 fields with key fields PlanVersion, ObjectType, ObjectID, ObjectType, ObjectID.

4 data source(s) 15 fields

Data Sources (4)

SourceAliasJoin Type
wfd_d_jobcodet new union_all
hrp1000 object from
wfd_d_new_pers switch left_outer
wfd_d_new_pers switch inner

Annotations (6)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PJPDOBJECT view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PlanVersion hrp1000 plvar
KEY ObjectType hrp1000 otype
KEY ObjectID hrp1000 objid
ObjectStatus hrp1000 istat
StartDate hrp1000 begda
EndDate hrp1000 endda
Name hrp1000 short
mandtkeyasPlanVersion
KEY ObjectType
KEY ObjectID
ObjectStatus
StartDate start_date
EndDate end_date
Name
Language 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PJPDOBJECT'
@VDM.viewType: #BASIC
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_J_PDOBJECT

  as select from    hrp1000        as object
    left outer join wfd_d_new_pers as switch on object.mandt = switch.mandt

{
  key object.plvar as PlanVersion,
  key object.otype as ObjectType,
  key object.objid as ObjectID,

      object.istat as ObjectStatus,

      object.begda as StartDate,
      object.endda as EndDate,
      //object.stext as Name

      object.short as Name,
      object.langu as Language
      //    _Relation

}
where
     switch.switch is null
  or switch.switch <> 'NEW'

union all select from wfd_d_jobcodet as new
  inner join          wfd_d_new_pers as switch on new.client = switch.mandt

{
  key ''                                                               as PlanVersion,
  key 'C'                                                              as ObjectType,
  key cast( job_code  as abap.numc( 8 )  )                             as ObjectID,

      ''                                                               as ObjectStatus,

      start_date                                                       as StartDate,
      end_date                                                         as EndDate,
      //object.stext as Name

      cast( job_title    as  abap.char( 12 )  )                        as Name,
      coalesce(  cast ($session.system_language as langu ), language ) as Language
      //    _Relation

}
where
  switch.switch = 'NEW'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1000",
"WFD_D_JOBCODET",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More