P_EntProjSimilarProjData

DDL: P_ENTPROJSIMILARPROJDATA SQL: PEPSMLBDATA Type: view COMPOSITE Package: VDM_PPM_OBJ_ANLYTS_PROJCOST_ML

Nearest Projects Basic Data

P_EntProjSimilarProjData is a Composite CDS View that provides data about "Nearest Projects Basic Data" in SAP S/4HANA. It reads from 1 data source (R_EnterpriseProjectElement) and exposes 12 fields with key fields ProjectUUID, SimilarProjectUUID, ProjectInternalID, SimilarProjectInternalID. It has 4 associations to related views. Part of development package VDM_PPM_OBJ_ANLYTS_PROJCOST_ML.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
R_EnterpriseProjectElement SummaryTask inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_EnterpriseProject _ProjectRoot _ProjectRoot.ProjectUUID = _SimProjBasicData.ProjectUUID
[1..1] R_EnterpriseProject _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.ProjectElementUUID = _Responsible.ReferencedObjectUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PEPSMLBDATA view
AbapCatalog.compiler.compareFilter 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 _ProjectRoot ProjectInternalID
KEY SimilarProjectInternalID _SimilarProjectRoot ProjectInternalID
ProjectPredictedFactor _SimProjBasicData ProjectPredictedFactor
TaskUUID R_EnterpriseProjectElement ProjectElementUUID
SimilarProject _SimilarProjectRoot Project
PlannedStartDate _ProjectRoot PlannedStartDate
PlannedEndDate _ProjectRoot PlannedEndDate
CompanyCode _ProjectRoot CompanyCode
ControllingArea _ProjectRoot ControllingArea
Project _ProjectRoot Project 
@AbapCatalog.sqlViewName: 'PEPSMLBDATA'
@AbapCatalog.compiler.compareFilter: 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            R_EnterpriseProjectElement  as SummaryTask on _SimProjBasicData.SimilarProjectUUID = SummaryTask.ProjectUUID

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

  association [1..1] to R_EnterpriseProject         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.ProjectElementUUID = _Responsible.ReferencedObjectUUID
{

  key _SimProjBasicData.ProjectUUID         as ProjectUUID,
  key _SimProjBasicData.SimilarProjectUUID  as SimilarProjectUUID,
  key _ProjectRoot.ProjectInternalID,
  key _SimilarProjectRoot.ProjectInternalID as SimilarProjectInternalID,

      _SimProjBasicData.ProjectPredictedFactor,

      SummaryTask.ProjectElementUUID        as TaskUUID,
      _SimilarProjectRoot.Project           as SimilarProject,
      _ProjectRoot.PlannedStartDate,
      _ProjectRoot.PlannedEndDate,
      _ProjectRoot.CompanyCode,
      _ProjectRoot.ControllingArea,
      _ProjectRoot.Project,

      case
         when _ProjectInExecution.AmountInGlobalCurrency > 0
         then 'X'
         else ''
         end                                as ProjectIsInExecution

}
where
      SummaryTask.EntProjectElementObjectType =  'DPO'
  and _SimProjBasicData.ProjectUUID           <> _SimProjBasicData.SimilarProjectUUID

Learn More