C_MasterProjectBasicData

DDL: C_MASTERPROJECTBASICDATA SQL: CMPBASICDATA Type: view CONSUMPTION

Basic Data - Single Project Overview Screen

C_MasterProjectBasicData is a Consumption CDS View that provides data about "Basic Data - Single Project Overview Screen" in SAP S/4HANA. It reads from 1 data source (I_MasterProject) and exposes 14 fields with key field ProjectUUID. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_MasterProject I_MasterProject from

Associations (2)

CardinalityTargetAliasCondition
[1..1 ] I_MstrProjNmbrOfPurReqns _MPPRCount $projection.MasterProject = _MPPRCount.MasterProject
[1..1] I_MstrProjNmbrOfOvrdPurOrds _MPPOCount $projection.MasterProject = _MPPOCount.MasterProject

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPBASICDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic Data - Single Project Overview Screen view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_MasterProject ProjectUUID
MasterProjectUUID I_MasterProject MasterProjectUUID
MasterProject I_MasterProject MasterProject
MasterProjectName I_MasterProject MasterProjectName
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
MasterProjectType I_MasterProject MasterProjectType
MasterProjectOrganization I_MasterProject MasterProjectOrganization
ChangeRequest I_Mstrprojissuechangreq ChangeRequest
Issue I_Mstrprojissuechangreq Issue
NmbrOfActiesDueInNextWeek I_ActivitiesDueInNextWeek NmbrOfActiesDueInNextWeek
MstrProjActiveRiskCount I_ActiveRisk MstrProjActiveRiskCount
NumberOfOverdueActivities I_ODActivity NumberOfOverdueActivities
NumberOfPurchaseRequisitions _MPPRCount NumberOfPurchaseRequisitions
NumberOfPurchaseOrders _MPPOCount NumberOfPurchaseOrders 
@AbapCatalog.sqlViewName: 'CMPBASICDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label:'Basic Data - Single Project Overview Screen'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory:#XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.dbHints: [{dbSystem: #HDB,
                        hint:     'NO_RECOMPILE_WITH_SQL_PARAMETERS'}]
define view C_MasterProjectBasicData
  as select from    I_MasterProject
    left outer to one join I_Mstrprojissuechangreq   on I_MasterProject.MasterProject = I_Mstrprojissuechangreq.MasterProject
    left outer to one join I_ActiveRisk              on I_MasterProject.MasterProject = I_ActiveRisk.MasterProject
    left outer to one join I_ODActivity              on I_MasterProject.MasterProject = I_ODActivity.MasterProject
    left outer to one join I_ActivitiesDueInNextWeek on I_MasterProject.MasterProject = I_ActivitiesDueInNextWeek.MasterProject
    association [1..1 ] to I_MstrProjNmbrOfPurReqns as _MPPRCount on $projection.MasterProject = _MPPRCount.MasterProject
    association [1..1] to I_MstrProjNmbrOfOvrdPurOrds as _MPPOCount on $projection.MasterProject = _MPPOCount.MasterProject

//    left outer join I_MstrProjNmbrOfPurReqns  on I_MasterProject.ProjectUUID = I_MstrProjNmbrOfPurReqns.ProjectUUID

//    left outer join I_MstrProjNmbrOfOvrdPurOrds on I_MasterProject.ProjectUUID = I_MstrProjNmbrOfOvrdPurOrds.ProjectUUID

//    left outer join C_MstrProjPRCount         on I_MasterProject.MasterProject       = C_MstrProjPRCount.MasterProject

//    left outer join I_MstrProjPOOverdue       on I_MasterProject.MasterProject       = I_MstrProjPOOverdue.MasterProject

{
  key I_MasterProject.ProjectUUID,
  // key I_MasterProject.MasterProjectUUID_E,

      I_MasterProject.MasterProjectUUID,
      I_MasterProject.MasterProject,
      I_MasterProject.MasterProjectName,
      I_MasterProject.MasterProjectIsConfidential,
      I_MasterProject.MasterProjectType,
      I_MasterProject.MasterProjectOrganization,
      I_Mstrprojissuechangreq.ChangeRequest,
      I_Mstrprojissuechangreq.Issue,
      I_ActivitiesDueInNextWeek.NmbrOfActiesDueInNextWeek,
      I_ActiveRisk.MstrProjActiveRiskCount,
      I_ODActivity.NumberOfOverdueActivities,
//      I_MstrProjNmbrOfPurReqns.NumberOfPurchaseRequisitions,

//      I_MstrProjNmbrOfOvrdPurOrds.NumberOfPurchaseOrders

      _MPPRCount.NumberOfPurchaseRequisitions,
      _MPPOCount.NumberOfPurchaseOrders
      
//      _MPPRCount,

//      _MPPOCount 

      
}

Learn More