Skip to Content
0
Former Member
Jan 10, 2011 at 02:11 PM

Short and long text from 2 datasources

51 Views

Hello!

I have following issue:

Loading 0material_text (matnr,spras, txtsh, txtlg) from 2 datasources

1. 0material_text (short texts)

2. READ_TEXT_mat (I created FM datasource with read_text function) - (long texts)

Mostly data from those 2 DS is for same material records, but also some data is only in 0material_text and some data is only in READ_TEXT_mat.

Both DS work correctly, but when i load data for example from 0material_text DS it fills IO for relevant data with short_text and deletes long_texts. And READ_TEXT_mat does the same, only it fills long_texts and deletes long_texts for relevant data.

Solution would be to create insert/update for lets say READ_TEXT_mat datasource... so it would first inserts data for those records that does not exist in IO and then update only txtlg for those that do exist.

I hope i have been clear. Any idea, solution....?

Tnx Gorazd