Question:
Hi
What are cluster tables and can BW extract from cluster tables?
Thank you
Answer:
Cluster tables are tables that hold tables and are not the same as transparent tables. You should know this by looking into the SAP documentation.
I don't believe you can extract directly from a cluster table. (correct me if I'm wrong anyone). I think you would need to have a generic extractor that extracts via a function module or abap program.
Answer:
You are correct, you cannot accesss cluster tables directly as a datasource. You must access them via an ABAP program (which you would have to write yourself). Essentially cluster tables are legacy table types. (There supposed to be gone, but there are still a bunch out there, they haven't gotten around to converting them all yet ).
My understanding of cluster tables is that it is essnetially one field holding the information and a program knows how to read the data to be human readable.
Answer:
Hi all,
A function module might be your best option for reading the cluster table. However, using an InfoSet Query should also do the job. If you are not keen on programming and no complicated logic is required, this is an option worth considering.
Cheers
Jorgen
_________________
______________________________
Jorgen Bonde Rasmussen
jbrasmussen@mail.dk
Answer:
There are numerous macros that SAP has for accessing cluster tables to make life a little more simple. I am not sure exactly what they are but I have seen them implemented in several programs.
Regards,
EL
Answer:
A function module might be your best option for reading the cluster table. However, using an InfoSet Query should also do the job. If you are not keen on programming and no complicated logic is required, this is an option worth considering.
I *thought* InfoSets could not properly read a cluster table and that you would still have to program/write a function module to pull the information you want? (I am fairly certain this is the case for 4.6C b/c we had the recent requiremnt to get info out of a cluster table to flat file and the only way to do it was via ABAP, as the InfoSet Query could not properly read the cluster table.
- Stephen
Answer:
Stephen,
You might be right. My understanding is that this is possible. As far as I remember, I prototyped it 3 years back. My understanding is that the infoset generates a program that then reads a cluster table. If I can find the time, I will test it. I'm sorry if I have posted any missleading info.
Cheers
Jorgen
_________________
______________________________
Jorgen Bonde Rasmussen
jbrasmussen@mail.dk
Answer:
I checked it out (at least under 4.6C), you CAN use a cluster table in an InfoSet, the problem is you can only use that table by itself. You cannot join a cluster table to any other tables. (which is what we were trying to do in our case.)
So, if you want to pull a cluster table by itself, you should be able to do that in an infoset. It just can't be done as part of a join. Doh!
- Stephen
Answer:
Hi,
Sounds good, I wount check any further.
Cheers
Jorgen
_________________
______________________________
Jorgen Bonde Rasmussen
jbrasmussen@mail.dk
Answer:
Hi,
We faced a similiar situation with a join of tables BKPF and BSEG(cluster). The joining was done with ABAP direct read and the combination was saved into a new custom table.
AO