Looking up Master data from from a DSO 0sd_o01

[Former Member]

Hello experts!

I have a situation where I need to bring new master data into BW. The only way I have to bring these new fields is by customizing/enhancing extractor 2LIS_11_VAHDR. But the rest of my data flow is reading data using 2LIS_11_VAITM. in other words, I need to to get new data into 0SD_O02, I need to look it up from 0SD_O01 filled using the enhanced extractor (2LIS_11_VAHDR).

Questions:

1) since I already have data in target (0SD_O01/0SD_O02), do I delete everything and full load or use Full Repair request 0SD_O01 / 0SD_O02

2) to bring the missing data 0SD_O02 which feed the rest of data from I need to look up data from 0SD_O01. Does this lookup be done in transformation using read from DSO or it must be done in Start/End routine?

Thanks for your help.

[former_member186445 · Accepted solution]

you could also create a second dso OSD_001B where you map only the new fields coming from vahdr. this way you don't need to mess with the existing flow...

1. you can do a full repair.

2. depending of your version, but you can do a read dso in the field routine, it's easier... but from experience a select for all entries in the start routine with a read in the field routine is faster (depending on the size of the dso etc)....

M.

[Former Member]

Thanks Mario for your quick answer!