P_RU_VATDocumentExtraInfo

DDL: P_RU_VATDOCUMENTEXTRAINFO SQL: PRUVATDOCEXTINF Type: view COMPOSITE Package: GLO_FIN_IS_VAT_RU
16 Fields 3 Data Sources

Extra information of accounting document

P_RU_VATDocumentExtraInfo is a Composite CDS View that provides data about "Extra information of accounting document" in SAP S/4HANA. It reads from 3 data sources (P_RU_VATDocumentExtraInfo2, I_Ru_VatDocExtras, I_Ru_VatDocExtras) and exposes 16 fields with key fields CompanyCode, AccountingDocument, FiscalYear, SenderLogicalSystem, AccountingDocument. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (3)

SourceAliasJoin Type
P_RU_VATDocumentExtraInfo2 P_RU_VATDocumentExtraInfo2 from
I_Ru_VatDocExtras VatLongTexts union_all
I_Ru_VatDocExtras VatLongTexts union_all

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRUVATDOCEXTINF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Run On
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SenderLogicalSystem SenderLogicalSystem Sender Logical System
ExternalInvoice External Number
CompanyCode Run On
KEY AccountingDocument I_Ru_VatDocExtras AccountingDocument Journal Entry
KEY FiscalYear I_Ru_VatDocExtras FiscalYear G/L Fiscal Year
KEY SenderLogicalSystem I_Ru_VatDocExtras SenderLogicalSystem Sender Logical System
ExternalInvoice I_Ru_VatDocExtras ExternalInvoice External Number
CompanyCode Run On
KEY AccountingDocument I_Ru_VatDocExtras AccountingDocument Journal Entry
KEY FiscalYear I_Ru_VatDocExtras FiscalYear G/L Fiscal Year
KEY SenderLogicalSystem I_Ru_VatDocExtras SenderLogicalSystem Sender Logical System
ExternalInvoice I_Ru_VatDocExtras ExternalInvoice External Number
InvoiceDate I_Ru_VatDocExtras InvoiceDate Run On

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_VATDocumentExtraInfo.
-- 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: PRUVATDOCEXTINF

CREATE VIEW P_RU_VATDocumentExtraInfo AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  SenderLogicalSystem,
  cast(ExternalInvoice as firu_inv_extnum) AS ExternalInvoice,
  VatLongTexts.InvoiceDate AS InvoiceDate
FROM P_RU_VATDocumentExtraInfo2
-- UNION ALL with additional select branch(es): I_Ru_VatDocExtras
;

Learn More