List of tables for CN41, CJI1, CJI3 and CJI5 ??

Former Member — Mon, 24 Nov 2014 06:42:48 GMT

Hi Experts,

I have to create a report which includes data as mentioned below.

1. For summary use CN41.

2. For Budget Line item wise use CJI1 (only use Budget type KBFR)

3. For item wise commitment detail use CJI5

4. For Actual cost Line item wise use CJI3 (Remove Document type AA)

I have searched alot but could only find tables PROJ, PRPS and COVP.

But I am not able to find the remaining table that are connected to each other via project code(PSPNR) primary key.

So pls if anyone knows or has a list of all tables for Project based transactions then pls help.

Thanks,

Vishal

Re: List of tables for CN41, CJI1, CJI3 and CJI5 ??

former_member543959 — Mon, 24 Nov 2014 08:38:12 GMT

Hi Vishal,

This could have been answered better in PS forum. Here is a link with comprehensive coverage for PS DB tables and how they are linked.

Best of luck.

Saurabh