topic Re: SAP query in Application Development and Automation Discussions

SAP query

Former Member — Thu, 10 Nov 2005 14:49:13 GMT

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 — Thu, 10 Nov 2005 15:02:59 GMT

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 — Thu, 10 Nov 2005 15:10:32 GMT

Hello Thanks

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

Former Member — Thu, 10 Nov 2005 15:14:48 GMT

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 — Fri, 11 Nov 2005 13:14:55 GMT

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