P_EBWIP_PRODUCTIONCOST1

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

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

define view P_EBWIP_ProductionCost1
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : datum,
    P_Ledger  : fins_ledger
  as select from R_ControllingActualLineItem
{
  key CompanyCode,
  key OrderID,
  key OrderItem,

      sum(AmountInCompanyCodeCurrency)  as AmountInCompanyCodeCurrency,
      sum(AmountInGlobalCurrency)       as AmountInGlobalCurrency,

      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
}
where
  (
          AccountAssignmentType       =  'OR'
    or    AccountAssignmentType       =  'OP'
  )
  and(
          OrderCategory               =  '10'
    or    OrderCategory               =  '40'
    or(
          OrderCategory               =  '05'
      and BusinessTransactionCategory <> 'TBCS' // Transaction-Based Split

      and BusinessTransactionCategory <> 'EBWP' // WIP

      and BusinessTransactionCategory <> 'EBVP' // Variance

      and BusinessTransactionCategory <> 'KOAE'
    )
  )
  and     ControllingDocument         <> ''
  and(
          OriginCtrlgDebitCreditCode  =  'L'
    or    OriginCtrlgDebitCreditCode  =  'A'
  )
  and     SubLedgerAcctLineItemType   <> '09101'
  and     SubLedgerAcctLineItemType   <> '09111'
  and     PostingDate                 <= :P_KeyDate
  and     Ledger                      =  :P_Ledger
group by
  CompanyCode,
  OrderID,
  OrderItem
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CONTROLLINGACTUALLINEITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/