Skip to Content
0
Former Member
Jul 17, 2010 at 01:01 PM

How to find tables which has more than 1000 Partitions

53 Views

Hi All,

Is there any other way to find out the tables which has more than 1000 Partitions ?

Apart from SAP report RSDD_MSSQL_CUBEANALYZE. Because this report is not working for me as job getting cancel again and again with ABAP dump DBIF_DSQL2_SQL.I already check SAP Note 1309838, but itu2019s not applicable for us because we are on highest support package level SAP_BW 701 SP06.

Thanks,

Harshal