Solved: Submit Report select options not working

kabil_g · ‎05-01-2015

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.

Former Member · ‎05-01-2015

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

Former Member · ‎05-01-2015

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

kabil_g · ‎05-01-2015

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

Former Member · ‎05-01-2015

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.

kabil_g · ‎05-02-2015

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>[].

Former Member · ‎05-01-2015

How is S_WERKS declared in your program?

Rob

kabil_g · ‎05-02-2015

HI ROB,

SELECT-OPTIONS : s_werks FOR marc-werks

nishantbansal91 · ‎05-02-2015

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

kabil_g · ‎05-02-2015

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.

nishantbansal91 · ‎05-02-2015

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

kabil_g · ‎05-02-2015

Hi Nishant ,

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