P_RU_DATASELVATCRQNewItems

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_DATASELVATCRQNewItems.
-- 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: PRUDTSELVATCRQNI
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_RequestID : j_3rf_vatcrq_n1

CREATE VIEW P_RU_DATASELVATCRQNewItems AS
SELECT
  $parameters.P_StatryRptgEntity AS StatryRptgEntity,
  $parameters.P_StatryRptCategory AS StatryRptCategory,
  $parameters.P_StatryRptRunID AS StatryRptRunID,
  VATCRQ8.RequestID AS RequestID,
  VATCRQ8.FiscalYear AS FiscalYear,
  VATCRQ8.TaxPeriod AS TaxPeriod,
  VATCRQ8.VATRetCorrNum AS CorrNumber,
  VATCRQ8.RequestLineItemNum AS LineNumber,
  VATCRQ8.AddFlag AS AddFlag,
  VATCRQPROC.Status as LineStatus AS P_StatryRptgEntityasStatryRptgEntity,
  '00005' AS SectionNumber,
  VATCRQPROC.Status AS LineStatus
FROM P_RU_VATCRQSEC8 AS VATCRQ8
LEFT OUTER JOIN P_RU_VATCRQProsessingData AS VATCRQPROC ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RU_VATCRQSEC9, P_RU_VATCRQSEC10, P_RU_VATCRQSEC11, P_RU_VATCRQSEC12, P_RU_VATCRQKS
;