Drilldown of Special Ledger Balances

[Former Member]

Hello,

I made a report to show the Special Ledger balances (table TRACTSLT).

Now I need a drilldown to line items (like in GD13), is there any functionality I can reuse and call with some parameters?

Thanks in advance,

Marcel

[Former Member]

What type of output you are giving, classical or ALV?

Instead of writing code you can just open tcode GD13 for a particular clicked Ledger.

Use SET PARAMETER and CALL TRANSACTION...AND SKIP FIRST SCREEN Statements.

Regards

Karthik D

[Former Member]

Output is given in an ALV Grid.

And thanks for the suggestion, i will give it a try.

Best Regards,

Marcel

[Former Member]

Try as follows;

Give wa_fieldcat-hotspot = 'X'. for that ledger field and give USER_COMMAND routine name in the ALV FM Call.

Now in the USER_COMMAND routine get the ledger number, set the parameter and call transaction GD13.

Hope this will be helpful.

Regards

Karthik D

[Former Member]

But now I don't need only to skip the first screen, I also have the information to skip the following screens and wanted to do so:

Skip following screens:

• Display Total Records: Selection Ledger xx

• Display of All Data Records and Key Fields

• Breakdown for Ledger xx Based on Selection

So my target is to show the screen "Display line items for period xxx".

I hope you understand what i mean

Edited by: Marcel Winder on Jun 29, 2009 1:39 PM

[Former Member]

Hi,

Just Record a BDC and include that in a routine in your program, and call the routine by supplying required fields from the user_command routine. Hope this will help you solve your problem.

Regards

Karthik D

[Former Member]

Thanks for your support, but as far as I see I can only automatically fill and skip screens with input fields via BDC.

So it's not possible to automatically select a row and "double click" it in a grid, like in screen "Display of All Data Records and Key Fields" right?

Because it's hard to just copy the part of the code which shows "Display line items for period xxx" and adjust it.

[Former Member]

deleted post

Edited by: Marcel Winder on Jul 1, 2009 1:21 PM

[Former Member]

Line item transaction for special legder: GD20