topic interactive report in Application Development and Automation Discussions

interactive report

Former Member — Wed, 12 Dec 2007 07:22:32 GMT

hi friends i have done with an interactive report an my probs is

in my basic list iam displaying salesorder no

sales organiztion

sales grp

customer number.

an my probs is that when iam double clicking on any of the 4 fields in basic list its displaying secondary list...

rather when i double click on only sales order number i should go into secondary list but not on the remaining 3 fields.

an more over when i click on one sales order number( ie for example i have sales order no 4969 in my basic list an when i click on this no it should only shw the details of this no in the secondary list but not all the other sales orderno information)..........

hw can i do this...... plz help me out..... points will be regard

Re: interactive report

Former Member — Wed, 12 Dec 2007 09:34:02 GMT

hi,

are u using classical or ALV?

If classical than try like this

AT LINE-SELECTION.

PERFORM cal_vf03.

FORM cal_vf03.

GET CURSOR LINE lin DISPLAY OFFSET off.

GET CURSOR FIELD fld. " DISPLAY OFFSET off LINE lin.

IF fld = 'ITAB-VBELN'.

SET PARAMETER ID 'VF' FIELD itab-vbeln.

CALL TRANSACTION 'VF03' AND SKIP FIRST SCREEN.

SET PARAMETER ID 'VF' FIELD space.

ELSEIF fld = 'ITAB-KUNAG'.

CALL TRANSACTION 'MIGO'.

ELSE.

CALL TRANSACTION 'MM03'.

ENDIF.

check the condition like i have checked in bold font..

Itab is my internal table name....

ENDFORM. "cal_vf03

and are u using HIDE?

u have to do like this

SELECT vbeln fkart fkdat netwr kunag FROM vbrk

INTO CORRESPONDING FIELDS OF TABLE itab

WHERE vbeln LIKE '00000033%'.

LOOP AT itab.

WRITE:/1 sy-vline,

itab-vbeln UNDER 'Billing Doc.' HOTSPOT ON,

18 sy-vline,

itab-fkart UNDER 'Billing Type',

33 sy-vline,

itab-fkdat UNDER 'billing Date',

48 sy-vline,

itab-netwr UNDER 'Net Value' LEFT-JUSTIFIED,

68 sy-vline,

itab-kunag UNDER 'Customer' HOTSPOT ON,

80 sy-vline.

HIDE : itab-vbeln.

HIDE : itab-kunag.

ENDLOOP.

ULINE AT /1(80).

Message was edited by:

Dhwani shah

Re: interactive report

Former Member — Wed, 12 Dec 2007 09:48:07 GMT

Hi satish,

try like this..



DATA :
       field_value TYPE char20,
       field_name TYPE char20.

AT LINE-SELECTION.

  GET CURSOR FIELD field_name VALUE field_value.
  IF field_name EQ 'ITAB-SALESORDER'.      "sales order field name
    PERFORM display_second_list USING field_value . "display second list
    CLEAR : field_name, field_value .
  ELSE.
    EXIT.
  ENDIF.