BW ABAP Help

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