P_EBPAO_TR_VarianceByType2

DDL: P_EBPAO_TR_VARIANCEBYTYPE2 SQL: PEBPAOTRVRCBT2 Type: view COMPOSITE

P_EBPAO_TR_VarianceByType2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, P_EBPAO_TR_VarianceByType1) and exposes 2 fields with key fields CompanyCode, OrderID.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles LedgerCompanyCodeCrcyRole inner
P_EBPAO_TR_VarianceByType1 P_EBPAO_TR_VarianceByType1 from

Parameters (5)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_CurrencyRole fac_crcyrole
P_SubLedgerAcctLineItemType slalittype

Annotations (7)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode VarianceCost CompanyCode
KEY OrderID VarianceCost OrderID 
@AbapCatalog.sqlViewName: 'PEBPAOTRVRCBT2'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

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

define view P_EBPAO_TR_VarianceByType2
  with parameters
    P_Ledger                    : fins_ledger,
    P_FromFiscalYearPeriod      : fins_fyearperiod,
    P_ToFiscalYearPeriod        : fins_fyearperiod,
    P_CurrencyRole              : fac_crcyrole,
    P_SubLedgerAcctLineItemType : slalittype
  as select from P_EBPAO_TR_VarianceByType1( P_Ledger                    : :P_Ledger,
                                             P_FromFiscalYearPeriod      : :P_FromFiscalYearPeriod,
                                             P_ToFiscalYearPeriod        : :P_ToFiscalYearPeriod,
                                             P_SubLedgerAcctLineItemType : :P_SubLedgerAcctLineItemType ) as VarianceCost
    inner join   I_LedgerCompanyCodeCrcyRoles                                                             as LedgerCompanyCodeCrcyRole on  LedgerCompanyCodeCrcyRole.CompanyCode = VarianceCost.CompanyCode
                                                                                                                                       and LedgerCompanyCodeCrcyRole.Ledger      = :P_Ledger
{
  key VarianceCost.CompanyCode,
  key VarianceCost.OrderID,

      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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"P_EBPAO_TR_VARIANCEBYTYPE1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More