I_BudgetEntrAndChgDocBasic

DDL: I_BUDGETENTRANDCHGDOCBASIC SQL: IFMBDGECDOCB Type: view COMPOSITE
60 Fields 1 Data Sources

Budget Entry and Change Document Items Basic

I_BudgetEntrAndChgDocBasic is a Composite CDS View that provides data about "Budget Entry and Change Document Items Basic" in SAP S/4HANA. It reads from 1 data source (I_BudgetEntrChgDocDocument) and exposes 60 fields with key fields BudgetChangeDocument, FinMgmtAreaFiscalYear, FinancialManagementArea, BudgetCategory, BudgetChangeDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_BudgetEntrChgDocDocument Bdgt from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFMBDGECDOCB view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Budget Entry and Change Document Items Basic view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY BudgetChangeDocument I_BudgetEntrChgDocDocument BudgetChangeDocument
KEY FinMgmtAreaFiscalYear I_BudgetEntrChgDocDocument FinMgmtAreaFiscalYear Fiscal Year
KEY FinancialManagementArea I_BudgetEntrChgDocDocument FinancialManagementArea FM Area
KEY BudgetCategory I_BudgetEntrChgDocDocument BudgetCategory Plan Category
KEY BudgetChangeDocumentItem I_BudgetEntrChgDocDocument BudgetChangeDocumentItem
BudgetDocumentYear I_BudgetEntrChgDocDocument BudgetDocumentYear Fiscal Year
BudgetEntryDocument I_BudgetEntrChgDocDocument BudgetEntryDocument Document Number
BudgetEntryDocumentItem I_BudgetEntrChgDocDocument BudgetEntryDocumentItem
BudgetedFund I_BudgetEntrChgDocDocument BudgetedFund Fund
BudgetedFundsCenter I_BudgetEntrChgDocDocument BudgetedFundsCenter Funds Center
BudgetedCommitmentItem I_BudgetEntrChgDocDocument BudgetedCommitmentItem Commitment Item
BudgetedFunctionalArea I_BudgetEntrChgDocDocument BudgetedFunctionalArea Functional Area
BudgetedGrantID I_BudgetEntrChgDocDocument BudgetedGrantID Grant
BudgetedFundedProgram I_BudgetEntrChgDocDocument BudgetedFundedProgram Funded Program
BudgetedBudgetPeriod I_BudgetEntrChgDocDocument BudgetedBudgetPeriod Budget Period
BudgetedFundsMgmtCustomerField I_BudgetEntrChgDocDocument BudgetedFundsMgmtCustomerField Customer Field
TransactionCurrency I_BudgetEntrChgDocDocument TransactionCurrency Transaction Currency
FinancialManagementAreaCrcy I_BudgetEntrChgDocDocument FinancialManagementAreaCrcy FM Area Currency
BudgetAmountInTransactionCrcy I_BudgetEntrChgDocDocument BudgetAmountInTransactionCrcy
BudgetAmountInFMACrcy I_BudgetEntrChgDocDocument BudgetAmountInFMACrcy
CommitmentItemCategory I_BudgetEntrChgDocDocument CommitmentItemCategory Commitment Item Cat.
BdgtCashEffectivityFiscalYear I_BudgetEntrChgDocDocument BdgtCashEffectivityFiscalYear
BudgetValueType I_BudgetEntrChgDocDocument BudgetValueType BCS Value Type
BudgetWorkFlowStatus I_BudgetEntrChgDocDocument BudgetWorkFlowStatus Workflow Status
InternalBudgetingProcess I_BudgetEntrChgDocDocument InternalBudgetingProcess Budgeting Process
BudgetType I_BudgetEntrChgDocDocument BudgetType Budget Type
BudgetVersion I_BudgetEntrChgDocDocument BudgetVersion Version
BudgetChangeDocCreationDate I_BudgetEntrChgDocDocument BudgetChangeDocCreationDate
BudgetEntryDocumentType I_BudgetEntrChgDocDocument BudgetEntryDocumentType
BudgetEntryDocumentFamily I_BudgetEntrChgDocDocument BudgetEntryDocumentFamily
OriginalBudgetingApplication I_BudgetEntrChgDocDocument OriginalBudgetingApplication Original Application
CreationDate I_BudgetEntrChgDocDocument CreationDate Time Stamp
LastChangeDate I_BudgetEntrChgDocDocument LastChangeDate Time Stamp
BudgetEntryDocumentDate I_BudgetEntrChgDocDocument BudgetEntryDocumentDate
BudgetEntryDocumentDescription I_BudgetEntrChgDocDocument BudgetEntryDocumentDescription
BudgetEntryDocumentStatus I_BudgetEntrChgDocDocument BudgetEntryDocumentStatus
BdgtEntryDocReversalStatus I_BudgetEntrChgDocDocument BdgtEntryDocReversalStatus
ReversalReason I_BudgetEntrChgDocDocument ReversalReason Reversal Reason
ReversalRefBudgetEntryDocument I_BudgetEntrChgDocDocument ReversalRefBudgetEntryDocument
LogicalSystem I_BudgetEntrChgDocDocument LogicalSystem Logical System
FiscalTreasuryLoanCohort I_BudgetEntrChgDocDocument FiscalTreasuryLoanCohort
PublicLaw I_BudgetEntrChgDocDocument PublicLaw
FiscalTreasuryLegislationType I_BudgetEntrChgDocDocument FiscalTreasuryLegislationType
FiscalTreasuryAgency I_BudgetEntrChgDocDocument FiscalTreasuryAgency
FiscalTreasuryBudgetAccount I_BudgetEntrChgDocDocument FiscalTreasuryBudgetAccount
PartnerCompany I_BudgetEntrChgDocDocument PartnerCompany Trading Partner
BudgetEntryDocDistributionKey I_BudgetEntrChgDocDocument BudgetEntryDocDistributionKey
BudgetEntryDocItemIsAdditional I_BudgetEntrChgDocDocument BudgetEntryDocItemIsAdditional
BdgtEntrDocItmAdditionalItem I_BudgetEntrChgDocDocument BdgtEntrDocItmAdditionalItem
BudgetEntryDocItemDescription I_BudgetEntrChgDocDocument BudgetEntryDocItemDescription
ReferenceDocument I_BudgetEntrChgDocDocument ReferenceDocument Reference Document
ReferenceDocumentFiscalYear I_BudgetEntrChgDocDocument ReferenceDocumentFiscalYear Year Cur.Period
ReferenceDocumentItem I_BudgetEntrChgDocDocument ReferenceDocumentItem Reference item
ReferenceDocumentType I_BudgetEntrChgDocDocument ReferenceDocumentType Reference Document Type
ReferenceDocumentContext I_BudgetEntrChgDocDocument ReferenceDocumentContext Reference Document Context
ReferenceDocumentLogicalSystem I_BudgetEntrChgDocDocument ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
CommitmentItemFiscalYear I_BudgetEntrChgDocDocument CommitmentItemFiscalYear Commit. Item FY
_TransactionCurrency I_BudgetEntrChgDocDocument _TransactionCurrency
_FinMgmtArea I_BudgetEntrChgDocDocument _FinMgmtArea
_Currency I_BudgetEntrChgDocDocument _Currency

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_BudgetEntrAndChgDocBasic.
-- 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: IFMBDGECDOCB

CREATE VIEW I_BudgetEntrAndChgDocBasic 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.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,
  Bdgt.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  Bdgt._TransactionCurrency AS _TransactionCurrency,
  Bdgt._FinMgmtArea AS _FinMgmtArea,
  Bdgt._Currency AS _Currency
FROM I_BudgetEntrChgDocDocument AS Bdgt
;

Learn More