I_EnterpriseProjectRanking

DDL: I_ENTERPRISEPROJECTRANKING Type: view BASIC

Enterprise Project Ranking

I_EnterpriseProjectRanking is a Basic CDS View that provides data about "Enterprise Project Ranking" in SAP S/4HANA. It reads from 2 data sources (/s4ppm/ranking, I_PPM_Text) and exposes 19 fields with key field EnterpriseProjectRankingUUID. It has 1 association to related views.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
/s4ppm/ranking Ranking from
I_PPM_Text TextMaster left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency _Currency.Currency = $projection.EntProjectRankingCurrency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPPMENTPROJRANK view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey EnterpriseProjectRankingUUID view
EndUserText.label Enterprise Project Ranking view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY EnterpriseProjectRankingUUID ranking_guid
EnterpriseProjectRanking id
EnterpriseProjectRankingName I_PPM_Text ObjectName
EntProjRankingProcessingStatus processing_status
EntProjectRankingReviewDate review_date
PlanningCategory planning_category
PlanningPeriodStartDate planning_period_start
PlanningPeriodEndDate planning_period_end
ProfitCenter profit_center
ControllingArea controlling_area
EntProjectRankingCurrency currency
EntProjectRankingCostThreshold cost_threshold
CreatedByUser created_by
CreationDateTime created_on
LastChangedByUser changed_by
LastChangeDateTime changed_on
MasterLanguage master_language
EntProjRankingApprovalDateTime approval_timestamp
_Currency _Currency 
@AbapCatalog: {
  sqlViewName: 'IPPMENTPROJRANK',
  compiler.compareFilter: true
}

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   usageType: {
     serviceQuality: #A,
     sizeCategory:  #M,
     dataClass: #MASTER
   },
   representativeKey: 'EnterpriseProjectRankingUUID',
   semanticKey: ['EnterpriseProjectRanking']
}

@EndUserText.label: 'Enterprise Project Ranking'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 
define view I_EnterpriseProjectRanking
  as select from    /s4ppm/ranking as Ranking
    left outer join I_PPM_Text     as TextMaster on  TextMaster.LanguageCode         = Ranking.master_language
                                                 and TextMaster.ReferencedObjectUUID = Ranking.ranking_guid
  association [0..1] to I_Currency                    as _Currency          on  _Currency.Currency = $projection.EntProjectRankingCurrency
                                                 
{

  key ranking_guid          as EnterpriseProjectRankingUUID,
      id                    as EnterpriseProjectRanking,
      TextMaster.ObjectName as EnterpriseProjectRankingName,
      processing_status     as EntProjRankingProcessingStatus,
      review_date           as EntProjectRankingReviewDate,
      planning_category     as PlanningCategory,
      planning_period_start as PlanningPeriodStartDate,
      planning_period_end   as PlanningPeriodEndDate,
      profit_center         as ProfitCenter,
      controlling_area      as ControllingArea,

      @Semantics.currencyCode:true      
      currency              as EntProjectRankingCurrency,
      @Semantics.amount.currencyCode: 'EntProjectRankingCurrency'
      cost_threshold        as EntProjectRankingCostThreshold,
      
      created_by            as CreatedByUser,
      created_on            as CreationDateTime,
      changed_by            as LastChangedByUser,
      changed_on            as LastChangeDateTime,
      master_language       as MasterLanguage,
      approval_timestamp    as EntProjRankingApprovalDateTime,
      
      _Currency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TEXT",
"/S4PPM/RANKING"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More