SAP Knowledge Base Article - Preview

2304508 - Orphaned aggregate tables

Symptom

Transaction DB02 diagnostics alerts missing tables. The tables are of type /BIC/D10*, /BIC/F10* or /BIC/E10*. Such a table for instance may be named /BIC/D1000103 or /BIC/F100010. Hence the aggregate-ID should be 100010. However, you do not find this aggregate existing for any InfoCube on your system.

The situation may vary, the only common thing usually is that the aggregate does not appear in RSA1 or RSDDV. Hence you cannot cleanup the situation by reactivating the aggregate.

For instance it may be the case that the aggregate table only appears in transaction SE14, but cannot be displayed in transaction SE11. The table can be empty or filled with data. The aggregate may still be present in table RSDCUBE, but missing in table RSDDAGGRDIR or the other way round.


Read more...

Environment

  • SAP Netweaver All Versions

Product

SAP NetWeaver all versions

Keywords

RSDDV, RSA1 , KBA , BW-BEX-OT-AGGR , Aggregates (Definition and Filling) , BW-BEX-OT-DBIF , Interface to Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.