How to check Assignment of Selection ID, forecast profile and last run time

[Former Member]

Hi All,

I need to collect following information in a single report,

1. Selection ID

2. Assigned forecast profile

3. Some of important Forecast profile parameters.

4. Last time forecast was run on the selection id with the assigned forecast profile.

Is there any standard transaction from where i can get this details. If not what are the tables for getting these details, especially for the point 4.

Many thanks & Regards

Shankar

[Former Member]

Thannks all for your help.

[Former Member]

Hi Shankar,

The table /SAPAPO/DP440G contains most of the information

that you require

Please confirm

Regards

R. Senthil Mareeswaran.

[Former Member]

Hi Senthil,

Thanks for your reply.

It was useful information, but this table doesn't contain the last forecast run time for the selection ID. Let me know, if you come across any table with that information.

Other than the above option of ABAP report, is ther any transaction or standard report for getting all this details directly?

Regards

Shankar

[Former Member]

Hi Shankar,

Please check following two DB tables for the additional information:

/SAPAPO/TSPLB (Background Job for Planning Area)

/SAPAPO/TSPLAKTT(Text Table for TSPLBAKT (Activities of Background Planning))

You may have to create a report taking data from the above 2-3 and some additional related tables.

For direct viewing, the background job spools for the forecasting jobs give good information.

Regards

Datta