Skip to Content
0
Former Member
Jan 19, 2012 at 06:05 PM

combining heterogeneous data sources in a single data target

25 Views

Dear Experts,

I have a requirement as below for combining multiple data sources (different key fields) into a single target

Target Key Fields : sales doc, item, schdl line, delivery no and delivery item.

1 source key fields : sales doc and item (VAITM)

2 source key fields :sales doc, item, schdl line, delivery no and delivery item (V_SSL)

3. source key fields : delivery number and delivery item. (VCITM)

Is there an innovative way of combining all these records in a single record in data target rather then creating multiple entries (due to different source keys) rather than using a conventional look up routines.

We are on BI 7.0.

Thanks,

Rita

Edited by: Rita Tripathi on Jan 19, 2012 7:05 PM