C_BudgetEntryDocItemCmtmtTP

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 C_BudgetEntryDocItemCmtmtTP.
-- 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: CBDGTDOCITCMTTP

CREATE VIEW C_BudgetEntryDocItemCmtmtTP AS
SELECT
  BudgetEntryDocumentItem9G.BudgetEntryDocument AS BudgetEntryDocument,
  BudgetEntryDocumentItem9G.FinancialManagementArea AS FinancialManagementArea,
  BudgetEntryDocumentItem9G.BudgetDocumentYear AS BudgetDocumentYear,
  BudgetEntryDocumentItem9G.BudgetEntryDocumentItem AS BudgetEntryDocumentItem,
  BudgetEntryDocumentItem9G.FinancialManagementAreaForEdit AS FinancialManagementAreaForEdit,
  BudgetEntryDocumentItem9G.BudgetEntryDocItemForEdit AS BudgetEntryDocItemForEdit,
  BudgetEntryDocumentItem9G.InternalBudgetingProcess AS InternalBudgetingProcess,
  BudgetEntryDocumentItem9G.BdgtCashEffectivityFiscalYear AS BdgtCashEffectivityFiscalYear,
  BudgetEntryDocumentItem9G.BudgetedFund AS BudgetedFund,
  BudgetEntryDocumentItem9G.BudgetedBudgetPeriod AS BudgetedBudgetPeriod,
  BudgetEntryDocumentItem9G.BudgetedFundsCenter AS BudgetedFundsCenter,
  BudgetEntryDocumentItem9G.BudgetedCommitmentItem AS BudgetedCommitmentItem,
  BudgetEntryDocumentItem9G.BudgetedFunctionalArea AS BudgetedFunctionalArea,
  BudgetEntryDocumentItem9G.BudgetedFundedProgram AS BudgetedFundedProgram,
  BudgetEntryDocumentItem9G.BudgetedGrantID AS BudgetedGrantID,
  BudgetEntryDocumentItem9G.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  BudgetEntryDocumentItem9G.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  BudgetEntryDocumentItem9G.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  BudgetEntryDocumentItem9G.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  BudgetEntryDocumentItem9G.BudgetValueType AS BudgetValueType,
  BudgetEntryDocumentItem9G.BudgetType AS BudgetType,
  BudgetEntryDocumentItem9G.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  BudgetEntryDocumentItem9G.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  BudgetEntryDocumentItem9G.BudgetAmountInFMACrcy AS BudgetAmountInFMACrcy,
  _CurrentCommitmentBudget.BudgetAmountInFMACrcy AS CurCommitmentBdgtAmtInFMACrcy,
  _AvailableBudget.AvailableAmountInFMACrcy AS AvailableAmountInFMACrcy,
  BudgetEntryDocumentItem9G.BudgetEntryDocItemDescription AS BudgetEntryDocItemDescription,
  _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearEndDate AS FinMgmtAreaFiscalYearEndDate
