C_EntProjWrkPckgProjectStatus

DDL: C_ENTPROJWRKPCKGPROJECTSTATUS SQL: CENTPREPRJWPSTAT Type: view CONSUMPTION

WBS Element object page processing status

C_EntProjWrkPckgProjectStatus is a Consumption CDS View that provides data about "WBS Element object page processing status" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectTask) and exposes 17 fields with key field TaskUUID. It has 1 association to related views. It is exposed through 3 OData services (UI_ENTPROJECTCONTROL, UI_ENTPROJECTHIERARCHY, UI_ENTPROJECTWBSELEMENT).

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectTask Task from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProcessingStatusText _StatText $projection.ProcessingStatus = _StatText.ProcessingStatus

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CENTPREPRJWPSTAT view
ClientDependent true view
Metadata.allowExtensions true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey TaskUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label WBS Element object page processing status view

OData Services (3)

ServiceBindingVersionContractRelease
UI_ENTPROJECTCONTROL UI_ENTPROJECTCONTROL V2 C1 NOT_RELEASED
UI_ENTPROJECTHIERARCHY UI_ENTPROJECTHIERARCHY V2 C1 NOT_RELEASED
UI_ENTPROJECTWBSELEMENT UI_ENTPROJECTWBSELEMENT V2 C1 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID TaskUUID
ProcessingStatus ProcessingStatus
ProcessingStatusText _StatText ProcessingStatusText
WBSElementInternalID
SystemStatus
_AuthUser I_PPM_ProjectTask _AuthUser
_AuthSubst I_PPM_ProjectTask _AuthSubst
_AuthRole I_PPM_ProjectTask _AuthRole
_AuthGroup I_PPM_ProjectTask _AuthGroup
ControllingArea I_PPM_ProjectTask ControllingArea
ProfitCenter I_PPM_ProjectTask ProfitCenter
CompanyCode I_PPM_ProjectTask CompanyCode
FunctionalArea I_PPM_ProjectTask FunctionalArea
Plant I_PPM_ProjectTask Plant
ResponsibleCostCenter I_PPM_ProjectTask ResponsibleCostCenter
EnterpriseProjectType _Root EnterpriseProjectType
ProjectProfileCode _Root ProjectProfileCode
@AbapCatalog.sqlViewName: 'CENTPREPRJWPSTAT'
@ClientDependent: true
@Metadata.allowExtensions: true
@AbapCatalog.compiler.compareFilter: true 

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'TaskUUID'
@ObjectModel: {
    usageType: {
       serviceQuality:  #D,
       dataClass:       #MIXED,
       sizeCategory:    #L
    }
}
  
@VDM: {
    viewType: #CONSUMPTION
} 
@EndUserText.label: 'WBS Element object page processing status'

define view C_EntProjWrkPckgProjectStatus     
  as select from I_PPM_ProjectTask as Task
  association [1..1] to I_PPM_ProcessingStatusText as _StatText on $projection.ProcessingStatus = _StatText.ProcessingStatus
{
    @ObjectModel: {
        text: {
            element: ['ProcessingStatusText']
        }
    } 
    
key TaskUUID,
    ProcessingStatus                    as ProcessingStatus,

    @UI.hidden: false
    _StatText.ProcessingStatusText       as ProcessingStatusText,

    cast(concat('PR', WBSElementInternalID) as j_objnr)  as WBSElementInternalID,
    
    @ObjectModel.virtualElement: true
    @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_PPM_WPKG_GET_SYSSTAT'
    @UI.hidden: false
    cast('' as text1000)         as SystemStatus,
    
    // Assoziations for Auth-check

      Task._AuthUser,
      Task._AuthSubst,
      Task._AuthRole,
      Task._AuthGroup,
      
     Task.ControllingArea as ControllingArea,
     Task.ProfitCenter as ProfitCenter,
     
     @UI.hidden: true
     Task.CompanyCode,
     @UI.hidden: true
     Task.FunctionalArea,
     @UI.hidden: true
     Task.Plant,
     @UI.hidden: true
     Task.ResponsibleCostCenter,
     @UI.hidden: true
     _Root.EnterpriseProjectType,
     @UI.hidden: true
     _Root.ProjectProfileCode
    
}
where
    _StatText.Language = $session.system_language