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]

Joe,

i am writting this code in Start Routine of Transfer Rule.

i have changed dataPak to Data_Package . but it shows me below error in code ...

The field "DATA_PACKAGE" is unknown, but there are the following fields

with similar names: "DATAPAK" and "L_S_DATA_PACKAGE_LINE".

Please check it and write step by step code which will help me in understand flow as first condense and then remove duplicate record.

Thanks Joe.

[Former Member]

Hi,

If you are writing it in the start routine of the transfer rules i guess it would be DATAPAK

But I suggest, leave the condense code as it is.

And just add the delete statement in the START ROUTINE OF THE UPDATE RULE.

Because the code otherwise if fine.

And I am normally used to writing my code in the UPDATE RULE

This should remove your duplicate records.

Regards,

Joe

Edited by: lazarus_joey on Feb 21, 2012 2:52 PM

Edited by: lazarus_joey on Feb 21, 2012 3:03 PM