P_RU_DSVATCRQSec8

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_DSVATCRQSec8.
-- 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: PRUDSVATCRQSEC8
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_RequestID : j_3rf_vatcrq_n1, P_SectionNumber : j_3rf_vatcrq_sect_num, P_AddFlag : flag

CREATE VIEW P_RU_DSVATCRQSec8 AS
SELECT
  $parameters.P_SectionNumber AS SectionNumber,
  VATCRQ8.FiscalYear AS FiscalYear,
  VATCRQ8.TaxPeriod AS TaxPeriod,
  VATCRQ8.VATRetCorrNum AS VATRetCorrNum,
  VATCRQ8.RequestLineItemNum AS RequestLineItemNum,
  VATCRQ8.AddFlag AS AddFlag,
  VATCRQ8.ExternalDocNumber AS ExternalDocNumber,
  VATCRQ8.OriginalInvDate AS OriginalInvDate,
  VATCRQ8.OrigInvRevNumber AS OrigInvRevNumber,
  VATCRQ8.OrigInvRevDate AS OrigInvRevDate,
  VATCRQ8.CorrectiveInvDate AS CorrectiveInvDate,
  VATCRQ8.CorrectiveInvExtNumber AS CorrectiveInvExtNumber,
  VATCRQ8.CorrectiveInvRevNumber AS CorrectiveInvRevNumber,
  VATCRQ8.CorrectiveInvRevDate AS CorrectiveInvRevDate,
  VATCRQ8.CurrencyCode AS CurrencyCode,
  VATCRQ8.OKVCurrencyCode AS OKVCurrencyCode,
  VATCRQ8.InvoiceAmount AS InvoiceAmount,
  VATCRQ8.TaxAmount AS TaxAmount,
  VATCRQ8.ErrorCode AS ErrorCode,
  CustomDeclarNum.CustomDeclarationNumber AS CustomDeclarationNumber,
  reported_items.LineStatus AS Status
FROM P_RU_VATCRQSEC8 AS VATCRQ8
LEFT OUTER JOIN P_RU_VATCRQCustomDeclarNum AS CustomDeclarNum ON /* join condition not captured in parsed metadata */
;