P_EBPAO_VarianceTrend2

DDL: P_EBPAO_VARIANCETREND2 SQL: PEBPAOVARCTRD2 Type: view COMPOSITE

P_EBPAO_VarianceTrend2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_EBPAO_VarianceTrend1) and exposes 5 fields with key fields CompanyCode, OrderID, OrderItem, FiscalYearPeriod, SubLedgerAcctLineItemType.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles _LedgerCompanyCodeCrcyRole inner
P_EBPAO_VarianceTrend1 P_EBPAO_VarianceTrend1 from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fac_crcyrole

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBPAOVARCTRD2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _VarianceCost CompanyCode
KEY OrderID _VarianceCost OrderID
KEY OrderItem _VarianceCost OrderItem
KEY FiscalYearPeriod _VarianceCost FiscalYearPeriod
KEY SubLedgerAcctLineItemType _VarianceCost SubLedgerAcctLineItemType 
@AbapCatalog.sqlViewName: 'PEBPAOVARCTRD2'
@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.viewType: #COMPOSITE
@VDM.private: true
define view P_EBPAO_VarianceTrend2
  with parameters
    P_Ledger               : fins_ledger,
    P_FromFiscalYearPeriod : fins_fyearperiod,
    P_ToFiscalYearPeriod   : fins_fyearperiod,
    P_CurrencyRole         : fac_crcyrole
  as select from P_EBPAO_VarianceTrend1( P_Ledger               : :P_Ledger,
                                         P_FromFiscalYearPeriod : :P_FromFiscalYearPeriod,
                                         P_ToFiscalYearPeriod   : :P_ToFiscalYearPeriod ) as _VarianceCost
    inner join   I_LedgerCompanyCodeCrcyRoles                                             as _LedgerCompanyCodeCrcyRole on  _LedgerCompanyCodeCrcyRole.CompanyCode = _VarianceCost.CompanyCode
                                                                                                                        and _LedgerCompanyCodeCrcyRole.Ledger      = :P_Ledger
{
  key _VarianceCost.CompanyCode,
  key _VarianceCost.OrderID,
  key _VarianceCost.OrderItem,
  key _VarianceCost.FiscalYearPeriod,
  key _VarianceCost.SubLedgerAcctLineItemType,

      cast(
        case :P_CurrencyRole
           when _LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole  then _VarianceCost.AmountInCompanyCodeCurrency
           when _LedgerCompanyCodeCrcyRole.GlobalCurrencyRole       then _VarianceCost.AmountInGlobalCurrency
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role then _VarianceCost.AmountInFreeDefinedCurrency1
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role then _VarianceCost.AmountInFreeDefinedCurrency2
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role then _VarianceCost.AmountInFreeDefinedCurrency3
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role then _VarianceCost.AmountInFreeDefinedCurrency4
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role then _VarianceCost.AmountInFreeDefinedCurrency5
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role then _VarianceCost.AmountInFreeDefinedCurrency6
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role then _VarianceCost.AmountInFreeDefinedCurrency7
           when _LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role then _VarianceCost.AmountInFreeDefinedCurrency8
         else 0
      end as farp_amount_display_crcy) as AmountInDisplayCurrency
}

Learn More