What is C_BudgetEntryDocument_ObjP in SAP S/4HANA?

C_BudgetEntryDocument_ObjP is a consumption CDS view in SAP S/4HANA. Additional Selection Budget Entry Document It contains 31 fields.

Which tables does C_BudgetEntryDocument_ObjP read from?

C_BudgetEntryDocument_ObjP reads data from: I_BudgetEntryDocument.

What VDM layer is C_BudgetEntryDocument_ObjP?

C_BudgetEntryDocument_ObjP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BudgetEntryDocument_ObjP

DDL: C_BUDGETENTRYDOCUMENT_OBJP SQL: CBUDGETDOCOBJP Type: view CONSUMPTION

31 Fields 1 Data Sources 4 Associations

Additional Selection Budget Entry Document

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

Data Sources (1)

Source	Alias	Join Type
I_BudgetEntryDocument	BudgetEntryDocument	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..*]	C_BudgetEntryItemForObjP	_Item	`$projection.FinancialManagementArea = _Item.FinancialManagementArea and $projection.BudgetDocumentYear = _Item.BudgetDocumentYear and $projection.BudgetEntryDocument = _Item.BudgetEntryDocument`
[0..*]	C_BudDocForObjP	_FamilyDoc	`$projection.FinancialManagementArea = _FamilyDoc.FinancialManagementArea and $projection.BudgetDocumentYear = _FamilyDoc.BudgetDocumentYear and $projection.BudgetEntryDocumentFamily = _FamilyDoc.BudgetEntryDocumentFamily and $projection.BudgetEntryDocumentFamily <> ' '`
[0..*]	C_BudgetaryDocumentForObjP	_JournalEntry	`_JournalEntry.ReferenceDocumentType = 'FMED' and _JournalEntry.OriginalReferenceDocument = $projection.OriginalPredecessorRefDocument`
[1..1]	E_BudgetEntryDocument	_Extension	`$projection.BudgetEntryDocument = _Extension.BudgetEntryDocument and $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.BudgetDocumentYear = _Extension.BudgetDocumentYear`

Annotations (13)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.sqlViewName	CBUDGETDOCOBJP	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Additional Selection Budget Entry Document	view
UI.headerInfo.typeName	Budget Entry Document	view
UI.headerInfo.typeNamePlural	Budget Entry Documents	view
UI.headerInfo.title.value	BudgetEntryDocument	view
UI.headerInfo.description.value	BudgetEntryDocumentDescription	view

Fields (31)

Key	Field	Source Table	Source Field	Description
KEY	FinancialManagementArea	I_BudgetEntryDocument	FinancialManagementArea	Financial Management Area
KEY	BudgetDocumentYear	I_BudgetEntryDocument	BudgetDocumentYear	Document Year
KEY	BudgetEntryDocument	I_BudgetEntryDocument	BudgetEntryDocument	Budget Entry Document
	BudgetEntryDocumentFamily	I_BudgetEntryDocument	BudgetEntryDocumentFamily	Document Family
	FinancialManagementAreaName			Financial Management Area Name
	BudgetingProcess	I_BudgetEntryDocument	BudgetingProcess	Budgeting Process
	BudgetingProcessName			Process Name
	BudgetVersion	I_BudgetEntryDocument	BudgetVersion	Budget Version
	ControllingVersionText			Version Name
	CreatedByUser	I_BudgetEntryDocument	CreatedByUser	Created By
	CreationDate	I_BudgetEntryDocument	CreationDate	Created On
	CreationTime	I_BudgetEntryDocument	CreationTime	Created At
	CreationDateTime	I_BudgetEntryDocument	CreationDateTime	Created At
	LastChangedByUser	I_BudgetEntryDocument	LastChangedByUser	Last Changed By
	LastChangeDate	I_BudgetEntryDocument	LastChangeDate	Last Changed Date
	LastChangeTime	I_BudgetEntryDocument	LastChangeTime	Last Changed Time
	LastChangeDateTime	I_BudgetEntryDocument	LastChangeDateTime	Last Changed At
	BudgetEntryDocumentDate	I_BudgetEntryDocument	BudgetEntryDocumentDate	Document Date
	PostingDate	I_BudgetEntryDocument	PostingDate	Posting Date
	ReversalReason	I_BudgetEntryDocument	ReversalReason	Reversal Reason
	BudgetingResponsiblePersonName	I_BudgetEntryDocument	BudgetingResponsiblePersonName	Person Responsible
	BudgetEntryDocumentDescription	I_BudgetEntryDocument	BudgetEntryDocumentDescription	Budget Entry Document Description
	BudgetEntryDocumentStatus	I_BudgetEntryDocument	BudgetEntryDocumentStatus	Document Status
	BudgetEntryDocumentStatusName			Document Status Name
	BdgtEntryDocReversalStatus	I_BudgetEntryDocument	BdgtEntryDocReversalStatus	Document Reversal Status
	ReversalRefBudgetEntryDocument	I_BudgetEntryDocument	ReversalRefBudgetEntryDocument	Reversal Reference Budget Entry Document
	BudgetEntryDocumentType	I_BudgetEntryDocument	BudgetEntryDocumentType	Entry Document Type
	OriginalPredecessorRefDocument
	_Item		_Item
	_FamilyDoc		_FamilyDoc
	_JournalEntry		_JournalEntry

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 C_BudgetEntryDocument_ObjP.
-- 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: CBUDGETDOCOBJP

