How to apply offset using SQL script in procedures

I am new to AMDP.I have to write logic in BW transformation using AMDP script.

I have location char 10 field which is deriving from source and i have to updated with target 0plant(char 4).

Ex: Location field value is XXXX1111

I have to update in the target like 1111.

How to achieve this??