P_RU_DSVATCRQSec9

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_DSVATCRQSec9.
-- 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: PRUDSVATCRQSEC9
-- 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_DSVATCRQSec9 AS
SELECT
  $parameters.P_SectionNumber AS SectionNumber,
  VATCRQ9.FiscalYear AS FiscalYear,
  VATCRQ9.TaxPeriod AS TaxPeriod,
  VATCRQ9.VATRetCorrNum AS VATRetCorrNum,
  VATCRQ9.RequestLineItemNum AS RequestLineItemNum,
  VATCRQ9.AddFlag AS AddFlag,
  VATCRQ9.ExternalDocNumber AS ExternalDocNumber,
  VATCRQ9.OriginalInvDate AS OriginalInvDate,
  VATCRQ9.OrigInvRevNumber AS OrigInvRevNumber,
  VATCRQ9.OrigInvRevDate AS OrigInvRevDate,
  VATCRQ9.CorrectiveInvDate AS CorrectiveInvDate,
  VATCRQ9.CorrectiveInvExtNumber AS CorrectiveInvExtNumber,
  VATCRQ9.CorrectiveInvRevNumber AS CorrectiveInvRevNumber,
  VATCRQ9.CorrectiveInvRevDate AS CorrectiveInvRevDate,
  case when VATCRQ9.OKVCurrencyCode = '000' then '' else VATCRQ9.OKVCurrencyCode end as OKVCurrencyCode AS OKVCurrencyCodeendasOKVCurrencyCode,
  VATCRQ9.InvoiceAmountFC AS DocumentAmountFCurr,
  VATCRQ9.InvoiceAmountLC AS DocumentAmount,
  VATCRQ9.VAT18BaseAmount AS VAT18BaseAmount,
  VATCRQ9.VAT10BaseAmount AS VAT10BaseAmount,
  VATCRQ9.VAT7BaseAmount AS VAT7BaseAmount,
  VATCRQ9.VAT5BaseAmount AS VAT5BaseAmount,
  VATCRQ9.VAT0BaseAmount AS VAT0BaseAmount,
  VATCRQ9.VATFreeBaseAmount AS VATFreeBaseAmount,
  VATCRQ9.VAT18Amount AS VAT18Amount,
  VATCRQ9.VAT10Amount AS VAT10Amount,
  VATCRQ9.VAT7Amount AS VAT7Amount,
  VATCRQ9.VAT5Amount AS VAT5Amount,
  VATCRQ9.ErrorCode AS ErrorCode,
  reported_items.LineStatus AS Status
FROM P_RU_VATCRQSEC9 AS VATCRQ9
;