I_BudgetEntryDocument

DDL: I_BUDGETENTRYDOCUMENT SQL: IFMBDGTDOC Type: view COMPOSITE

Budget Entry Document

I_BudgetEntryDocument (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_BudgetEntryDocument is a Composite CDS View that provides data about "Budget Entry Document" in SAP S/4HANA. It reads from 1 data source (I_BudgetEntryDocumentBasic) and exposes 45 fields with key fields FinancialManagementArea, BudgetDocumentYear, BudgetEntryDocument. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-FM-BCS-BU
CapabilitiesData Source for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_BudgetEntryDocumentBasic I_BudgetEntryDocumentBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BudgetEntryDocumentItem _BudgetEntryDocumentItem $projection.FinancialManagementArea = _BudgetEntryDocumentItem.FinancialManagementArea and $projection.BudgetDocumentYear = _BudgetEntryDocumentItem.BudgetDocumentYear and $projection.BudgetEntryDocument = _BudgetEntryDocumentItem.BudgetEntryDocument

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IFMBDGTDOC view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Entry Document view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea Financial Management Area
KEY BudgetDocumentYear BudgetDocumentYear Document Year
KEY BudgetEntryDocument BudgetEntryDocument Budget entry document number
BudgetEntryDocumentFamily BudgetEntryDocumentFamily Document Family Number
OriginalBudgetingApplication OriginalBudgetingApplication Original Application
BudgetingProcess BudgetingProcess Budgeting Process
BudgetVersion BudgetVersion Budget Version
CreatedByUser CreatedByUser User Who Created or Updated the Object
CreationDate CreationDate Date on which the object was created or updated
CreationTime CreationTime Time at which the object was created or updated
LastChangedByUser LastChangedByUser Last user to change object
LastChangeDate LastChangeDate Date on which the object was changed
LastChangeTime LastChangeTime Time at which the object was changed
BudgetEntryDocumentDate BudgetEntryDocumentDate Document Date
PostingDate PostingDate Posting Date in the Document
ReversalReason ReversalReason Reason for Reversal of Budget Document
BudgetingResponsiblePersonName BudgetingResponsiblePersonName Person Responsible for Planning/Budgeting
BudgetEntryDocumentDescription BudgetEntryDocumentDescription Header Text for Budget Entry Document
BudgetEntryDocumentStatus BudgetEntryDocumentStatus Status of a budget entry document
BdgtEntryDocReversalStatus BdgtEntryDocReversalStatus Reversal Status
ReversalRefBudgetEntryDocument ReversalRefBudgetEntryDocument Reversal Reference Document Number
BudgetEntryDocumentType BudgetEntryDocumentType Budget entry document type
LogicalSystem LogicalSystem Logical System
FiscalTreasuryLoanCohort FiscalTreasuryLoanCohort Reporting Year for Cohort
PublicLaw PublicLaw Public Law Cited
FiscalTreasuryLegislationType FiscalTreasuryLegislationType Type of Legislation
FiscalTreasuryAgency FiscalTreasuryAgency Transfer Agency
FiscalTreasuryBudgetAccount FiscalTreasuryBudgetAccount Trnsf acct for c.pmt
PartnerCompany PartnerCompany Company ID of Trading Partner
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Logical system of source document
ReferenceDocumentContext ReferenceDocumentContext Reference Organizational Units
ReferenceDocument ReferenceDocument Reference Doc. Number
OriginalReferenceDocument OriginalReferenceDocument Reference Key
AutomaticBdgtPostingReference AutomaticBdgtPostingReference Reference Document Number
_FinMgmtArea _FinMgmtArea
_BudgetEntryDocumentItem _BudgetEntryDocumentItem
_OriginalBudgetingApplication _OriginalBudgetingApplication
_BudgetingProcess _BudgetingProcess
_BudgetEntryDocumentStatus _BudgetEntryDocumentStatus
_BdgtEntryDocReversalStatus _BdgtEntryDocReversalStatus
_BudgetEntryDocumentType _BudgetEntryDocumentType
_BudgetVersion _BudgetVersion
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_BudgetEntryDocument.
-- 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: IFMBDGTDOC

CREATE VIEW I_BudgetEntryDocument AS
SELECT
  FinancialManagementArea,
  BudgetDocumentYear,
  BudgetEntryDocument,
  BudgetEntryDocumentFamily,
  OriginalBudgetingApplication,
  BudgetingProcess,
  BudgetVersion,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BudgetEntryDocumentDate,
  PostingDate,
  ReversalReason,
  BudgetingResponsiblePersonName,
  BudgetEntryDocumentDescription,
  BudgetEntryDocumentStatus,
  BdgtEntryDocReversalStatus,
  ReversalRefBudgetEntryDocument,
  BudgetEntryDocumentType,
  LogicalSystem,
  FiscalTreasuryLoanCohort,
  PublicLaw,
  FiscalTreasuryLegislationType,
  FiscalTreasuryAgency,
  FiscalTreasuryBudgetAccount,
  PartnerCompany,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  OriginalReferenceDocument,
  AutomaticBdgtPostingReference
FROM I_BudgetEntryDocumentBasic
LEFT OUTER JOIN I_BudgetEntryDocumentItem AS _BudgetEntryDocumentItem ON FinancialManagementArea = _BudgetEntryDocumentItem.FinancialManagementArea AND BudgetDocumentYear = _BudgetEntryDocumentItem.BudgetDocumentYear AND BudgetEntryDocument = _BudgetEntryDocumentItem.BudgetEntryDocument  -- association [0..*]
;