Skip to Content
Former Member
Dec 19, 2006 at 04:55 AM

Regarding combining data from 2 data sources


Hi All,

I want to represent data from two data sources. Orders (2lis_11_vaitm) and billing (2lis_13_vditm). We have in common Plant, Material customer etc. I want the query to be executed based on Billing date. However, when I am executing the report based on billing date, I am getting all orders as 0 and I am only getting Inv qty and value. The reason for this is there is no billing date in 2lis_11_vaitm. So, how to merge these two data sources??