ABAP help

Hello everyone,

I have a scenario where abap is required to calculate values based on the Value type of a source field. here is the scenario and would be helpful if get any sample code to achieve the desired output.

Source:

Doc# ValueType valuechar

1234 101 12/13

1234 102 12/14

1234 103 12/17

1234 105 12/20

Output:

Doc# Valuchar-when 101; value char-when102 value-char when 103

1234 12/13 12/14 12/17

Valuechar-when 101,103,103 are 3 char fields for which the values to populate. this is something like converting row level data to column. the other values 105 etc should be avoided.help is appreciated.

Regards,

Mady