P_RU_VATReturnSection12

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_VATReturnSection12.
-- 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: PRUVATRET12

CREATE VIEW P_RU_VATReturnSection12 AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  SourceDocument AS OriginalDocument,
  SourceDocumentFiscalYear AS OriginalDocumentYear,
  RevisionNumber,
  RU_VATReturnSectionType,
  RU_VATSubScenario,
  cast(' ' as firu_inv_origdoc) AS Invoice,
  cast('0000' as firu_inv_origyear) AS InvoiceYear,
  ExternalInvoice,
  InvoiceDate,
  cast('' as firu_inv_revdoc) AS RevisionInvoice,
  cast('0000' as firu_inv_revyear) AS RevisionInvoiceYear,
  cast('000' as firu_inv_origrevnum) AS OriginalInvoiceRevisionNumber,
  cast('00000000' as firu_inv_origrevdate) AS OriginalInvoiceRevisionDate,
  cast('' as firu_inv_corrdoc) AS CorrectionInvoice,
  cast('0000' as firu_inv_corryear) AS CorrectionInvoiceYear,
  cast('' as j_3rfinv_corre) AS ExternalCorrectionInvoice,
  cast('00000000' as j_3rfinv_corrd) AS CorrectionInvoiceDate,
  cast('000' as j_3rfinv_revno_corr) AS CorrectionInvoiceRevisionNmbr,
  cast('00000000' as j_3rfinv_corr_revd) AS CorrectionInvoiceRevisionDate,
  TaxReportingDate,
  IsReversal,
  IsReversed,
  cast('' as firu_invoice_type) AS RU_InvoiceType,
  TaxCode,
  cast('' as verstax) AS TaxItemGroupingVersion,
  CompanyCodeCurrency,
  Currency,
  CurrencyISOCode,
  TotalAmountInTransactionCrcy,
  cast(0 as glo_total_amount_incompcrcy) AS TotalAmountInCoCodeCrcy,
  TaxAmountInTransCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInCoCodeCrcy,
  cast(0 as firu_taxbaseamount0cccrcy) AS TxBaseAmtWithTxRate0InCCCrcy,
  cast(0 as firu_taxbaseamount5cccrcy) AS TxBaseAmtWithTxRate5InCCCrcy,
  cast(0 as firu_taxbaseamount7cccrcy) AS TxBaseAmtWithTxRate7InCCCrcy,
  cast(0 as firu_taxbaseamount10cccrcy) AS TxBaseAmtWithTxRate10InCCCrcy,
  cast(0 as firu_taxbaseamount18cccrcy) AS TxBaseAmtWithTxRate18InCCCrcy,
  cast(0 as firu_taxbaseamount20cccrcy) AS TxBaseAmtWithTxRate20InCCCrcy,
  cast(0 as firu_baseamountnotaxcccrcy) AS BaseAmtWithoutTxInCCCrcy,
  cast(0 as firu_taxamount5cccrcy ) AS TxAmtWithTxRate5InCCCrcy,
  cast(0 as firu_taxamount7cccrcy ) AS TxAmtWithTxRate7InCCCrcy,
  cast(0 as firu_taxamount10cccrcy ) AS TxAmtWithTxRate10InCCCrcy,
  cast(0 as firu_taxamount18cccrcy) AS TxAmtWithTxRate18InCCCrcy,
  cast(0 as firu_taxamount20cccrcy) AS TxAmtWithTxRate20InCCCrcy,
  Sign,
  BusinessPartner,
  BusinessPartnerIsOrganization,
  BusinessPartnerIsNaturalPerson,
  cast(CustomerName as firu_partner_name) AS BusinessPartnerName,
  RU_PartnerOrganizationINN,
  RU_PartnerOrganizationKPP,
  RU_PartnerPersonINN,
  FirstName,
  LastName,
  MiddleName,
  cast('' as glo_partner_country) AS BusinessPartnerCountry,
  cast('' as j_3rf_bk_agent_id) AS Agent,
  cast('' as firu_is_agent_org) AS AgentIsOrganization,
  cast('' as j_3rf_bk_agent_name) AS AgentOrganizationName,
  cast('' as j_3rf_bk_agent_inn) AS RU_AgentOrganizationINN,
  cast('' as j_3rf_bk_agent_kpp) AS RU_AgentOrganizationKPP,
  cast('' as firu_agent_pers_inn) AS RU_AgentPersonINN,
  cast('' as firu_agent_pers_last_name) AS AgentPersonSurname,
  cast('' as firu_agent_pers_first_name) AS AgentPersonName,
  cast('' as firu_agent_pers_middle_name) AS AgentPersonMiddleName,
  cast('' as firu_inv_companycode_in) AS RU_IncomingInvoiceCompanyCode,
  cast('' as firu_inv_origdoc_in) AS RU_IncomingInvoiceNumber,
  cast('0000' as firu_inv_origyear_in) AS RU_IncomingInvoiceFiscalYear,
  cast('' as firu_inv_corrdoc_in) AS IncomingCorrectionInvoice,
  cast('0000' as firu_inv_corryear_in) AS IncomingCorrectionInvoiceYear,
  cast('000' as firu_inv_revnum_in) AS IncomingRevisionNumber,
  cast('' as firud_ext_number_in) AS IncomingExternalInvoice,
  cast('00000000' as firu_inv_extdate_in) AS RU_IncomingInvoiceDate,
  cast('' as firu_invoice_type_in) AS RU_IncomingInvoiceType,
  cast('' as firud_trans_crcy_in) AS IncomingInvoiceTransCurrency,
  cast('' as firu_inv_currency_iso_code_in) AS IncgInvoiceTransCrcyISOCode,
  cast(0 as firu_invj_linked_amount) AS CommsnTradeInvoiceLinkedAmount,
  cast(0 as firu_invj_linked_vat) AS CommsnTradeInvcLinkedVATAmount,
  cast(0 as firu_amount_org_intranscrcy) AS OriginalAmountInTransacCrcy,
  cast(0 as firu_taxamount_org_intranscrcy) AS OriginalTaxAmountInTransacCrcy,
  cast(0 as firu_amount_dif_intranscrcy) AS DifferenceAmtInTransCrcy,
  cast(0 as firu_taxamount_dif_intranscrcy) AS DifferenceTaxAmtInTransCrcy,
  RU_VATOperationType,
  cast('' as firu_vatrdealtp) AS SalesDealType,
  '' AS RU_TerritoryClassfctnOKTMO,
  '' AS VATReturnOperation,
  '0000' AS ExportInvcConfirmedFiscalYear,
  '' AS FiscalPeriod,
  RU_VATReturnSection,
  RU_VATReturnLine,
  RU_VATReturnVersion,
  RU_VATSubScenarioVersion,
  RU_VATScenario,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM P_RU_VATReturnSection122
;