Underlying tables

[Former Member]

Hi all,

I have a basic doubt. We have a cube 0crm_c04 which is opportunities cube in CRM. When i go to the help documentation it lists out infosources and the information about the queries .I know that we load the data into cube from header data source and item data source based on the requirement.

But prior to loading data i would be interested to find out the underlying tables and the fields it supports.how can i view them. Pls correct me if i am understanding wrong.

[former_member188975 · Accepted solution]

Sometime you may like to read this blog by Roberto. It talks about understanding the tables that data comes from and how to look at this info for different datasources:

/people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

[former_member188975]

Hi PK,

Here is the info for the datasources. You can see the fields and the tables the info is being extracted from (in CRM)

http://help.sap.com/saphelp_nw04/helpdata/en/39/a5252db1142c4188bbde476a39c723/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/61/ef450b577111d6b21500508b5d5211/content.htm

Hope this helps...

[Former Member]

Bhanu,

Tell me the secret, I have been searching this the whole night yesterday and i burnt my head and could not find.Thanks a lot for understanding my question in the right sense and i will award u full points. keep it up!

Thanks,

PK

[former_member188975]

No big secret If you look at the left hand tree in the Search page, there is a node for Datasources...you can find this info there. Usually they (SAP help) will have a link to the datasource from the InfoSource page.

I also knew this as I have worked with these datasources...