P_RU_InvoiceTotalAmount1

DDL: P_RU_INVOICETOTALAMOUNT1 SQL: PRUINVTOTAMOUNT1 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
11 Fields 1 Data Sources

Invoice Total Amount

P_RU_InvoiceTotalAmount1 is a Consumption CDS View that provides data about "Invoice Total Amount" in SAP S/4HANA. It reads from 1 data source (P_RU_BSET) and exposes 11 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (1)

SourceAliasJoin Type
P_RU_BSET bset from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUINVTOTAMOUNT1 view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RU_BSET CompanyCode Receiver Company Code
KEY AccountingDocument P_RU_BSET AccountingDocument Journal Entry
KEY FiscalYear P_RU_BSET FiscalYear G/L Fiscal Year
KEY TaxItem P_RU_BSET TaxItem Tax Item
TaxCode P_RU_BSET TaxCode Tax Code
TaxRate P_RU_BSET TaxRate Tax Rate
DebitCreditCode P_RU_BSET DebitCreditCode Single-Character Flag
TaxBaseAmountInCoCodeCrcy P_RU_BSET TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy P_RU_BSET TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy P_RU_BSET TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount P_RU_BSET TaxAmount Tax Amt in Rptg Crcy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RU_InvoiceTotalAmount1.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRUINVTOTAMOUNT1

CREATE VIEW P_RU_InvoiceTotalAmount1 AS
SELECT
  bset.CompanyCode AS CompanyCode,
  bset.AccountingDocument AS AccountingDocument,
  bset.FiscalYear AS FiscalYear,
  bset.TaxItem AS TaxItem,
  bset.TaxCode AS TaxCode,
  bset.TaxRate AS TaxRate,
  bset.DebitCreditCode AS DebitCreditCode,
  bset.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  bset.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  bset.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  bset.TaxAmount AS TaxAmount
FROM P_RU_BSET AS bset
;

Learn More