CREATE VIEW C_BudgetEntryDocument_ObjP AS
SELECT
  BudgetEntryDocument.FinancialManagementArea AS FinancialManagementArea,
  BudgetEntryDocument.BudgetDocumentYear AS BudgetDocumentYear,
  BudgetEntryDocument.BudgetEntryDocument AS BudgetEntryDocument,
  BudgetEntryDocument.BudgetEntryDocumentFamily AS BudgetEntryDocumentFamily,
  BudgetEntryDocument._FinMgmtArea._Text[1:Language=$session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  BudgetEntryDocument.BudgetingProcess AS BudgetingProcess,
  BudgetEntryDocument._BudgetingProcess._Text[1:Language=$session.system_language].BudgetingProcessName AS BudgetingProcessName,
  BudgetEntryDocument.BudgetVersion AS BudgetVersion,
  BudgetEntryDocument._BudgetVersion._Text[1:Language=$session.system_language].ControllingVersionText AS ControllingVersionText,
  BudgetEntryDocument.CreatedByUser AS CreatedByUser,
  BudgetEntryDocument.CreationDate AS CreationDate,
  BudgetEntryDocument.CreationTime AS CreationTime,
  BudgetEntryDocument.CreationDateTime AS CreationDateTime,
  BudgetEntryDocument.LastChangedByUser AS LastChangedByUser,
  BudgetEntryDocument.LastChangeDate AS LastChangeDate,
  BudgetEntryDocument.LastChangeTime AS LastChangeTime,
  BudgetEntryDocument.LastChangeDateTime AS LastChangeDateTime,
  BudgetEntryDocument.BudgetEntryDocumentDate AS BudgetEntryDocumentDate,
  BudgetEntryDocument.PostingDate AS PostingDate,
  BudgetEntryDocument.ReversalReason AS ReversalReason,
  BudgetEntryDocument.BudgetingResponsiblePersonName AS BudgetingResponsiblePersonName,
  BudgetEntryDocument.BudgetEntryDocumentDescription AS BudgetEntryDocumentDescription,
  BudgetEntryDocument.BudgetEntryDocumentStatus AS BudgetEntryDocumentStatus,
  BudgetEntryDocument._BudgetEntryDocumentStatus._Text[1:Language=$session.system_language].BudgetEntryDocumentStatusName AS BudgetEntryDocumentStatusName,
  BudgetEntryDocument.BdgtEntryDocReversalStatus AS BdgtEntryDocReversalStatus,
  BudgetEntryDocument.ReversalRefBudgetEntryDocument AS ReversalRefBudgetEntryDocument,
  BudgetEntryDocument.BudgetEntryDocumentType AS BudgetEntryDocumentType,
  concat(concat(BudgetEntryDocument.BudgetEntryDocument, BudgetEntryDocument.FinancialManagementArea), BudgetEntryDocument.BudgetDocumentYear) AS OriginalPredecessorRefDocument
FROM I_BudgetEntryDocument AS BudgetEntryDocument
LEFT OUTER JOIN C_BudgetEntryItemForObjP AS _Item ON FinancialManagementArea = _Item.FinancialManagementArea AND BudgetDocumentYear = _Item.BudgetDocumentYear AND BudgetEntryDocument = _Item.BudgetEntryDocument  -- association [1..*]
LEFT OUTER JOIN C_BudDocForObjP AS _FamilyDoc ON FinancialManagementArea = _FamilyDoc.FinancialManagementArea AND BudgetDocumentYear = _FamilyDoc.BudgetDocumentYear AND BudgetEntryDocumentFamily = _FamilyDoc.BudgetEntryDocumentFamily AND BudgetEntryDocumentFamily <> ' '  -- association [0..*]
LEFT OUTER JOIN C_BudgetaryDocumentForObjP AS _JournalEntry ON _JournalEntry.ReferenceDocumentType = 'FMED' AND _JournalEntry.OriginalReferenceDocument = OriginalPredecessorRefDocument  -- association [0..*]
LEFT OUTER JOIN E_BudgetEntryDocument AS _Extension ON BudgetEntryDocument = _Extension.BudgetEntryDocument AND FinancialManagementArea = _Extension.FinancialManagementArea AND BudgetDocumentYear = _Extension.BudgetDocumentYear  -- association [1..1]
;

Depth:

C_BudgetEntryDocument_ObjP view

I_BudgetEntryDocument view_entity