P_RU_DSVATReporting2

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_DSVATReporting2.
-- 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: PRUDSVATRPTG2

CREATE VIEW P_RU_DSVATReporting2 AS
SELECT
  VatReporting.CompanyCode AS CompanyCode,
  VatReporting.AccountingDocument AS AccountingDocument,
  VatReporting.FiscalYear AS FiscalYear,
  VatReporting.AccountingDocumentType AS AccountingDocumentType,
  VatReporting.PostingDate AS PostingDate,
  VatReporting.TaxReportingDate AS TaxReportingDate,
  VatReporting.IsReversal AS IsReversal,
  VatReporting.IsReversed AS IsReversed,
  VatReporting.ReverseDocument AS ReverseDocument,
  VatReporting.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  VatReporting.ReverseDocumentTaxRepDate AS ReverseDocumentTaxRepDate,
  VatReporting.ReverseTaxItem AS ReverseTaxItem,
  VatReporting.SrcDocNmbrForOriginalDocument AS SrcDocNmbrForOriginalDocument,
  VatReporting.SrcDocYearForOriginalDocument AS SrcDocYearForOriginalDocument,
  VatReporting.SrcDocTypeForOriginalDocument AS SrcDocTypeForOriginalDocument,
  VatReporting.TaxItem AS TaxItem,
  VatReporting.TaxCode AS TaxCode,
  VatReporting.DebitCreditCode AS DebitCreditCode,
  VatReporting.IsNegativePosting AS IsNegativePosting,
  VatReportingCust.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatReportingCust.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  VatReportingCust.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatReportingCust.RU_VATReturnLine AS RU_VATReturnLine,
  VatReportingCust.RU_VATSubScenario AS RU_VATSubScenario,
  VatReportingCust.RU_VATScenario AS RU_VATScenario,
  VatReportingCust.RU_VATSubScenarioItem AS RU_VATSubScenarioItem,
  VatReportingCust.IsCorrectionInvoice AS IsCorrectionInvoice,
  VatReportingCust.RU_SourceDocumentType AS RU_SourceDocumentType
FROM P_RU_DSVATReporting1 AS VatReporting
INNER JOIN P_RU_VATReportingCust AS VatReportingCust ON /* join condition not captured in parsed metadata */
;