Showing results for 
Search instead for 
Did you mean: 

use of SQL CTBL tables in logic

0 Kudos

In v4, the conso engine produced a side table all preceded with CTBL and this table contained each parent and all its ultimate children. By querying this table, you could get in scope in your query all the children of a specific parent. This technique was used very often in logic in the %SELECT% statements where you would do something like return all the ultimate children for your consolidation (or GROUPS) structure on which you need to perform additional logic steps after consolidation (for example to correct capital charges).

It is my understanding that these CTBL tables are no longer generated in v5 and hence v7.

Hence my question:

- is this true

- if so, what would be an alternative to using this technique you have experience with ?

Thank you for your help,

Edwin van Geel, SAP Netherlands

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Edwin,

Most of the CTBL tables are still being generated and can still be used using logic.

I don't have experience with v7, so I can't really help you with this one, but on the other hand, somehow I can't imagine that they removed this from v7 M.