Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP query

Former Member
0 Kudos

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

4 REPLIES 4

Former Member
0 Kudos

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 .

0 Kudos

Hello Thanks

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

0 Kudos

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
0 Kudos

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