SAP query

[Former Member]

Hello ABAP Guru

I need a help here. trying to create SAP query joining three table VBAK VBAP KONV since KONV being cluster table I am not able to do that

thpough I am suceesfully establishe dthe link

VBAK-VBELN=VBAP-VBELN

VBAK-KNUMV=KONV-KNUMV & VBAP-POSNR=KONV-KPOSN

OSS msg says we have to write routine in sap query

but I never used that option

anyone has any clue on how to use cluster table in SAP query?

Thx

Praveen

[Former Member]

Hi,

If you use Cluster tables in your query you will get error while compiling/activation.

The table join doesn't shown any syntax error but

Write a routine in your infoset Attributes .

[Former Member]

Hello Thanks

so you mean under the option extras/code sequesnce we have to select codes n write routine?

[Former Member]

Yes.

In Infoset > Extras> Define Additional Field--> Write your code.

Ex:

CLEAR MPG1.

SELECT SINGLE * FROM TVM1T WHERE MVGR1 = MVKE-MVGR1.

IF SY-SUBRC = 0.

CONCATENATE TVM1T-MVGR1 TVM1T-BEZEI INTO MPG1 SEPARATED BY SPACE.

ENDIF.

[Former Member]

Hi,

Inner Join can't be used for cluster tables.

Write a routine in SAP query as follows.

do inner join on vbak,vbap into internal table

itab.

select for konv for all entries itab .

Regards

Amole