How can I replicate a transaction using SQL?

[rdlr]

Where I work, people uses certain transactions daily. Mi idea is to connect to the server where all the SAP tables are storaged and query them into a PowerBi report where they can have an easy access to them, filter them etc. I know that I can see the tables they use and on which columns they join in SQVI if I was the one who designed that transaction, my question is how I can check that for some default transactions?

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!