Read data from Bex query in to internal table of ABAP program

Hi Experts,

I am core abaper and had a requirement where I need to get the Bex query data into abap program and display as ALV Grid. I tried some Function modules to read bex query into internal table of my abap program. but didn't work.

Can somebody please let me know the procedure or code to solve the issue.

my inputs are I have query, info provider name.

Best regards,

Saida reddy.