Changes to existing query.

[Former Member]

Hello All,

I need to make changes to any existing query. The existing one fetches data only from a single table, but now I need to add 3 more fields in the output. These three fields are from a different table.

Can yo let me know, how can i achieve this.

Looking forward for your replies.

Thanks and Regards,

Santhosh Guptha N.

[Former Member]

hi,

If you find similar key fields or foreign keys in other table then you can use join, otherwise use 'FOR ALL ENTRIES' to get the records from second table based on first.

[Former Member]

Hello Hari,

Thanks for your reply.

I need to make changes in a SAP QUERY(created through SQ01) and not in any of the reports.

Thanks and Regards,

Santhosh Guptha N.

[Former Member]

Hi Santhosh,

For your reference.

[;

Regards,

Jithin

[Former Member]

hi,

Even in queries also you can use join, just add the new table, and select the required fields for output.

[Former Member]

Hi..

Can you give me any pointers as to how do i do it?

Should i make the changes in the infoset and then make the same in the query, or can i do it directly in SQ01.

Thanks and Regards,

Santhosh Guptha N.

[Former Member]

Hi Santosh,

Please refer the below join statement where the value is selected from 2 different tables. hope it helps.

Select A~Vbeln
          A~vbtyp
          B~posnr
          B~erdat
          into table I_VBAP
          from vbak as A innner Join VBAP as B
          on  a~vbeln = b~vbeln
          where   a~vbeln IN lr_vbeln AND
                      b~posnr IN lr_posnr AND
                      b~aedat IN lr_aedat AND
                     ( a~vbtyp EQ 'A' OR
                       a~vbtyp EQ 'B' OR
                       a~vbtyp EQ 'G' ).

Regards,

Jithin

[Former Member]

hi,

You can add the second table in infoset using join option ,in query select the required field for output. Please check the key fields combination for join.

[Former Member]

Hello Hari,

The join option is disabled in the query, which i am working on.

Can you please let me know, as to why is this, and how i can change the same.

Thanks and Regards,

Santhosh Guptha N