P_EBPC_EBVariance_F5_1

DDL: P_EBPC_EBVARIANCE_F5_1 Type: view_entity COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS

Event-Based Order Event-Based Variance

P_EBPC_EBVariance_F5_1 is a Composite CDS View that provides data about "Event-Based Order Event-Based Variance" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 5 fields with key fields CompanyCode, OrderItem, SubLedgerAcctLineItemType. 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 OrderItem OrderItem
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType
DisplayCurrency FreeDefinedCurrency5
AmountInDisplayCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

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

define view entity P_EBPC_EBVariance_F5_1
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod
  as select from I_JournalEntryItem
{
  key CompanyCode,
  key case
        when OrderID = '' then OriginOrder // V-Price Variance (BSX transaction)

        else OrderID
      end                                                       as OrderID,
  key OrderItem,
  key SubLedgerAcctLineItemType,

      FreeDefinedCurrency5                                      as DisplayCurrency,

      sum(cast(AmountInFreeDefinedCurrency5 as abap.dec(23,2))) as AmountInDisplayCurrency
}
where
  (
       SubLedgerAcctLineItemType    =  '09130' //Input Price Variance

    or SubLedgerAcctLineItemType    =  '09131' //Input Quantity variance

    or SubLedgerAcctLineItemType    =  '09132' //Resource Usage variance

    or SubLedgerAcctLineItemType    =  '09139' //Lot Size variance

    or SubLedgerAcctLineItemType    =  '09140' //Remaining variance

  )
  and  BusinessTransactionCategory  =  'EBVP'
  and  TransactionTypeDetermination <> 'GBB'
  and  FiscalYearPeriod             >= $parameters.P_FromFiscalYearPeriod
  and  FiscalYearPeriod             <= $parameters.P_ToFiscalYearPeriod
  and  Ledger                       = $parameters.P_Ledger
group by
  CompanyCode,
  OrderID,
  OriginOrder,
  OrderItem,
  SubLedgerAcctLineItemType,
  FreeDefinedCurrency5

Learn More