Table of ODS-Tables

[Former Member]

Hi guys,

does anybody know the table, in which the information is stored of which tables a ODS-Object consists? E. g. ODS-Object OSD001 consists of /BIC/AOSD00100, the active table, /BIC/AOSD0012040, the new data and /BIC/B<some generic number>, the change log.

regards

Siggi

[klaus_werner · Accepted solution]

Hi Siggi,

the /BIC/B table can be seen in table RSTSODS with key 8<ODS Object name>. The other table names are hard coded invariably the same, not stored in a table.

REgards, Klaus

[Former Member · Accepted solution]

Hi Klaus,

thank's for your quick reply. Isn't it possible that I find more than one entry for my ODS, even if I specify dateto and datefrom, is it? The ODSNAME in that table is not only 8<ods-name>, it is 8<ods-name>_<2character suffix>.

regards

Siggi

[klaus_werner · Accepted solution]

Hi Siggi,

I was a little too fast with the answer, you are right, I forgot the system suffix. Yes, there may be several entries but the current one should be the one with the highest (9999) date to, shouldn't it? More than one of that type should not exist.

Regards, Klaus