Report Drill Down

[Former Member]

Hello All,

I have a report which displays G/L Account header info from BKPF. It displays the fields in order as BUKRS BELNR BUDAT WAERS XBLNR TCODE USNAM KURSF. The requirement is to drill down for each of these records. The drill down should take the user to FB03 tcode 'Display Document-Overview'. How can I do this? Pls help.

Thanks

M A

[Former Member]

Hello All,

I have a report which displays G/L Account header info from BKPF. It displays the fields in order as BUKRS BELNR BUDAT WAERS XBLNR TCODE USNAM KURSF. The requirement is to drill down for each of these records. The drill down should take the user to FB03 tcode 'Display Document-Overview'. How can I do this? Pls help.

Thanks

M A

[jayanthi_jayaraman]

Hi,

You need to use call transaction and at line selection.

[Former Member]

Hi

U should to display the fyscal year (GJAHR) too:

START-OF-SELECTION.

LOOP AT ITAB.
  WRITE: / ITAB-BUKRS,
  ...................

  HIDE: ITAB-BUKRS,
        ITAB-BELNR,
        ITAB-GJAHR.
ENDLOOP.

CLEAR ITAB.

AT LINE-SELECTION.

CHECK NOT ITAB IS INITIAL.

SET PARAMETER ID'BLN' FIELD ITAB-BELNR.
SET PARAMETER ID'BUK' FIELD ITAB-BUKRS.
SET PARAMETER ID'GJR' FIELD ITAB-GJAHR.

CALL TRANSACTION 'FB03' AND SKIP FIRST SCREEN.

Max

[Former Member]

Thanks a lot Max

[Former Member]

If it is a normal report, then you can do this:

at user-command.

if sy-ucomm = <focde for double click>.

set parameter 'BLN' field itab-belnr. "This field must have been hidden in the end-of-selection section when it is written.

call transaction 'FB03' and skip first screen.

endif.