P_RU_CommissionTradeInvoice12

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_CommissionTradeInvoice12.
-- 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.

CREATE VIEW P_RU_CommissionTradeInvoice12 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.TaxItem AS TaxItem,
  VatReporting.TaxItemGroup AS TaxItemGroup,
  VatReporting.TaxCode AS TaxCode,
  VatReporting.TaxCountry AS TaxCountry,
  VatReporting.TaxJurisdiction AS TaxJurisdiction,
  VatReporting.DebitCreditCode AS DebitCreditCode,
  VatReportingCust.DebitCreditCode AS DebitCreditCodeCust,
  VatReporting.IsNegativePosting AS IsNegativePosting,
  VatReporting.TransactionTypeDetermination AS TransactionTypeDetermination,
  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_CommissionTradeInvoice11 AS VatReporting
INNER JOIN P_RU_VATReportingCust AS VatReportingCust ON /* join condition not captured in parsed metadata */
;