I_BudgetEntryDocItemPayTP

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_BudgetEntryDocItemPayTP.
-- 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_BudgetEntryDocItemPayTP AS
SELECT
  BudgetEntryItem.FinancialManagementArea AS FinancialManagementArea,
  BudgetEntryItem.BudgetDocumentYear AS BudgetDocumentYear,
  BudgetEntryItem.BudgetEntryDocument AS BudgetEntryDocument,
  BudgetEntryItem.BudgetEntryDocumentItem AS BudgetEntryDocumentItem,
  BudgetEntryItem.BudgetEntryDocumentItem AS BudgetEntryDocItemForEdit,
  BudgetEntryItem.FinancialManagementArea AS FinancialManagementAreaForEdit,
  BudgetEntryItem.InternalBudgetingProcess AS InternalBudgetingProcess,
  BudgetEntryItem.BudgetValueType AS BudgetValueType,
  BudgetEntryItem.BudgetType AS BudgetType,
  BudgetEntryItem.BdgtCashEffectivityFiscalYear AS BdgtCashEffectivityFiscalYear,
  BudgetEntryItem.BudgetedFund AS BudgetedFund,
  BudgetEntryItem.BudgetedBudgetPeriod AS BudgetedBudgetPeriod,
  BudgetEntryItem.BudgetedFundsCenter AS BudgetedFundsCenter,
  BudgetEntryItem.BudgetedCommitmentItem AS BudgetedCommitmentItem,
  BudgetEntryItem.BudgetedFunctionalArea AS BudgetedFunctionalArea,
  BudgetEntryItem.BudgetedFundedProgram AS BudgetedFundedProgram,
  BudgetEntryItem.BudgetedGrantID AS BudgetedGrantID,
  _BdgtEntrItemSubdivision.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  _BdgtEntrItemSubdivision.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  _BdgtEntrItemSubdivision.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  _BdgtEntrItemSubdivision.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  BudgetEntryItem.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  BudgetEntryItem.BudgetEntryDocItemDescription AS BudgetEntryDocItemDescription
FROM I_BudgetEntryDocumentItemBasic AS BudgetEntryItem
LEFT OUTER JOIN I_BudgetEntryDocTP AS _BudgetEntryDocument ON FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND BudgetEntryDocument = _BudgetEntryDocument.BudgetEntryDocument AND BudgetDocumentYear = _BudgetEntryDocument.BudgetDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_BudgetingProcessItem AS _BudgetingProcessLine ON InternalBudgetingProcess = _BudgetingProcessLine.BudgetingProcessAtLineLevel  -- association [1..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND BudgetedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundToBudgetPeriod AS _BudgetPeriod ON FinancialManagementArea = _BudgetPeriod.FinancialManagementArea AND BudgetedFund = _BudgetPeriod.Fund AND BudgetedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterByYear AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear AND BudgetedFundsCenter = _FundsCenter.FundsCenter  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' ) AND BudgetedCommitmentItem = _CommitmentItem.CommitmentItem  -- 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_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND BudgetedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON FinancialManagementAreaCrcy = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BdgtEntrItemSubdivisionBasic AS _BdgtEntrItemSubdivision ON FinancialManagementArea = _BdgtEntrItemSubdivision.FinancialManagementArea AND BudgetDocumentYear = _BdgtEntrItemSubdivision.BudgetDocumentYear AND BudgetEntryDocument = _BdgtEntrItemSubdivision.BudgetEntryDocument AND BudgetEntryDocumentItem = _BdgtEntrItemSubdivision.BudgetEntryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
;