cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

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

Chetan35
Explorer
0 Likes
1,704

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.

Accepted Solutions (1)

Accepted Solutions (1)

Jeremy_Deo
Contributor
0 Likes

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

 

Chetan35
Explorer
0 Likes
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..?

Answers (5)

Answers (5)

Jeremy_Deo
Contributor
0 Likes

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

Chetan35
Explorer
0 Likes
my values are come under KBN0, how
Jeremy_Deo
Contributor
0 Likes

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

Chetan35
Explorer
0 Likes
yes but in BPGE, BUDAT is not exist, any other way...?
Jeremy_Deo
Contributor
0 Likes

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

Chetan35
Explorer
0 Likes
Dear sir,
Chetan35
Explorer
0 Likes
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
Jeremy_Deo
Contributor
0 Likes

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

Chetan35
Explorer
0 Likes
Hi sir, i am am working on HANA RISE
Jeremy_Deo
Contributor
0 Likes

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

Chetan35
Explorer
0 Likes
Hi, BUDAT Is not exist in table