SUBMIT STATEMENT

[Former Member]

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

[Former Member]

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]

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

will u be able to help me further

[Former Member]

Use Import and Export from the memory ID's .

[faisal_altaf2]

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

[Former Member]

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

[Former Member]

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

[dev_parbutteea]

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.

[Former Member]

Thanks for ur reply

but what declaration should be done r_tart ?

[dev_parbutteea]

Hi,

ranges: r_mtart FOR T134-mtart .

Regards.

[Former Member]

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