Tables in Multiprovider

[Former Member]

I want to check which DB Tables are used in Multiprovider  AERP_FCLM_MP05. How can I check?

[ccc_ccc]

Hi John,

Tables:

RSDCUBE == > You can get all infocubes/mulitproviders list

RSDCUBEIOBJ ==> List of infoobjects used in Infocube

RSDICMULTIIOBJ ==>It gives the list multiprovider and what are the infocubes used and infoobjects

RSDODSO  ==> List of DSO

RSDODSOIOBJ ==> List of infoobjects used in DSO

RSDIOBJ ==> List of Infoobjects

RSQISET ==> List of Infosets

RSQFOBJ==> List of DSO/Infobjects  used in infoset

Hope this will help you to solve the issue.

Thank you,

Nanda

[Former Member]

Hi John,

Please see the below link which contains the list of important(commonly used) tables in SAP BW.

Important Tables in SAP BW 7.x - SAP NetWeaver Business Warehouse - SCN Wiki

Hope this might help you.

Regards,

Nikhil.

[Former Member]

Hi Mahesh/Nikhil,

As Infocube/DSOs are created on Data which resides in some Tables. I want to know that how can we get List of all tables used in a particular Infocube/Multiprovider (for any one of these will be sufficient)

[Former Member]

Hi John,

Multiprovider is the Virtual provider. I think there are no specific tables available for it.

Thanks and Regards,

Mahesh