topic Re: Reports Select Option in Application Development and Automation Discussions

Reports Select Option

Former Member — Tue, 22 Aug 2006 08:32:18 GMT

Hi all,

I have a task - i have to use "SELECT-OPTIONS of one program into select statements of another program, Please solve my problem.

Thanks in advance

Ranjith

Re: Reports Select Option

Former Member — Tue, 22 Aug 2006 08:33:32 GMT

Hi Ranjit,

Try using SUBMIT option with the addition SELTAB.

You can also pass the select options along with the SUBMIT statement. Take a look at the help.

Code used to populate 'select-options' & execute report  
DATA: seltab type table of rsparams,
      seltab_wa like line of seltab.

  seltab_wa-selname = 'PNPPERNR'.
  seltab_wa-sign    = 'I'.
  seltab_wa-option  = 'EQ'.

* load each personnel number accessed from the structure into
* parameters to be used in the report
  loop at pnppernr.
    seltab_wa-low = pnppernr-low.
    append seltab_wa to seltab.
  endloop.
  SUBMIT zreport with selection-table seltab
                                via selection-screen.

Cheers

Message was edited by: Vijayendra Rao

Re: Reports Select Option

Former Member — Tue, 22 Aug 2006 08:33:52 GMT

Hello Ranjith,

Use <b>SUBMIT</b> statement

If useful reward.

Vasanth

Re: Reports Select Option

Former Member — Tue, 22 Aug 2006 08:35:05 GMT

refer..

Re: Reports Select Option

Former Member — Tue, 22 Aug 2006 08:44:11 GMT

Hi Ranjit,

Use SUBMIT statement in this way ..

SUBMIT ztab with selection-table selecttab
         via selection-screen.

Regards,

Santosh

Re: Reports Select Option

Former Member — Tue, 22 Aug 2006 08:52:05 GMT

Hi Ranjith,

here an example with two little Reports:

REPORT ZGRO_TEST.

TABLES: MARA.

SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.

START-OF-SELECTION.

SUBMIT ZGRO_TESTT

WITH S_MATNR IN S_MATNR

AND RETURN.

END-OF-SELECTION.

REPORT ZGRO_TESTT.

TABLES: MARA.

SELECT-OPTIONS: S_MATNR FOR MARA-MATNR NO-DISPLAY.

START-OF-SELECTION.

BREAK-POINT.

SELECT * FROM MARA WHERE MATNR IN S_MATNR.

WRITE: / MARA-MATNR.

ENDSELECT.

END-OF-SELECTION.

zgro_test calls zgro_testt with the select-options.

Regards, Dieter

Re: Reports Select Option

Former Member — Wed, 23 Aug 2006 14:05:24 GMT

Hi Ranjith,

is your Problem still open?

Regards, Dieter

Re: Reports Select Option

Former Member — Wed, 23 Aug 2006 14:24:04 GMT

Hi Dieter

Thanks for good example.

Bye

Ragards

Ranjith