05-26-2006 12:43 PM
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.
05-26-2006 12:46 PM
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
05-26-2006 12:50 PM
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
05-26-2006 12:47 PM
Hi,
Try this
SUBMIT RFITEMGL via selection-screen option
Regards,
Amole
05-26-2006 12:50 PM
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
05-26-2006 12:51 PM
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.
05-26-2006 1:10 PM
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
05-29-2006 9:01 AM
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.
05-31-2006 5:35 AM
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
05-26-2006 2:43 PM
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
05-26-2006 4:15 PM
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!!