I_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 I_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: IFMJRNLITM

CREATE VIEW I_FundsMgmtJournalEntryItem AS
SELECT
  ReferenceDocumentContext,
  RefDocAccountAssignment,
  ReferenceDocumentScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentLogicalSystem,
  ReferenceDocumentType,
  FundsMgmtRefDocumentCategory,
  FundsMgmtLongSequenceNumber,
  FundsMgmtAmountType,
  Ledger,
  FinancialManagementArea,
  FinMgmtAreaFiscalYear,
  FundsMgmtJournalEntry,
  FundsMgmtJournalEntryItem,
  FinMgmtAreaPeriod,
  CashEffectivityFiscalYear,
  TransactionCurrency,
  PostedAmountInTransCrcy,
  FinancialManagementAreaCrcy,
  PostedAmountInFMACrcy,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedBudgetPeriod,
  PostedFundsMgmtCustomerField,
  CompanyCode,
  BusinessArea,
  GLAccount,
  ProfitCenter,
  Segment,
  FundsMgmtValueType,
  BusinessTransactionType,
  IsStatisticalItem,
  FundsMgCarryForwardLevel,
  _FundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  _FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  _Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _CommitmentItem.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  _CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _FunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  _FundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  _FundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp
FROM P_FundsMgmtJournalEntryItem
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON PostedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND PostedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterByYear AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear AND PostedFundsCenter = _FundsCenter.FundsCenter  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND PostedCommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' )  -- association [1..1]
LEFT OUTER JOIN I_Grant AS _Grant ON PostedGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND PostedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON PostedFunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
;