C_RU_VATReturnMainSectionItemC

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 C_RU_VATReturnMainSectionItemC.
-- 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: CRUVATRETMSIC
-- Parameters: P_FiscalYearVariant : fis_periv, P_Date : datum

CREATE VIEW C_RU_VATReturnMainSectionItemC AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  PostingDate,
  TaxReportingDate,
  DocumentDate,
  IsReversal,
  IsReversed,
  SourceDocument,
  SourceDocumentFiscalYear,
  cast( ExternalInvoice as firu_inv_extnum ) AS ExternalInvoice,
  cast( InvoiceDate as firu_inv_extdate ) AS InvoiceDate,
  CompanyCodeCurrency,
  BusinessTransactionType,
  AccountingDocumentType,
  TaxCode,
  cast( TaxBaseAmountInCoCodeCrcy as firu_taxbaseamountcccrcy ) AS TaxBaseAmountInCoCodeCrcy,
  cast( TaxAmountInCoCodeCrcy as firu_taxamountcccrcy ) AS TaxAmountInCoCodeCrcy,
  cast( Supplier as bu_partner ) AS Supplier,
  cast( SupplierName as firu_partner_name_250 ) AS SupplierName,
  cast( RU_PartnerOrganizationINN as firu_partner_inn ) AS RU_PartnerOrganizationINN,
  cast( RU_PartnerOrganizationKPP as firu_partner_kpp ) AS RU_PartnerOrganizationKPP,
  cast( RU_PartnerPersonINN as firu_partner_pers_inn ) AS RU_PartnerPersonINN,
  cast( FirstName as firu_partner_pers_first_name ) AS FirstName,
  cast( LastName as firu_partner_pers_last_name ) AS LastName,
  cast( MiddleName as firu_partner_pers_middle_name ) AS MiddleName,
  cast( RU_TerritoryClassfctnOKTMO as firu_oktmo_int) 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_VATReturnVersion,
  RU_VATReturnSectionType,
  RU_VATReturnSection,
  cast( RU_VATReturnLine as j_3rvatdline ) AS TaxBoxByTaxAuthority,
  cast( VATReturnItemDescription as firu_vatitdes_250 ) AS VATReturnItemDescription,
  RU_VATSubScenarioVersion,
  RU_VATSubScenario,
  RU_VATScenario,
  AuthorizationGroup,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM P_RU_VATReturnGeneralSection3
;