01-28-2009 5:43 PM
Hi,
I want to get data which is in report S_ALR_87013543.I am particularly looking for projected plan values
I got actual values in table COEP but where do i get plan values?Is there a BAPI /FM to get this data?
rgds
Vara
01-28-2009 10:53 PM
Hi,
general way to find source tables is to run SQL trace (ST04 or ST01). As far as I remember it should be in the tables COSS, COSP, COSSP, COSPP. You can check selection conditions for each column in report painter. You can also check BAPI BAPI_COPAPLANNING_GETDATA.
Cheers
01-29-2009 4:28 AM
Hi,
since this is for project systems BAPI did not fulfill my requirement .
I have done following..for getting OBJNR's I went to PRPS by inputting my project number in PSPHI .
After getting OBJNR's I went to COSP with version (C01- this is what I need) and inputted OBJNR's
I got values but these are little bit less .Why is it so?
or am i searching wrong way?
rgds
Vara
01-29-2009 5:00 AM
Hi,
I had to write similar report and I had to use all tables from my previous post. If you run SQL trace for that report you will see all conditions which you have to use for these tables. My advise is to run SQL trace and reconstruct logic of that report from SQL queries. This strategy worked for me.
Cheers
01-29-2009 5:21 AM
Hello Vara,
The "Projected Plan values" are also stored in COEP.
The planned values are identitfied by COEP-WRTTP (Value Type).
Actual --> COEP-WRTTP = 4
Plan --> COEP-WRTTP = 1.
Hope this is clear.
BR,
Suhas
01-29-2009 5:28 AM
Suhas,
I have Checked COEP for Value type = 1.
and it is empty.I only see value type 4 in this table.May be this is due to config.
Rgds
Vara
02-05-2009 5:12 PM