P_RU_InvoiceTotalAmount

DDL: P_RU_INVOICETOTALAMOUNT SQL: PRUINVTOTAMOUNT Type: view CONSUMPTION

P_RU_InvoiceTotalAmount is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_InvoiceTotalAmount4) and exposes 9 fields.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_RU_InvoiceTotalAmount4 P_RU_InvoiceTotalAmount4 from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUINVTOTAMOUNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
AccountingDocument AccountingDocument
FiscalYear FiscalYear
AmountInCompanyCodeCurrency
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
AmountInTransactionCurrency
TaxBaseAmountInTransCrcy
TaxAmount 
@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":""
}
}*/

Learn More