P_RU_ExtInvoiceTotalAmount1

DDL: P_RU_EXTINVOICETOTALAMOUNT1 SQL: PRUEXTINVTOTAMT1 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
9 Fields 2 Data Sources

Invoice Total Amount

P_RU_ExtInvoiceTotalAmount1 is a Consumption CDS View that provides data about "Invoice Total Amount" in SAP S/4HANA. It reads from 2 data sources (P_RU_BSET, I_RU_VATDocumentExtraInfo) and exposes 9 fields. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (2)

SourceAliasJoin Type
P_RU_BSET Bset from
I_RU_VATDocumentExtraInfo VatLongTexts inner

Annotations (5)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_BSET CompanyCode Receiver Company Code
AccountingDocument P_RU_BSET AccountingDocument Journal Entry
FiscalYear P_RU_BSET FiscalYear G/L Fiscal Year
ExternalAccountingDocument I_RU_VATDocumentExtraInfo ExternalInvoice External Number
ExternalAcctgDocumentDate I_RU_VATDocumentExtraInfo InvoiceDate Run On
TaxAmountInCoCodeCrcy P_RU_BSET TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy P_RU_BSET TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmount P_RU_BSET TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy P_RU_BSET TaxBaseAmountInTransCrcy Value-Added Tax

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_ExtInvoiceTotalAmount1.
-- 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: PRUEXTINVTOTAMT1

CREATE VIEW P_RU_ExtInvoiceTotalAmount1 AS
SELECT
  Bset.CompanyCode AS CompanyCode,
  Bset.AccountingDocument AS AccountingDocument,
  Bset.FiscalYear AS FiscalYear,
  VatLongTexts.ExternalInvoice AS ExternalAccountingDocument,
  VatLongTexts.InvoiceDate AS ExternalAcctgDocumentDate,
  Bset.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  Bset.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  Bset.TaxAmount AS TaxAmount,
  Bset.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy
FROM P_RU_BSET AS Bset
INNER JOIN I_RU_VATDocumentExtraInfo AS VatLongTexts ON /* join condition not captured in parsed metadata */
;

Learn More