P_ProjPredictionDteCalcintmd

DDL: P_PROJPREDICTIONDTECALCINTMD SQL: PPREDDTEINTMD Type: view COMPOSITE

P_ProjPredictionDteCalcintmd is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_FinancialPlanningEntryItem) and exposes 10 fields with key field ProjectInternalID.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_FinancialPlanningEntryItem I_FinancialPlanningEntryItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPREDDTEINTMD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID
Project _ProjectBasicData ProjectExternalID
PlanningCategory PlanningCategory
CompanyCode CompanyCode
FiscalYearPeriod FiscalYearPeriod
FiscalYear FiscalYear
FiscalPeriod FiscalPeriod
FiscalYearVariant FiscalYearVariant
GlobalCurrency GlobalCurrency
CreationDate 
@AbapCatalog.sqlViewName: 'PPREDDTEINTMD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.preserveKey:true
@ObjectModel: {usageType: {
       serviceQuality:  #C,
       dataClass:       #MIXED,
       sizeCategory:    #S
   }
 }

define view P_ProjPredictionDteCalcintmd
  as select from I_FinancialPlanningEntryItem
{
  key ProjectInternalID,
      // S/4 Hana CE2302- Field Deprecation - Begin

      //  Project,

      _ProjectBasicData.ProjectExternalID                                                as Project,
      // S/4 Hana CE2302- Field Deprecation - End

      PlanningCategory,
      CompanyCode,
      FiscalYearPeriod,
      FiscalYear,
      FiscalPeriod,
      FiscalYearVariant,
      case when PlanningCategory = 'PREDICT01'
      then AmountInGlobalCurrency  end                                                   as PredictedAmtInGlobalCurrency,
      case when PlanningCategory = 'PREDICT02'
      then AmountInGlobalCurrency  end                                                   as LowerPredictionAmtInGlobCrcy,
      case when PlanningCategory = 'PREDICT03'
      then AmountInGlobalCurrency  end                                                   as UpperPredictionAmtInGlobCrcy,
      GlobalCurrency,
      case when PostingDate = '00000000' or PostingDate is null
                then _FiscalPeriod.FiscalPeriodStartDate
             else PostingDate
        end                                                                              as PostingDate,
      cast(cast(substring(FinancialPlanningReqTransSqnc,1,8)as abap.dats) as fis_budat ) as CreationDate
}
where
     PlanningCategory = 'PREDICT01'
  or PlanningCategory = 'PREDICT02'
  or PlanningCategory = 'PREDICT03'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALPLANNINGENTRYITEM",
"I_FISCALYEARPERIODFORCMPNYCODE",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More