What is I_BudgetEntryDocTP in SAP S/4HANA?

I_BudgetEntryDocTP is a transactional CDS view in SAP S/4HANA. Budget Entry Document Header - TP It contains 49 fields.

Which tables does I_BudgetEntryDocTP read from?

I_BudgetEntryDocTP reads data from: I_BudgetEntryDocumentBasic.

What VDM layer is I_BudgetEntryDocTP?

I_BudgetEntryDocTP is classified as a Transactional view that supports create, update, and delete operations.

I_BudgetEntryDocTP

DDL: I_BUDGETENTRYDOCTP Type: view TRANSACTIONAL

49 Fields 1 Data Sources 5 Associations

Budget Entry Document Header - TP

I_BudgetEntryDocTP is a Transactional CDS View that provides data about "Budget Entry Document Header - TP" in SAP S/4HANA. It reads from 1 data source (I_BudgetEntryDocumentBasic) and exposes 49 fields with key fields FinancialManagementArea, BudgetDocumentYear, BudgetEntryDocument. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BudgetEntryDocumentBasic	BudgetEntry	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..*]	I_BudgetEntryDocItemPayTP	_Items	`$projection.FinancialManagementArea = _Items.FinancialManagementArea and $projection.BudgetDocumentYear = _Items.BudgetDocumentYear and $projection.BudgetEntryDocument = _Items.BudgetEntryDocument`
[0..*]	I_BudgetEntryDocItemCmtmtTP	_Items9G	`$projection.FinancialManagementArea = _Items9G.FinancialManagementArea and $projection.BudgetDocumentYear = _Items9G.BudgetDocumentYear and $projection.BudgetEntryDocument = _Items9G.BudgetEntryDocument`
[0..1]	I_BudgetEntryDocumentStatusD	_OverallStatus	`$projection.BudgetEntryDocumentStatus = _OverallStatus.BudgetEntryDocumentStatus`
[1..1]	I_FinancialManagementArea	_FinMgmtAreaForEdit	`$projection.FinancialManagementAreaForEdit = _FinMgmtAreaForEdit.FinancialManagementArea`
[1..1]	E_BudgetEntryDocument	_Extension	`$projection.BudgetEntryDocument = _Extension.BudgetEntryDocument and $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.BudgetDocumentYear = _Extension.BudgetDocumentYear`

Annotations (21)

