topic Re: Going to a tcode at line selection in Application Development and Automation Discussions

Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 19:57:13 GMT

Hello Gurus.

I am writing a program which displays the list of sales org and the status of the material (obsoleted or active) by giving the material name in the selection screen.

Now the program displays a list of 3 columns - material, sales org, material status.

<b>Now if I select one of the row, then a particular tcode (CO09) screen should appear with the data taken from the line selection and some other default data required for the tcode.</b>

Can someone help me out to write the code for the bold part.

Thanks in advance.

Regards,

Balu

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:10:10 GMT

May be something like this:

report test.

data: ivbak type table of vbak with header line.
 
data : cursor_field(30),
       field_value(30) .
 
select-options: s_vbeln for ivbak-vbeln.
 
start-of-selection.
 
  select * into corresponding fields of table ivbak
      from vbak
          where vbeln in s_vbeln.
 
  loop at ivbak.
    format hotspot on.
    write:/ ivbak-vbeln.
    hide ivbak-vbeln.
    format hotspot off.
  endloop.
 
at line-selection.
 
  set parameter id 'AUN' field ivbak-vbeln.
  call transaction 'VA03' and skip first screen.

Sri

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:28:10 GMT

Thanks Sri...

Assigned points.

I have one more question. In the first I get an output of material, sales org and material status.

Is there a way that I proceed to line selection and go to tcode only if the material status is a specific value.

Regards,

Balu.

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:30:45 GMT

Hi,

Use Hide statement only in specific conditions..

LOOP AT it_mara.

IF it_mara-mtart = '1234'.

Hide only in specific conditions..

HIDE it_mara-matnr.

ENDIF.

ENDLOOP.

Thanks

Naren

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:32:47 GMT

Try this:

report test.

data: ivbak type table of vbak with header line.

data : cursor_field(30),

field_value(30) .

select-options: s_vbeln for ivbak-vbeln.

start-of-selection.

select * into corresponding fields of table ivbak

from vbak

where vbeln in s_vbeln.

loop at ivbak.

format hotspot on.

write:/ ivbak-vbeln.

hide ivbak-vbeln.

format hotspot off.

endloop.

at line-selection.

Cond to check if material status is a particular value

GET CURSOR FIELD field1. "Use GET CURSOR

CHECK field1(4) EQ 'JTAB'. "CHECK HERE

set parameter id 'AUN' field ivbak-vbeln.

call transaction 'VA03' and skip first screen.

Sri

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:34:39 GMT

You'll also need the plant for CO09.

Rob

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:40:20 GMT

Start with:

REPORT ztest LINE-SIZE 80 MESSAGE-ID 00.

TABLES marc.

START-OF-SELECTION.
  SELECT * FROM marc UP TO 10 ROWS.

    WRITE: /001 marc-matnr, marc-werks.
    HIDE :      marc-matnr, marc-werks.

  ENDSELECT.

AT LINE-SELECTION.
  SET PARAMETER ID 'MAR' FIELD marc-matnr.
  SET PARAMETER ID 'WRK' FIELD marc-werks.

  CALL TRANSACTION 'CO09' AND SKIP FIRST SCREEN.

Rob

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:40:57 GMT

Thanks Sri.

Regards,

Balu

Re: Going to a tcode at line selection

Former Member — Mon, 01 Oct 2007 20:42:52 GMT

Thanks Narendran and Rob.

Points assigned to you.

Regards,

Balu