write subroutine to remove single space after string

[Former Member]

Hi Expert,

I am loading Master Data for Inventory , but due to space after my Material record (eg . Correct record - L20233 Error record - "L20233 " ) space sfter 3 charector . it is throughing me error. after edting records in PSA i am able load it further to 0material . Can anyone please help me in writing routine at Transformation level to remove space while loading . Step by step approach is highly appreciated.

[Former Member]

I have written code at field level as ,

Result = Tran-strature-/bic/matnr.

condense no-gaps.

But , In PSA i have two records comming from source system . 1. Correct record 2. same record but haviing space behind it (that space i am removing with the help of above code) but in Infoobject it shows Duplicate Data Records .(because it is having corrct record and Condensed record.

Can any one please help me in code for ,

1. Condense Record -- so that it will remove space AS ABOVE I HAVE WRITTEN.

Note - after first step we will carry two records with same identity . - correct record and condensed.

2. I need Code for transfer rouitne to TO REMOVE DUPLICATE ADJESENT RECORD.

[Former Member]

You may have to write the code in the update rules - start routine

DELETE ADJACENT DUPLICATES
                   FROM DATA_PACKAGE
                   COMPARING YOUR_KEY

Regards,

Joe.