Question Re: is there is any table which provide Posting date of b... in Enterprise Resource Planning Q&A

is there is any table which provide Posting date of budget supplement document number.

Chetan35 — Wed, 16 Apr 2025 07:26:05 GMT

i have requirement of change in supplement or return in wbs element budget. i got the document number, but unable to find out the document posting date.

Re: is there is any table which provide Posting date of b...

Jeremy_Deo — Wed, 16 Apr 2025 07:42:40 GMT

Hello dear user,

And thank you for asking your question in the SAP Community blog.

In SAP S/4HANA (including Public Cloud), for WBS element budget supplements or returns, you can track posting dates of budget documents using the following tables and approaches:

Primary Table: BPGE – Budget Line Items (CO)

Table Name: BPGE
Purpose: Stores budget line items including original budget, supplements, returns, transfers, etc.
Key Fields:

BELNR: Budget document number
OBJNR: Object number (related to WBS element)
GJAHR: Fiscal year
BDGT_TYPE: Budget type (e.g., supplement, return)
BUDAT: Posting date of the budget document

Use this table to retrieve the posting date (BUDAT) for your budget supplement document number

I hope this will help answer your question.

Best regards,

Jeremy

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 07:48:32 GMT

Hi, BUDAT Is not exist in table

Re: is there is any table which provide Posting date of b...

Jeremy_Deo — Wed, 16 Apr 2025 08:07:45 GMT

Dear user,

Can you please mention on which version of SAP you are working on ?

I will probably find another option for you on that basis.

Thank you in advance for your answer.

Best regards,

Jeremy

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 08:14:18 GMT

Hi sir, i am am working on HANA RISE

Re: is there is any table which provide Posting date of b...

Jeremy_Deo — Wed, 16 Apr 2025 08:31:43 GMT

Dear user,

Thank you for your reply.

For your previous question about finding the posting date (BUDAT) of a budget supplement or return document for WBS elements :

In RISE (Private Edition), the standard tables used in Investment Management (IM) and Project System (PS) for budget documents include :

1. BPJA / BPGE / BPBK

These tables store budget data, but do not hold the posting date (BUDAT).

2. FMIFIIT (if Funds Management is active)

Contains financial data but usually not relevant for just PS budget supplements.

3. Table IMAVC_OBJECT or FMBDT

Still might not give you BUDAT.

Best Option: Use Function Module or FM View

The posting date for budget supplements or returns is usually found only at runtime in logs or via function modules, such as:

Function Module: BP_DOCUMENT_READ
This reads the full budget document — including supplement/return information and posting date.
You can test it via SE37 using your document number.

I hope this will help answer your question.

Best regards,

Jeremy

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 09:31:40 GMT

Dear sir,

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 09:34:29 GMT

dear sir, thanks for your valuable reply, i can see the same through CJ3B. But i have to cretae a report to track date transfer of budget (mass) within some time limit. is threr is any way to devlope that kind of report

Re: is there is any table which provide Posting date of b...

Jeremy_Deo — Wed, 16 Apr 2025 09:46:33 GMT

Dear user,

Yes, you can develop a custom report to track budget transfers supplements/returns/transfers) within a given date range for WBS elements using standard tables from Project System (PS) and Budget Control System (BCS).

Useful Tables and Fields

The budget documents are stored in these tables:

Table	Description	Key Fields
BPGE	Original Budget (Annual)	OBJNR, GJAHR, VERSN, WRTTP, BUDAT
BPJA	Annual Budget Amounts	Same as above
BPBK	Budget Document Header

I hope this will help answer your question.

Best regards,

Jeremy

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 09:49:16 GMT

yes but in BPGE, BUDAT is not exist, any other way...?

Re: is there is any table which provide Posting date of b...

Jeremy_Deo — Wed, 16 Apr 2025 09:58:20 GMT

Dear user,

Use BPBK table instead of BPGE then.

If the BUDAT date field is not in the BPBK table, use the AEDAT (modification date) or CPUDT (creation date) field.

That's the only option you have there I'm afraid.

Hope this will help.

Best regards,

Jeremy

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 10:24:25 GMT

Dear sir, thank you for your support, this work for me. I have a other question, is there is any any key in BPGE table which diffrentiate that the budget is return or suppliment..?

Re: is there is any table which provide Posting date of b...

Jeremy_Deo — Wed, 16 Apr 2025 10:34:07 GMT

Dear user,

Yes the table BPGE (which stores budget line items) does contain a key field that differentiates between budget supplements, returns, and original budget postings.

Key Field to Use: VRGNG (Business Transaction)

This field indicates what kind of budget transaction it is. Here are the most relevant values:

*VRGNG Value*	*Description*	*Budget Type*
KBUD	Budgeting	Original Budget
KBUE	Budget Supplement	Supplement
KBRU	Budget Return	Return
KBHI	Budget Release	Release
KBFR	Budget Freeze	Freeze

I hope this will help answer your question.

Best regards,

Jeremy

Re: is there is any table which provide Posting date of b...

Chetan35 — Wed, 16 Apr 2025 10:37:15 GMT

my values are come under KBN0, how