‎2010 Nov 25 10:28 PM
Hello everyone,
I have developed a report and for the double click event I want it to display the table entries of a table due some conditions.
To do so I noticed that these kind of programs start with /1BCDWB/DB and then the table name, for example the program to list entries for BKPF is this:
/1BCDWB/DBBKPF
My program as a code similar to this:
SUBMIT /1BCDWB/DBBKPF
WITH I1-low EQ u20181000u2019
AND RETURN.
The problem is that nothing is shown, does anyone know why?
Thanks,
John
‎2010 Nov 26 11:11 AM
Hi,
I tried just now and it is working fine.
/1BCDWB/DBBKPF program is for showing table entries for BKPF.
This standard program will not work by simply submit.
we have to set some values (memory id) for it to work using submit.
Just copy paste and it works fine. Also we have to use range to pass to I1 as below.
REPORT abc.
DATA : rbukrs TYPE RANGE OF bukrs WITH HEADER LINE.
DATA: mem_id(32) VALUE 'TABELLENANZEIGER'.
DATA: action(4) TYPE c.
*---- Set range for the screen field
rbukrs-sign = 'I'.
rbukrs-option = 'EQ'.
rbukrs-low = '1000'.
APPEND rbukrs.
*------- Export
action = 'ANZE'.
EXPORT action TO MEMORY ID mem_id.
*----- Submit
SUBMIT /1bcdwb/dbbkpf
WITH i1 IN rbukrs
VIA SELECTION-SCREEN.regards,
amit m.
‎2010 Nov 25 11:51 PM
Howdy,
Submit is generally for background processing only. You may be able to do what you want by creating a t-code and using CALL TRANSACTION instead.
When you create the transaction which will be a report type, you can tick the "Skip Initial Screen" box and specify your parameter I1-low = '1000' in the transaction parameters.
Cheers
Alex
‎2010 Nov 26 4:39 AM
Hi,
Pass the values to select options as :
DATA: rspar_tab TYPE TABLE OF rsparams,
rspar_line LIKE LINE OF rspar_tab.
rspar_line-selname = 'I1'.
rspar_line-kind = 'S'.
rspar_line-sign = 'I'.
rspar_line-option = 'BT'.
rspar_line-low = '1000'.
rspar_line-high = '9999'.
APPEND rspar_line TO rspar_tab.
SUBMIT /1BCDWB/DBBKPF
WITH SELECTION-TABLE rspar_tab
AND RETURN.Regards,
Srini.
‎2010 Nov 26 4:50 AM
First question is it a ALV report?
On Double Clicking what, you want to show BKFP table tcode?
‎2010 Nov 26 11:11 AM
Hi,
I tried just now and it is working fine.
/1BCDWB/DBBKPF program is for showing table entries for BKPF.
This standard program will not work by simply submit.
we have to set some values (memory id) for it to work using submit.
Just copy paste and it works fine. Also we have to use range to pass to I1 as below.
REPORT abc.
DATA : rbukrs TYPE RANGE OF bukrs WITH HEADER LINE.
DATA: mem_id(32) VALUE 'TABELLENANZEIGER'.
DATA: action(4) TYPE c.
*---- Set range for the screen field
rbukrs-sign = 'I'.
rbukrs-option = 'EQ'.
rbukrs-low = '1000'.
APPEND rbukrs.
*------- Export
action = 'ANZE'.
EXPORT action TO MEMORY ID mem_id.
*----- Submit
SUBMIT /1bcdwb/dbbkpf
WITH i1 IN rbukrs
VIA SELECTION-SCREEN.regards,
amit m.
‎2010 Nov 26 12:16 PM
Be aware that the /1BCDWB/DB... programs can be re-generated at any time with different selection criteria via SE16, so the assumption that I1 stands for BUKRS might no be true in the future.
I would rather not build fixed program logic around this.
Thomas