BDLS issue with table RSDDSTATTDP

[Former Member]

Hi,

We did a system refresh & the BDLS ran for a very long duration in our SCM system. Table RSDDSTATDTP was processing for 7 hours.

Can we schedule a clean up of the table before the activity with the job SAP_RSDDSTAT_DATA_DELETE.

Also what are the data that would be affected by this cleanup & this was recommended for BI system . Can we schedule for SCM. Please advice.

Thanks,

[Sriram2009]

Hi

Kindly check this SAP KBA 1547980 - BDLS Performance

Regards

Ram

[Reagan]

Hello

Refer to this SAP note.

706478 - Preventing Basis tables from increasing considerably

Delete the table data and do a table reorg for this table and rebuild the indexes.

Regards

RB

[ACE-SAP]

Hi

This table does only contain statistics, it should be Ok to clean it up

Have a look to these threads

Table RSDDSTAT too big | SCN

BW Statistics and RSDDSTAT* views, tables - SAP NetWeaver Business Warehouse - SCN Wiki

Regards