topic Re: Select query after the submit stmt in Application Development and Automation Discussions

Select query after the submit stmt

Former Member — Fri, 10 Oct 2008 10:40:52 GMT

Hi,

Have used the submit stmt as

" SUBMIT pgm name WITH SELECTION-TABLE rspar_tab

EXPORTING LIST TO MEMORY

AND RETURN."

Now the o/p generated is saved in the memory.In the report which is generated I have to fetch only 2 values based on one field as criteria..How to write the select query.

Re: Select query after the submit stmt

Former Member — Fri, 10 Oct 2008 10:52:23 GMT

Hi,

Have you tried a F1 help on EXPORTING LIST TO MEMORY command?There is a clear explanation for this

LIST_FROM_MEMORY

This is the Function module to get the data from memory to internal table after SUBMIT..EXPORTING LIST TO MEMORY.

Cheers,

Kothand

Re: Select query after the submit stmt

Former Member — Fri, 10 Oct 2008 12:00:37 GMT

hi,

after the submit statement use the LIST_FROM_MEMORY

function module...this function module loads the list from ABAP memory to an internal table of row type ABAPLIST...

after the data has been saved in an internal table u can do selection on the basis of the field...

Edited by: siddharth kumar on Oct 10, 2008 2:01 PM

Re: Select query after the submit stmt

Former Member — Fri, 10 Oct 2008 12:08:12 GMT

Hi,

Have tried the same but the o/p is like

RFCSIZE RFCRECORD

1000 |20202020202020202020202020202020202020202020202020202020202020<

from this how can i fetched my required data

Re: Select query after the submit stmt

Former Member — Fri, 10 Oct 2008 12:12:57 GMT

Try running the returned internal table through funvtion LIST_TO_ASCI.

If you go to the function group, you can find all LIST related function modules.