topic Re: Query Question in Application Development and Automation Discussions

Query Question

Former Member — Fri, 13 Feb 2009 12:10:13 GMT

Hi,

How can i join a table with an internal table in Sap Query?

i have a base table (aufk) and i will be creating an internal table with code in an infoset. Then i need to join the internal table with aufk.

Thanks,

Re: Query Question

former_member582701 — Fri, 13 Feb 2009 12:14:07 GMT

SELECT *

FROM AUFK

INTO TABLE i_aufk

FOR ALL ENTRIES IN i_itab

WHERE field = i_itab-field.

Re: Query Question

Former Member — Fri, 13 Feb 2009 12:18:27 GMT

Can you give more details?

i created an infoset with just aufk.

then where will i put this code? in additional fields? or where?

Thanks.

Re: Query Question

Former Member — Fri, 13 Feb 2009 12:19:33 GMT

Hi Alper

[Table Joins|http://help.sap.com/saphelp_nw04/helpdata/EN/50/a71ec8f65911d296390000e82de14a/content.htm]

Regards,

Sravanthi

Re: Query Question

Former Member — Fri, 13 Feb 2009 13:24:26 GMT

Hi Alper,

Here is the sample code for inner join.

SELECT mara~matnr

marc~werks

INTO TABLE t_material

FROM mara AS mara INNER JOIN marc AS marc

ON mara_{matnr = marc}matnr

WHERE mara~mtart = p_mtart.

here instead of a standard table use your internal table.

Hope it helps!

Much Regards,

Amuktha.

Re: Query Question

Former Member — Fri, 13 Feb 2009 16:22:10 GMT

i was thinking about doing this on sq01 sap query,

from what you wrote i should understand that i need to create a seperate program for this?

Re: Query Question

Sandra_Rossi — Fri, 13 Feb 2009 21:43:05 GMT

Yes. sq01 is made to help querying out database tables, not doing some "complex" abap. In SQ01, can't you query a DB table instead of creating an internal table?

Re: Query Question

Former Member — Sat, 14 Feb 2009 06:43:45 GMT

what i have is :

order no

order no--~~-material no~~--~~reserved amount~~--

1--

1001
10--

1--

1002
5--

2--

1018
1--

order no~~-material no~~

consumed amount

1--

1001
4--

1--

1003
7--

2--

1018
1--

with these 3 tables, i want to get :

order no~~-material no~~

reservedconsumed--difference

1--

1001
10
4
6--

1--

1002
3
0
3--

1--

1003
0
7
~~(-7)~~----

2--

1018
1
1
0--

as you can see material numbers are unique lists for that order both from reservations and consumes.

Any hope?

Alper,

Re: Query Question

Sandra_Rossi — Sat, 14 Feb 2009 15:03:02 GMT

Thank you for the details, it's clear : I don't see how it can be done in only one query, so I guess you'd better create an abap program.