I_PROJECTOVERALLCOST

CDS View

Project Overall Cost

I_PROJECTOVERALLCOST is a CDS View in S/4HANA. Project Overall Cost. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PPM_PrStCmrProjByKeyFigures view left_outer COMPOSITE 
@AbapCatalog.sqlViewName: 'IPROJOVRLCST'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Overall Cost'

@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
@AbapCatalog.preserveKey:true

define view I_ProjectOverallCost
  as select from P_PROJSUMOFOVRLCOSTS as _ProjSumOfOvrlCosts
{
  key _ProjSumOfOvrlCosts.ProjectSummaryTaskUUID,
  key _ProjSumOfOvrlCosts.ProjectUUID,
  key _ProjSumOfOvrlCosts.Project,
  key _ProjSumOfOvrlCosts.ProjectInternalID,
      @Semantics.currencyCode:true
      _ProjSumOfOvrlCosts.GlobalCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ProjSumOfOvrlCosts.ActualAmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ProjSumOfOvrlCosts.PlanAmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ProjSumOfOvrlCosts.CmtmtCostInGlobalCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ProjSumOfOvrlCosts.PredictedAmtInGlobalCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ProjSumOfOvrlCosts.BaselineAmtInGlobalCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      _ProjSumOfOvrlCosts.BaselineAmtInGlobalCrcy - _ProjSumOfOvrlCosts.ActualAmountInGlobalCurrency as ActlPlnDiffAmtInGlobalCrcy,
      case
      when (  _ProjSumOfOvrlCosts.BaselineAmtInGlobalCrcy <> 0 )
      then (division( _ProjSumOfOvrlCosts.BaselineAmtInGlobalCrcy -  _ProjSumOfOvrlCosts.ActualAmountInGlobalCurrency,  _ProjSumOfOvrlCosts.BaselineAmtInGlobalCrcy,2) * 100)
      end                                                    as ActPlnDiffAmtInPercentage,
      _AuthUserFin,
      _AuthSubstFin,
      _AuthRoleFin,
      _AuthGroupFin
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PROJSUMOFOVRLCOSTS"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH"
],
"BASE":
[
"P_PROJSUMOFOVRLCOSTS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More