SAP Query - SQ01 and SQ02

[former_member210252]

Hi All,

I have a requirement to user three tables TAB1,TAB2 and TAB3. As TAB3 is cluster table I am unable to use it in Joins. But TAB1 and TAB2 I am able to Join.

Now, after TAB1 and TAB2 are joined then the result how can we make use of TAB3 in the query.

Please share ideas if any.

Regards,

Rafi

[Former Member]

Hi Rafi,

Have you tried using it within a formula?

You can set a new field according to your requirement and code it, on it you can use any table, even call functions and so on.

This thread have the explanation of what I am talking about.

Regards,

Silvia Anselmi

[former_member210252]

Hi Silvia,

Thanks for your reply.

I am looking for using existing TAB1 and TAB2 result with TAB3.

Not for single filed but for multiple fields from TAB3 with respect to the result of TAB1 + TAB2.

Regards,

Rafi

[Former Member]

Rafi,

Still I think you can meet your requirements with what I am telling you, why don't you explain me a little more so we can see what we can do?

Regards,

Silvia

[former_member210252]

Silvia,

I joined two standard tables in query and able to get the result. Now, I want to make use of

another table using the result of two tables(I cannot use this table in join as it is a cluster table).

I would select few fields from the table which I did not used in join.

Regards,

Rafi

[michael_kozlowski]

JOIN doesn't work for cluster tables. If the tables are part of a logical database use LDB.

[sarat_malladi]

Try using those two tables in below mentioned section of code and use the third table here.

[VenkatRamesh_V]

Hi Rafi,

Can you tell the cluster table name.

Eg: Bseg table is cluster  table but the same data's are Splited into many table, eg: vendor entries,

customer entires and  gl entires( eg: tables bsik, bsak, bsid, bsad,.. etc ).

Hope it helpful,

Regards,

Venkat.