What is I_BudgetEntrAndChgDoc in SAP S/4HANA?

I_BudgetEntrAndChgDoc is a composite CDS view in SAP S/4HANA. Budget Entry and Change Document Items It contains 103 fields.

Which tables does I_BudgetEntrAndChgDoc read from?

I_BudgetEntrAndChgDoc reads data from: I_BudgetEntrAndChgDocBasic.

What VDM layer is I_BudgetEntrAndChgDoc?

I_BudgetEntrAndChgDoc is classified as a Composite view that combines data from multiple basic views.

I_BudgetEntrAndChgDoc

DDL: I_BUDGETENTRANDCHGDOC SQL: IFMBDGDOCITMB Type: view COMPOSITE

103 Fields 1 Data Sources 20 Associations

Budget Entry and Change Document Items

I_BudgetEntrAndChgDoc is a Composite CDS View that provides data about "Budget Entry and Change Document Items" in SAP S/4HANA. It reads from 1 data source (I_BudgetEntrAndChgDocBasic) and exposes 103 fields with key fields BudgetChangeDocument, FinMgmtAreaFiscalYear, FinancialManagementArea, BudgetCategory, BudgetChangeDocumentItem. It has 20 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BudgetEntrAndChgDocBasic	Bdgt	from

Associations (20)

