N_EarmarkedFundsDocumentItm

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 N_EarmarkedFundsDocumentItm.
-- 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: NEMRKDFNDSDOCITM

CREATE VIEW N_EarmarkedFundsDocumentItm AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentCategory AS EarmarkedFundsDocumentCategory,
  _EarmarkedFundsDocument.EarmarkedFundsDocumentType AS EarmarkedFundsDocumentType,
  ControllingArea,
  CompanyCode,
  FinancialManagementArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  PostingDate,
  _EmrkdFndsLatestItmInFndsMgmt.FinMgmtAreaLatestFiscalYear AS FinMgmtAreaLatestFiscalYear,
  _EmrkdFndsLatestItmInFndsMgmt.FundsMgmtUpdateDate AS FundsMgmtUpdateDate,
  EmrkdFndsDocItmCreatedByUser,
  EmrkdFndsDocItmCreationDate,
  EmrkdFndsDocItmLastChgdByUsr,
  LastChangeDate,
  EmrkdFndsDocItmLastChangeDate,
  GLAccount,
  CostCenter,
  InternalOrder,
  WBSElementInternalID,
  ProjectNetwork,
  CostElement,
  CommitmentItem,
  FundsCenter,
  Fund,
  FundedProgram,
  BudgetPeriod,
  FunctionalArea,
  GrantID,
  BusinessArea,
  Product,
  Supplier,
  Customer,
  AlternativePayee,
  DocumentItemText,
  EmrkdFndsReferenceDocumentItem,
  DueDate,
  EmrkdFndsItmCompletionDate,
  EmrkdFndsDocItmGroupingNumber,
  EmrkdFndsItmPrdcssrDocCat,
  EmrkdFndsItmPredecessor,
  EmrkdFndsItmPrdcssrItem,
  EmrkdFndsItmPrdcssrCompleted,
  PrdcssrFundsReservationDoc,
  PrdcssrFundsReservationDocItem,
  PrdcssrFundsPreCmtmtDoc,
  PrdcssrFundsPreCmtmtDocItem,
  EmrkdFndsItmIsCompleted,
  EmrkdFndsItmIsStatistical,
  EmrkdFndsItmIsDeleted,
  EmrkdFndsItmIsSender,
  EmrkdFndsItmIsReceiver,
  EmrkdFndsItmManualEditBlock,
  EmrkdFndsItmIsBlkdAgainstUsage,
  EmrkdFndsItmIsUnlimited,
  EmrkdFndsItmToleranceLmtInPct,
  EmrkdFndsOverrideGlobTolerance,
  EmrkdFndsItmIsApproved,
  EmrkdFndsItmNoCarryforward,
  EmrkdFndsAcctAssgmtChangeable,
  EmrkdFndsHasValueAdjustments,
  EmrkdFndsItmCnsmpnInCCCrcyOnly,
  EmrkdFndsDocItmNmbrOfProcgItms,
  EmrkdFndsAmountInTransCrcy,
  EmrkdFndsRelAmtInTransCrcy,
  EmrkdFndsOpenAmtInTransCrcy,
  EmrkdFndsChgdAmtInTransCrcy,
  EmrkdFndsCnsmdAmtInTransCrcy,
  EmrkdFndsOriglAmtInTransCrcy,
  EmrkdFndsAmountInCCCrcy,
  EmrkdFndsRelAmtInCCCrcy,
  EmrkdFndsOpenAmtInCCCrcy,
  EmrkdFndsChgdAmtInCCCrcy,
  EmrkdFndsCnsmdAmtInCCCrcy,
  EmrkdFndsOriglAmtInCCCrcy
FROM I_EarmarkedFundsDocumentItem
LEFT OUTER JOIN I_EmrkdFndsLatestItmInFndsMgmt AS _EmrkdFndsLatestItmInFndsMgmt ON EarmarkedFundsDocument = _EmrkdFndsLatestItmInFndsMgmt.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _EmrkdFndsLatestItmInFndsMgmt.EarmarkedFundsDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear AND CommitmentItem = _CommitmentItem.CommitmentItem  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemText AS _CommitmentItemText ON FinancialManagementArea = _CommitmentItemText.FinancialManagementArea AND CommitmentItemFiscalYear = _CommitmentItemText.FinMgmtAreaFiscalYear AND CommitmentItem = _CommitmentItemText.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_DocCategory AS _EarmarkedFundsDocCategory ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCategory.EarmarkedFundsDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocCatText AS _EarmarkedFundsDocCatText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocCatText.EarmarkedFundsDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_DocType AS _EarmarkedFundsDocType ON EarmarkedFundsDocumentType = _EarmarkedFundsDocType.EarmarkedFundsDocumentType AND EarmarkedFundsDocumentCategory = _EarmarkedFundsDocType.EarmarkedFundsDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocTypeText AS _EarmarkedFundsDocTypeText ON EarmarkedFundsDocumentCategory = _EarmarkedFundsDocTypeText.EarmarkedFundsDocumentCategory AND EarmarkedFundsDocumentType = _EarmarkedFundsDocTypeText.EarmarkedFundsDocumentType  -- association [0..*]
;