Tables for FM Budget Release and Budget

[Former Member]

Dear Gurus,

Can any one please provide the tables for FM Budget and Release??

Regards,

Venkat

[Former Member]

Thanks

[former_member206396]

Mr. Reddy,

Please find few tables that may help you..,

BPEP - actual budget ( need to add the amount against all periods )

FMIFIIT - cosumed budget ( same as above )

other : FMPOSIT, FMIOI and

useful FM : FM_GET_YEAR_FROM_DATE

Thanks

Ram

[Former Member]

Dear Ram,

Thanks... i want to see the budget and Budget Release with combination of Fund Centre and Commitment Item.

Can you please provide me any other tables?

regards,

venkat

[Former Member]

Any one can provide the Tables?

Regards,

Venkat

[iklovski]

Hi,

The budget tables are:

FMBH - headers

FMBL - lines

FMBDP - change documents

FMBDT - totals

Regards,

Eli

[former_member206396]

Reddy,

As per my knowledge, there are no direct tables w.r.t funds center and commit item.

That is the reason i have given main tables as well as useful tables.

Here, the mentioned tables BPEP and FMIFIIT takes POSIT and OBJNR.

So, first need to get the above mentioned fields using funds center and commitment item.

Follow the sample code, which might help ur purpose..

CONCATENATE 'FS' <controlling area> <funds center> INTO temp_objnr SEPARATED BY ' '.

SELECT SINGLE posit

FROM fmposit

INTO temp_posit

WHERE fikrs = <controlling area>

AND fipex = temp_fipex. " commitment item...

SELECT objnr

posit

wtp01 wtp02 wtp03 wtp04 wtp05 wtp06 wtp07 wtp08 wtp09 wtp10

wtp11 wtp12 wtp13 wtp14 wtp15 wtp16

FROM bpep

INTO TABLE it_bpep

WHERE objnr = temp_objnr

AND posit = temp_posit

AND wrttp = '43' " this depends on ur senario

AND gjahr = year. " fisical year

LOOP AT it_bpep.

COLLECT it_bpep INTO it_bpep_temp.

CLEAR : wa_bpep.

ENDLOOP.

SELECT fistl fipex trbtr FROM fmifiit INTO TABLE it_fmifiit

WHERE fonds IN r_fonds

AND fistl = temp_fistl

AND fipex = temp_fipex

and GJAHR = year. " fisical year

LOOP AT it_fmifiit. " for consumed budget

COLLECT it_fmifiit INTO it_fmifiit_temp.

CLEAR : wa_fmifiit.

ENDLOOP.

Hope this helps.

Otherwise, do mention what exactaly you want..

Thanks

Ram

[iklovski]

I'm afraid to say, that the data in your post is a bit misleading and irrelevant for the question...