Help needed on ABAP Query

[Former Member]

Hi Guys,

I need to join RBKP,RSEGand BKPF using SQ01. But BKPF has no link to RBKP or RSEG.

The only link is AWKEY field of BKPF which contains MIRO DOC as first 10 charcters but in SQ01 i cant split 10 characters of BKPF to link with RBKP.

Please help m on how to use CODE option in this regard in SQ01.

Is it possible to link these 3 tables.

I can write simple ABAP program but if it can happen thru SQ01 query. It is helpful.

Thanks

Eswar Rao.

[Former Member]

Hi Guys,

I need to join RBKP,RSEGand BKPF using SQ01. But BKPF has no link to RBKP or RSEG.

The only link is AWKEY field of BKPF which contains MIRO DOC as first 10 charcters but in SQ01 i cant split 10 characters of BKPF to link with RBKP.

Please help m on how to use CODE option in this regard in SQ01.

Is it possible to link these 3 tables.

I can write simple ABAP program but if it can happen thru SQ01 query. It is helpful.

Thanks

Eswar Rao.

[Former Member]

Go to edit mode in Infoset (SQ02) and from menu GO TO ---> Code

Here you will find various events to write your code.

[Former Member]

Hi,

I tried in code but how will i get internal table structure at runtime becoz query generates a run time program .so how will i use that.

i kept break point and tried but i am not getting how to proceed further.

please suggest.