Name	Value	Level
AbapCatalog.sqlViewName	IBDGTENTRYDOCHTP	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Budget Entry Document Header - TP	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#CLIENT_DEPENDENT	view
ObjectModel.modelCategory	#BUSINESS_OBJECT	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingEnabled	true	view
ObjectModel.writeDraftPersistence	FMBUDGET_DOCHD	view
ObjectModel.draftEnabled	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	EXTERNAL_CALCULATION	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.entityChangeStateId	DocumentLastChangedDateAndTime	view
ObjectModel.sapObjectNodeType.name	BudgetEntryDocument	view

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	FinancialManagementArea	I_BudgetEntryDocumentBasic	FinancialManagementArea	FM Area
KEY	BudgetDocumentYear	I_BudgetEntryDocumentBasic	BudgetDocumentYear	Fiscal Year
KEY	BudgetEntryDocument	I_BudgetEntryDocumentBasic	BudgetEntryDocument	Document Number
	FinancialManagementAreaForEdit	I_BudgetEntryDocumentBasic	FinancialManagementArea	FM Area
	BudgetDocYearForEdit	I_BudgetEntryDocumentBasic	BudgetDocumentYear	Fiscal Year
	BudgetEntryDocForEdit	I_BudgetEntryDocumentBasic	BudgetEntryDocument	Document Number
	BudgetEntryDocumentType	I_BudgetEntryDocumentBasic	BudgetEntryDocumentType	TSW Document type
	BudgetingProcess	I_BudgetEntryDocumentBasic	BudgetingProcess	Budgeting Process
	BudgetVersion	I_BudgetEntryDocumentBasic	BudgetVersion	Version
	DocumentDate	I_BudgetEntryDocumentBasic	BudgetEntryDocumentDate	Document Date
	PostingDate	I_BudgetEntryDocumentBasic	PostingDate	Posting Date for GR
	CreatedByUser	I_BudgetEntryDocumentBasic	CreatedByUser	User Name
	CreationTime	I_BudgetEntryDocumentBasic	CreationTime	Time of Change
	CreationDate	I_BudgetEntryDocumentBasic	CreationDate	Time Stamp
	LastChangedByUser	I_BudgetEntryDocumentBasic	LastChangedByUser	User Name
	LastChangeDate	I_BudgetEntryDocumentBasic	LastChangeDate	Time Stamp
	DocumentLastChangedDateAndTime	I_BudgetEntryDocumentBasic	LastChangeTime	Time changed
	BudgetEntryDocumentStatus	I_BudgetEntryDocumentBasic	BudgetEntryDocumentStatus	Document Status
	BudgetEntryDocumentDescription	I_BudgetEntryDocumentBasic	BudgetEntryDocumentDescription	Text
	PublicLaw	I_BudgetEntryDocumentBasic	PublicLaw	Public Law
	FiscalTreasuryLoanCohort	I_BudgetEntryDocumentBasic	FiscalTreasuryLoanCohort	Year Cohort
	FiscalTreasuryLegislationType	I_BudgetEntryDocumentBasic	FiscalTreasuryLegislationType	Legislation
	FiscalTreasuryAgency	I_BudgetEntryDocumentBasic	FiscalTreasuryAgency	Transfer Agency
	FiscalTreasuryBudgetAccount	I_BudgetEntryDocumentBasic	FiscalTreasuryBudgetAccount	Trnsf acct for c.pmt
	PartnerCompany	I_BudgetEntryDocumentBasic	PartnerCompany	Trading Partner
	BudgetingResponsiblePersonName	I_BudgetEntryDocumentBasic	BudgetingResponsiblePersonName	Person Resp.
	ReversalRefBudgetEntryDocument	I_BudgetEntryDocumentBasic	ReversalRefBudgetEntryDocument	Reversal Ref. Nr.
	BdgtEntryDocReversalStatus	I_BudgetEntryDocumentBasic	BdgtEntryDocReversalStatus	Reversal Status
	ReversalReason	I_BudgetEntryDocumentBasic	ReversalReason	Reversal Reason
	BdgtEntryDocTitle
	BudgetAmendmentForm		BudgetAmendmentForm	Form of Amendment
	BdgtAmendmentFormSpecification		BdgtAmendmentFormSpecification	Specification Code
	USFedTrdgPartSubLevelPrefix		USFedTrdgPartSubLevelPrefix
	USFedTradingPartnerAgency		USFedTradingPartnerAgency
	USFedAllocTransfAgencyTrdgPart		USFedAllocTransfAgencyTrdgPart
	USFedTrdgPartBeginPerdOfAvaily		USFedTrdgPartBeginPerdOfAvaily
	USFedTrdgPartEndPerdOfAvaily		USFedTrdgPartEndPerdOfAvaily
	USFedTrdgPartAvailabilityType		USFedTrdgPartAvailabilityType
	USFedTrdgPartMainAccount		USFedTrdgPartMainAccount
	USFedTrdgPartSubAccount		USFedTrdgPartSubAccount
	USFedTrdgPartBusEventTypeCode		USFedTrdgPartBusEventTypeCode
	Associations_Items
	_Items9G		_Items9G
	_FinMgmtArea		_FinMgmtArea
	_FinMgmtAreaForEdit		_FinMgmtAreaForEdit
	_OverallStatus		_OverallStatus
	_BudgetEntryDocumentType	I_BudgetEntryDocumentBasic	_BudgetEntryDocumentType
	_BudgetingProcess	I_BudgetEntryDocumentBasic	_BudgetingProcess
	_BudgetVersion	I_BudgetEntryDocumentBasic	_BudgetVersion

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_BudgetEntryDocTP.
-- 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.

