Skip to Content
Former Member
Jan 07, 2009 at 04:11 PM

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?


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.