Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Database tables in BW

Former Member

‎2005 Jun 03 8:00 AM

0 Likes
382

Hi Gurus,

Can anyone please give information about the database table where all the ods object and its associated tables like active table, change log, new data table are stored in BW. It would be of great help. Any help would be fine.

Thanks,

Prabhu.

1 REPLY 1
Read only

Former Member

‎2005 Jun 03 8:26 AM

0 Likes
262

Hi,

the tables which you look are:

Active Data /BIC/A<ODS_NAME>00

- New Data /BIC/A<ODS_NAME>10 in BW 2.x /BIC/A<ODS_NAME>40 in BW 3.x

- Change Log: search in table RSTSODS with the string "8<ODS_NAME>" in field ODSNAME, the name of Change Log is in field ODSNAME_TECH.

http://help.sap.com/saphelp_bw32/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

Regards,

Jagath