Skip to Content
avatar image
Former Member

Looking up Master data from from a DSO 0sd_o01

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 29 at 02:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 30 at 09:57 PM

    Thanks Mario for your quick answer!

    Add comment
    10|10000 characters needed characters exceeded