P_EBPAO_WIPOVERVIEW1

CDS View

Event-Based Production Accounting Overview WIP 1

P_EBPAO_WIPOVERVIEW1 is a CDS View in S/4HANA. Event-Based Production Accounting Overview WIP 1. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EBPAO_WIPOverview2 view from COMPOSITE Event-Based Production Accounting Overview WIP 2 
@AbapCatalog: {
  sqlViewName: 'PEBPAOWIPOVW1',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM: {
  private: true,
  viewType: #COMPOSITE
}
define view P_EBPAO_WIPOverview1
  with parameters
    P_Ledger             : fins_ledger,
    P_ToFiscalYearPeriod : fins_fyearperiod
  as select from I_JournalEntryItem
{
  key Ledger,
  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
  (
       SubLedgerAcctLineItemType   = '09100'
    or SubLedgerAcctLineItemType   = '09110'
  )
  and  BusinessTransactionCategory = 'EBWP'
  and  FiscalYearPeriod            <= $parameters.P_ToFiscalYearPeriod
  and  Ledger                      = $parameters.P_Ledger
group by
  Ledger,
  CompanyCode,
  OrderID,
  OrderItem

Learn More