P_RU_INVOICETOTALAMOUNT

CDS View

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_RU_CommissionTradeInvoice0 view inner CONSUMPTION
P_RU_InvoiceCrcyRateCalc view from CONSUMPTION
P_RU_InvoiceJournal5 view left_outer CONSUMPTION

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