P_EntProjSimilarProjData

DDL: P_ENTPROJSIMILARPROJDATA SQL: PEPSMLBDATA Type: view COMPOSITE

P_EntProjSimilarProjData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PPM_Task) and exposes 12 fields with key fields ProjectUUID, SimilarProjectUUID, ProjectInternalID, SimilarProjectInternalID. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_Task SummaryTask inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectRoot _ProjectRoot _ProjectRoot.ProjectUUID = _SimProjBasicData.ProjectUUID
[1..1] I_PPM_ProjectRoot _SimilarProjectRoot _SimilarProjectRoot.ProjectUUID = _SimProjBasicData.SimilarProjectUUID
[0..1] P_EnterpriseProjectActCosts _ProjectInExecution _ProjectInExecution.ProjectUUID = _SimProjBasicData.ProjectUUID and _ProjectInExecution.AmountInGlobalCurrency > 0 and _ProjectInExecution.IsSettled = 'X'
[0..1] I_SingleResponsibleForProj _Responsible SummaryTask.TaskUUID = _Responsible.ReferencedObjectUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEPSMLBDATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID _SimProjBasicData ProjectUUID
KEY SimilarProjectUUID _SimProjBasicData SimilarProjectUUID
KEY ProjectInternalID
KEY SimilarProjectInternalID
ProjectPredictedFactor _SimProjBasicData ProjectPredictedFactor
TaskUUID I_PPM_Task TaskUUID
SimilarProject
PlannedStartDate
PlannedEndDate
CompanyCode
ControllingArea
Project 
@AbapCatalog.sqlViewName: 'PEPSMLBDATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel: {
    usageType: {
       serviceQuality:  #D,
       dataClass:       #MIXED,
       sizeCategory:    #XL
   }
}
define view P_EntProjSimilarProjData
  as select distinct from I_EntProjSimilarProjBscData as _SimProjBasicData

    inner join            I_PPM_Task                  as SummaryTask on _SimProjBasicData.SimilarProjectUUID = SummaryTask.ProjectUUID

  association [1..1] to I_PPM_ProjectRoot            as _ProjectRoot        on  _ProjectRoot.ProjectUUID = _SimProjBasicData.ProjectUUID

  association [1..1] to I_PPM_ProjectRoot            as _SimilarProjectRoot on  _SimilarProjectRoot.ProjectUUID = _SimProjBasicData.SimilarProjectUUID

// P_EntProjActualCostLineItems 

  association [0..1] to P_EnterpriseProjectActCosts as _ProjectInExecution on  _ProjectInExecution.ProjectUUID            = _SimProjBasicData.ProjectUUID
                                                                            and _ProjectInExecution.AmountInGlobalCurrency > 0
                                                                            and _ProjectInExecution.IsSettled = 'X'
  association [0..1] to I_SingleResponsibleForProj   as _Responsible        on  SummaryTask.TaskUUID = _Responsible.ReferencedObjectUUID
{

  key _SimProjBasicData.ProjectUUID                                                                                    as ProjectUUID,
  key _SimProjBasicData.SimilarProjectUUID                                                                             as SimilarProjectUUID,
  key _ProjectRoot[1:inner]._I_Project.ProjectInternalID,
  key _SimilarProjectRoot[1:inner]._I_Project.ProjectInternalID                                                        as SimilarProjectInternalID,

      _SimProjBasicData.ProjectPredictedFactor,
      
       SummaryTask.TaskUUID,
      _SimilarProjectRoot[1:inner]._I_Project.Project                                                                  as SimilarProject,
      _ProjectRoot[1:inner]._I_Project.PlannedStartDate,
      _ProjectRoot[1:inner]._I_Project.PlannedEndDate,
      _ProjectRoot[1:inner]._I_Project.CompanyCode,
      _ProjectRoot[1:inner]._I_Project.ControllingArea,
      _ProjectRoot[1:inner]._I_Project.Project,
      
      case
         when _ProjectInExecution.AmountInGlobalCurrency > 0
         then 'X'
         else ''
         end                                                                                                           as ProjectIsInExecution
    
}
where
  SummaryTask.ObjectType = 'DPO'
  and _SimProjBasicData.ProjectUUID <> _SimProjBasicData.SimilarProjectUUID

Learn More