Ineractive report

[Former Member]

hi,

how to create an interactive report which displays the month wise sales journal based on sales organization, material number and billing date..

thanx and regards

kalpana

[Former Member]

Hi,

An Interactive report is one which an user can interact with, ideally on clicking on a primary list the user would be navigated to a secondary list. Similarly you can navigate till 20 secondary lists.

Pls find below a simple example of interactive list from SAP Library :

<b>

REPORT demo_list_interactive_1.

START-OF-SELECTION.
  WRITE: 'Basic List, SY-LSIND =', sy-lsind.

AT LINE-SELECTION.
  WRITE: 'Secondary List, SY-LSIND =', sy-lsind.

</b>

Copy and paste this code on your abap editor, execute the same. You`ll understand the functionality.

Apart from this you can also creative interactive reports using ALV GRID / ALV LIST...for which you would have to use Events.

Hope this info. is helpful. If you`ve have access to SAP Library, refer to document no. 980.

Reward points if helpful.

Regards

[Former Member]

Hello,

Hope you have already started working on this.

1. Get all the values from VBAK, VBAP, VBRK, VBEP.

2. Prepare the data as per the required format(GET the required report layout from the Functional team/users).

3. Summarize the report at top-level and display. Say Show only the Sales Org, Material & month.

4. When user clicks on the SalesOrg, goto the drill down report and show the divisions under that Sales org.

5. When user clicks on division goto next level of report and show all the customer and relevant details.

Use HIDE to get the value of the field. Also use GET CURSOR for relevant details. You must be aware of using event AT LINE SELECTION.

Regards,

Vishal

*Reward if helpful*