drill down to FI source document FB03

[Former Member]

Moderator message: please do not offer or ask for points

Report will be exported to excel in easy to read and copy format like and also should have all the capabilities like KSB1 including dynamic selection.

User should be able to drill down to FI source document (FB03).

and should have display variant on selection screen

<<Text removed>>

Edited by: Matt on Dec 12, 2008 8:45 AM

[Former Member]

use submit statement and also

use get/ set parameter id to get into the standard transaction

[matt]

Please do not offer or ask for points

[RaymondGiuseppi]

You may develop a report with :

Create a single [ALV report|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_codesamples&query=alvreportsample&adv=false&sortby=cm_rnd_rankvalue]. there are already many samples at sdn

For dynamic selection, use one of the FI logical database or make some search at sdn of FM like [FREE_SELECTIONS_DIALOG|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=free_selections_dialog&adv=false&sortby=cm_rnd_rankvalue]

- BMM Documents for Number

- BRF Document Database

- BRM Accounting Documents

- DDF CUSTOMER DATABASE

- KDF Vendor Database

- SDF G/L Account Database

To pass a display variant look at the parameters of FM REUSE_ALV_GRID_DISPLAY or cl_gui_alv_grid->set_table_for_first_display, search sdn for FM like [REUSE_ALV_VARIANT_F4|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=reuse_alv_variant_f4&adv=false&sortby=cm_rnd_rankvalue]

To execute drilldown like FB03 search sdn for FM like [AC_DOCUMENT_SENDER|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=ac_document_sender&adv=false&sortby=cm_rnd_rankvalue]

Or you may use tools like report painter

Look for SAP help at [User-Defined Reports|http://help.sap.com/erp2005_ehp_04/helpdata/EN/eb/1377e443c411d1896f0000e8322d00/frameset.htm]

Regards