P_RU_VATRetImpEAEU

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_VATRetImpEAEU.
-- 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: PRUVATRETEAEU
-- Parameters: P_FiscalYearVariant : fis_periv, P_Date : datum

CREATE VIEW P_RU_VATRetImpEAEU AS
SELECT
  SelectedDocument.CompanyCode AS CompanyCode,
  SelectedDocument.AccountingDocument AS AccountingDocument,
  SelectedDocument.FiscalYear AS FiscalYear,
  SelectedDocument.PostingDate AS PostingDate,
  SelectedDocument.TaxReportingDate AS TaxReportingDate,
  SelectedDocument.DocumentDate AS DocumentDate,
  SelectedDocument.IsReversal AS IsReversal,
  SelectedDocument.IsReversed AS IsReversed,
  SelectedDocument.SourceDocument AS SourceDocument,
  SelectedDocument.SourceDocumentFiscalYear AS SourceDocumentFiscalYear,
  SelectedDocument.ExternalInvoice AS ExternalInvoice,
  SelectedDocument.InvoiceDate AS InvoiceDate,
  SelectedDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  SelectedDocument.BusinessTransactionType AS BusinessTransactionType,
  SelectedDocument.AccountingDocumentType AS AccountingDocumentType,
  SelectedDocument.TaxCode AS TaxCode,
  SelectedDocument.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  SelectedDocument.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  SelectedDocument.RU_VATReturnVersion AS RU_VATReturnVersion,
  SelectedDocument.RU_VATReturnSection AS RU_VATReturnSection,
  SelectedDocument.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  SelectedDocument.RU_VATReturnLine AS RU_VATReturnLine,
  SelectedDocument.VATReturnItemDescription AS VATReturnItemDescription,
  SelectedDocument.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  SelectedDocument.RU_VATSubScenario AS RU_VATSubScenario,
  SelectedDocument.RU_VATScenario AS RU_VATScenario,
  SelectedDocument.StatryRptgEntity AS StatryRptgEntity,
  SelectedDocument.StatryRptCategory AS StatryRptCategory,
  SelectedDocument.StatryRptRunID AS P_FiscalYearVariant,
  SelectedDocument.StatryRptRunID AS StatryRptRunID
FROM P_RU_VATReturnGeneralSection3
INNER JOIN P_RU_CheckLinkToImpNotNum AS IsLinkExists ON /* join condition not captured in parsed metadata */
INNER JOIN P_RU_BSET AS ReferredDocument ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RU_VATReturnGeneralSection3
;