topic Re: Submit Report select options not working in Application Development and Automation Discussions

Submit Report select options not working

kabil_g — Fri, 01 May 2015 12:30:16 GMT

Dear Frds,

Searched lot of threads not getting idea .

I am calling the report J_1HSTCD in my custom program

For Plants is reading the first given input rest not reading.

While importing the data it's retreiving only one plant contents

Below are my conditions... Pls help me

lt_selscreen-selname = 'BM_MATNR'.

lt_selscreen-kind = 'S'.

LOOP AT s_matnr.

lt_selscreen-sign = s_matnr-sign.

lt_selscreen-option = s_matnr-option.

lt_selscreen-low = s_matnr-low.

lt_selscreen-high = s_matnr-high.

APPEND lt_selscreen.

ENDLOOP.

CLEAR lt_selscreen.

lt_selscreen-selname = 'BM_WERKS'.

lt_selscreen-kind = 'S'.

LOOP AT s_werks.

lt_selscreen-sign = s_werks-sign.

lt_selscreen-option = 'BT'.

lt_selscreen-low = s_werks-low.

lt_selscreen-high = s_werks-high.

APPEND lt_selscreen.

ENDLOOP.

CLEAR lt_selscreen.

lt_selscreen-selname = 'BM_BUKRS'.

lt_selscreen-kind = 'S'.

LOOP AT s_bukrs.

lt_selscreen-sign = 'I'.

lt_selscreen-option = 'EQ'.

lt_selscreen-low = s_bukrs-low.

lt_selscreen-high = s_bukrs-high.

APPEND lt_selscreen.

ENDLOOP.

CLEAR lt_selscreen.

lt_selscreen-selname = 'MTART'.

lt_selscreen-kind = 'S'.

LOOP AT s_bukrs.

lt_selscreen-sign = 'I'.

lt_selscreen-option = 'EQ'.

lt_selscreen-low = s_mtart-low.

lt_selscreen-high = s_mtart-high.

APPEND lt_selscreen.

ENDLOOP.

CLEAR lt_selscreen.

lt_selscreen-selname = 'DATUM'.

lt_selscreen-kind = 'S'.

lt_selscreen-sign = 'I'.

lt_selscreen-option = 'BT'.

lt_selscreen-low = s_datum-low.

lt_selscreen-high = s_datum-high.

APPEND lt_selscreen.

CLEAR lt_selscreen.

lt_selscreen-selname = 'BWBST'.

lt_selscreen-kind = 'P'.

lt_selscreen-option = 'EQ'.

lt_selscreen-low = ''.

APPEND lt_selscreen.

CLEAR lt_selscreen.

lt_selscreen-selname = 'S_RPT2'.

lt_selscreen-kind = 'P'.

lt_selscreen-option = 'EQ'.

lt_selscreen-low = 'X'.

APPEND lt_selscreen.

CLEAR lt_selscreen.

cl_salv_bs_runtime_info=>set(

EXPORTING display = abap_false

metadata = abap_false

data = abap_true ).

* * Submit Wage Type Reporter

SUBMIT j_1hstcd

WITH SELECTION-TABLE lt_selscreen

AND RETURN.

Re: Submit Report select options not working

Former Member — Fri, 01 May 2015 15:07:59 GMT

hi kabil,

Try to replace this code

lt_selscreen-selname = 'BM_WERKS'.

lt_selscreen-kind = 'S'.

LOOP AT s_werks.

lt_selscreen-sign = s_werks-sign.

lt_selscreen-option = 'BT'.

lt_selscreen-low = s_werks-low.

lt_selscreen-high = s_werks-high.

APPEND lt_selscreen.

ENDLOOP.

with

lt_selscreen-selname = 'BM_WERKS'.

lt_selscreen-kind = 'S'.

LOOP AT s_werks.

lt_selscreen-sign = s_werks-sign.

lt_selscreen-option = s_werks-option

lt_selscreen-low = s_werks-low.

lt_selscreen-high = s_werks-high.

APPEND lt_selscreen.

ENDLOOP.

and try please

Re: Submit Report select options not working

