C_ActiveProjectOvrlSts

DDL: C_ACTIVEPROJECTOVRLSTS SQL: CACTPROJOVRLSTS Type: view CONSUMPTION
27 Fields 3 Associations

All active Projects - Overall Status

C_ActiveProjectOvrlSts is a Consumption CDS View that provides data about "All active Projects - Overall Status" in SAP S/4HANA. It has 3 associations to related views.

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SingleResponsibleForProj _Responsible $projection.ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID
[0..1] I_EnterpriseProject _EnterpriseProject $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
[1..1] E_PPM_Project _ProjectHeaderExtension $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CACTPROJOVRLSTS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.preserveKey true view
EndUserText.label All active Projects - Overall Status view
Consumption.semanticObject EnterpriseProject view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
UI.headerInfo.typeName Project view
UI.headerInfo.typeNamePlural Projects view
UI.headerInfo.description.label Project ID view
UI.headerInfo.description.value Project view
UI.headerInfo.title.label Project Name view
UI.headerInfo.title.value ProjectName view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID Project UUID
KEY ProjectSummaryTaskUUID ProjectSummaryTaskUUID Entity GUID
IsOverallStatus ProjStatus IsOverallStatus Overall
ProjectName _Root ProjectName Long Text
Status ProjStatus Status Workflow Status
StatusTrend ProjStatus StatusTrend Trend
AreaTrendCriticality
OverallProjectStsCriticality _Root OverallProjectStsCriticality
Project _Root Project WBS Element
BusinessPartnerFullName _Responsible BusinessPartnerFullName Broker Name
BusinessPartnerUUID _Responsible BusinessPartnerUUID UUID
ProjectType _EnterpriseProject EnterpriseProjectType Proj.type
BusinessPartner
StatusAreaSortNumber
_AreaStatus ProjStatus _AreaStatus
_AreaStatusText ProjStatus _AreaStatusText
_AreaTrend ProjStatus _AreaTrend
_AreaTrendText ProjStatus _AreaTrendText
CompanyCode _EnterpriseProject CompanyCode Receiver Company Code
ControllingArea _EnterpriseProject ControllingArea Controlling Area
ProfitCenter _EnterpriseProject ProfitCenter Profit Center
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_Responsible _Responsible
_EnterpriseProject _EnterpriseProject

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ActiveProjectOvrlSts.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CACTPROJOVRLSTS

CREATE VIEW C_ActiveProjectOvrlSts AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjStatus.IsOverallStatus AS IsOverallStatus,
  _Root.ProjectName AS ProjectName,
  ProjStatus.Status AS Status,
  ProjStatus.StatusTrend AS StatusTrend,
  ProjStatus._AreaTrend.Criticality AS AreaTrendCriticality,
  _Root.OverallProjectStsCriticality AS OverallProjectStsCriticality,
  _Root.Project AS Project,
  _Responsible.BusinessPartnerFullName AS BusinessPartnerFullName,
  _Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _EnterpriseProject.EnterpriseProjectType AS ProjectType,
  _Responsible._BusinessUser.BusinessPartner AS BusinessPartner,
  ProjStatus._AreaStatus.SortField AS StatusAreaSortNumber,
  ProjStatus._AreaStatus AS _AreaStatus,
  ProjStatus._AreaStatusText AS _AreaStatusText,
  ProjStatus._AreaTrend AS _AreaTrend,
  ProjStatus._AreaTrendText AS _AreaTrendText,
  _EnterpriseProject.CompanyCode AS CompanyCode,
  _EnterpriseProject.ControllingArea AS ControllingArea,
  _EnterpriseProject.ProfitCenter AS ProfitCenter
LEFT OUTER JOIN I_SingleResponsibleForProj AS _Responsible ON ProjectSummaryTaskUUID = _Responsible.ReferencedObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProject AS _EnterpriseProject ON ProjectUUID = _EnterpriseProject.ProjectUUID  -- association [0..1]
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [1..1]
;

Learn More