I_JrnlEntrItmToBOPFormItmCube

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 I_JrnlEntrItmToBOPFormItmCube.
-- 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: IJEBOPFICUBE

CREATE VIEW I_JrnlEntrItmToBOPFormItmCube AS
SELECT
  Ledger,
  SourceLedger,
  m.CompanyCode AS CompanyCode,
  m.FiscalYear AS FiscalYear,
  m.AccountingDocument AS AccountingDocument,
  LedgerGLLineItem,
  m.CADocumentNumber AS CADocumentNumber,
  m.CASubItemNumber AS CASubItemNumber,
  m.CABPItemNumber AS CABPItemNumber,
  m.CAGLItemNumber AS CAGLItemNumber,
  BOPRptgCntry,
  BOPForm,
  BOPFormItem,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  m.CAReconciliationKey AS CAReconciliationKey,
  m.BusinessPartner AS BusinessPartner,
  m.CADocumentType AS CADocumentType,
  cast( CompanyCodeCountry as glo_companycountry) AS CompanyCodeCountry,
  cast( BOPPartnerCntry as land1 ) AS BOPPartnerCntry,
  PostingDate,
  FiscalYearVariant,
  ChartOfAccounts,
  GLAccount,
  TaxCode,
  AccountingDocumentType,
  SpecialGLCode,
  m.IsEUTriangularDeal AS IsEUTriangularDeal,
  DebitCreditCode,
  TransactionCurrency,
  AmountInTransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  ClearingDate,
  ClearingAccountingDocument,
  CAClearingAccountingDocument,
  ClearingDocFiscalYear,
  IsReversal,
  IsReversed,
  FinancialAccountType,
  Customer,
  Supplier,
  OffsettingAccountType,
  OffsettingAccount,
  PartnerCompany
LEFT OUTER JOIN I_Country AS _BOPRptgCntry ON BOPRptgCntry = _BOPRptgCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _BOPPartnerCntry ON BOPPartnerCntry = _BOPPartnerCntry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _CompanyCodeCountry ON CompanyCodeCountry = _CompanyCodeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON SourceLedger = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON m.CompanyCode = _JournalEntry.CompanyCode AND m.FiscalYear = _JournalEntry.FiscalYear AND m.AccountingDocument = _JournalEntry.AccountingDocument  -- association [1..1]
LEFT OUTER JOIN I_JournalEntryItem AS _JournalEntryItem ON Ledger = _JournalEntryItem.Ledger AND SourceLedger = _JournalEntryItem.SourceLedger AND CompanyCode = _JournalEntryItem.CompanyCode AND FiscalYear = _JournalEntryItem.FiscalYear AND m.AccountingDocument = _JournalEntryItem.AccountingDocument AND m.LedgerGLLineItem = _JournalEntryItem.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
;