kabil_g — Fri, 01 May 2015 15:20:37 GMT

Hi Abdul,

Thnxs for reply . I have tried tat also.

When Debugging standard report data is flowing in that report for both the plants while importing not reflecting in my Zreport

Re: Submit Report select options not working

Former Member — Fri, 01 May 2015 15:41:56 GMT

How is S_WERKS declared in your program?

Rob

Re: Submit Report select options not working

Former Member — Fri, 01 May 2015 15:48:52 GMT

hi kabil,

After submit statement.

you should call this interface:

cl_salv_bs_runtime_info=>get_data_ref(
IMPORTING r_data = r_data ).

Now r_data has data from report.

ASSIGN r_data->* TO <itab_data>.

Now itab_data has data which can be sent to alv report.

Re: Submit Report select options not working

kabil_g — Sat, 02 May 2015 04:35:14 GMT

HI ROB,

SELECT-OPTIONS : s_werks FOR marc-werks

Re: Submit Report select options not working

kabil_g — Sat, 02 May 2015 04:39:14 GMT

HI Abdul,

I have the logic already .

TRY.

cl_salv_bs_runtime_info=>get_data_ref(

IMPORTING r_data = lr_pay_data ).

ASSIGN lr_pay_data->* TO <gt_final>.

CATCH cx_salv_bs_sc_runtime_info.

MESSAGE `Unable to retrieve ALV data` TYPE 'E'.

ENDTRY.

cl_salv_bs_runtime_info=>clear_all( ).

lt_data[] = <gt_final>[].

Re: Submit Report select options not working

nishantbansal91 — Sat, 02 May 2015 05:25:00 GMT

Dear Kabil,,

Instead of passing internal table pass the values directly to Screen fields/.

Below is the sample code. Its easy process and you will easily identify your field name.

cl_salv_bs_runtime_info=>set(

EXPORTING display = abap_false

metadata = abap_true

data = abap_true ).

SUBMIT rwddownload WITH filia = werks

WITH artnr IN lt_update_matnr_vk11

WITH datum = sy-datum

WITH plu = 'X'

WITH alle = 'X'

EXPORTING LIST TO MEMORY AND RETURN.

cl_salv_bs_runtime_info=>get_data_ref(

IMPORTING r_data = lf_ref ).

ASSIGN lf_ref->* TO <lt_data>.

cl_salv_bs_runtime_info=>clear_all( )..

One thing must ensure that your name is field name should be match with program input field name.

Thanks

Nishant

Re: Submit Report select options not working

kabil_g — Sat, 02 May 2015 06:00:44 GMT

Hi Nishant

Afert changes same result getting .

SUBMIT j_1hstcd WITH mtart IN s_mtart

WITH datum IN s_datum

WITH bm_matnr IN s_matnr

WITH bm_werks IN s_werks

WITH bm_bukrs IN s_bukrs

WITH bwbst = ''

WITH s_rpt2 = 'X'

VIA SELECTION-SCREEN EXPORTING LIST TO MEMORY AND RETURN.

Re: Submit Report select options not working

nishantbansal91 — Sat, 02 May 2015 07:29:09 GMT

Dear Kabil,

I have checked the code in my system its working fine, it might be some other mistake in your code.

Pleas check my below code the same value i got in the BM_WERKS table in J_1hstcd after initialization event.

ls_Werks-low = 10.

ls_Werks-high = 101.

ls_Werks-option = 'BT'.

ls_Werks-sign = 'I'.

append ls_werks to lt_Werks.

clear ls_Werks.

ls_Werks-low = 1.

ls_Werks-option = 'BT'.

ls_Werks-sign = 'I'.

append ls_werks to lt_Werks.

SUBMIT j_1hstcd

WITH bm_werks IN lt_werks

WITH s_rpt2 = 'X'

VIA SELECTION-SCREEN EXPORTING LIST TO MEMORY AND RETURN.

BREAK-POINT.

Thanks

Nishant

Re: Submit Report select options not working

kabil_g — Sat, 02 May 2015 07:53:05 GMT

Hi Nishant ,

My problem is while importing not retreiving data Export data is populating