Yes, there are two possible ways of achieving such extraction:
Create DDIC view on the tables and then create GLUE extractor on the view.
Use ABAP extractor, which enables user to write custom ABAP code where you can read several tables and join their data. More Information can be found in the ABAP extractor user guide.