Populate certain DSO columns by different transformations

[Former Member]

Hello experts! I'm really new to bw and ABAP. I've made just simple models that don't require really complex transformations. But I have a requirement from a customer that needs data of different documents on a single view with an status per document generated on a different DSO.

So my question is: Is it possible to create a DSO with "blank" columns and through transformations, call a DSO, populate, store the data, and then on another transformation, call another DSO that compares another part of the date and populate the other column?

Thank you!, best regards

This is a graphic representation:

[former_member186445]

you can do this in one transformation. you need to create a start routine in the transformation from your DataSource to DSO1. in the start routine,

first select the corresponding data from DSO2 and DSO3. next step is to loop over the source package, read the itabs with data from DSO2/DSO3 and insert in source package. you can find how to' for routines and many coding examples here on these forums.

M.