I_EarmarkedFundsDocumentItem

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_EarmarkedFundsDocumentItem.
-- 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 I_EarmarkedFundsDocumentItem AS
SELECT
  cast ( belnr as fmis_earmarkedfundsdoc preserving type ) AS EarmarkedFundsDocument,
  cast ( blpos as fmis_earmarkedfundsdocitem preserving type ) AS EarmarkedFundsDocumentItem,
  _EarmarkedFundsDocument.ControllingArea AS ControllingArea,
  _EarmarkedFundsDocument.CompanyCode AS CompanyCode,
  _EarmarkedFundsDocument.FinancialManagementArea AS FinancialManagementArea,
  _EarmarkedFundsDocument.TransactionCurrency AS TransactionCurrency,
  _EarmarkedFundsDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  _EarmarkedFundsDocument.PostingDate AS PostingDate,
  erfas AS EmrkdFndsDocItmCreatedByUser,
  erdat AS EmrkdFndsDocItmCreationDate,
  aende AS EmrkdFndsDocItmLastChgdByUsr,
  aedat AS LastChangeDate,
  aedat AS EmrkdFndsDocItmLastChangeDate,
  saknr AS GLAccount,
  kostl AS CostCenter,
  aufnr AS InternalOrder,
  cast ( pspnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  nplnr AS ProjectNetwork,
  kstar AS CostElement,
  fipex AS CommitmentItem,
  fistl AS FundsCenter,
  geber AS Fund,
  measure AS FundedProgram,
  budget_pd AS BudgetPeriod,
  fkber AS FunctionalArea,
  grant_nbr AS GrantID,
  gsber AS BusinessArea,
  cast ( matnr as productnumber preserving type ) AS Product,
  lifnr AS Supplier,
  kunnr AS Customer,
  lnrza AS AlternativePayee,
  ptext AS DocumentItemText,
  rfpos AS EmrkdFndsReferenceDocumentItem,
  fdatk AS DueDate,
  erldat AS EmrkdFndsItmCompletionDate,
  ef_group_number AS EmrkdFndsDocItmGroupingNumber,
  cast ( prctr as fis_prctr preserving type ) AS ProfitCenter,
  refbltyp AS EmrkdFndsItmPrdcssrDocCat,
  refbelnr AS EmrkdFndsItmPredecessor,
  refblpos AS EmrkdFndsItmPrdcssrItem,
  refseterlk AS EmrkdFndsItmPrdcssrCompleted,
  cast ( erlkz as fmre_erlkz preserving type ) AS EmrkdFndsItmIsCompleted,
  stats AS EmrkdFndsItmIsStatistical,
  loekz AS EmrkdFndsItmIsDeleted,
  xsender AS EmrkdFndsItmIsSender,
  xempfgr AS EmrkdFndsItmIsReceiver,
  poslock AS EmrkdFndsItmManualEditBlock,
  blpkz AS EmrkdFndsItmIsBlkdAgainstUsage,
  consumekz AS EmrkdFndsItmIsUnlimited,
  uebto AS EmrkdFndsItmToleranceLmtInPct,
  tolov AS EmrkdFndsOverrideGlobTolerance,
  cast ( wkapp as fmis_efd_itmisapproved preserving type ) AS EmrkdFndsItmIsApproved,
  carryov AS EmrkdFndsItmNoCarryforward,
  cast ( acchang as fmis_efd_acctassgmtchangeable preserving type ) AS EmrkdFndsAcctAssgmtChangeable,
  pmactive AS EmrkdFndsHasValueAdjustments,
  abgwaers AS EmrkdFndsItmCnsmpnInCCCrcyOnly,
  ewscount AS EmrkdFndsDocItmNmbrOfProcgItms,
  fm_split_batch AS PubSecSplitBatchNumberID,
  fm_split_begru AS PubSecSplitAuthznGroup,
  cast ( wtges as kblwtg preserving type ) AS EmrkdFndsAmountInTransCrcy,
  cast ( wtgesapp as wtgesapp preserving type ) AS EmrkdFndsRelAmtInTransCrcy,
  cast ( wtfree as fmwtfree preserving type ) AS EmrkdFndsOpenAmtInTransCrcy,
  cast ( deltawtapp as deltawtapp preserving type ) AS EmrkdFndsChgdAmtInTransCrcy,
  cast ( wtabg as kblwtabg preserving type ) AS EmrkdFndsCnsmdAmtInTransCrcy,
  cast ( wtorig as fmwtorig preserving type ) AS EmrkdFndsOriglAmtInTransCrcy,
  cast ( hwges as fmis_efd_amountincccrcy preserving type ) AS EmrkdFndsAmountInCCCrcy,
  cast ( hwgesapp as hwgesapp preserving type ) AS EmrkdFndsRelAmtInCCCrcy,
  cast ( hwfree as fmis_efd_openamtincccrcy preserving type ) AS EmrkdFndsOpenAmtInCCCrcy,
  cast ( deltahwapp as deltahwapp preserving type ) AS EmrkdFndsChgdAmtInCCCrcy,
  cast ( hwabg as kblwtabg preserving type ) AS EmrkdFndsCnsmdAmtInCCCrcy,
  cast ( hworig as fmhworig preserving type ) AS EmrkdFndsOriglAmtInCCCrcy
FROM kblp AS efitm
LEFT OUTER JOIN I_EarmarkedFundsDocument AS _EmrkdFndsItmPredecessor ON EmrkdFndsItmPredecessor = _EmrkdFndsItmPredecessor.EarmarkedFundsDocument  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFundsDocumentItem AS _EmrkdFndsItmPrdcssrItem ON EmrkdFndsItmPredecessor = _EmrkdFndsItmPrdcssrItem.EarmarkedFundsDocument AND EmrkdFndsItmPrdcssrItem = _EmrkdFndsItmPrdcssrItem.EarmarkedFundsDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_EmrkdFndsValueAdjustmentDoc AS _EmrkdFndsValueAdjustmentDoc ON EarmarkedFundsDocument = _EmrkdFndsValueAdjustmentDoc.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _EmrkdFndsValueAdjustmentDoc.EarmarkedFundsDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_EmrkdFndsProcgTotalsByTrans AS _EmrkdFndsProcgTotalsByTrans ON EarmarkedFundsDocument = _EmrkdFndsProcgTotalsByTrans.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _EmrkdFndsProcgTotalsByTrans.EarmarkedFundsDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_DocCategory AS _EmrkdFndsItmPrdcssrDocCat ON EmrkdFndsItmPrdcssrDocCat = _EmrkdFndsItmPrdcssrDocCat.EarmarkedFundsDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_MnlEditBlk AS _EarmarkedFundsMnlEditBlk ON EmrkdFndsItmManualEditBlock = _EarmarkedFundsMnlEditBlk.EarmarkedFundsManualEditBlock  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_User AS _EmrkdFndsDocItmCreatedByUser ON EmrkdFndsDocItmCreatedByUser = _EmrkdFndsDocItmCreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _EmrkdFndsDocItmLastChgdByUsr ON EmrkdFndsDocItmLastChgdByUsr = _EmrkdFndsDocItmLastChgdByUsr.UserID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON CostCenter = _CurrentCostCenter.CostCenter AND ControllingArea = _CurrentCostCenter.ControllingArea AND _CurrentCostCenter.ValidityEndDate >= $session.system_date AND _CurrentCostCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON ControllingArea = _CostCenterText.ControllingArea AND CostCenter = _CostCenterText.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ProfitCenter = _CurrentProfitCenter.ProfitCenter AND ControllingArea = _CurrentProfitCenter.ControllingArea AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON InternalOrder = _InternalOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON CostElement = _CostElement.CostElement AND ControllingArea = _CostElement.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemByEmrkdFnds AS _CommitmentItemByEmrkdFnds ON EarmarkedFundsDocument = _CommitmentItemByEmrkdFnds.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _CommitmentItemByEmrkdFnds.EarmarkedFundsDocumentItem  -- 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_FundText AS _FundText ON FinancialManagementArea = _FundText.FinancialManagementArea AND Fund = _FundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _CurrentFundsCenter ON FinancialManagementArea = _CurrentFundsCenter.FinancialManagementArea AND FundsCenter = _CurrentFundsCenter.FundsCenter AND _CurrentFundsCenter.ValidityEndDate >= $session.system_date AND _CurrentFundsCenter.ValidityStartDate <= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterByEarmarkedFunds AS _FundsCenterByEarmarkedFunds ON EarmarkedFundsDocument = _FundsCenterByEarmarkedFunds.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _FundsCenterByEarmarkedFunds.EarmarkedFundsDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundedProgramText AS _FundedProgramText ON FinancialManagementArea = _FundedProgramText.FinancialManagementArea AND FundedProgram = _FundedProgramText.FundedProgram  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _BudgetPeriodText ON BudgetPeriod = _BudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FundsMgmtFunctionalArea ON FunctionalArea = _FundsMgmtFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerText ON Customer = _CustomerText.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _AlternativePayee ON AlternativePayee = _AlternativePayee.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _AlternativePayeeText ON Supplier = _AlternativePayeeText.Supplier  -- association [0..1]
LEFT OUTER JOIN E_EarmarkedFundsDocumentItem AS _Extension ON EarmarkedFundsDocument = _Extension.EarmarkedFundsDocument AND EarmarkedFundsDocumentItem = _Extension.EarmarkedFundsDocumentItem  -- association [1]
LEFT OUTER JOIN I_EmrkdFndsDocItmProcgItem AS _EmrkdFndsDocItmProcgItem ON /* condition not available in parsed metadata */  -- association [0..*]
;