topic Re: call transaction from query in Application Development and Automation Discussions

call transaction from query

Former Member — Tue, 23 Feb 2010 06:12:01 GMT

Hello

I have query which calling transaction MD04 which needs 2 parameters : Material & Plant.

I call the Transaction (from the query) by calling the hereunder ABAP Report Program.

Its doesn'twork...

Can u advise ?

Thanks.

Amnon.

REPORT ZMD04.

data : p_matnr type matnr,

p_werks type werks_d.

IMPORT MDKP-MATNR TO p_matnr FROM MEMORY ID 'P_MAT'.

SET PARAMETER ID 'MAT' FIELD P_MATNR.

SET PARAMETER ID 'WRK' FIELD P_WERKS.

call TRANSACTION 'MD04' AND SKIP FIRST SCREEN.

Re: call transaction from query

Abhijit74 — Tue, 23 Feb 2010 06:45:14 GMT

Hi,

What's your SAP version. I have tried with ECC6.0 it's working, i.e. it's calling the transaction. You can try with another way by submitting the program like SUBMIT SAPMM61R AND RETURN.

Thanks,

Abhijit

Re: call transaction from query

Former Member — Tue, 23 Feb 2010 09:04:22 GMT

Hello,

Thanks for your reply.

The transaction MD04 opened, but without the material and plant value from the line in the Abap-Query. Tthe parameters value in report are empty.

When the transaction MD04 opened, i get the error massage "fill in all required fields.

I use Ecc 6.

Amnon

Re: call transaction from query

Former Member — Tue, 23 Feb 2010 09:23:18 GMT

HI ,

Your code is proper & working.

Take any matnr & werks like below.

data : p_matnr type matnr VALUE '000000001000004065',

p_werks type werks_d VALUE '2001'.

IMPORT MDKP-MATNR TO p_matnr FROM MEMORY ID 'P_MAT'.

SET PARAMETER ID 'MAT' FIELD P_MATNR.

SET PARAMETER ID 'WRK' FIELD P_WERKS.

call TRANSACTION 'MD04' AND SKIP FIRST SCREEN.

Regard's

Shabbir

Re: call transaction from query

Former Member — Tue, 23 Feb 2010 09:42:33 GMT

Hi Amnon,

I tried this and working fine.

data : p_matnr type matnr VALUE '111',

p_werks type werks_d VALUE '123'.

SET PARAMETER ID 'MAT' FIELD P_MATNR.

SET PARAMETER ID 'WRK' FIELD P_WERKS.

call TRANSACTION 'MD04' AND SKIP FIRST SCREEN.

Please check your code. import may not working in your case. try in debug and check the value.

Regards,

Venkat

Re: call transaction from query

venkat_o — Tue, 23 Feb 2010 09:57:07 GMT

Hi, <li> Problem may be with IMPORT MDKP-MATNR TO p_matnr FROM MEMORY ID 'P_MAT' statement. Check corresponding EXPORT statement where you are passing p_matnr value. <li>It does not skip first screen, if you pass empty material number. Thanks Venkat.O

Re: call transaction from query

Former Member — Tue, 23 Feb 2010 12:25:25 GMT

Hello Experts

I found the problem. I need to define the data with "PARAMETERS" command and not with "DATA".

Here is the final report :

REPORT ZMD04.

parameters : p_matnr type matnr,

parameters : p_werks type werks_d.

SET PARAMETER ID 'MAT' FIELD P_MATNR.

SET PARAMETER ID 'WRK' FIELD P_WERKS.

call TRANSACTION 'MD04' AND SKIP FIRST SCREEN.