FROM I_BudgetEntryDocItemCmtmtTP AS BudgetEntryDocumentItem9G
LEFT OUTER JOIN C_BudgetEntryDocumentTP AS _BudgetEntryDocument ON FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND BudgetDocumentYear = _BudgetEntryDocument.BudgetDocumentYear AND BudgetEntryDocument = _BudgetEntryDocument.BudgetEntryDocument  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtAreaForEdit ON FinancialManagementAreaForEdit = _FinMgmtAreaForEdit.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementAreaForEdit = _Fund.FinancialManagementArea AND BudgetedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementAreaForEdit = _FundsCenter.FinancialManagementArea AND BudgetedFundsCenter = _FundsCenter.FundsCenter AND FinMgmtAreaFiscalYearEndDate <= _FundsCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementAreaForEdit = _FundedProgram.FinancialManagementArea AND BudgetedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementAreaForEdit = _CommitmentItem.FinancialManagementArea AND BudgetedCommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' )  -- association [0..1]
LEFT OUTER JOIN I_FundToBudgetPeriod AS _BudgetPeriod ON FinancialManagementAreaForEdit = _BudgetPeriod.FinancialManagementArea AND BudgetedFund = _BudgetPeriod.Fund AND BudgetedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON BudgetedFunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON BudgetedGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetingProcessItem AS _BudgetingProcessLine ON InternalBudgetingProcess = _BudgetingProcessLine.BudgetingProcessAtLineLevel  -- association [1..1]
LEFT OUTER JOIN I_BudgetType AS _BudgetType ON FinancialManagementAreaForEdit = _BudgetType.FinancialManagementArea AND BudgetValueType = _BudgetType.BudgetValueType AND BudgetType = _BudgetType.BudgetType  -- association [0..1]
LEFT OUTER JOIN I_BudgetValueType AS _BudgetValueType ON BudgetValueType = _BudgetValueType.BudgetValueType  -- 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_FuncAreaSubdivisionBasic AS _FuncAreaSubdivisionBasic ON FunctionalAreaSubdivisionID = _FuncAreaSubdivisionBasic.FunctionalAreaSubdivisionID  -- association [0..1]
LEFT OUTER JOIN I_FuncArea1Subdivision AS _FuncArea1Subdivision ON FunctionalAreaSubdivisionID = _FuncArea1Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea1Subdivision = _FuncArea1Subdivision.FunctionalArea1Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FuncArea2Subdivision AS _FuncArea2Subdivision ON FunctionalAreaSubdivisionID = _FuncArea2Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea2Subdivision = _FuncArea2Subdivision.FunctionalArea2Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FuncArea3Subdivision AS _FuncArea3Subdivision ON FunctionalAreaSubdivisionID = _FuncArea3Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea3Subdivision = _FuncArea3Subdivision.FunctionalArea3Subdivision  -- association [0..1]
LEFT OUTER JOIN I_CurrentBudgetPerBdgtType AS _CurrentCommitmentBudget ON FinancialManagementAreaForEdit = _CurrentCommitmentBudget.FinancialManagementArea AND FinMgmtAreaFiscalYear = _CurrentCommitmentBudget.FinMgmtAreaFiscalYear AND BudgetType = _CurrentCommitmentBudget.BudgetType AND BdgtCashEffectivityFiscalYear = _CurrentCommitmentBudget.BdgtCashEffectivityFiscalYear AND _CurrentCommitmentBudget.BudgetCategory = '9G' AND BudgetedCommitmentItem = _CurrentCommitmentBudget.BudgetedCommitmentItem AND BudgetedFund = _CurrentCommitmentBudget.BudgetedFund AND BudgetedFunctionalArea = _CurrentCommitmentBudget.BudgetedFunctionalArea AND BudgetedFundsCenter = _CurrentCommitmentBudget.BudgetedFundsCenter AND BudgetedBudgetPeriod = _CurrentCommitmentBudget.BudgetedBudgetPeriod AND BudgetedFundedProgram = _CurrentCommitmentBudget.BudgetedFundedProgram AND BudgetedGrantID = _CurrentCommitmentBudget.BudgetedGrantID AND FinancialManagementAreaCrcy = _CurrentCommitmentBudget.FinancialManagementAreaCrcy AND _CurrentCommitmentBudget.BudgetVersion = '000'  -- association [0..*]
LEFT OUTER JOIN I_AvailBudgetPerBudgetAddress AS _AvailableBudget ON FinancialManagementAreaForEdit = _AvailableBudget.FinancialManagementArea AND _AvailableBudget.BudgetCategory = '9G' AND _AvailableBudget.AvailabilityControlLedger = '9I' AND FinMgmtAreaFiscalYear = _AvailableBudget.FinMgmtAreaFiscalYear AND BdgtCashEffectivityFiscalYear = _AvailableBudget.BdgtCashEffectivityFiscalYear AND BudgetedCommitmentItem = _AvailableBudget.BudgetedCommitmentItem AND BudgetedFund = _AvailableBudget.BudgetedFund AND BudgetedFunctionalArea = _AvailableBudget.BudgetedFunctionalArea AND BudgetedFundsCenter = _AvailableBudget.BudgetedFundsCenter AND BudgetedBudgetPeriod = _AvailableBudget.BudgetedBudgetPeriod AND BudgetedFundedProgram = _AvailableBudget.BudgetedFundedProgram AND BudgetedGrantID = _AvailableBudget.BudgetedGrantID  -- association [0..*]
;