Create a view from 10 tables

Hi Experts,

I want to create a view from 10 pricing tables rather than write 10 different select query in my application. Most of the columns of the pricing tables are same. I want all the data from these tables into the respective columns. Further I want an indicator as to which table does this record belong to. How can I achieve this?

Ex:

Table 1 columns: kappl kschl vkorg vtweg vkgrp

Table 2 columns: kappl kschl vkorg vtweg matkl matnr

if each table has two records, I want 4 records in my view in the respective columns along with the indicator that this record belongs to a specific column.

Regards