SAP query - Drill down

hi,

what about your first thread?

let us assume like this

first report displays all the sales order header details

if you click the sales order the second one need to populate item details

1. create a first query & infoset with data retrieval by program

in the first quey we need to retrieve the sales order number which is selected by user, in the first query program you add the logic like below

at user-command.

l_case = sy-lisel+1(8).

l_vbeln = sy-lisel+23(1o).

• or you can use get cursor field also

if l_case = 'Sales order'.

set parameter id 'VBELN' field l_vbeln.

call transaction 'ZSecondreport' and skip first screen.

endif.

2. create a infoset by table join for a second query with parameter/select option (sales order number)

and create a tcode for the query ( say ZSecondreport ) this is called from first query.

I hope this will work.

note:

normally if its complex we can go for normal report instead of query

cheers,

sasi