I_PPM_ProjectPublicSectorTP

DDL: I_PPM_PROJECTPUBLICSECTORTP SQL: IPPMPROJPSMTP Type: view TRANSACTIONAL

Public Sector fields for Project

I_PPM_ProjectPublicSectorTP is a Transactional CDS View that provides data about "Public Sector fields for Project" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectPublicSector) and exposes 16 fields with key field ProjectUUID. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectPublicSector pst from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PPM_ProjectTP _Root $projection.ProjectUUID = _Root.ProjectUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPROJPSMTP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.writeDraftPersistence PPM_PROJPSM_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Public Sector fields for Project view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID
ProjectSummaryTaskUUID ProjectSummaryTaskUUID
ProjectInternalID ProjectInternalID
WBSElementInternalID WBSElementInternalID
Fund Fund
FundIsFixAssigned FundIsFixAssigned
GrantID GrantID
GrantIsFixAssigned GrantIsFixAssigned
SponsoredProgram SponsoredProgram
FunctionalArea I_PPM_ProjectPublicSector FunctionalArea
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_Root _Root 
@AbapCatalog.sqlViewName: 'IPPMPROJPSMTP'

@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@AbapCatalog.preserveKey
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
//@feature: 'BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR'

@ObjectModel: {
   representativeKey: 'ProjectUUID',
   alternativeKey: [ { id : 'ProjectSummaryTaskUUID',   element: ['ProjectSummaryTaskUUID'], uniqueness: #UNIQUE },
                     { id : 'ProjectInternalID',        element: ['ProjectInternalID'], uniqueness: #UNIQUE },
                     { id : 'WBSElementInternalID',     element: ['WBSElementInternalID'], uniqueness: #UNIQUE }],
   writeDraftPersistence: 'PPM_PROJPSM_D',
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     serviceQuality:  #D, 
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #L
    },
    semanticKey: ['ProjectUUID']
}
@EndUserText.label: 'Public Sector fields for  Project'
define view I_PPM_ProjectPublicSectorTP
  as select from I_PPM_ProjectPublicSector as pst
 association [1..1] to I_PPM_ProjectTP as _Root on $projection.ProjectUUID = _Root.ProjectUUID
{
  key ProjectUUID,
      ProjectSummaryTaskUUID,
      ProjectInternalID,
      WBSElementInternalID,
      Fund,
      FundIsFixAssigned,
      GrantID,
      GrantIsFixAssigned,
      //2008 sponsored program

      SponsoredProgram,
      pst.FunctionalArea,
      FunctionalAreaIsFixAssigned,


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

      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _Root
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTPUBLICSECTOR"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_PROJECTTP"
],
"BASE":
[
"I_PPM_PROJECTPUBLICSECTOR"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More