topic Re: drill down to FI source document FB03 in Application Development and Automation Discussions

drill down to FI source document FB03

Former Member — Thu, 11 Dec 2008 11:01:08 GMT

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

Re: drill down to FI source document FB03

Former Member — Thu, 11 Dec 2008 11:03:49 GMT

use submit statement and also

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

Re: drill down to FI source document FB03

matt — Fri, 12 Dec 2008 07:46:57 GMT

Please do not offer or ask for points

Re: drill down to FI source document FB03

RaymondGiuseppi — Fri, 12 Dec 2008 09:02:25 GMT

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