Table to fetch 'To Date' of CJE0.

[Former Member]

Hello Friends,

Currently I am working on a customized report wherein I need to have Live to Date (LTD) column. If I refer CJE0 for any Project Def, it has To Date column.

From PRPS table I have found Object Numbers for the Project, and now I want to know which controlling or any other table will provide the live to Date entries.

I have found COSS and COSP tables, but they did not help me. Need to have table which should have link between OBJNR field of PRPS and Live to Date (LTD) of field.

Please help!

Your reply is very much appreciated.

Regards,

Sabya Sachi

[Former Member]

Hi sabya,

see this-http://scn.sap.com/docs/DOC-28689

Hope this will suffice your need.

Regards,

Pranav

[Former Member]

Hi Pranv,

thanks for the reply, but it did not help me.

Regards,

Sabya

[Former Member]

What do you mean by 'Live to Date"? Is it user field or customer field you are referring here.

thank you!

Mahendra

[Former Member]

Hi Mahendra,

Sorry, I really did not understand your question. CJE0 is basically a customized report where in To Date is the field.

Live to Date- Includes all data from start of project to current date and time.

Please let me know if I can help you further.

Regards,

Sabya

[Former Member]

If I understood correctly, you are buliding a project financials report where you want user to input 'To Date' and show all the costs and other details till that date.

If my understanding is correct, then I would suggest you better do this report using report painter. Where you have to just choose key fields and characteristics. You can search for similar type of report in GRR3(report group:6P3) and copy the same and make changes as you want to have.

Regards,

Mahendra

[Former Member]

Hi Mahendra,

It is the business requirement to have such PS report wherein the out put should be taken from the combination of CJI3 and CJI5 reports.

We have almost completed our work, the only requirement is remained is the Live to Date column in it.

Therefore I started this thread.

Your help in this regard is much appreciated!

Regards,

Sabya