topic Re: Regarding SUBMIT Statement in Application Development and Automation Discussions

Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 09:43:08 GMT

Hi All,

I have a issue with SUBMIT statement.

My issue is as below:

I have a report say REPORT1 .

In this right now i am capturing material information and storing in one new internal table I_MAT. which is having MATNR field in it.

Now from here i need to submit a new program say REPORT2 which is having few selection-screen elements i need to fill them from here with SUBMIT statement.

Selection screen elements need to be filled:

S_MATNR, P_WERKS, P_MAT, P_S, S_EMAIL.

Now for this purpose i have declared another internal table as below:

DATA: RSPAR LIKE RSPARAMS OCCURS 0 WITH HEADER LINE.

Now i need to fill this internal table for above screen elements.

I have appended P_WERKS, P_MAT, P_S elements as below:

RSPAR-SELNAME = 'P_WERKS'.

RSPAR-KIND = 'P'.

RSPAR-LOW = p_werks.

APPEND RSPAR.

RSPAR-SELNAME = 'P_MAT'.

RSPAR-KIND = 'P'.

RSPAR-LOW = C_X.

APPEND RSPAR.

RSPAR-SELNAME = 'P_S'.

RSPAR-KIND = 'P'.

RSPAR-LOW = ''.

APPEND RSPAR.

Now i need to update S_MATNR, S_EMAIL.

S_MATNR i need to fill with I_MAT internal table with values of I_MAT-MATNR. which can be multiple.

Here how i need to append the same.

S_EMAIL i need to fill in with values in S_EMAIL which can be multiple.

Here how i need to append the same.

Then i can write submit statement as below:

SUBMIT REPORT2 VIA SELECTION-SCREEN

WITH SELECTION-TABLE RSPAR

AND RETURN.

Can anybody tell me how can i fill above two [S_MATNR, S_EMAIL] elements to pass all the data to SUBMIT statement.

Thanks in advance.

Thanks,

Deep.

Re: Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 09:47:23 GMT

HI Deep

To keep it simple, for select-options populate a range and use as below:

SUBMIT ZREPORT2 VIA SELECTION_SCREEN
   WITH P_WERKS = p_werks
   WITH S_MATNR in R_MATNR
   AND RETURN.

Kind Regards

Eswar

Re: Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 09:51:27 GMT

Hi Deep

Please check out how I filled my select option 'DOCNUM'.

The table i_edidc had the values which needed to be populated

LOOP AT i_edidc INTO wa_edidc.

wa_rsparams-selname = 'DOCNUM'.

wa_rsparams-kind = 'S'.

wa_rsparams-sign = 'I'.

wa_rsparams-option = 'EQ'.

wa_rsparams-low = wa_edidc-docnum.

APPEND wa_rsparams TO i_rsparams.

CLEAR wa_rsparams.

You can do the same... and then call the submit statement

ENDLOOP.

SUBMIT program name EXPORTING LIST TO MEMORY

WITH SELECTION-TABLE i_rsparams.

Re: Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 09:56:17 GMT

instead of ur logic, declare separate internal tables for all selection-screen fields and populate them with data...It can have multiple entries. then use

SUBMIT ZREPORT2 VIA SELECTION_SCREEN

WITH P_WERKS = p_werks

WITH S_MATNR in i_MATNR

AND RETURN.

Re: Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 09:59:38 GMT

Hi,

How S_EMAIL screen element need to be filled up.

Which is available in REPORT1 with multiple emails i need to pass the same into REPORT2 through submit statement.

Thanks,

Deep.

Re: Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 10:05:02 GMT

lets say s_email is available in internal table i_email

then

loop at i_email into wa_email.

wa_rsparams-selname = 'S_EMAIL'.

wa_rsparams-kind = 'S'.

wa_rsparams-sign = 'I'.

wa_rsparams-option = 'EQ'.

wa_rsparams-low = wa_email-emailname.

APPEND wa_rsparams TO i_rsparams.

CLEAR wa_rsparams.

endloop.

suppose it is also in a select-option with the same name 'S_EMAIL'then

wa_rsparams-selname = 'S_EMAIL'.

wa_rsparams-kind = 'S'.

wa_rsparams-sign = 'I'.

wa_rsparams-option = 'BT'.

wa_rsparams-low = s_email-low.

wa_rsparam-high = s_email-high

APPEND wa_rsparams TO i_rsparams.

CLEAR wa_rsparams.

Hope this helps you ...

Re: Regarding SUBMIT Statement

Former Member — Thu, 30 Nov 2006 10:07:47 GMT

As per the approach i have given earlier,

use WITH and '=' operation for PARAMETERS and 'IN' for Select-Options.

Kind Regards

Eswar