Load master data from differents datasource BW/4

[former_member726451]

Hi,

I have a BW/4 infoobject time dependant with 2 differents datasources from R/3 in order to load attributes.

The first datasource load all attributes except one (in example field X, not mapped in this transformation), the second datasource load only the field X and the rest of the fields are not mapped in the transformation.

I execute the first load and all fields except field X are successfully populated, but after when I execute the DTP full for second datasource all fields populated by the first datasource are empty.

How can I control this situation?

thanks in advance

[former_member726451]

Hi Debjit Singha,

Thank you for your help in this matter.

I know the load mater data process with time dependant infoobjects.

About your solutions, I prefer don´t create a intermediate DSO and add ZNIF as field of first datasource (0EMPLOYEE_ATTR) and avoid the second load, but your proposition is ok. In any case, I want to understand this problem in BW/4 because en my old system BW 7.3 this logic with the same datasources working. In BW 7.3 I can activate master data between loads (using process chains) but in BW/4 I can´t activate manually infobect (the infoobject activation in auto)

thanks you very much again.

regards

[MKreitlein]

Hello David,

in theory, several error cases are possible:

1) do you use a start- or endroutine and you have selected all fields but eventually don't use them? I did not find an appropriate link, but with incorrect selection, you will clear fields, unwantedly.

2) is it possible the date-from/date-to values don't match, and the one attribute is available in a different time span than the others?

3) Have you tried activating the first request, before loading the second source? I'm not sure but might be there is only one M version of a record available and the 2nd with only one attribute overwrites the first M version with all other attributes filled.

To really find the solution you need to check this or provide more details and screenshots.

Thanks, Martin

[former_member726451]

Hi Martin,

About your comments:

1) I haven't start/end routines in the transformation, but yesterday I did a test adding end routines empty in each transformation but with the fields marked respectively, not worked...

2) I think that interval dates are correct. In my old BW 7.3 these logic working whitout problems (activating master data between loads)

3) In my BW 7.3 yes, but in my current BW/4 I can´t activate 0EMPLOYEE master data before second load, in BW/4 the infoobject are activating automatically.

In BW/4, are there any option but I don´t know?

Thanks for your help!

regards