I_BudgetDocument

DDL: I_BUDGETDOCUMENT SQL: IBDGTDOCUMENT Type: view COMPOSITE
26 Fields 1 Data Sources 1 Associations

Budget Document header

I_BudgetDocument is a Composite CDS View that provides data about "Budget Document header" in SAP S/4HANA. It reads from 1 data source (I_BudgetDocumentBasic) and exposes 26 fields with key fields ControllingArea, BudgetDocumentYear, BudgetDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BudgetDocumentBasic I_BudgetDocumentBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BudgetDocumentItem _BudgetDocumentItem $projection.ControllingArea = _BudgetDocumentItem.ControllingArea and $projection.BudgetDocumentYear = _BudgetDocumentItem.BudgetDocumentYear and $projection.BudgetDocument = _BudgetDocumentItem.BudgetDocument

Annotations (11)

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 IBDGTDOCUMENT view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Document header view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY BudgetDocumentYear BudgetDocumentYear Fiscal Year
KEY BudgetDocument BudgetDocument Document Number
BudgetDocumentType BudgetDocumentType Document Type
BudgetCategoryUsage BudgetCategoryUsage Category Usage
PlanningCategory PlanningCategory Plan Category
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
BudgetingResponsiblePersonName BudgetingResponsiblePersonName Person Resp.
BudgetDocumentStatus BudgetDocumentStatus Document Status
BudgetProcessGroup BudgetProcessGroup Budgeting Process
BudgetDocumentDescription BudgetDocumentDescription Document Description
ReversalRefBudgetDocument ReversalRefBudgetDocument Reversal Ref. Nr.
ReversalReason ReversalReason Reversal Reason
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
_BudgetDocumentItem _BudgetDocumentItem
_PlanningCategory _PlanningCategory
_BudgetDocumentType _BudgetDocumentType
_ControllingArea _ControllingArea
_BudgetProcessGroup _BudgetProcessGroup
_BudgetDocumentStatus _BudgetDocumentStatus

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_BudgetDocument.
-- 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: IBDGTDOCUMENT

CREATE VIEW I_BudgetDocument AS
SELECT
  ControllingArea,
  BudgetDocumentYear,
  BudgetDocument,
  BudgetDocumentType,
  BudgetCategoryUsage,
  PlanningCategory,
  PostingDate,
  DocumentDate,
  BudgetingResponsiblePersonName,
  BudgetDocumentStatus,
  BudgetProcessGroup,
  BudgetDocumentDescription,
  ReversalRefBudgetDocument,
  ReversalReason,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_BudgetDocumentBasic
LEFT OUTER JOIN I_BudgetDocumentItem AS _BudgetDocumentItem ON ControllingArea = _BudgetDocumentItem.ControllingArea AND BudgetDocumentYear = _BudgetDocumentItem.BudgetDocumentYear AND BudgetDocument = _BudgetDocumentItem.BudgetDocument  -- association [0..*]
;

Learn More