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

[FCI]

Hi David,

This is not normal. If every attributes is time-dependant, some attributes may become blank on specific period depending on the periods you're loading in both data flows (that are not necessarily the same). But the attributes loaded in the first dataflow should stay filled on the validity period loaded in the first dataflow (though periods may be split after the 2nd dataflow depending on the periods loaded).

1st dataSource : 01/01/2020 - 15/01/2020    X       NA
InfoObject :     
                 01/01/2020 - 15/01/2020    X       BLANK
2nd dataSource : 07/01/2020 - 20/01/2020    NA      A     
InfoObject :                               
                 01/01/2020 - 06/01/2020    X        BLANK
                 07/01/2020 - 15/01/2020    X        A     
                 16/01/2020 - 20/01/2020    BLANK    A

Regards,

FCI