I_BudgetEntrAndChgDocWthPeriod

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_BudgetEntrAndChgDocWthPeriod.
-- 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: IFMBDGDOCITMP

CREATE VIEW I_BudgetEntrAndChgDocWthPeriod AS
SELECT
  Bdgt.BudgetChangeDocument AS BudgetChangeDocument,
  Bdgt.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  Bdgt.FinancialManagementArea AS FinancialManagementArea,
  Bdgt.BudgetCategory AS BudgetCategory,
  Bdgt.BudgetChangeDocumentItem AS BudgetChangeDocumentItem,
  Bdgt.FinMgmtAreaPeriod AS FinMgmtAreaPeriod,
  Bdgt.BudgetedFund AS BudgetedFund,
  Bdgt.BudgetedFundsCenter AS BudgetedFundsCenter,
  Bdgt.BudgetedCommitmentItem AS BudgetedCommitmentItem,
  Bdgt.BudgetedFunctionalArea AS BudgetedFunctionalArea,
  Bdgt.BudgetedGrantID AS BudgetedGrantID,
  Bdgt.BudgetedFundedProgram AS BudgetedFundedProgram,
  Bdgt.BudgetedBudgetPeriod AS BudgetedBudgetPeriod,
  Bdgt.BudgetedFundsMgmtCustomerField AS BudgetedFundsMgmtCustomerField,
  Bdgt.TransactionCurrency AS TransactionCurrency,
  Bdgt.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  Bdgt.BudgetAmountInTransactionCrcy AS BudgetAmountInTransactionCrcy,
  Bdgt.BudgetAmountInFMACrcy AS BudgetAmountInFMACrcy,
  Bdgt.CommitmentItemCategory AS CommitmentItemCategory,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  Bdgt.BdgtCashEffectivityFiscalYear AS BdgtCashEffectivityFiscalYear,
  Bdgt.BudgetValueType AS BudgetValueType,
  Bdgt.BudgetWorkFlowStatus AS BudgetWorkFlowStatus,
  Bdgt.InternalBudgetingProcess AS InternalBudgetingProcess,
  Bdgt.BudgetType AS BudgetType,
  Bdgt.BudgetVersion AS BudgetVersion,
  Bdgt.BudgetChangeDocCreationDate AS BudgetChangeDocCreationDate,
  Bdgt.ReferenceDocument AS ReferenceDocument,
  Bdgt.ReferenceDocumentFiscalYear AS ReferenceDocumentFiscalYear,
  Bdgt.ReferenceDocumentItem AS ReferenceDocumentItem,
  Bdgt.ReferenceDocumentType AS ReferenceDocumentType,
  Bdgt.ReferenceDocumentContext AS ReferenceDocumentContext,
  Bdgt.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  _FundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  _FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  _FunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  _BdgtEntrItemSubdivision.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  _BdgtEntrItemSubdivision.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  _BdgtEntrItemSubdivision.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  _BdgtEntrItemSubdivision.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  _BdgtEntrItemSubdivision.CommitmentItemSubdivisionID AS CommitmentItemSubdivisionID,
  _BdgtEntrItemSubdivision.CommitmentItem1Subdivision AS CommitmentItem1Subdivision,
  _BdgtEntrItemSubdivision.CommitmentItem2Subdivision AS CommitmentItem2Subdivision,
  _BdgtEntrItemSubdivision.CommitmentItem3Subdivision AS CommitmentItem3Subdivision,
  _BdgtEntrItemSubdivision.CommitmentItem4Subdivision AS CommitmentItem4Subdivision,
  _BdgtEntrItemSubdivision.CommitmentItem5Subdivision AS CommitmentItem5Subdivision,
  _BdgtEntrItemSubdivision.FundsSubdivisionID AS FundsSubdivisionID,
  _BdgtEntrItemSubdivision.Funds1Subdivision AS Funds1Subdivision,
  _BdgtEntrItemSubdivision.Funds2Subdivision AS Funds2Subdivision,
  _BdgtEntrItemSubdivision.FundsCenterSubdivisionID AS FundsCenterSubdivisionID,
  _BdgtEntrItemSubdivision.FundsCenter1Subdivision AS FundsCenter1Subdivision,
  _BdgtEntrItemSubdivision.FundsCenter2Subdivision AS FundsCenter2Subdivision,
  _BdgtEntrItemSubdivision.FundsCenter3Subdivision AS FundsCenter3Subdivision
FROM I_BdgtEntrAndChgDocWthPerdBsc AS Bdgt
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FinMgmtAreaFiscalYear = _FiscalYear.FiscalYear AND _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearVariant = _FiscalYear.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND BudgetedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON 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 BudgetedCommitmentItem = _CommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear  -- 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_ControllingVersion AS _BudgetVersion ON BudgetVersion = _BudgetVersion.ControllingVersion  -- association [1..1]
LEFT OUTER JOIN I_BudgetCategory AS _BudgetCategory ON FinancialManagementArea = _BudgetCategory.FinancialManagementArea AND BudgetCategory = _BudgetCategory.BudgetCategory  -- association [1..1]
LEFT OUTER JOIN I_BudgetValueType AS _BudgetValueType ON BudgetValueType = _BudgetValueType.BudgetValueType  -- association [1..1]
LEFT OUTER JOIN I_InternalBudgetingProcess AS _BudgetingProcess ON InternalBudgetingProcess = _BudgetingProcess.InternalBudgetingProcess  -- association [1..1]
LEFT OUTER JOIN I_BudgetType AS _BudgetType ON FinancialManagementArea = _BudgetType.FinancialManagementArea AND BudgetValueType = _BudgetType.BudgetValueType AND BudgetType = _BudgetType.BudgetType  -- association [0..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BdgtEntrItemSubdivisionBasic AS _BdgtEntrItemSubdivision ON FinancialManagementArea = _BdgtEntrItemSubdivision.FinancialManagementArea AND ReferenceDocumentFiscalYear = _BdgtEntrItemSubdivision.BudgetDocumentYear AND ReferenceDocument = _BdgtEntrItemSubdivision.BudgetEntryDocument AND ReferenceDocumentItem = _BdgtEntrItemSubdivision.BudgetEntryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON FinancialManagementAreaCrcy = _Currency.Currency  -- association [0..1]
;