P_RU_VATCRQSEC8

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_VATCRQSEC8.
-- 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: PRUVATCRQSEC8

CREATE VIEW P_RU_VATCRQSEC8 AS
SELECT
  VATCRQ8.n1 AS RequestID,
  VATCRQ8.gjahr AS FiscalYear,
  VATCRQ8.period AS TaxPeriod,
  VATCRQ8.corr_num AS VATRetCorrNum,
  VATCRQ8.num_line AS RequestLineItemNum,
  VATCRQ8.flag_add AS AddFlag,
  VATCRQ8.ext_number AS ExternalDocNumber,
  VATCRQ8.bukrs AS CompanyCode,
  VATCRQ8.gjahr_inv AS InvFiscalYear,
  VATCRQ8.belnr_inv AS InvDocNumber,
  VATCRQ8.gjahr_trn AS TrnFiscalYear,
  VATCRQ8.belnr_trn AS TrnDocNumber,
  VATCRQ8.gjahr_pay AS PayFiscalYear,
  VATCRQ8.belnr_pay AS PayDocNumber,
  VATCRQ8.ext_number AS ExternalDocumentNumber,
  VATCRQ8.bldat_orig_inv AS OriginalInvDate,
  VATCRQ8.belnr_orig_rev AS OrigInvRevNumber,
  VATCRQ8.bldat_orig_rev AS OrigInvRevDate,
  VATCRQ8.bldat_corr_inv AS CorrectiveInvDate,
  VATCRQ8.ext_number_corr AS CorrectiveInvExtNumber,
  VATCRQ8.number_corr_rev AS CorrectiveInvRevNumber,
  VATCRQ8.bldat_corr_rev AS CorrectiveInvRevDate,
  VATCRQ8.waers AS CurrencyCode,
  VATCRQ8.wrbtr_wrs_pay AS OKVCurrencyCode,
  VATCRQ8.wrbtr_pay AS InvoiceAmount,
  VATCRQ8.hwste_pay AS TaxAmount,
  VATCRQ8.hwste_wrs_pay AS TaxAmountOKVCurrencyCode,
  VATCRQ8.err_code AS ErrorCode,
  VATCRQ8.pay_ext_number AS PayDocExtNumberAndDate,
  VATCRQ8.pay_ext_bldat AS PayDocDate,
  VATCRQ8.vendor AS VendorNumber,
  VATCRQ8.vendor_name AS VendorName,
  VATCRQ8.tech_mm_inv_vornu AS TechMMInvoiceNumber,
  VATCRQ8.mm_inv_vornu AS MMInvoiceNumber
FROM j3rf_vatcrq8 AS VATCRQ8
;