Skip to Content

SAP Query - SQ01 and SQ02

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 04, 2015 at 04:51 PM

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


    Capture.JPG (22.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2015 at 03:00 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Nov 02, 2015 at 05:22 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2015 at 05:07 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded