Query Question

[Former Member]

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,

[former_member582701]

SELECT *

FROM AUFK

INTO TABLE i_aufk

FOR ALL ENTRIES IN i_itab

WHERE field = i_itab-field.

[Former Member]

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.

[Former Member]

Hi Alper

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

Regards,

Sravanthi

[Former Member]

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.

[Former Member]

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?

[Sandra_Rossi]

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?

[Former Member]

what i have is :

order no

1

2

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,

[Sandra_Rossi]

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.