P_RU_FixedAssetValueTrans1

@AbapCatalog.sqlViewName: 'PRUFASSETVTR1'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_FixedAssetValueTrans1
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set

  as select from I_FixedAssetValue( P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet )

{
  key CompanyCode,
  key AssetDepreciationArea,
  key MasterFixedAsset,
  key FixedAsset,
  key AccountingDocument,
  key TransactionSubitem,
  key Ledger,
  key FiscalYear,
  key FiscalPeriod,
  key SubLedgerAcctLineItemType,
  key AssetAcctTransClassfctn,
  key AssetAccountingKeyFigureSet,
  key AssetAccountingKeyFigure,
  key DebitCreditCode,
      LogicalSystem,
      ReferenceDocumentType,
      ReferenceDocumentContext,
      LedgerFiscalYear,
      FiscalYearVariant,
      FiscalYearPeriod,
      IsReversal,
      IsReversed,
      DocumentDate,
      PostingDate,
      AssetValueDate,
      AmountInCompanyCodeCurrency,
      AssetTransactionType,
      ReferenceDocument,
      ReferenceDocumentItem,
      ReversalReferenceDocument,
      ReversalTransactionSubitem,
      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '000' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as anbtr,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '200' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as invzvl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '300' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as aufwvl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '400' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as aufnvl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '500' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as nafavl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '600' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as safavl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '700' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as aafavl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '800' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as mafavl,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '900' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as erlbt,  //ret_revenue


      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '901' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as verko,  //ret_costs

      
      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '902' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as ret_loss,

      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '903' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as ret_gain,
      
      case substring( AssetAccountingKeyFigure, 8, 3 )
        when  '904' then AmountInCompanyCodeCurrency
        else 0
      end                                                           as ret_nbv
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIXEDASSETVALUE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/