I_PPM_ProjectStatusAreaTP

DDL: I_PPM_PROJECTSTATUSAREATP SQL: IPPMPROSTATATP Type: view TRANSACTIONAL

PPM Status Area for Project Transactional Object View

I_PPM_ProjectStatusAreaTP is a Transactional CDS View that provides data about "PPM Status Area for Project Transactional Object View" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectStatusArea) and exposes 23 fields with key field StatusAreaUUID. It has 2 associations to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectStatusArea I_PPM_ProjectStatusArea from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTP _Root $projection.ProjectUUID = _Root.ProjectUUID ---Extension
[1..1] E_PPM_ProjectStatusArea _ProjectStatusExtension $projection.StatusAreaUUID = _ProjectStatusExtension.StatusAreaUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPROSTATATP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label PPM Status Area for Project Transactional Object View view
ObjectModel.writeDraftPersistence PPM_STAT_AREA_D view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.presentationVariant.sortOrder.by SortField view
UI.presentationVariant.sortOrder.direction #ASC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY StatusAreaUUID StatusAreaUUID
ProjectUUID ProjectUUID
ProjectSummaryTaskUUID ProjectSummaryTaskUUID
WBSElementInternalID WBSElementInternalID
StatusArea StatusArea
Status Status
StatusTrend StatusTrend
Comments Comments
SortField SortField
IsOverallStatus IsOverallStatus
Criticality Criticality
_Area _Area
_AreaText _AreaText
_AreaStatus _AreaStatus
_AreaStatusText _AreaStatusText
_AreaTrend _AreaTrend
_AreaTrendText _AreaTrendText
_Root _Root
_ProjObjRoot _ProjObjRoot
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup 
@AbapCatalog.sqlViewName: 'IPPMPROSTATATP'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'PPM Status Area for Project Transactional Object View'
@ObjectModel:
  {
    writeDraftPersistence: 'PPM_STAT_AREA_D',
    updateEnabled: true,
    deleteEnabled: true,
    semanticKey:  [ 'StatusArea' ],
    usageType:
    {
      serviceQuality: #C, 
      sizeCategory: #L,
      dataClass: #TRANSACTIONAL
    }
  }
@UI.presentationVariant.sortOrder: { by: 'SortField', direction: #ASC } 
define view I_PPM_ProjectStatusAreaTP as select from I_PPM_ProjectStatusArea
  association [1..1] to I_PPM_ProjectTP as _Root on $projection.ProjectUUID = _Root.ProjectUUID
  
---Extension Association
  association [1..1] to E_PPM_ProjectStatusArea   as _ProjectStatusExtension  on  $projection.StatusAreaUUID = _ProjectStatusExtension.StatusAreaUUID
  
{
      @ObjectModel.readOnly: true
  key StatusAreaUUID, 
      @ObjectModel.readOnly: true
      ProjectUUID,
      @ObjectModel.readOnly: true
      ProjectSummaryTaskUUID,    
      @ObjectModel.readOnly: true
      WBSElementInternalID,
      StatusArea, 
      Status,
      StatusTrend,
      Comments,
      SortField,
      IsOverallStatus,
      Criticality,

      /* Associations */
      _Area,
      _AreaText, 
      _AreaStatus, 
      _AreaStatusText, 
      _AreaTrend, 
      _AreaTrendText, 
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]        
      _Root,
      
      _ProjObjRoot,
      _AuthUser,
      _AuthSubst,
      _AuthRole,
      _AuthGroup 
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSTATUSAREA"
],
"ASSOCIATED":
[
"E_PPM_PROJECTSTATUSAREA",
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_PROJECTTP",
"I_PPM_STATUSAREACODE",
"I_PPM_STATUSAREACODETEXT",
"I_PPM_STATUSAREASTATUS",
"I_PPM_STATUSAREASTATUSTEXT",
"I_PPM_STATUSAREATREND",
"I_PPM_STATUSAREATRENDTEXT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_PROJECTSTATUSAREA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More