KSB1 data extraction issue

[Former Member]

Hi Experts!!!

I have an issue regarding KSB1 extraction of Activities specifically. The report was not fetching the activities data in the report, whereas expenses data was appearing.

After selecting the data source of database & archive, then the report started fetching the activities data. Here my question is when the data is archived is it deleted from the main database?

How can I see when & who performed this action?

[Former Member · Accepted solution]

The problem has been resolved, actually a patch was installed by the Basis team to improve the speed of the system that patch effected the table ONKRL (table which contains the master data of activities), in fact it deleted the master data in the table. that table is now updated.

[iklovski]

Hi,

Archived data is indeed distinguished from the main tables; that's the purpose of archiving. You can follow the history of the archiving via SARA transaction.

Regards,

Eli

[Former Member]

thanks for your response,

I think I have to re-phrase my question, actually KSB1 is behaving very odd in terms of activity values fetching. The data is available on the main database, other reports like COOIS showing actual activity data and KP27 is dispalying planned activity data.

But the KSB1 is not fetching the data properly, what may be reason behind it. Please help....

[iklovski]

What is your SAP release?

[Former Member]

SAP ECC 6.0