topic Re: Using the option SUBMIT in Application Development and Automation Discussions

Using the option SUBMIT

Former Member — Fri, 26 May 2006 11:43:03 GMT

Hi,

I m trying to use SUBMIT for excuting the transaction FBL3N.

SUBMIT RFITEMGL

WITH SD_SAKNR-LOW = s_hkont-low

with SD_SAKNR-high = s_hkont-high

WITH SD_BUKRS-LOW = s_bukrs-low

WITH SD_BUKRS-high = s_bukrs-high

with %%DYN009-LOW = s_blart-low

with %%DYN014-LOW = i_bseg_data2-prctr

with SO_BUDAT-LOW = s_budat-low

with SO_BUDAT-high = s_budat-high

WITH X_OPSEL = space

WITH X_CLSEL = space

WITH X_AISEL = 'X'

EXPORTING LIST TO MEMORY

AND RETURN.

The problem is that the no record details are being fetched and no list is getting generated but when i am passing the same details in the transaction FBL3N directly I can see a report list getting generated.

Here I am not sure as to what is happening and why no records are being fetched in case when i m trying to do it through my program.

Thanks and regards,

Avi.

Re: Using the option SUBMIT

Former Member — Fri, 26 May 2006 11:46:18 GMT

Hi,

Do this, don't specify the low or high, just say SD_SAKNR in S_HKONT. Similary for other as well.

SUBMIT RFITEMGL

WITH SD_SAKNR-LOW = s_hkont-low

with SD_SAKNR-high = s_hkont-high

WITH SD_BUKRS-LOW = s_bukrs-low

WITH SD_BUKRS-high = s_bukrs-high

with %%DYN009-LOW = s_blart-low

with %%DYN014-LOW = i_bseg_data2-prctr

with SO_BUDAT-LOW = s_budat-low

with SO_BUDAT-high = s_budat-high

WITH X_OPSEL = space

WITH X_CLSEL = space

WITH X_AISEL = 'X'

EXPORTING LIST TO MEMORY

AND RETURN.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Using the option SUBMIT

Former Member — Fri, 26 May 2006 11:47:02 GMT

Hi,

Try this

SUBMIT RFITEMGL via selection-screen option

Regards,

Amole

Re: Using the option SUBMIT

Former Member — Fri, 26 May 2006 11:50:08 GMT

do lkike this:

Fil the s_hkont and other ranges

s_hknot-low = 'hghj'.

s_hknot-high = 'hghj'.

s_hknot-sign = 'I'.

s_hknot-option = 'BT'.

appned s_hkont.

then submit ,

SUBMIT RFITEMGL

WITH SD_SAKNR in s_hkont

WITH SD_BUKRS in s_bukrs

..........EXPORTING LIST TO MEMORY

AND RETURN.

Regards,

Ravi

Re: Using the option SUBMIT

suresh_datti — Fri, 26 May 2006 11:50:28 GMT

It is quite possible the values you are passing through SUBMIT are getting wiped out during the INITIALIZATION event in RFITEMGL. You can check this out by putting a break-point right before the START-OF-SELECTION event in RFITEMGL. And then execute your SUBMIT.

Regards,

Suresh Datti

Re: Using the option SUBMIT

Former Member — Fri, 26 May 2006 11:51:22 GMT

Hi Avinash,

1. try with this simple hard coded values,

and see if report is generated or not.

report abc.

submit RFITEMGL

with SD_BUKRS-LOW = '1000'

with SD_SAKNR-LOW = '1'

with SD_SAKNR-high = '1000'

exporting list to memory and return.

regards,

amit m.

Re: Using the option SUBMIT

andreas_mann3 — Fri, 26 May 2006 12:10:46 GMT

Hi,

try that:

SUBMIT RFITEMGL
WITH SD_SAKNR in s_hkont
WITH SD_BUKRS in s_bukrs
with SO_BUDAT in s_budat
WITH X_AISEL = 'X'
EXPORTING LIST TO MEMORY
AND RETURN.
*with %%DYN009-LOW = s_blart-low
*wwith %%DYN014-LOW = i_bseg_data2-prctr

the last two are dynamic selections i think.

syntax is :

DATA:   GT_EXPRESSIONS         TYPE RSDS_TEXPR.
submit...
 WITH FREE SELECTIONS GT_EXPRESSIONS...

Andreas

Re: Using the option SUBMIT

Former Member — Fri, 26 May 2006 13:43:38 GMT

Hi Avinash,

You can do this way either. you can import the internal table from RFITEMGL if it is writing to memory ID this way.

SUBMIT RFITEMGL

WITH SD_SAKNR-LOW = s_hkont-low

with SD_SAKNR-high = s_hkont-high

WITH SD_BUKRS-LOW = s_bukrs-low

WITH SD_BUKRS-high = s_bukrs-high

with %%DYN009-LOW = s_blart-low

with %%DYN014-LOW = i_bseg_data2-prctr

with SO_BUDAT-LOW = s_budat-low

with SO_BUDAT-high = s_budat-high

WITH X_OPSEL = space

WITH X_CLSEL = space

WITH X_AISEL = 'X'

AND RETURN.

<b>IMPORT <internal_table> FROM MEMORY ID '<memory_id>'.</b>

where <internal_table> is internal table declared in your program.

Hope this will be of some help to you.

Regards,

Vicky

PS: Award points if helpful

Re: Using the option SUBMIT

Former Member — Fri, 26 May 2006 15:15:05 GMT

Hi Avinash,

I tried with following option and it worked.

select-options :sd_saknr for skb1-saknr,

sd_bukrs for skb1-bukrs,

so_budat for bsis-budat.

start-of-selection.

submit rfitemgl via selection-screen

with sd_saknr in sd_saknr

with sd_bukrs in sd_bukrs

with x_aisel = 'X'

with x_opsel = ' '

with so_budat in so_budat

exporting list to memory

and return.

Then you can use FM 'LIST_FROM_MEMORY' to retrieve the list from memory.

Just keep a breakpoint in the rfitemgl program to check if 'it_pos' internal table is populated since after the data is fetched using LDB, this table is populated and the same is displayed on screen.

Cheers,

Vikram

Please reward for helpful replies!!

Re: Using the option SUBMIT

Former Member — Mon, 29 May 2006 08:01:56 GMT

Hi Andreas,

You are right the last two option are infact dynamic selection.

As specified when I am not able to use the option GT_EXPRESSIONS, as i m not able to use in corrct fashion(this involves field EXPR_TAB which of typr another structure RSDSEXPR).Can you help me in this regard.

Thanks

Avi.

Re: Using the option SUBMIT

Former Member — Wed, 31 May 2006 04:35:39 GMT

HI Andreas,

The problem for poulating the dynamic value is solved but when I m trying to populate the document number in order to narrow down my selction criteria, the document number are not getting populated properly and instead a report is being displayed for all the records,is there anything mich i m missing on this.

Thanks,

AVi