Cardinality	Target	Alias	Condition
[0..1]	I_Fund	_Fund	`$projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.BudgetedFund = _Fund.Fund`
[0..1]	I_BudgetPeriod	_BudgetPeriod	`$projection.BudgetedBudgetPeriod = _BudgetPeriod.BudgetPeriod`
[0..1]	I_FundsCenterByYear	_FundsCenter	`$projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear and $projection.BudgetedFundsCenter = _FundsCenter.FundsCenter`
[0..1]	I_CommitmentItem	_CommitmentItem	`$projection.FinancialManagementArea = _CommitmentItem.FinancialManagementArea and $projection.BudgetedCommitmentItem = _CommitmentItem.CommitmentItem and $projection.CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear`
[0..1]	I_FundsMgmtFunctionalArea	_FunctionalArea	`$projection.BudgetedFunctionalArea = _FunctionalArea.FunctionalArea`
[0..1]	I_Grant	_Grant	`$projection.BudgetedGrantID = _Grant.GrantID`
[0..1]	I_FundedProgram	_FundedProgram	`$projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea and $projection.BudgetedFundedProgram = _FundedProgram.FundedProgram`
[1..1]	I_ControllingVersion	_BudgetVersion	`$projection.BudgetVersion = _BudgetVersion.ControllingVersion`
[1..1]	I_BudgetCategory	_BudgetCategory	`$projection.FinancialManagementArea = _BudgetCategory.FinancialManagementArea and $projection.BudgetCategory = _BudgetCategory.BudgetCategory`
[1..1]	I_BudgetValueType	_BudgetValueType	`$projection.BudgetValueType = _BudgetValueType.BudgetValueType`
[1..1]	I_InternalBudgetingProcess	_BudgetingProcess	`$projection.InternalBudgetingProcess = _BudgetingProcess.InternalBudgetingProcess`
[0..1]	I_BudgetType	_BudgetType	`$projection.FinancialManagementArea = _BudgetType.FinancialManagementArea and $projection.BudgetValueType = _BudgetType.BudgetValueType and $projection.BudgetType = _BudgetType.BudgetType`
[0..1]	I_ReferenceDocumentType	_ReferenceDocumentType	`$projection.ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType`
[0..1]	I_OriginalBudgetingApplication	_OriginalBudgetingApplication	`$projection.OriginalBudgetingApplication = _OriginalBudgetingApplication.OriginalBudgetingApplication`
[1..1]	I_BudgetEntryDocumentStatus	_BudgetEntryDocumentStatus	`$projection.BudgetEntryDocumentStatus = _BudgetEntryDocumentStatus.BudgetEntryDocumentStatus`
[0..1]	I_BudgetEntryDocumentType	_BudgetEntryDocumentType	`$projection.BudgetEntryDocumentType = _BudgetEntryDocumentType.BudgetEntryDocumentType`
[1..1]	I_BdgtEntryDocReversalStatus	_BudgetEntryDocReversalStatus	`$projection.BdgtEntryDocReversalStatus = _BudgetEntryDocReversalStatus.BdgtEntryDocReversalStatus`
[1..1]	I_ReversalReason	_BudgetEntryDocReversalReason	`$projection.ReversalReason = _BudgetEntryDocReversalReason.ReversalReason`
[0..1]	I_BdgtEntrItemSubdivisionBasic	_BdgtEntrItemSubdivision	`$projection.FinancialManagementArea = _BdgtEntrItemSubdivision.FinancialManagementArea and $projection.BudgetDocumentYear = _BdgtEntrItemSubdivision.BudgetDocumentYear and $projection.BudgetEntryDocument = _BdgtEntrItemSubdivision.BudgetEntryDocument and $projection.BudgetEntryDocumentItem = _BdgtEntrItemSubdivision.BudgetEntryDocumentItem`
[0..1]	I_LogicalSystem	_LogicalSystem	`$projection.ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	IFMBDGDOCITMB	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Budget Entry and Change Document Items	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XXL	view

Fields (103)

Key	Field	Source Table	Source Field	Description
KEY	BudgetChangeDocument	I_BudgetEntrAndChgDocBasic	BudgetChangeDocument
KEY	FinMgmtAreaFiscalYear	I_BudgetEntrAndChgDocBasic	FinMgmtAreaFiscalYear	Fiscal Year
KEY	FinancialManagementArea	I_BudgetEntrAndChgDocBasic	FinancialManagementArea	FM Area
KEY	BudgetCategory	I_BudgetEntrAndChgDocBasic	BudgetCategory	Plan Category
KEY	BudgetChangeDocumentItem	I_BudgetEntrAndChgDocBasic	BudgetChangeDocumentItem
	BudgetDocumentYear	I_BudgetEntrAndChgDocBasic	BudgetDocumentYear	Fiscal Year
	BudgetEntryDocument	I_BudgetEntrAndChgDocBasic	BudgetEntryDocument	Document Number
	BudgetEntryDocumentItem	I_BudgetEntrAndChgDocBasic	BudgetEntryDocumentItem
	BudgetedFund	I_BudgetEntrAndChgDocBasic	BudgetedFund	Fund
	BudgetedFundsCenter	I_BudgetEntrAndChgDocBasic	BudgetedFundsCenter	Funds Center
	BudgetedCommitmentItem	I_BudgetEntrAndChgDocBasic	BudgetedCommitmentItem	Commitment Item
	BudgetedFunctionalArea	I_BudgetEntrAndChgDocBasic	BudgetedFunctionalArea	Functional Area
	BudgetedGrantID	I_BudgetEntrAndChgDocBasic	BudgetedGrantID	Grant
	BudgetedFundedProgram	I_BudgetEntrAndChgDocBasic	BudgetedFundedProgram	Funded Program
	BudgetedBudgetPeriod	I_BudgetEntrAndChgDocBasic	BudgetedBudgetPeriod	Budget Period
	BudgetedFundsMgmtCustomerField	I_BudgetEntrAndChgDocBasic	BudgetedFundsMgmtCustomerField	Customer Field
	TransactionCurrency	I_BudgetEntrAndChgDocBasic	TransactionCurrency	Transaction Currency
	FinancialManagementAreaCrcy	I_BudgetEntrAndChgDocBasic	FinancialManagementAreaCrcy	FM Area Currency
	BudgetAmountInTransactionCrcy	I_BudgetEntrAndChgDocBasic	BudgetAmountInTransactionCrcy
	BudgetAmountInFMACrcy	I_BudgetEntrAndChgDocBasic	BudgetAmountInFMACrcy
	CommitmentItemCategory	I_BudgetEntrAndChgDocBasic	CommitmentItemCategory
	CommitmentItemFiscalYear	I_BudgetEntrAndChgDocBasic	CommitmentItemFiscalYear	Commit. Item FY
	BdgtCashEffectivityFiscalYear	I_BudgetEntrAndChgDocBasic	BdgtCashEffectivityFiscalYear
	BudgetValueType	I_BudgetEntrAndChgDocBasic	BudgetValueType	BCS Value Type
	BudgetWorkFlowStatus	I_BudgetEntrAndChgDocBasic	BudgetWorkFlowStatus
	InternalBudgetingProcess	I_BudgetEntrAndChgDocBasic	InternalBudgetingProcess
	BudgetType	I_BudgetEntrAndChgDocBasic	BudgetType
	BudgetVersion	I_BudgetEntrAndChgDocBasic	BudgetVersion	Version
	BudgetChangeDocCreationDate	I_BudgetEntrAndChgDocBasic	BudgetChangeDocCreationDate
	BudgetEntryDocumentType	I_BudgetEntrAndChgDocBasic	BudgetEntryDocumentType
	BudgetEntryDocumentFamily	I_BudgetEntrAndChgDocBasic	BudgetEntryDocumentFamily
	OriginalBudgetingApplication	I_BudgetEntrAndChgDocBasic	OriginalBudgetingApplication
	CreationDate	I_BudgetEntrAndChgDocBasic	CreationDate	Time Stamp
	LastChangeDate	I_BudgetEntrAndChgDocBasic	LastChangeDate	Time Stamp
	BudgetEntryDocumentDate	I_BudgetEntrAndChgDocBasic	BudgetEntryDocumentDate
	BudgetEntryDocumentDescription	I_BudgetEntrAndChgDocBasic	BudgetEntryDocumentDescription
	BudgetEntryDocumentStatus	I_BudgetEntrAndChgDocBasic	BudgetEntryDocumentStatus
	BdgtEntryDocReversalStatus	I_BudgetEntrAndChgDocBasic	BdgtEntryDocReversalStatus
	ReversalReason	I_BudgetEntrAndChgDocBasic	ReversalReason	Reversal Reason
	ReversalRefBudgetEntryDocument	I_BudgetEntrAndChgDocBasic	ReversalRefBudgetEntryDocument
	LogicalSystem	I_BudgetEntrAndChgDocBasic	LogicalSystem	Logical System
	FiscalTreasuryLoanCohort	I_BudgetEntrAndChgDocBasic	FiscalTreasuryLoanCohort
	PublicLaw	I_BudgetEntrAndChgDocBasic	PublicLaw
	FiscalTreasuryLegislationType	I_BudgetEntrAndChgDocBasic	FiscalTreasuryLegislationType
	FiscalTreasuryAgency	I_BudgetEntrAndChgDocBasic	FiscalTreasuryAgency
	FiscalTreasuryBudgetAccount	I_BudgetEntrAndChgDocBasic	FiscalTreasuryBudgetAccount
	PartnerCompany	I_BudgetEntrAndChgDocBasic	PartnerCompany	Trading Partner
	BudgetEntryDocDistributionKey	I_BudgetEntrAndChgDocBasic	BudgetEntryDocDistributionKey
	BudgetEntryDocItemIsAdditional	I_BudgetEntrAndChgDocBasic	BudgetEntryDocItemIsAdditional
	BdgtEntrDocItmAdditionalItem	I_BudgetEntrAndChgDocBasic	BdgtEntrDocItmAdditionalItem
	BudgetEntryDocItemDescription	I_BudgetEntrAndChgDocBasic	BudgetEntryDocItemDescription
	ReferenceDocument	I_BudgetEntrAndChgDocBasic	ReferenceDocument	Reference Document
	ReferenceDocumentFiscalYear	I_BudgetEntrAndChgDocBasic	ReferenceDocumentFiscalYear	Year Cur.Period
	ReferenceDocumentItem	I_BudgetEntrAndChgDocBasic	ReferenceDocumentItem	Reference item
	ReferenceDocumentType	I_BudgetEntrAndChgDocBasic	ReferenceDocumentType	Reference Document Type
	ReferenceDocumentContext	I_BudgetEntrAndChgDocBasic	ReferenceDocumentContext	Reference Document Context
	ReferenceDocumentLogicalSystem	I_BudgetEntrAndChgDocBasic	ReferenceDocumentLogicalSystem	Ref. Doc. Lgcl Syst.
	FundAuthznGrp	_Fund	FundAuthznGrp
	BudgetPeriodAuthznGrp	_BudgetPeriod	BudgetPeriodAuthznGrp
	FundedProgramAuthznGrp	_FundedProgram	FundedProgramAuthznGrp
	FundsCenterAuthznGrp	_FundsCenter	FundsCenterAuthznGrp
	CommitmentItemAuthznGrp	_CommitmentItem	CommitmentItemAuthznGrp
	FunctionalAreaAuthznGrp	_FunctionalArea	FunctionalAreaAuthznGrp
	GrantAuthznGrp	_Grant	GrantAuthznGrp
	FunctionalAreaSubdivisionID	_BdgtEntrItemSubdivision	FunctionalAreaSubdivisionID	Farea Subdivision ID
	FunctionalArea1Subdivision	_BdgtEntrItemSubdivision	FunctionalArea1Subdivision	FN Substring 1
	FunctionalArea2Subdivision	_BdgtEntrItemSubdivision	FunctionalArea2Subdivision	FN Substring 2
	FunctionalArea3Subdivision	_BdgtEntrItemSubdivision	FunctionalArea3Subdivision	FN Substring 3
	CommitmentItemSubdivisionID	_BdgtEntrItemSubdivision	CommitmentItemSubdivisionID	CItem Subdiv. ID
	CommitmentItem1Subdivision	_BdgtEntrItemSubdivision	CommitmentItem1Subdivision	CI Substring 1
	CommitmentItem2Subdivision	_BdgtEntrItemSubdivision	CommitmentItem2Subdivision	CI Substring 2
	CommitmentItem3Subdivision	_BdgtEntrItemSubdivision	CommitmentItem3Subdivision	CI Substring 3
	CommitmentItem4Subdivision	_BdgtEntrItemSubdivision	CommitmentItem4Subdivision	CI Substring 4
	CommitmentItem5Subdivision	_BdgtEntrItemSubdivision	CommitmentItem5Subdivision	CI Substring 5
	FundsSubdivisionID	_BdgtEntrItemSubdivision	FundsSubdivisionID	Fund Subdivision ID
	Funds1Subdivision	_BdgtEntrItemSubdivision	Funds1Subdivision	FD Substring 1
	Funds2Subdivision	_BdgtEntrItemSubdivision	Funds2Subdivision	FD Substring 2
	FundsCenterSubdivisionID	_BdgtEntrItemSubdivision	FundsCenterSubdivisionID	Fctr Subdiv. ID
	FundsCenter1Subdivision	_BdgtEntrItemSubdivision	FundsCenter1Subdivision	FC Substring 1
	FundsCenter2Subdivision	_BdgtEntrItemSubdivision	FundsCenter2Subdivision	FC Substring 2
	FundsCenter3Subdivision	_BdgtEntrItemSubdivision	FundsCenter3Subdivision	FC Substring 3
	_Fund		_Fund
	_BudgetPeriod		_BudgetPeriod
	_FundedProgram		_FundedProgram
	_FundsCenter		_FundsCenter
	_CommitmentItem		_CommitmentItem
	_FunctionalArea		_FunctionalArea
	_Grant		_Grant
	_BudgetCategory		_BudgetCategory
	_BudgetValueType		_BudgetValueType
	_BudgetingProcess		_BudgetingProcess
	_BudgetType		_BudgetType
	_BudgetVersion		_BudgetVersion
	_TransactionCurrency	I_BudgetEntrAndChgDocBasic	_TransactionCurrency
	_ReferenceDocumentType		_ReferenceDocumentType
	_OriginalBudgetingApplication		_OriginalBudgetingApplication
	_BudgetEntryDocumentStatus		_BudgetEntryDocumentStatus
	_BudgetEntryDocReversalStatus		_BudgetEntryDocReversalStatus
	_BudgetEntryDocumentType		_BudgetEntryDocumentType
	_BudgetEntryDocReversalReason		_BudgetEntryDocReversalReason
	_FinMgmtArea	I_BudgetEntrAndChgDocBasic	_FinMgmtArea
	_BdgtEntrItemSubdivision		_BdgtEntrItemSubdivision
	_LogicalSystem		_LogicalSystem

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_BudgetEntrAndChgDoc.
-- 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: IFMBDGDOCITMB

CREATE VIEW I_BudgetEntrAndChgDoc AS
SELECT
  Bdgt.BudgetChangeDocument AS BudgetChangeDocument,
  Bdgt.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  Bdgt.FinancialManagementArea AS FinancialManagementArea,
  Bdgt.BudgetCategory AS BudgetCategory,
  Bdgt.BudgetChangeDocumentItem AS BudgetChangeDocumentItem,
  Bdgt.BudgetDocumentYear AS BudgetDocumentYear,
  Bdgt.BudgetEntryDocument AS BudgetEntryDocument,
  Bdgt.BudgetEntryDocumentItem AS BudgetEntryDocumentItem,
  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,
  Bdgt.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.BudgetEntryDocumentType AS BudgetEntryDocumentType,
  Bdgt.BudgetEntryDocumentFamily AS BudgetEntryDocumentFamily,
  Bdgt.OriginalBudgetingApplication AS OriginalBudgetingApplication,
  Bdgt.CreationDate AS CreationDate,
  Bdgt.LastChangeDate AS LastChangeDate,
  Bdgt.BudgetEntryDocumentDate AS BudgetEntryDocumentDate,
  Bdgt.BudgetEntryDocumentDescription AS BudgetEntryDocumentDescription,
  Bdgt.BudgetEntryDocumentStatus AS BudgetEntryDocumentStatus,
  Bdgt.BdgtEntryDocReversalStatus AS BdgtEntryDocReversalStatus,
  Bdgt.ReversalReason AS ReversalReason,
  Bdgt.ReversalRefBudgetEntryDocument AS ReversalRefBudgetEntryDocument,
  Bdgt.LogicalSystem AS LogicalSystem,
  Bdgt.FiscalTreasuryLoanCohort AS FiscalTreasuryLoanCohort,
  Bdgt.PublicLaw AS PublicLaw,
  Bdgt.FiscalTreasuryLegislationType AS FiscalTreasuryLegislationType,
  Bdgt.FiscalTreasuryAgency AS FiscalTreasuryAgency,
  Bdgt.FiscalTreasuryBudgetAccount AS FiscalTreasuryBudgetAccount,
  Bdgt.PartnerCompany AS PartnerCompany,
  Bdgt.BudgetEntryDocDistributionKey AS BudgetEntryDocDistributionKey,
  Bdgt.BudgetEntryDocItemIsAdditional AS BudgetEntryDocItemIsAdditional,
  Bdgt.BdgtEntrDocItmAdditionalItem AS BdgtEntrDocItmAdditionalItem,
  Bdgt.BudgetEntryDocItemDescription AS BudgetEntryDocItemDescription,
  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,
  _CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _FunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _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,
  Bdgt._TransactionCurrency AS _TransactionCurrency,
  Bdgt._FinMgmtArea AS _FinMgmtArea
FROM I_BudgetEntrAndChgDocBasic AS Bdgt
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_OriginalBudgetingApplication AS _OriginalBudgetingApplication ON OriginalBudgetingApplication = _OriginalBudgetingApplication.OriginalBudgetingApplication  -- association [0..1]
LEFT OUTER JOIN I_BudgetEntryDocumentStatus AS _BudgetEntryDocumentStatus ON BudgetEntryDocumentStatus = _BudgetEntryDocumentStatus.BudgetEntryDocumentStatus  -- association [1..1]
LEFT OUTER JOIN I_BudgetEntryDocumentType AS _BudgetEntryDocumentType ON BudgetEntryDocumentType = _BudgetEntryDocumentType.BudgetEntryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BdgtEntryDocReversalStatus AS _BudgetEntryDocReversalStatus ON BdgtEntryDocReversalStatus = _BudgetEntryDocReversalStatus.BdgtEntryDocReversalStatus  -- association [1..1]
LEFT OUTER JOIN I_ReversalReason AS _BudgetEntryDocReversalReason ON ReversalReason = _BudgetEntryDocReversalReason.ReversalReason  -- association [1..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_LogicalSystem AS _LogicalSystem ON ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
;

Depth:

I_BudgetEntrAndChgDoc view

I_BudgetEntrAndChgDocBasic view

I_FundsMgmtBdgtDocItmCube view