how to join DD07T table in sap hana view to get table categoty information

Hi i want to display table category infirmation in the report.

Like table name and its category.

i could find DD07T table which is text table and gives table categoty descriptions like below.

i want table which holds corrosponding table name and its category information, so that i can join DD07t table get the table name and its category in SAP HANA view .

please let us know.

thanks in Advance