I_MPJournalEntryItemCube

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_MPJournalEntryItemCube.
-- 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: IMPJRNLCUBE

CREATE VIEW I_MPJournalEntryItemCube AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LedgerFiscalYear,
  GLRecordType,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  ChartOfAccounts,
  ControllingArea,
  cast( _ControllingArea.ControllingAreaName as fis_bezei preserving type ) AS ControllingAreaName,
  BusinessTransactionType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  GLAccount,
  CostCenter,
  PartnerCostCenter,
  BusinessArea,
  Segment,
  TransactionCurrency,
  AmountInTransactionCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  FiscalPeriod,
  cast (PostingDate as abap.char( 10 )) AS PostingDate,
  DocumentDate,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  AccountingDocCreatedByUser,
  PurchasingDocument,
  PurchasingDocumentItem,
  DocumentItemText,
  SalesOrder,
  SalesOrderItem,
  Material,
  Plant,
  Supplier,
  Customer,
  FinancialAccountType,
  ControllingObject,
  PersonnelNumber,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElement,
  WorkPackage,
  Project,
  ProjectNetwork,
  RelatedNetworkActivity,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision
FROM I_JournalEntryItem
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON OrderID = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
;