topic Re: Help with this SELECT in Application Development and Automation Discussions

Help with this SELECT

former_member384574 — Mon, 11 Aug 2008 10:38:08 GMT

Hi to everybody!!

I need help or any idea that can help me to solve my problem... I've to make an ALV with two differents infotypes, PA0002 and PA0015, I have to print from PA0002 pernr, perid, vorna and nachn and from PA0015 I have to print BETRG.

I make this with an inner join, but doesn't work well, this is my select

SELECT

PA0002_{PERNR PA0002}PERID

PA0002_{VORNA PA0002}NACHN

PA0015~LGART

INTO

(wa_tabla-pernr, wa_tabla-perid, wa_tabla-vorna,

wa_tabla-nachn, wa_tabla-betrg)

FROM PA0002 INNER JOIN pa0015 ON

PA0002_{PERNR = PA0015}PERNR

GROUP BY

PA0002_{PERNR PA0002}PERID

PA0002_{VORNA PA0002}NACHN

PA0015~LGART.

APPEND wa_tabla TO itab_tabla.

ENDSELECT.

DOes anybody tell me what happend? Or any other idea for do this?!

Thanks very much!

Re: Help with this SELECT

Former Member — Mon, 11 Aug 2008 10:54:31 GMT

Hi ,

Take an internal table with all required fields .

SELECT

PA0002_{PERNR PA0002}PERID

PA0002_{VORNA PA0002}NACHN

PA0015~LGART

INTO * table itab *

FROM PA0002 INNER JOIN pa0015 ON

PA0002_{PERNR = PA0015}PERNR

After fetching the entire data use sort . This even increases the performance

Re: Help with this SELECT

former_member787646 — Mon, 11 Aug 2008 11:10:51 GMT

Instead of using SELECT ...ENDSELECT you can save the records in the internal table at one go using

Array Fetch.

Try this....

SELECT

PA0002_{PERNR PA0002}PERID

PA0002_{VORNA PA0002}NACHN

PA0015~LGART

INTO TABLE itab_tabla FROM PA0002 INNER JOIN pa0015 ON

PA0002_{PERNR = PA0015}PERNR.

Hope it helps.

Murthy

Re: Help with this SELECT

former_member384574 — Mon, 11 Aug 2008 11:24:55 GMT

Thanks a lot! It works perfectly