Yes it is possible. When you define the grid, define an event handler. See the documentation to the ABAP "SET HANDLER" for detailed examples on how to trap events, like double click, which you can use to implement drill down.
Dig Deeper on SAP ABAP
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
A SearchSAP.com reader wants to know if it's possible to write an SAP ABAP program that will read source code and then create an SAP ABAP function ... Continue Reading