Project Balance Table

[Former Member]

Hi experts!

What are the DB tables i can retrieve the Project & WBS balance???

I have to develop a report on project balances.

Please help!!!

Thank you all in advance!!!

[nitin_patoliya · Accepted solution]

I suggest you for the PS to use std. reports till the time you can extend and satisfy your requirement.

If your requirement isn ot satisfied in that case you can go for the development.

Any way tables you can look after are

Please refer this link

PS Tables AFAB Network - Relationships

PS Tables IMAK Appropriation requests

PS Tables IMAV Appropriation request variants

PS Tables IMPR Capital Investment Program Positions

PS Tables IMPU Texts for cap. inv. program positions

PS Tables IMTP Capital Investment Programs

PS Tables IMZO CO object assignment

PS Tables PMCO Cost structure of maintenance order

PS Tables PRHI WBS Hierarchy

PS Tables PROJ Projects

PS Tables PRPS Work Breakdown structures

RPSCO : Project info database

These are the FI /CO tables which may be helpful to you in PS context.

FI / CO Tables BPEJ Budget revision header

FI / CO Tables BPEP Line Item Period Values

FI / CO Tables BPGE Overall/annual budget

FI / CO Tables BPJA Overall/annual budget

COSP : pri mary cost

COSS : Sec. cost

COEP : Actual cost

COOI : Commitment

COEJ : Planned cost.

Network: AFKO, AUFK

Activity: AFVV, AFVC

Activity Element: AFVV, AFVC

Milestone: MLST

Budget: BPGE, BPJA

Regards

Nitin P.

[Former Member]

Ok,

i tried the following order:

prps with the project id --> coss with the prps-objnr and cosp with the prps-objnr.

Even though some projects do not have a zero balance there are no entries neither in coss nor in cosp.

Any ideas????

Please help!!!