shsm_efditm

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 shsm_efditm.
-- 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 shsm_efditm AS
SELECT
  cast ( efitm.EarmarkedFundsDocument as kblnr_dy preserving type ) AS belnr,
  cast ( efitm.EarmarkedFundsDocumentItem as kblpos_dy preserving type ) AS blpos,
  cast( concat('00', efitm.EarmarkedFundsDocumentItem) as cc_rfpos ) AS FundsMgmtReferenceDocumentItem,
  efitm.FinancialManagementArea AS CommitmentItemFinMgmtArea,
  EFDLatestItemInFM.FinMgmtAreaLatestFiscalYear AS FinMgmtAreaLatestFiscalYear,
  efitm.FinancialManagementArea AS FundsCenterFinMgmtArea,
  efitm.PostingDate AS PostingDate,
  coalesce(EFDLatestItemInFM.FundsMgmtUpdateDate, efitm.PostingDate) AS FundsCenterKeyDate,
  efitm.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  efitm.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  efitm.EarmarkedFundsDocument AS EarmarkedFunds,
  efitm.EarmarkedFundsDocumentItem AS EarmarkedFundsItem,
  efitm.ControllingArea AS ControllingArea,
  efitm.CompanyCode AS CompanyCode,
  efitm.FinancialManagementArea AS FinancialManagementArea,
  efitm.ControllingArea AS kokrs,
  efitm.CompanyCode AS bukrs,
  efitm.FinancialManagementArea AS fikrs,
  cast ( efitm.TransactionCurrency as twaer preserving type ) AS waers,
  efitm.TransactionCurrency AS TransactionCurrency,
  efitm.CompanyCodeCurrency AS hwaer,
  efitm.CompanyCodeCurrency AS CompanyCodeCurrency,
  efitm.PostingDate AS budat,
  efitm._EarmarkedFundsDocument.DocumentDate AS bldat,
  cast ( efitm._EarmarkedFundsDocument.EarmarkedFundsDocumentType as fmre_blart preserving type ) AS blart,
  cast ( efitm._EarmarkedFundsDocument.EarmarkedFundsDocumentCategory as fmre_bltyp preserving type ) AS bltyp,
  efitm._EarmarkedFundsDocument.EarmarkedFundsDocEntryStatus AS mvstat,
  efitm._EarmarkedFundsDocument.EarmarkedFundsDocReference AS xblnr,
  efitm._EarmarkedFundsDocument.EarmarkedFundsDocReference2 AS fmre_xblnr2,
  efitm._EarmarkedFundsDocument.EarmarkedFundsDocReference3 AS fmre_xblnr3,
  efitm._EarmarkedFundsDocument.EarmarkedFundsHeaderText AS ktext,
  efitm._EarmarkedFundsDocument.EmrkdFndsDocCreatedByUser AS kerfas,
  efitm._EarmarkedFundsDocument.EmrkdFndsDocCreationDate AS kerdat,
  efitm._EarmarkedFundsDocument.EmrkdFndsDocLastChangedByUser AS kaende,
  efitm._EarmarkedFundsDocument.EmrkdFndsDocLastChangeDate AS kaedat,
  efitm.EmrkdFndsDocItmCreatedByUser AS erfas,
  efitm.EmrkdFndsDocItmCreationDate AS erdat,
  efitm.EmrkdFndsDocItmLastChgdByUsr AS aende,
  efitm.EmrkdFndsDocItmLastChangeDate AS aedat,
  efitm.GLAccount AS GLAccount,
  efitm.GLAccount AS saknr,
  efitm.CostCenter AS CostCenter,
  efitm.CostCenter AS kostl,
  efitm.InternalOrder AS InternalOrder,
  efitm.InternalOrder AS aufnr,
  cast ( efitm.WBSElementInternalID as ps_psp_ele preserving type) AS pspnr,
  efitm._WBSElement.WBSElementExternalID AS WBSElementExternalID,
  efitm._WBSElement.WBSElementExternalID AS posid,
  efitm.ProjectNetwork AS nplnr,
  efitm.CostElement AS kstar,
  efitm.CommitmentItem AS CommitmentItem,
  cast ( efitm.CommitmentItem as fm_fipex preserving type ) AS fipex,
  efitm.FundsCenter AS FundsCenter,
  efitm.FundsCenter AS fistl,
  efitm.Fund AS Fund,
  efitm.Fund AS geber,
  efitm.FundedProgram AS FundedProgram,
  efitm.FundedProgram AS measure,
  efitm.BudgetPeriod AS BudgetPeriod,
  efitm.BudgetPeriod AS budget_pd,
  efitm.FunctionalArea AS FunctionalArea,
  efitm.FunctionalArea AS fkber,
  efitm.GrantID AS GrantID,
  efitm.GrantID AS grant_nbr,
  efitm.BusinessArea AS gsber,
  cast ( efitm.Product as matnr preserving type ) AS matnr,
  efitm.Supplier AS lifnr,
  efitm.Customer AS kunnr,
  efitm.AlternativePayee AS lnrza,
  efitm.DocumentItemText AS ptext,
  efitm.EmrkdFndsReferenceDocumentItem AS rfpos,
  efitm.DueDate AS fdatk,
  efitm.EmrkdFndsItmCompletionDate AS erldat,
  efitm.EmrkdFndsItmPrdcssrDocCat AS refbltyp,
  efitm.EmrkdFndsItmPredecessor AS refbelnr,
  efitm.EmrkdFndsItmPrdcssrItem AS refblpos,
  efitm.EmrkdFndsItmPrdcssrCompleted AS refseterlk,
  efitm.EmrkdFndsItmIsCompleted AS erlkz,
  efitm.EmrkdFndsItmIsStatistical AS stats,
  efitm.EmrkdFndsItmIsDeleted AS loekz,
  efitm.EmrkdFndsItmIsSender AS xsender,
  efitm.EmrkdFndsItmIsReceiver AS xempfgr,
  efitm.EmrkdFndsItmManualEditBlock AS poslock,
  efitm.EmrkdFndsItmIsBlkdAgainstUsage AS blpkz,
  efitm.EmrkdFndsItmIsUnlimited AS consumekz,
  efitm.EmrkdFndsItmToleranceLmtInPct AS uebto,
  efitm.EmrkdFndsOverrideGlobTolerance AS tolov,
  efitm.EmrkdFndsItmIsApproved AS wkapp,
  efitm.EmrkdFndsItmNoCarryforward AS carryov,
  efitm.EmrkdFndsAcctAssgmtChangeable AS acchang,
  efitm.EmrkdFndsHasValueAdjustments AS pmactive,
  efitm.EmrkdFndsItmCnsmpnInCCCrcyOnly AS abgwaers,
  efitm.EmrkdFndsAmountInTransCrcy AS wtges,
  efitm.EmrkdFndsRelAmtInTransCrcy AS wtgesapp,
  efitm.EmrkdFndsOpenAmtInTransCrcy AS wtfree,
  efitm.EmrkdFndsChgdAmtInTransCrcy AS deltawtapp,
  efitm.EmrkdFndsCnsmdAmtInTransCrcy AS wtabg,
  efitm.EmrkdFndsOriglAmtInTransCrcy AS wtorig,
  efitm.EmrkdFndsAmountInCCCrcy AS hwges,
  efitm.EmrkdFndsRelAmtInCCCrcy AS hwgesapp,
  efitm.EmrkdFndsOpenAmtInCCCrcy AS hwfree,
  efitm.EmrkdFndsChgdAmtInCCCrcy AS deltahwapp,
  efitm.EmrkdFndsCnsmdAmtInCCCrcy AS hwabg,
  efitm.EmrkdFndsOriglAmtInCCCrcy AS hworig,
  efitm.EmrkdFndsOpenAmtTransCrcyText AS cwtfree,
  efitm._EarmarkedFundsDocument AS _EarmarkedFundsDocument,
  efitm._TransactionCurrency AS _TransactionCurrency,
  efitm._CompanyCodeCurrency AS _CompanyCodeCurrency,
  efitm._CompanyCode AS _CompanyCode,
  efitm._ControllingArea AS _ControllingArea,
  efitm._FinancialManagementArea AS _FinancialManagementArea,
  efitm._CostCenter AS _CostCenter,
  efitm._CurrentCostCenter AS _CurrentCostCenter,
  efitm._InternalOrder AS _InternalOrder,
  efitm._WBSElement AS _WBSElement,
  efitm._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  efitm._CostElement AS _CostElement,
  efitm._ProjectNetwork AS _ProjectNetwork,
  efitm._CommitmentItemByEmrkdFnds AS _CommitmentItemByEmrkdFnds,
  efitm._Fund AS _Fund,
  efitm._CurrentFundsCenter AS _CurrentFundsCenter,
  efitm._FundsCenterByEarmarkedFunds AS _FundsCenterByEarmarkedFunds,
  efitm._FundedProgram AS _FundedProgram,
  efitm._BudgetPeriod AS _BudgetPeriod,
  efitm._FundsMgmtFunctionalArea AS _FundsMgmtFunctionalArea,
  efitm._FunctionalArea AS _FunctionalArea,
  efitm._Grant AS _Grant,
  efitm._BusinessArea AS _BusinessArea,
  efitm._Product AS _Product,
  efitm._Supplier AS _Supplier,
  efitm._Customer AS _Customer
