topic Re: SUBMIT STATEMENT in Application Development and Automation Discussions

SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 05:36:07 GMT

In program i am calling another report using submit following statement i am using

PARAMETERS : PLNT LIKE YWIP-WERKS OBLIGATORY. "PLANT

SELECT-OPTIONS : SLOC FOR S032-LGORT OBLIGATORY,

MATNR FOR S032-MATNR.

SUBMIT RMCB0300 WITH SL_WERKS-LOW = PLNT

WITH SL_LGORT = SLOC-LOW

WITH SL_MATNR = MATNR-LOW

WITH SL_MATNR = MATNR-HIGH

WITH SL_MTART = 'HALB' WITH SL_MTART = 'VERP'

WITH SL_MTART = 'ROH' WITH SL_MTART = 'FERT'

WITH SL_SPMON-LOW = FPERIOD

WITH SLV_NO = 'STK'

WITH SL_SPMON-HIGH = FPERIOD EXPORTING LIST TO MEMORY AND RETURN.

for storage location if i give more than 1 storage location for particular material

then it repeats the same values for all storage location

but material is available only for 1 storage location

how will i rectify this problem?

please help

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 05:41:15 GMT

HI,

You can use this way.. as you can n number of values in the selection screen fields of called program.

DATA SELECTION_TABLE TYPE STANDARD TABLE OF  RSPARAMS.
SUBMIT RMCB0300
          WITH SELECTION-TABLE selection_table 
EXPORTING LIST TO MEMORY AND RETURN.

Refer to the DEMO example provided by SAP..[Filling the Selection Screen of a Called Program |http://help.sap.com/saphelp_nw70/helpdata/EN/9f/dba51a35c111d1829f0000e829fbfe/frameset.htm]

Re: SUBMIT STATEMENT

faisalatsap — Fri, 10 Apr 2009 05:41:29 GMT

Hi,Shruti,

Problem is in the following Lines i think,

WITH SL_MATNR = MATNR-LOW
WITH SL_MATNR = MATNR-HIGH

Change the above lines to one following.

WITH SL_MATNR IN MATNR

Hope above will solve out your problem,

Please Reply if any issue,

Best Regards,

Faisal

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 05:52:51 GMT

Hi Shruti,

You can also pass like this,


SUBMIT z_class_emp
USING SELECTION-SET 'VARIANT1' 
AND RETURN.
And IMPORT from memory ID.

Thanks & regards,

Dileep .C

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 05:53:46 GMT

Hi Faisal thanks for ur reply i tried using ur mathod but still same record is being displayed for all 3storage location but material is only available for 1 storage location

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 06:07:16 GMT

Hi Avinash,

Thanks, for reply but using this method it takes lot of time to execute a single record and it is reading the record many times and is giving dump but when same parameters i pass in mc.9 it gives only 1 record

this problem arises only when i specify material no. otherwise it gives correct o/p when i specify all 3 storage location and no material number

please help,

thanks

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 06:22:59 GMT

Hi,

You need to check the material for particular Storage location even after giving Multiple strorage location.

Then it is difficult to do that ..as your passing material and storage location in different parameters.

Instead you call the SUBMIT statement twice once for material number with particular storage location and second without material number.

Re: SUBMIT STATEMENT

dev_parbutteea — Fri, 10 Apr 2009 06:24:03 GMT

Hi,

PARAMETERS : PLNT LIKE YWIP-WERKS OBLIGATORY. "PLANT

SELECT-OPTIONS : SLOC FOR S032-LGORT OBLIGATORY,

MATNR FOR S032-MATNR.

r_mtart-low = 'HALB'

r_mtart-option = 'EQ'

r_mtart-sign = 'I'

append r_mtart " do same for other mtart values and spmon

SUBMIT RMCB0300 WITH SL_WERKS-LOW = PLNT

WITH SL_LGORT in sloc

WITH SL_MATNR in matnr

WITH SL_MTART in r_mtart

WITH SL_SPMON in r_spmon

WITH SLV_NO = 'STK'

EXPORTING LIST TO MEMORY AND RETURN.

Regards.

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 06:39:57 GMT

Thanks for ur reply

but what declaration should be done r_tart ?

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 06:46:44 GMT

Hi,

But the problem is that user will be completely aware of exact storage location he will enter all storage location

applicable for that material and then he will check with mc.9 and my zprogram material no. and storage location both have to passed compulsory

Are u aware whether any table stores current data of mc.9 otherwise i can fetch data from their

Thanks for reply

But still my issue has not been resolved

Re: SUBMIT STATEMENT

dev_parbutteea — Fri, 10 Apr 2009 07:19:23 GMT

Hi,

ranges: r_mtart FOR T134-mtart .

Regards.

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 07:27:17 GMT

Thanks for ur prompt reply

i have tried the solution that u have provided

But still it is giving 3 records for all storage but record is available only for 1 storage location

Further help will be appreciated

Thanks

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 07:28:24 GMT

will u be able to help me further

Re: SUBMIT STATEMENT

Former Member — Fri, 10 Apr 2009 07:44:48 GMT

Use Import and Export from the memory ID's .