P_FundsMgmtJournalEntryItem

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_FundsMgmtJournalEntryItem.
-- 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: PFMJRNLITM

CREATE VIEW P_FundsMgmtJournalEntryItem AS
SELECT
  _Header.ReferenceDocumentContext AS ReferenceDocumentContext,
  cast( '00000' as cc_rfknt preserving type ) AS RefDocAccountAssignment,
  cast( '0000' as cc_rfete preserving type ) AS ReferenceDocumentScheduleLine,
  cast( '00000' as rcond preserving type ) AS RefDocPricingElementContent,
  _Header.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _Header.ReferenceDocumentType AS ReferenceDocumentType,
  cast( FundsMgmtSequenceNumber as gu_recid ) AS FundsMgmtLongSequenceNumber,
  FundsMgmtAmountType,
  Ledger,
  FinancialManagementArea,
  FinMgmtAreaFiscalYear,
  cast( FundsManagementDocument as fmis_journal_entry preserving type ) AS FundsMgmtJournalEntry,
  cast( concat(' ', FundsManagementDocumentItem) as fmis_journal_entry_item ) AS FundsMgmtJournalEntryItem,
  FinMgmtAreaPeriod,
  CashEffectivityFiscalYear,
  IsStatisticalItem,
  FundsMgCarryForwardLevel,
  FundsMgmtValueType,
  BusinessTransactionType,
  TransactionCurrency,
  cast(PostedAmountInTransCrcy as vtcur9_cs) AS PostedAmountInTransCrcy,
  FinancialManagementAreaCrcy,
  cast (PostedAmountInFMACrcy as vlcur9_cs) AS PostedAmountInFMACrcy,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedFundsMgmtCustomerField,
  PostedBudgetPeriod,
  CompanyCode,
  BusinessArea,
  GLAccount,
  ProfitCenter,
  ControllingArea,
  FundsMgmtRefDocumentCategory,
  Segment
FROM I_FundsManagementDocumentItem
-- UNION ALL with additional select branch(es): I_FundsMgmtCommitmentEntryItem, I_FundsMgmtCtrlgDocumentItem
;