I_PPM_PROJECTPUBLICSECTOR

CDS View

Extension for Public Sector Fields

I_PPM_PROJECTPUBLICSECTOR is a CDS View in S/4HANA. Extension for Public Sector Fields. It contains 12 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 12 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EntProjectPublicSectorTP view from TRANSACTIONAL Project Extension fields for PSM
I_EntProjectPublicSectorTP_2 view_entity from TRANSACTIONAL Project Extension fields for PSM
I_PPM_ProjectPublicSectorTP view from TRANSACTIONAL Public Sector fields for Project

Fields (12)

KeyField CDS FieldsUsed in Views
KEY ProjectUUID ProjectUUID 2
ControllingArea ControllingArea 1
FunctionalArea FunctionalArea 1
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned 1
Fund Fund 1
FundIsFixAssigned FundIsFixAssigned 1
GrantID GrantID 1
GrantIsFixAssigned GrantIsFixAssigned 1
ProfitCenter ProfitCenter 1
ProjectInternalID ProjectInternalID 2
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 2
SponsoredProgram SponsoredProgram 1 
@AbapCatalog.sqlViewName: 'IPPMPRJPSM'

@VDM: {
    viewType: #COMPOSITE,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AbapCatalog.preserveKey:true

@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   compositionRoot: false,
   representativeKey: 'ProjectUUID',
   alternativeKey: [ { id : 'ProjectSummaryTaskUUID', uniqueness: #UNIQUE } ],
   usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #L
    }
}

@feature: 'BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR'

@EndUserText.label: 'Extension for Public Sector Fields'
define view I_PPM_ProjectPublicSector
  as select from I_PPM_ProjectSummaryTask as pst
    inner join   I_WBSElementBasicData    as wbs on wbs.WBSElementInternalID = pst.WBSElementInternalID

  association [1..1] to I_PPM_Project as _Root on $projection.ProjectUUID = _Root.ProjectUUID
{
  key pst.ProjectUUID,
      pst.ProjectSummaryTaskUUID,
      pst.ProjectInternalID,
      pst.WBSElementInternalID,
      //    @Consumption.hidden: true

      //   prj.ControllingArea,    // only for auth check

      //  @Consumption.hidden: true

      //  prj.ProfitCenter,       // only for auth check

      wbs.Fund,
      wbs.FundIsFixAssigned,
      wbs.FunctionalArea,
      wbs.FunctionalAreaIsFixAssigned,
      wbs.GrantID,
      wbs.GrantIsFixAssigned,
      //2008 sponsored program

      wbs.SponsoredProgram,

      wbs.ControllingArea, // For Authorization similar to Joint Venture Accounting

      wbs.ProfitCenter, // For Authorization similar to Joint Venture Accounting


      @Consumption.hidden: true
      _AuthUser,
      @Consumption.hidden: true
      _AuthSubst,
      @Consumption.hidden: true
      _AuthRole,
      @Consumption.hidden: true
      _AuthGroup,

      _Root
}

Learn More