P_EBOrderVarianceCost1

DDL: P_EBORDERVARIANCECOST1 SQL: PEBORDVRCCST1 Type: view COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS

Event-Based Order Variance Cost layer 1

P_EBOrderVarianceCost1 is a Composite CDS View that provides data about "Event-Based Order Variance Cost layer 1" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 14 fields with key fields CompanyCode, OrderID, OrderItem. Part of development package ODATA_CO_RT_PRODUCTION_COSTS.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem I_JournalEntryItem from

Parameters (3)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEBORDVRCCST1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY OrderID OrderID
KEY OrderItem OrderItem
AmountInCompanyCodeCurrency
AmountInGlobalCurrency
FixedAmountInGlobalCrcy
AmountInFreeDefinedCurrency1
AmountInFreeDefinedCurrency2
AmountInFreeDefinedCurrency3
AmountInFreeDefinedCurrency4
AmountInFreeDefinedCurrency5
AmountInFreeDefinedCurrency6
AmountInFreeDefinedCurrency7
AmountInFreeDefinedCurrency8 
@AbapCatalog.sqlViewName: 'PEBORDVRCCST1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view P_EBOrderVarianceCost1
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod

  as select from I_JournalEntryItem
{
  key CompanyCode,
  key OrderID,
  key OrderItem,

      // Actual Amounts from ACDOCA

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

      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                       =  :P_Ledger
group by
  CompanyCode,
  OrderID,
  OrderItem

Learn More