PS - 'Budget/Planning' Ledger in RPSCO, BPJA tables

[Former Member]

Hi,

Could you help to advise what does the 'Budget/Planning' Ledger in RPSCO, BPJA tables mean? Is it related to whether Controlling area or object currency is used?

Also, may I know if the forecast values can also be extracted from the 2 tables?

Thanks!

Regards,

Vivian

[Former Member]

Hello,

For Plan Cost:

(1) For Plan Cost of individual WBS; we should pass WBS as input to PRPS-PSPNR and obtain the PRPS-OBJNR. After fetching the PRPS-OBJNR, pass this value to RPSCO-OBJNR with value type RPSCO-WRTTP = 1 and get Plan cost for WBS by adding the value obtained in the following fields of RPSCO table WLP00, WLP01,...to.... WLP16.

(2) For Plan Cost of network activity (NWA); we should pass the network number to AFKO-AUFNR and obtain AFKO-AUFPL. Pass AFKO-AUFPL to AFVC-AUFPL and obtain AFVC-OBJNR (object number for NWA). After fetching the AFVC-OBJNR, pass this value to RPSCO-OBJNR with value type RPSCO-WRTTP = 1 and get Plan cost for NWA by adding the value obtained in the following fields of RPSCO table WLP00, WLP01,...to.... WLP16

For Budget:

(1) In PS we have annual budget and overall budget. It is governed by Budget Profile defined in the Project.

The budget profile can be configured in three different ways:

Only annual budget.

(ii) Overall Budget.

(iii) Annual + Overall Budget (If this is the case then user has to maintain overall budget)

When the project has only annual budget then use table BPJA

When the project has only overall budget then use table BPGE

The best way to handle all the cases is first see BPJA table if you find values then populate your report by annual values. If the table is empty then select the value for that project in BPGE table.

Thanks & Regards,

Anish Walinjkar

[virendra_pal]

run se37 for function module HFPB_FIND_LEDGER and go to test mode

enter as follows

KOKRS controlling area

OWAER currency

this will result in

LEDNR_K ledger number in BPJA/ RPSCO tables

LEDNR_O not sure about this

KWAER currency

PERIV fiscal year variant

forecast values are nothing but planned values in possibily a different co version

Hope that helps