I_EntProjectPublicSectorTP_2

DDL: I_ENTPROJECTPUBLICSECTORTP_2 Type: view_entity TRANSACTIONAL

Project Extension fields for PSM

I_EntProjectPublicSectorTP_2 is a Transactional CDS View that provides data about "Project Extension fields for PSM" in SAP S/4HANA. It reads from 2 data sources (I_EnterpriseProjectTP_2, I_PPM_ProjectPublicSector) and exposes 12 fields with key field ProjectUUID. It has 2 associations to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_EnterpriseProjectTP_2 Project inner
I_PPM_ProjectPublicSector ProjectPSM from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_FundStdVH _FundVH $projection.Fund = _FundVH.Fund
[0..*] I_FundText _FundText $projection.Fund = _FundText.Fund and _FundText.Language = $session.system_language

Annotations (10)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Feature BF:PSM_BUDGET_ACCOUNTING_CONTROL, EPPM_PUBLIC_SECTOR view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Project Extension fields for PSM view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_PPM_ProjectPublicSector ProjectUUID
ProjectSummaryTaskUUID I_PPM_ProjectPublicSector ProjectSummaryTaskUUID
ProjectInternalID I_PPM_ProjectPublicSector ProjectInternalID
Fund I_PPM_ProjectPublicSector Fund
FundIsFixAssigned I_PPM_ProjectPublicSector FundIsFixAssigned
FunctionalAreaIsFixAssigned I_PPM_ProjectPublicSector FunctionalAreaIsFixAssigned
GrantID I_PPM_ProjectPublicSector GrantID
GrantIsFixAssigned I_PPM_ProjectPublicSector GrantIsFixAssigned
SponsoredProgram I_PPM_ProjectPublicSector SponsoredProgram
_FundVH _FundVH
_FundText _FundText
_EnterpriseProject _EnterpriseProject 
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}

@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@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 }],
    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #L
    }
}
@EndUserText.label: 'Project Extension fields for PSM'
define view entity I_EntProjectPublicSectorTP_2
  as select from I_PPM_ProjectPublicSector as ProjectPSM
    inner join   I_EnterpriseProjectTP_2   as Project on ProjectPSM.ProjectUUID = Project.ProjectUUID

  association        to parent I_EnterpriseProjectTP_2 as _EnterpriseProject on  $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
  association [0..*] to I_FundStdVH                    as _FundVH            on  $projection.Fund = _FundVH.Fund
  association [0..*] to I_FundText                     as _FundText          on  $projection.Fund   = _FundText.Fund
                                                                             and _FundText.Language = $session.system_language
{

  key ProjectPSM.ProjectUUID                 as ProjectUUID,
      ProjectPSM.ProjectSummaryTaskUUID      as ProjectSummaryTaskUUID,
      ProjectPSM.ProjectInternalID           as ProjectInternalID,
      @Consumption: {
            valueHelp: '_FundVH',
            filter.hidden: true
           }
      ProjectPSM.Fund                        as Fund,
      ProjectPSM.FundIsFixAssigned           as FundIsFixAssigned,
      ProjectPSM.FunctionalAreaIsFixAssigned as FunctionalAreaIsFixAssigned,
      ProjectPSM.GrantID                     as GrantID,
      ProjectPSM.GrantIsFixAssigned          as GrantIsFixAssigned,
      ProjectPSM.SponsoredProgram            as SponsoredProgram,
      //Association

      _FundVH,
      _FundText,
      _EnterpriseProject
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTERPRISEPROJECTTP_2",
"I_PPM_PROJECTPUBLICSECTOR"
],
"ASSOCIATED":
[
"I_ENTERPRISEPROJECTTP_2",
"I_FUNDSTDVH",
"I_FUNDTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More