FROM I_EarmarkedFundsDocumentItem AS efitm
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearStartDate <= PostingDate AND _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearEndDate >= PostingDate  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON CommitmentItemFinMgmtArea = _CommitmentItem.FinancialManagementArea AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear AND CommitmentItem = _CommitmentItem.CommitmentItem  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemText AS _CommitmentItemText ON CommitmentItemFinMgmtArea = _CommitmentItemText.FinancialManagementArea AND CommitmentItemFiscalYear = _CommitmentItemText.FinMgmtAreaFiscalYear AND CommitmentItem = _CommitmentItemText.CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenterFinMgmtArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter AND _FundsCenter.ValidityEndDate >= FundsCenterKeyDate AND _FundsCenter.ValidityStartDate <= FundsCenterKeyDate  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterText AS _FundsCenterText ON FundsCenterFinMgmtArea = _FundsCenterText.FinancialManagementArea AND FundsCenter = _FundsCenterText.FundsCenter AND _FundsCenterText.ValidityEndDate >= FundsCenterKeyDate AND _FundsCenterText.ValidityStartDate <= FundsCenterKeyDate  -- association [0..*]
LEFT OUTER JOIN I_EarmarkedFunds_DocCategory AS _EarmarkedFundsDocCategory ON bltyp = _EarmarkedFundsDocCategory.EarmarkedFundsDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_EarmarkedFunds_DocType AS _EarmarkedFundsDocType ON blart = _EarmarkedFundsDocType.EarmarkedFundsDocumentType AND bltyp = _EarmarkedFundsDocType.EarmarkedFundsDocumentCategory  -- association [0..1]
;