P_EntProjSdm238

DDL: P_ENTPROJSDM238 Type: view_entity BASIC

SDM: Private CDS View for Project Name

P_EntProjSdm238 is a Basic CDS View that provides data about "SDM: Private CDS View for Project Name" in SAP S/4HANA. It reads from 4 data sources (proj, /s4ppm/project, /s4ppm/task, prps) and exposes 11 fields with key field task_guid.

4 data source(s) 11 fields

Data Sources (4)

SourceAliasJoin Type
proj proj inner
/s4ppm/project s4p from
/s4ppm/task s4t inner
prps wbs inner

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label SDM: Private CDS View for Project Name view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY task_guid /s4ppm/task guid
project_guid /s4ppm/project guid
task_pspnr prps pspnr
external_id /s4ppm/task external_id
object_type /s4ppm/task object_type
pro_category /s4ppm/project pro_category
name /s4ppm/task name
post1 proj post1
cpcurr proj cpcurr
currency cpd currency
sdm_version 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'SDM: Private CDS View for Project Name'
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL }

define view entity P_EntProjSdm238
  as select from           /s4ppm/project as s4p
    inner join             /s4ppm/task    as s4t on  s4t.project_guid    =  s4p.guid
                                                 and s4t.object_type     =  'DPO'
                                                 and s4t.proc_status_own <> '42'
    inner join             prps           as wbs on wbs.pspnr = s4t.pspnr
    inner join             proj                  on proj.pspnr = s4p.pspnr
    left outer to one join /cpd/d_pfp_ph  as cpd on  s4p.pro_category = '7'
                                                 and cpd.mp_id_int    = s4p.guid
{
  key s4t.guid                       as task_guid,
      s4p.guid                       as project_guid,
      wbs.pspnr                      as task_pspnr,
      s4p.pspnr                      as project_pspnr,
      s4t.external_id                as external_id,
      s4t.object_type                as object_type,
      s4p.pro_category               as pro_category,

      s4t.name,
      proj.post1,

      proj.cpcurr,
      cpd.currency,

      cast( '00' as abap.char( 2 ) ) as sdm_version
}

where
  (
            s4p.pro_category =  '7'
    and(
            s4t.name         <> proj.post1
      or(
            cpd.db_key       is not null
        and proj.cpcurr      <> cpd.currency
      )
    )
  )
  or(
            s4p.pro_category =  '6'
    and     s4t.name         <> proj.post1
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/CPD/D_PFP_PH",
"/S4PPM/PROJECT",
"/S4PPM/TASK",
"PROJ",
"PRPS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More