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_InvoiceJournal5.
-- 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: PRUINVCJRNL5
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id
CREATE VIEW P_RU_InvoiceJournal5 AS
SELECT
InvoiceJournal.CompanyCode AS CompanyCode,
InvoiceJournal.AccountingDocument AS AccountingDocument,
InvoiceJournal.FiscalYear AS FiscalYear,
InvoiceJournal.PostingDate AS PostingDate,
InvoiceJournal.RU_VATSubScenario AS RU_VATSubScenario,
InvoiceJournal.RU_VATReturnSection AS RU_VATReturnSection,
InvoiceJournal.RU_VATReturnSectionType AS RU_VATReturnSectionType,
InvoiceJournal.RU_VATReturnVersion AS RU_VATReturnVersion,
InvoiceJournal.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
InvoiceJournal.RU_VATScenario AS RU_VATScenario,
InvoiceJournal.RU_CustomerOutputType AS RU_CustomerOutputType,
InvoiceJournal.RU_SupplierAgentOutputType AS RU_SupplierAgentOutputType,
InvoiceJournal.RU_SupplierOutputType AS RU_SupplierOutputType,
InvoiceJournal.RU_SubagentOutputType AS RU_SubagentOutputType,
InvoiceJournal.TaxCode AS TaxCode,
InvoiceJournal.DebitCreditCode AS DebitCreditCode,
(_OriginalDocumentAmount.TaxAmount + _OriginalDocumentAmount.TaxBaseAmountInTransCrcy) AS TotalAmountInTransCrcy,
(_OriginalDocumentAmount.TaxAmountInCoCodeCrcy + _OriginalDocumentAmount.TaxBaseAmountInCoCodeCrcy) AS TotalAmountInCoCodeCrcy,
InvoiceJournal.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
InvoiceJournal.TaxAmount AS TaxAmount,
InvoiceJournal.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
InvoiceJournal.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
InvoiceJournal.Currency AS Currency,
InvoiceJournal.CompanyCodeCurrency AS CompanyCodeCurrency,
InvoiceJournal.ItemWithTax AS ItemWithTax,
coalesce(_Currency.AlternativeCurrencyKey, '') AS AlternativeCurrencyKey,
InvoiceJournal.Invoice AS Invoice,
InvoiceJournal.InvoiceYear AS InvoiceYear,
coalesce(InvoiceExtraInfo.ExternalInvoice, '') AS ExternalInvoice,
coalesce(InvoiceExtraInfo.InvoiceDate, '') AS InvoiceDate,
InvoiceJournal.CorrectionInvoice AS CorrectionInvoice,
InvoiceJournal.CorrectionInvoiceYear AS CorrectionInvoiceYear,
coalesce(CorrInvoiceExtraInfo.ExternalInvoice, '') AS ExternalCorrectionInvoice,
coalesce(CorrInvoiceExtraInfo.InvoiceDate, '') AS CorrectionInvoiceDate,
InvoiceJournal.RevisionNumber AS RevisionNumber,
InvoiceJournal.RevisionInvoiceDate AS RevisionInvoiceDate,
InvoiceJournal.OriginalInvoiceRevisionNumber AS OriginalInvoiceRevisionNumber,
InvoiceJournal.OriginalInvoiceRevisionDate AS OriginalInvoiceRevisionDate,
case RU_CustomerOutputType when 'INV' then coalesce( BusinessPartnerItem.Customer, '') when 'BR' then coalesce( AcctgDocumentExtraInfo.Customer, '') else '' end as Buyer AS CustomerelseendasBuyer,
case RU_SupplierAgentOutputType when 'INC' then coalesce(IncInvBusinessPartnerItem.Supplier, '') when 'SL' then coalesce( AcctgDocumentExtraInfo.Supplier, '') else '' end as SellerAgent AS SupplierelseendasSellerAgent,
case RU_SupplierOutputType when 'INV' then coalesce( BusinessPartnerItem.Supplier, '') when 'SL' then coalesce( AcctgDocumentExtraInfo.Supplier, '') else '' end as Seller AS SupplierelseendasSeller,
case RU_SubagentOutputType when 'INV' then coalesce( BusinessPartnerItem.Supplier, '') else '' end as Subagent AS SupplierelseendasSubagent,
case $parameters.P_StatryRptCategory when 'RU_VAT_DCL' then InvoiceJournal.SalesDealType else case RU_SubagentOutputType when 'INV' then InvoiceJournal.SalesDealType else '' end end as SalesDealType AS SalesDealTypeelseendendasSalesDealType,
InvoiceJournal.CommsnTradeInvoiceLinkedAmount AS CommsnTradeInvoiceLinkedAmount,
InvoiceJournal.CommsnTradeInvcLinkedVATAmount AS CommsnTradeInvcLinkedVATAmount,
InvoiceJournal.CommsnTradeInvoiceLinkingCrcy AS CommsnTradeInvoiceLinkingCrcy,
InvoiceJournal.BusinessPartnerName AS BusinessPartnerName,
InvoiceJournal.RU_PartnerOrganizationINN AS RU_PartnerOrganizationINN,
InvoiceJournal.RU_PartnerOrganizationKPP AS RU_PartnerOrganizationKPP,
InvoiceJournal.RU_CommissionTradeCustomerName AS RU_CommissionTradeCustomerName,
InvoiceJournal.RU_CommissionTradeCustomerINN AS RU_CommissionTradeCustomerINN,
InvoiceJournal.RU_CommissionTradeCustomerKPP AS RU_CommissionTradeCustomerKPP,
InvoiceJournal.RU_CommissionTradeSupplierName AS RU_CommissionTradeSupplierName,
InvoiceJournal.RU_CommissionTradeSupplierINN AS RU_CommissionTradeSupplierINN,
InvoiceJournal.RU_CommissionTradeSupplierKPP AS RU_CommissionTradeSupplierKPP,
InvoiceJournal.IncInvBusinessPartnerName AS IncInvBusinessPartnerName,
InvoiceJournal.IncInvPartnerOrganizationINN AS IncInvPartnerOrganizationINN,
InvoiceJournal.IncInvPartnerOrganizationKPP AS IncInvPartnerOrganizationKPP,
InvoiceJournal.ActionRuleIsGenerated AS ActionRuleIsGenerated
LEFT OUTER JOIN P_RU_VATExtraInfo AS InvoiceExtraInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_VATExtraInfo AS CorrInvoiceExtraInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_VATExtraInfo AS AcctgDocumentExtraInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RU_InvoiceTotalAmount AS _OriginalDocumentAmount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS BusinessPartnerItem ON BusinessPartnerItem.CompanyCode = InvoiceJournal.CompanyCode AND BusinessPartnerItem.AccountingDocument = InvoiceJournal.AccountingDocument AND BusinessPartnerItem.FiscalYear = InvoiceJournal.FiscalYear AND (BusinessPartnerItem.FinancialAccountType = 'K' OR BusinessPartnerItem.FinancialAccountType = 'D') -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS IncInvBusinessPartnerItem ON IncInvBusinessPartnerItem.CompanyCode = InvoiceJournal.RU_IncomingInvoiceCompanyCode AND IncInvBusinessPartnerItem.AccountingDocument = InvoiceJournal.IncgInvoiceAccountingDocument AND IncInvBusinessPartnerItem.FiscalYear = InvoiceJournal.IncgInvoiceAcctgDocFiscalYear AND (IncInvBusinessPartnerItem.FinancialAccountType = 'K' OR IncInvBusinessPartnerItem.FinancialAccountType = 'D') -- association [0..1]
LEFT OUTER JOIN P_RU_VATExtraInfo AS _IncomingInvoiceExtraInfo ON _IncomingInvoiceExtraInfo.CompanyCode = InvoiceJournal.RU_IncomingInvoiceCompanyCode AND _IncomingInvoiceExtraInfo.AccountingDocument = InvoiceJournal.IncgInvoiceAccountingDocument AND _IncomingInvoiceExtraInfo.FiscalYear = InvoiceJournal.IncgInvoiceAcctgDocFiscalYear -- association [0..1]
;