Using the option SUBMIT

[Former Member]

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.

[Former Member]

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!!

[Former Member]

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

[suresh_datti]

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

[Former Member]

Hi,

Try this

SUBMIT RFITEMGL via selection-screen option

Regards,

Amole

[Former Member]

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

[Former Member]

Hi Avinash,

1. try with this simple hard coded values,

and see if report is generated or not.

2.

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.

[andreas_mann3]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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!!