P_RU_INVOICETOTALAMOUNT

CDS View

Invoice Total Amount

P_RU_INVOICETOTALAMOUNT is a CDS View in S/4HANA. Invoice Total Amount. It contains 2 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 2 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_RU_CommissionTradeInvoice0 view inner CONSUMPTION Commision Trade Invoices for Linking - Preparing 0
P_RU_InvoiceCrcyRateCalc view from CONSUMPTION Invoice Total Amount
P_RU_InvoiceJournal5 view left_outer CONSUMPTION InvJournal: Get Ext. Data, Partner and Agent (obsoleted)

Fields (2)

KeyField CDS FieldsUsed in Views
AmountInTransactionCurrency AmountInTransactionCurrency 1
TaxAmount TaxAmount 1 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUINVTOTAMOUNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_InvoiceTotalAmount
  as select from P_RU_InvoiceTotalAmount4

{
  CompanyCode,
  AccountingDocument,
  FiscalYear,

  cast( abs( TaxAmountInCoCodeCrcy + TaxBaseAmountInCoCodeCrcy )  as firu_amount_in_cc_curr )        as AmountInCompanyCodeCurrency,
  cast( abs( TaxBaseAmountInCoCodeCrcy )                          as hwbas_bses )                    as TaxBaseAmountInCoCodeCrcy,
  cast( abs( TaxAmountInCoCodeCrcy )                              as firu_taxamountcccrcy  )         as TaxAmountInCoCodeCrcy,

  cast( abs( TaxAmount + TaxBaseAmountInTransCrcy )               as firu_amount_in_trans_curr )     as AmountInTransactionCurrency,
  cast( abs( TaxBaseAmountInTransCrcy )                           as fwbas_bses  )                   as TaxBaseAmountInTransCrcy,
  cast( abs( TaxAmount )                                          as firu_taxamount_in_trans_curr  ) as TaxAmount
}

Learn More