cancel
Showing results for 
Search instead for 
Did you mean: 

Update two ODS using Start routine

Former Member
0 Kudos

Hi Experts,

I have two DSOs, One for 0MATERIAL_ATTR and another for 0MAT_SALES_ATTR. My requirement is to write a start routine while updating to YMAT_SALES_ATTR DSO which has a reference of Material from the YMAT_ATTR DSO. The material DSO is already loaded.

I have a written the Start routine for it. Now I have to Load the Materials to another Error DSO(YSALES_ERR) when the reference is not found. I have to rewirite the same start routine to update another DSO with the above condition.

I would appreciate some help.

Thanks,

Seema

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Seema,

Is there a reason you cannot connect the infosource to the two data targets? It is much easier that way (just connect the transformations to the infosource or create update rules against the infosource), also, you really do not want to write directly to the those master data objects within (or without) a Start Routine -- it is not recommended.

Brian

Former Member
0 Kudos

Hi Brian,

The Data is already in the first DSO layer where it just acts as a Passthrough. The scenario here is the Material master data and Materials with sales master data are loaded to the first layer . Then the Materials are loaded to the second layer. We must load the Material sales to the second layer only when it has reference to Material(2nd layer) . I have written the Start routine. But still the start routine misses to catch the bad ones.

Please help me with the code..

Thanks,

Seema