P_EBPC_TotalVariance_30_1

DDL: P_EBPC_TOTALVARIANCE_30_1 Type: view_entity COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS

Event-Based Order Total Cost Variance

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

1 data source(s) 5 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 (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY OrderID OrderID
KEY OrderItem OrderItem
DisplayCurrency GlobalCurrency
AmountInDisplayCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

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

define view entity P_EBPC_TotalVariance_30_1
  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,

      GlobalCurrency                                      as DisplayCurrency,

      sum(cast(AmountInGlobalCurrency as abap.dec(23,2))) as AmountInDisplayCurrency
}
where
      BusinessTransactionCategory  = 'EBVP'
  and TransactionTypeDetermination = 'GBB'
  and FiscalYearPeriod             >= $parameters.P_FromFiscalYearPeriod
  and FiscalYearPeriod             <= $parameters.P_ToFiscalYearPeriod
  and Ledger                       = $parameters.P_Ledger
group by
  CompanyCode,
  OrderID,
  OrderItem,
  GlobalCurrency

Learn More