P_EBOC_Variance2

@AbapCatalog.sqlViewName: 'PEBOCVARC2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.lifecycle.status: #DEPRECATED

define view P_EBOC_Variance2
  with parameters
    P_OrderID              : fis_order_number,
    P_FromFiscalYearPeriod : fis_jahrper,
    P_ToFiscalYearPeriod   : fis_jahrper,
    P_Ledger               : fins_ledger,
    P_CurrencyRole         : fac_crcyrole
  as select from P_EBOC_Variance1( P_OrderID              : :P_OrderID,
                                   P_FromFiscalYearPeriod : :P_FromFiscalYearPeriod,
                                   P_ToFiscalYearPeriod   : :P_ToFiscalYearPeriod,
                                   P_Ledger               : :P_Ledger ) as _Costs
    inner join   I_LedgerCompanyCodeCrcyRoles                           as _LedgerCompanyCodeCrcyRole on  _LedgerCompanyCodeCrcyRole.CompanyCode = _Costs.CompanyCode
                                                                                                      and _LedgerCompanyCodeCrcyRole.Ledger      = :P_Ledger
{
  key _Costs.CompanyCode,
  key ControllingArea,
  key CostElement,
  key BusinessTransactionType,
  key ControllingDebitCreditCode,
  key OriginSenderObject,
  key OrderID,
  key OrderItem,
  key AccountAssignmentType,
  key PartnerAccountAssignment,
  key PartnerAccountAssignmentType,
  key PartnerCostCenter,
  key PartnerCostCtrActivityType,
  key PartnerBusinessProcess,
  key PartnerOrder,
  key UnitOfMeasure,
  key Material,
  key CostOriginGroup,
  key cast('31' as co_wrttp)           as ControllingValueType, //31 = Variance

  key 'B'                              as CtrlgOriginClassification, //Origin Indicator


      cast(
        case :P_CurrencyRole
           when CompanyCodeCurrencyRole  then AmountInCompanyCodeCurrency
           when GlobalCurrencyRole       then AmountInGlobalCurrency
           when FreeDefinedCurrency1Role then AmountInFreeDefinedCurrency1
           when FreeDefinedCurrency2Role then AmountInFreeDefinedCurrency2
           when FreeDefinedCurrency3Role then AmountInFreeDefinedCurrency3
           when FreeDefinedCurrency4Role then AmountInFreeDefinedCurrency4
           when FreeDefinedCurrency5Role then AmountInFreeDefinedCurrency5
           when FreeDefinedCurrency6Role then AmountInFreeDefinedCurrency6
           when FreeDefinedCurrency7Role then AmountInFreeDefinedCurrency7
           when FreeDefinedCurrency8Role then AmountInFreeDefinedCurrency8
         else 0
      end as farp_amount_display_crcy) as AmountInDisplayCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES",
"P_EBOC_VARIANCE1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/