C_RU_IncomingInvcJrnlItemCube

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_IncomingInvcJrnlItemCube.
-- 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: CRUINCINVJRNC
-- Parameters: P_StatutoryReportVersion : firu_xml_version

CREATE VIEW C_RU_IncomingInvcJrnlItemCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  PostingDate,
  cast(TaxReportingDate as vatdate) AS TaxReportingDate,
  AccountingDocumentType,
  TaxCode,
  cast(Invoice as firu_inv_origdoc) AS Invoice,
  cast(InvoiceYear as firu_inv_origyear) AS InvoiceYear,
  cast(CorrectionInvoice as firu_inv_corrdoc) AS CorrectionInvoice,
  cast(CorrectionInvoiceYear as firu_inv_corryear) AS CorrectionInvoiceYear,
  cast(RevisionInvoice as firu_inv_revdoc) AS RevisionInvoice,
  cast(RevisionInvoiceYear as firu_inv_revyear) AS RevisionInvoiceYear,
  cast(RU_InvoiceType as firu_invoice_type) AS RU_InvoiceType,
  cast(ExternalInvoice as j_3rfinv_orige) AS ExternalInvoice,
  cast(InvoiceDate as j_3rfinv_origd) AS InvoiceDate,
  cast(OriginalInvoiceRevisionNumber as j_3rfinv_revno_orig) AS OriginalInvoiceRevisionNumber,
  cast(OriginalInvoiceRevisionDate as j_3rfinv_orig_revd) AS OriginalInvoiceRevisionDate,
  cast(ExternalCorrectionInvoice as j_3rfinv_corre) AS ExternalCorrectionInvoice,
  cast(CorrectionInvoiceDate as j_3rfinv_corrd) AS CorrectionInvoiceDate,
  cast(CorrectionInvoiceRevisionNmbr as j_3rfinv_revno_corr) AS CorrectionInvoiceRevisionNmbr,
  cast(CorrectionInvoiceRevisionDate as j_3rfinv_corr_revd) AS CorrectionInvoiceRevisionDate,
  Currency,
  cast(CurrencyISOCode as firu_currency_iso_code) AS CurrencyISOCode,
  cast(TotalAmountInTransactionCrcy as glo_total_amount_intrancrcy) AS TotalAmountInTransactionCrcy,
  cast(AmountInTransactionCurrency as glo_amount_trans_crcy) AS AmountInTransactionCurrency,
  cast(TaxAmountInTransCrcy as firu_taxamount_in_trans_curr) AS TaxAmountInTransCrcy,
  cast(OriginalAmountInTransacCrcy as firu_amount_org_intranscrcy) AS OriginalAmountInTransacCrcy,
  cast(OriginalTaxAmountInTransacCrcy as firu_taxamount_org_intranscrcy) AS OriginalTaxAmountInTransacCrcy,
  cast(DifferenceAmtInTransCrcy as firu_amount_dif_intranscrcy) AS DifferenceAmtInTransCrcy,
  cast(DifferenceTaxAmtInTransCrcy as firu_taxamount_dif_intranscrcy) AS DifferenceTaxAmtInTransCrcy,
  TaxItemGroupingVersion,
  Sign,
  cast(BusinessPartner as bu_partner) AS BusinessPartner,
  cast(BusinessPartnerIsOrganization as firu_is_bp_org) AS BusinessPartnerIsOrganization,
  BusinessPartnerIsNaturalPerson AS IsNaturalPerson,
  cast(BusinessPartnerName as firu_partner_name_250) AS BusinessPartnerName,
  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(Agent as firu_subagent) AS Agent,
  cast(AgentIsOrganization as firu_is_subagent_org) AS AgentIsOrganization,
  cast(AgentOrganizationName as firu_subagent_name) AS AgentOrganizationName,
  cast(RU_AgentOrganizationINN as firu_subagent_inn) AS RU_AgentOrganizationINN,
  cast(RU_AgentOrganizationKPP as firu_subagent_kpp) AS RU_AgentOrganizationKPP,
  cast(RU_AgentPersonINN as firu_subagent_pers_inn) AS RU_AgentPersonINN,
  cast(AgentPersonSurname as firu_subagent_pers_last_name) AS AgentPersonSurname,
  cast(AgentPersonName as firu_subagent_pers_first_name) AS AgentPersonName,
  cast(AgentPersonMiddleName as firu_subagent_pers_middle_name) AS AgentPersonMiddleName,
  RU_VATReturnVersion,
  RU_VATReturnSectionType,
  RU_VATSubScenarioVersion,
  RU_VATSubScenario,
  RU_VATScenario,
  SalesDealType,
  RU_VATOperationType,
  SourceDocument,
  SourceDocumentFiscalYear,
  RevisionNumber,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  cast('0' as firu_relevance_sign) AS ActionRuleIsGenerated
FROM P_RU_VATIncomingInvcJournal2
;