CREATE VIEW I_BudgetEntryDocTP AS
SELECT
  BudgetEntry.FinancialManagementArea AS FinancialManagementArea,
  BudgetEntry.BudgetDocumentYear AS BudgetDocumentYear,
  BudgetEntry.BudgetEntryDocument AS BudgetEntryDocument,
  BudgetEntry.FinancialManagementArea AS FinancialManagementAreaForEdit,
  BudgetEntry.BudgetDocumentYear AS BudgetDocYearForEdit,
  BudgetEntry.BudgetEntryDocument AS BudgetEntryDocForEdit,
  BudgetEntry.BudgetEntryDocumentType AS BudgetEntryDocumentType,
  BudgetEntry.BudgetingProcess AS BudgetingProcess,
  BudgetEntry.BudgetVersion AS BudgetVersion,
  BudgetEntry.BudgetEntryDocumentDate AS DocumentDate,
  BudgetEntry.PostingDate AS PostingDate,
  BudgetEntry.CreatedByUser AS CreatedByUser,
  BudgetEntry.CreationTime AS CreationTime,
  BudgetEntry.CreationDate AS CreationDate,
  BudgetEntry.LastChangedByUser AS LastChangedByUser,
  BudgetEntry.LastChangeDate AS LastChangeDate,
  BudgetEntry.LastChangeTime AS DocumentLastChangedDateAndTime,
  BudgetEntry.BudgetEntryDocumentStatus AS BudgetEntryDocumentStatus,
  BudgetEntry.BudgetEntryDocumentDescription AS BudgetEntryDocumentDescription,
  BudgetEntry.PublicLaw AS PublicLaw,
  BudgetEntry.FiscalTreasuryLoanCohort AS FiscalTreasuryLoanCohort,
  BudgetEntry.FiscalTreasuryLegislationType AS FiscalTreasuryLegislationType,
  BudgetEntry.FiscalTreasuryAgency AS FiscalTreasuryAgency,
  BudgetEntry.FiscalTreasuryBudgetAccount AS FiscalTreasuryBudgetAccount,
  BudgetEntry.PartnerCompany AS PartnerCompany,
  BudgetEntry.BudgetingResponsiblePersonName AS BudgetingResponsiblePersonName,
  BudgetEntry.ReversalRefBudgetEntryDocument AS ReversalRefBudgetEntryDocument,
  BudgetEntry.BdgtEntryDocReversalStatus AS BdgtEntryDocReversalStatus,
  BudgetEntry.ReversalReason AS ReversalReason,
  concat( BudgetEntryDocument , ' ') AS BdgtEntryDocTitle,
  BudgetAmendmentForm,
  BdgtAmendmentFormSpecification,
  USFedTrdgPartSubLevelPrefix,
  USFedTradingPartnerAgency,
  USFedAllocTransfAgencyTrdgPart,
  USFedTrdgPartBeginPerdOfAvaily,
  USFedTrdgPartEndPerdOfAvaily,
  USFedTrdgPartAvailabilityType,
  USFedTrdgPartMainAccount,
  USFedTrdgPartSubAccount,
  USFedTrdgPartBusEventTypeCode,
  BudgetEntry._BudgetEntryDocumentType AS _BudgetEntryDocumentType,
  BudgetEntry._BudgetingProcess AS _BudgetingProcess,
  BudgetEntry._BudgetVersion AS _BudgetVersion
FROM I_BudgetEntryDocumentBasic AS BudgetEntry
LEFT OUTER JOIN I_BudgetEntryDocItemPayTP AS _Items ON FinancialManagementArea = _Items.FinancialManagementArea AND BudgetDocumentYear = _Items.BudgetDocumentYear AND BudgetEntryDocument = _Items.BudgetEntryDocument  -- association [0..*]
LEFT OUTER JOIN I_BudgetEntryDocItemCmtmtTP AS _Items9G ON FinancialManagementArea = _Items9G.FinancialManagementArea AND BudgetDocumentYear = _Items9G.BudgetDocumentYear AND BudgetEntryDocument = _Items9G.BudgetEntryDocument  -- association [0..*]
LEFT OUTER JOIN I_BudgetEntryDocumentStatusD AS _OverallStatus ON BudgetEntryDocumentStatus = _OverallStatus.BudgetEntryDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtAreaForEdit ON FinancialManagementAreaForEdit = _FinMgmtAreaForEdit.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN E_BudgetEntryDocument AS _Extension ON BudgetEntryDocument = _Extension.BudgetEntryDocument AND FinancialManagementArea = _Extension.FinancialManagementArea AND BudgetDocumentYear = _Extension.BudgetDocumentYear  -- association [1..1]
;

Depth:

I_BudgetEntryDocTP view

I_BudgetEntryDocumentBasic view

C_BudgetEntryDocumentTP view