C_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 C_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.
-- SQL view name: CBDGTDOCITPAYTP

CREATE VIEW C_BudgetEntryDocItemPayTP AS
SELECT
  BudgetEntryDocumentItem.BudgetEntryDocument AS BudgetEntryDocument,
  BudgetEntryDocumentItem.FinancialManagementArea AS FinancialManagementArea,
  BudgetEntryDocumentItem.BudgetDocumentYear AS BudgetDocumentYear,
  BudgetEntryDocumentItem.BudgetEntryDocumentItem AS BudgetEntryDocumentItem,
  BudgetEntryDocumentItem.FinancialManagementAreaForEdit AS FinancialManagementAreaForEdit,
  BudgetEntryDocumentItem.BudgetEntryDocItemForEdit AS BudgetEntryDocItemForEdit,
  BudgetEntryDocumentItem.InternalBudgetingProcess AS InternalBudgetingProcess,
  BudgetEntryDocumentItem.BdgtCashEffectivityFiscalYear AS BdgtCashEffectivityFiscalYear,
  BudgetEntryDocumentItem.BudgetedFund AS BudgetedFund,
  BudgetEntryDocumentItem.BudgetedBudgetPeriod AS BudgetedBudgetPeriod,
  BudgetEntryDocumentItem.BudgetedFundsCenter AS BudgetedFundsCenter,
  BudgetEntryDocumentItem.BudgetedCommitmentItem AS BudgetedCommitmentItem,
  BudgetEntryDocumentItem.BudgetedFunctionalArea AS BudgetedFunctionalArea,
  BudgetEntryDocumentItem.BudgetedFundedProgram AS BudgetedFundedProgram,
  BudgetEntryDocumentItem.BudgetedGrantID AS BudgetedGrantID,
  BudgetEntryDocumentItem.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  BudgetEntryDocumentItem.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  BudgetEntryDocumentItem.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  BudgetEntryDocumentItem.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  BudgetEntryDocumentItem.BudgetValueType AS BudgetValueType,
  BudgetEntryDocumentItem.BudgetType AS BudgetType,
  BudgetEntryDocumentItem.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  BudgetEntryDocumentItem.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  BudgetEntryDocumentItem.BudgetAmountInFMACrcy AS BudgetAmountInFMACrcy,
  _CurrentPaymentBudget.BudgetAmountInFMACrcy AS CurPaymentBdgtAmtInFMACrcy,
  _AvailableBudget.AvailableAmountInFMACrcy AS AvailableAmountInFMACrcy,
  BudgetEntryDocumentItem.BudgetEntryDocItemDescription AS BudgetEntryDocItemDescription,
  _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearEndDate AS FinMgmtAreaFiscalYearEndDate,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear
FROM I_BudgetEntryDocItemPayTP AS BudgetEntryDocumentItem
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_FundsCenterByYear AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear AND BudgetedFundsCenter = _FundsCenter.FundsCenter  -- 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 CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear  -- 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 _CurrentPaymentBudget ON FinancialManagementAreaForEdit = _CurrentPaymentBudget.FinancialManagementArea AND FinMgmtAreaFiscalYear = _CurrentPaymentBudget.FinMgmtAreaFiscalYear AND BudgetType = _CurrentPaymentBudget.BudgetType AND BdgtCashEffectivityFiscalYear = _CurrentPaymentBudget.BdgtCashEffectivityFiscalYear AND _CurrentPaymentBudget.BudgetCategory = '9F' AND BudgetedCommitmentItem = _CurrentPaymentBudget.BudgetedCommitmentItem AND BudgetedFund = _CurrentPaymentBudget.BudgetedFund AND BudgetedFunctionalArea = _CurrentPaymentBudget.BudgetedFunctionalArea AND BudgetedFundsCenter = _CurrentPaymentBudget.BudgetedFundsCenter AND BudgetedBudgetPeriod = _CurrentPaymentBudget.BudgetedBudgetPeriod AND BudgetedFundedProgram = _CurrentPaymentBudget.BudgetedFundedProgram AND BudgetedGrantID = _CurrentPaymentBudget.BudgetedGrantID AND FinancialManagementAreaCrcy = _CurrentPaymentBudget.FinancialManagementAreaCrcy AND _CurrentPaymentBudget.BudgetVersion = '000'  -- association [0..*]
LEFT OUTER JOIN I_AvailBudgetPerBudgetAddress AS _AvailableBudget ON FinancialManagementAreaForEdit = _AvailableBudget.FinancialManagementArea AND _AvailableBudget.BudgetCategory = '9F' AND _AvailableBudget.AvailabilityControlLedger = '9H' 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..*]
;