Need Tables or TCODEs for some field

[MTerence]

Hi

I need to create a Z Report....i need to fetch the dates of Total Budget, Total Actual, Commitment Total, Total Assigned, and Total CIP.

I came to know for total CIP - BPGE... but for the rest

Can any one help...

- Pithan

[MTerence]

closed

[Former Member]

Hi Pithan,

Check the below tables.

BPGE - Budget, overall cost

BPJA - Budget, annual values

RPSCO - Project info database (cost, revenues)

RPSQT - Project info database (quantities)

COSP - Cost totals for external postings

COSS - Cost totals for internal postings

COSB - Total variances/result analysis

COEP - Line items, actuals

COOI - Line items, commitments

COEJ - Line items, planned orders

Hope these tables help you for your Z Report.

Br,

Hari.

[MTerence]

Hi

I checked ur Tables...

can u get info for the datas fetch in

S_ALR_87013558 - Budget/Actual/Commitment/Rem Plan/Assigned

here is a display of the things i have given the last post....

I need table for that.. is it possible to fetch from the TCODE

- Pithan

[Former Member]

Hi Pithan,

You must use any one of the above tables to fetch the required data for your Z report. Even in S_ALR report which you mentioned is also fetch data from the above said tables only. check entries in RPSCO as well.

Its a wonder if any one can tell us any new tables apart from the above mentioned, if exists !!

Br,

Hari.

[MTerence]

Hi Hari

Its great to see the tables... thats true... i used these tables only...

Bur i got a problem while executing the code using COOI... its running for run time dump... so... i need to check.. if some other tables fetches the same value as the COOI does...

I am giving the object no as the input...

Is there any table to check the Commitment in CJi3...

- Pithan

[Former Member]

Hi,

Try Table COSP : Commitment total records

Regards,

[MTerence]

Hi....

yes... i am able to get from COSP... but held up with one issue in prps and proj tables...

In PRPS - Field PSPNR ( the description is WBS Element)

In PROJ - Field PSPNR ( the description is Project Definition)

Why it is different ?

Can u explain...

- Pithan

[Former Member]

Hi,

IN PRPS : By inputing WBS IDin PSPNR , you get all the details for that WBS element .e.g. you get object number ,project number , etc.

In PROJ : By inputing Project ID in PSPNR , you get all the details for that Project Definition .e.g.you get object number . company code , controlling area .

Hope this solves your query.

Regards,

[Former Member]

Hi

In PRPS - Field PSPNR ( the description is WBS Element)

This is level 1 WBSE

In PROJ - Field PSPNR ( the description is Project Definition)

This is project def.

Normally in STD SAP the WBS level 1 is using the same name as project def. That is the reason the both the fields are having the same name with diff table.

Thanks

S.Murali