R_EarmarkedFundsDocItemDraft

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 R_EarmarkedFundsDocItemDraft.
-- 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.

CREATE VIEW R_EarmarkedFundsDocItemDraft AS
SELECT
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  DraftUUID,
  ParentDraftUUID,
  EarmarkedFundsDocItemForEdit,
  ControllingArea,
  CompanyCode,
  FinancialManagementArea,
  TransactionCurrency,
  CompanyCodeCurrency,
  PostingDate,
  EmrkdFndsDocItmCreatedByUser,
  EmrkdFndsDocItmCreationDate,
  EmrkdFndsDocItmLastChgdByUsr,
  EmrkdFndsDocItmLastChangeDate,
  GLAccount,
  CostCenter,
  InternalOrder,
  WBSElementInternalID,
  WBSElementExternalID,
  ProjectNetwork,
  CostElement,
  CommitmentItem,
  FundsCenter,
  Fund,
  FundedProgram,
  BudgetPeriod,
  FunctionalArea,
  GrantID,
  BusinessArea,
  Product,
  Supplier,
  Customer,
  AlternativePayee,
  DocumentItemText,
  EmrkdFndsReferenceDocumentItem,
  cast ( referencedocumentitem as fins_awitem ) AS ReferenceDocumentItem,
  DueDate,
  EmrkdFndsItmCompletionDate,
  EmrkdFndsDocItmGroupingNumber,
  ProfitCenter,
  EmrkdFndsItmPrdcssrDocCat,
  EmrkdFndsItmPredecessor,
  EmrkdFndsItmPrdcssrItem,
  EmrkdFndsItmPrdcssrCompleted,
  PrdcssrFundsReservationDoc,
  PrdcssrFundsReservationDocItem,
  PrdcssrFundsPreCmtmtDoc,
  PrdcssrFundsPreCmtmtDocItem,
  EmrkdFndsItmIsCompleted,
  EmrkdFndsItmIsStatistical,
  EmrkdFndsItmIsDeleted,
  EmrkdFndsItmIsSender,
  EmrkdFndsItmIsReceiver,
  EmrkdFndsItmManualEditBlock,
  EmrkdFndsItmIsBlkdAgainstUsage,
  EmrkdFndsItmIsUnlimited,
  EmrkdFndsItmToleranceLmtInPct,
  EmrkdFndsOverrideGlobTolerance,
  EmrkdFndsItmIsApproved,
  EmrkdFndsItmNoCarryforward,
  EmrkdFndsAcctAssgmtChangeable,
  EmrkdFndsHasValueAdjustments,
  EmrkdFndsItmCnsmpnInCCCrcyOnly,
  EmrkdFndsDocItmNmbrOfProcgItms,
  PubSecSplitBatchNumberID,
  PubSecSplitAuthznGroup,
  EmrkdFndsAmountInTransCrcy,
  EmrkdFndsRelAmtInTransCrcy,
  EmrkdFndsOpenAmtInTransCrcy,
  EmrkdFndsChgdAmtInTransCrcy,
  EmrkdFndsCnsmdAmtInTransCrcy,
  EmrkdFndsOriglAmtInTransCrcy,
  EmrkdFndsAmountInCCCrcy,
  EmrkdFndsRelAmtInCCCrcy,
  EmrkdFndsOpenAmtInCCCrcy,
  EmrkdFndsChgdAmtInCCCrcy,
  EmrkdFndsCnsmdAmtInCCCrcy,
  EmrkdFndsOriglAmtInCCCrcy,
  HasActiveEntity,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  DraftFieldChanges,
  PubSecBdgtAcctRevnExpnCode
FROM kblp_draft2 AS efitm_draft
LEFT OUTER JOIN R_EarmarkedFundsDocumentDraft AS _EarmarkedFundsDocumentDraft ON EarmarkedFundsDocument = _EarmarkedFundsDocumentDraft.EarmarkedFundsDocument AND ParentDraftUUID = _EarmarkedFundsDocumentDraft.DraftUUID  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FundsMgmtFunctionalArea ON FunctionalArea = _FundsMgmtFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN E_EarmarkedFundsDocItemDraft AS _ExtensionDraft ON EarmarkedFundsDocument = _ExtensionDraft.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _ExtensionDraft.EarmarkedFundsDocumentItem  -- association [1]
;