P_PROJPREDICTIONDTECALCINTMD

CDS View

P_PROJPREDICTIONDTECALCINTMD is a CDS View in S/4HANA. It contains 7 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 7 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_ProjectLastPredictedOn view from COMPOSITE
P_ProjectPredictionDateCalc view from COMPOSITE
P_ProjPredtWthMisgMnthSmmry view union_all COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY Project Project 1
CompanyCode CompanyCode 1
FiscalPeriod FiscalPeriod 1
FiscalYear FiscalYear 1
FiscalYearVariant FiscalYearVariant 1
GlobalCurrency GlobalCurrency 1
ProjectInternalID ProjectInternalID 1 
@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