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_VATReturnGeneralSection.
-- 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: PRUVATRETGS
-- Parameters: P_FiscalYearVariant : fis_periv, P_Date : datum
CREATE VIEW P_RU_VATReturnGeneralSection 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,
cast('' as firu_currency_iso_code) AS CurrencyISOCode,
cast(0 as glo_total_amount_intrancrcy) AS TotalAmountInTransactionCrcy,
cast(0 as glo_total_amount_incompcrcy) AS TotalAmountInCoCodeCrcy,
cast(0 as firu_taxamount_in_trans_curr) AS TaxAmountInTransCrcy,
TaxAmountInCoCodeCrcy,
cast(0 as fwbas) AS TaxBaseAmountInTransCrcy,
TaxBaseAmountInCoCodeCrcy,
cast(0 as firu_taxbaseamount0cccrcy) AS TxBaseAmtWithTxRate0InCCCrcy,
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_taxamount10cccrcy ) AS TxAmtWithTxRate10InCCCrcy,
cast(0 as firu_taxamount18cccrcy) AS TxAmtWithTxRate18InCCCrcy,
cast(0 as firu_taxamount20cccrcy) AS TxAmtWithTxRate20InCCCrcy,
Sign,
BusinessPartner,
BusinessPartnerIsOrganization,
BusinessPartnerIsNaturalPerson,
cast(SupplierName 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,
cast('' as j_3rfinv_opertypcod) AS RU_VATOperationType,
cast('' as firu_vatrdealtp) AS SalesDealType,
cast(RU_TerritoryClassfctnOKTMO as firu_oktmo) AS RU_TerritoryClassfctnOKTMO,
cast(VATReturnOperation as j_3rvatdopertype) AS VATReturnOperation,
cast(ExportInvcConfirmedFiscalYear as j_3r_rep_year) AS ExportInvcConfirmedFiscalYear,
cast(FiscalPeriod as j_3rf_tax_per) AS FiscalPeriod,
RU_VATReturnSection,
RU_VATReturnLine,
RU_VATReturnVersion,
RU_VATSubScenarioVersion,
RU_VATScenario,
StatryRptgEntity,
StatryRptCategory,
StatryRptRunID
FROM P_RU_VATReturnGeneralSection3
;