P_EBOC_MATERIALCOSTESTIMATE1

@AbapCatalog.sqlViewName: 'PEBOCMATCOSTEST1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view P_EBOC_MaterialCostEstimate1
  with parameters
    P_Ledger : fins_ledger
  as select from I_FinancialPlanningEntryItem as _PlanningEntryItem
{
  key CompanyCode,
  key PlanningCategory,
  key GLAccount                         as CostElement,
  key BusinessTransactionCategory,
  key ControllingDebitCreditCode,
  key AccountAssignmentType,
  key PartnerAccountAssignmentType,
  key PartnerCostCenter,
  key PartnerCostCtrActivityType,
  key PartnerOrder_2                    as PartnerOrder,
  key CostSourceUnit,
  key ProducedProduct,
  key Material,
  key WorkCenterInternalID,
  key OrderOperation,
  key Plant,
  key ControllingArea,
  key CostingLotSize,
  key LotSizeUnit,
  key CostEstimateValidityStartDate,
  key CostEstimateValidityEndDate,
  key SalesOrder,
  key SalesOrderItem,
  key IsLotSizeIndependent,
  key CostOriginGroup,
  key OriginCostCenter,
  key OriginCostCtrActivityType,

      sum(AmountInGlobalCurrency)       as AmountInGlobalCurrency,
      sum(FixedAmountInGlobalCrcy)      as FixedAmountInGlobalCurrency,
      sum(AmountInCompanyCodeCurrency)  as AmountInCompanyCodeCurrency,
      sum(AmountInFreeDefinedCurrency1) as AmountInFreeDefinedCurrency1,
      sum(AmountInFreeDefinedCurrency2) as AmountInFreeDefinedCurrency2,
      sum(AmountInFreeDefinedCurrency3) as AmountInFreeDefinedCurrency3,
      sum(AmountInFreeDefinedCurrency4) as AmountInFreeDefinedCurrency4,
      sum(AmountInFreeDefinedCurrency5) as AmountInFreeDefinedCurrency5,
      sum(AmountInFreeDefinedCurrency6) as AmountInFreeDefinedCurrency6,
      sum(AmountInFreeDefinedCurrency7) as AmountInFreeDefinedCurrency7,
      sum(AmountInFreeDefinedCurrency8) as AmountInFreeDefinedCurrency8,

      //Quantity

      sum(ValuationQuantity)            as TotalQuantity,
      sum(ValuationFixedQuantity)       as FixedQuantity      
}
where
      Ledger          = :P_Ledger
  and ProducedProduct is not initial
  and OrderID         is initial
group by
  CompanyCode,
  PlanningCategory,
  GLAccount,
  BusinessTransactionCategory,
  ControllingDebitCreditCode,
  AccountAssignmentType,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerOrder_2,
  CostSourceUnit,
  ProducedProduct,
  Material,
  WorkCenterInternalID,
  OrderOperation,
  Plant,
  ControllingArea,
  CostingLotSize,
  LotSizeUnit,
  CostEstimateValidityStartDate,
  CostEstimateValidityEndDate,
  SalesOrder,
  SalesOrderItem,
  IsLotSizeIndependent,
  CostOriginGroup,
  OriginCostCenter,
  OriginCostCtrActivityType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALPLANNINGENTRYITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/