P_EBPAO_VARIANCETREND1

CDS View

P_EBPAO_VARIANCETREND1 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EBPAO_VarianceTrend2 view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PEBPAOVARCTRD1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_EBPAO_VarianceTrend1 
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod
  as select from I_JournalEntryItem as JournalEntryItem
{
  key CompanyCode,
  key case
        when OrderID <> '' then OrderID
        else OriginOrder // V-Price Variance (BSX transaction)

      end                                                              as OrderID,
  key OrderItem,
  key FiscalYearPeriod,
  key SubLedgerAcctLineItemType,

      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
       BusinessTransactionCategory  =  'EBVP'
  and  TransactionTypeDetermination <> 'GBB'
  and  FiscalYearPeriod             >= $parameters.P_FromFiscalYearPeriod
  and  FiscalYearPeriod             <= $parameters.P_ToFiscalYearPeriod
  and  Ledger                       =  $parameters.P_Ledger
group by
  Ledger,
  CompanyCode,
  OrderID,
  OriginOrder,
  OrderItem,
  FiscalYearPeriod,
  SubLedgerAcctLineItemType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More