P_PPM_ProjectCostLineItem

@AbapCatalog.sqlViewName: 'PPRJCSTLINEITEMN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  usageType:{ sizeCategory: #XXL,
              dataClass:  #MIXED,
              serviceQuality: #D
   }
  }
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
//@EndUserText.label: 'prep view to get cost data'

@VDM.viewType: #COMPOSITE
define view P_PPM_ProjectCostLineItem
  as select from P_ProjectCostLineItems as ActPlnJrlEtry
  association [0..1] to I_PPM_ProjectSummaryTask    as _ProjectSummary on  _ProjectSummary.ProjectInternalID = $projection.ProjectInternalID
  association [1..1] to I_ProjectBudgetPlngCategory as _BudgetPlnCat   on  $projection.PlanningCategory             = _BudgetPlnCat.PlanningCategory
                                                                       and _BudgetPlnCat.PlanningCatIsForAvailyCtrl = 'X'

{
  key Ledger,
  key SourceLedger,
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key FinancialPlanningReqTransSqnc,
  key FinancialPlanningDataPacket,
  key ActualPlanJournalEntryItem,
      FinancialPlanningEntryItem,
      FiscalYearPeriod,
      SemanticTag,
      LedgerGLLineItem,
      LedgerFiscalYear,
      ControllingArea,

      GLAccount,
      ChartOfAccounts,
      AccountingDocCreatedByUser,

      BusinessArea,
      ProfitCenter,
      WBSElementProfitCenter,
      CostCenter,
      FunctionalArea,
      CostCtrActivityType,

      Project,
      //_ProjectBasicData.Project,


      ProjectInternalID,
      ProjectDescription,
      ProjectObjectNode,
      //      case

      //      when OrderID is not initial

      //      then OrderID

      //      else ProjectObjectNode end                                  as ProjectObjectNode,

      ProjectProfileCode,
      ProjectObject,

      _ProjectSummary.ProjectUUID,
      _ProjectSummary.ProjectCategory,
      _ProjectSummary.ProjectSummaryTaskUUID,
      _ProjectSummary.ProjectProcessingStatus,

      //      case

      //      when OrderID is not initial

      //      then  'X'

      //      else '' end                                                 as IncludePmOrder,


      AvailabilityControlIsActive,
      AvailabilityControlProfile,
      AvailyCtrlTimeRangeType,
      BudgetCurrencyRole,

      cast( WBSElement as /s4ppm/tv_external_id preserving type ) as WBSElement,
      WBSDescription,
      ResponsibleCostCenter,
      WBSElementInternalID,

      //CE2005 Projecttype as a filter

      ActPlnJrlEtry.ProjectType,

      //Commitment fields

      SourceReferenceDocumentType,
      SourceLogicalSystem,
      SourceReferenceDocumentCntxt,
      SourceReferenceDocument,
      SourceReferenceDocumentItem,
      SourceReferenceDocSubitem,
      IsCommitment,

      //Sending Partner fields

      PartnerOrder,
      PartnerOrderCategory,
      PartnerWBSElement,
      PartnerProject,
      BusinessTransactionType,
      DebitCreditCode,


      FiscalPeriod,
      FiscalYearVariant,

      PlanningCategory,

      @Semantics.currencyCode: true
      ControllingObjectCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
      AmountInObjectCurrency,

      @Semantics.currencyCode:true
      TransactionCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      AmountInTransactionCurrency,

      @Semantics.currencyCode:true
      CompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      AmountInCompanyCodeCurrency,

      @Semantics.currencyCode:true
      GlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      AmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      PlanAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      case
          when  PlanningCategory = 'PREDICT01' and AmountInGlobalCurrency > 0
              then AmountInGlobalCurrency
          else 0
      end                                                         as PredictedAmtInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      BaselineAmtInGlobalCrcy,


      // _Project,

      //  _WBSElement,

      _FiscalPeriod
}
where
      ActPlnJrlEtry.GlobalCurrency <> ''
  and ActPlnJrlEtry.IsCommitment   <> 'X'