BW ABAP Help

[former_member532796]

Hi Gurus,

I am having issues with the following senario and require abap, loading to a DSO.

Source:

Material   Error Code

S-123       01|23|5|1

A-123          23|4

B-124          20

Target:

Materil     error code

S-123          01

S-123          23

S-123          5

S-123          1

A-123          23

A-123          4

B-124          20

I have to split the records at '|' and add a new record if multiple error codes exist. Any help is appreciated.

Thanx,

Maddy

[Former Member · Accepted solution]

Hi,

    You must have material number and error code as key fields in your DSO. This will ensure that all the unique combinations of material no. and error codes are update in the DSO.

    You can write the code at the transformation level. Counting the no. of "I" present in the error code for each material and then looping as many times you can update the unique combination of material no. and error code to the DSO.

Regards,

Nilesh

[former_member532796 · Accepted solution]

Thanks Nilesh, I used split function to solve the issue but got to work on dynamic loop.