end routine lookup using table

[Former Member]

Hi Friends,

I have a requirement wherein we have a datasource and we need 3 fields to be enhanced into the datasource,but we were advised not to enhance datasource.The requirement is to do a lookup in DSO ,it will be like the extractor will remain intact,we will create DSO and include the three infoobjects which are mapped to the datasource fields.we will populate the infoobjects with the help of end routine which will lookup to the tables and get data to the infoobjects.

Do we need to apply start or end routine

Can you please advise that this can be achieved?if it is a yes then how to achieve it and what will be the code in the routine.Please reply if someone has

related link on this.

Regards,

Sivarama Landa

[former_member586947]

Hi,

   As you said that you have added 3 dummy fields in the extract structure of the data source, I suggest to go with start and field routine combination to lookup the data for these 3 fields.

Regards,

Satya.

[Former Member]

Hi Sivakris

are the three fields already avaialable in another DSO? if not, create a new datasource with key fields of first dso and three new fields and load to first dso directly, that will suffice.

[former_member285534]

Hi Sivakris,

Your requirement can be solved with field or start routines.  Please refer to this article by Surendra Kumar Reddy Koduru.

Best Regards,

Fernando