remove space at end of the target field MAT_PLANT in sap bw transformation level

[vijju-344]

i have been getting space in MAT_PLANT field at end of the name it has different type of naming conventions like '0000000334455' and fiew with text model like  E2S5T10, VALLWH... etc like wise however actual flow is DS-->DSO1-->DSO2-->MP  DS to DSO1 There is a function module to remove space and add '.' dot . but bringing the records  to DSO1 ex:

record 1 has  'VALLWH' and plant 5000 and

record 2 'VALLWH  '  plant 5001

then after transformation it bringing like

record 1  'VALLWH' and plant 5000 and

record 2 'VALLWH  '  plant 5001

record 3 'VALLWH.'  plant 5001

i tried all the possible ways to  remove trailing and leading space with field routine and formula between DSO1 to DSO2  like REPLACE ...RTRIM,CONDESE, SHIFT LEFT ect but couldnt find the solution i am not sure What is the cause and why am not able to removing it please experts help me on this at Target field MAT_PLANT

[roland_szajko]

To remove leading/trailing spaces:

• In HANA runtime you can use the TRIM function.
• In ABAP runtime you can use CONDENSE.

What exactly is your code? What is the result?

Is that really a space (hex 20) in the end or just a non-printable character?