Skip to Content
Author's profile photo Former Member

LSMW : Issue with Symbols in the Load File ( Display Convert Data Step)

LSMW : Issue with Symbols in the Load File ( Display Convert Data Step)

Issue :

Found this issue while loading data for General Tasklist through LSMW (Direct/Batch Input) .

Convert Data step is showing the correct record count , but at Display Convert Data Step , system is showing only few records.

(Reference for Tasklist Creation using LSMW , please refer LSMWLSMW – Task List Creation with 5 level input file using Batch Input   )

Using Example that I have used.

The input load file is having  187 records i.e., total of 16 transactions

Step : Read Data 

All the 187 records were read and correct count has been displayed on the screen.

/wp-content/uploads/2014/07/1_1_490818.jpg

Step : Convert Data

Even after Convert Data step , system is showing correct

/wp-content/uploads/2014/07/2_1_490819.jpg

Step : Display Converted Data

Here only few records are displayed . Though there are 187 records converted , but at the display level only 61 records are displayed and remaining are skipped.

/wp-content/uploads/2014/07/3_490826.jpg

After lot of R & D , came to know the root cause for this is the presence of a symbol in the load file.

/wp-content/uploads/2014/07/4_490827.jpg

Here , in the above image , a special symbol is being passed to the SAP , which it is unable to identify.

System is unable to identify that symbol.. so it is failing to read from there and it is not reading further .

Because of this , the system is reading till the symbol only .i.e.,   ‘TX42 Ensure the operator’ .

If anyone faces this kind of issue , please make sure to cleanse data in the load file .

Though the symbol is simple , it created a lot of problem.   🙂

Hope this might be helpful…!

Thanks

V Prasanth Kumar Reddy

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Thien Pham Minh
      Thien Pham Minh

      Thanks for sharing.

      just add on note, during the mapping data, can we use some function module to remove special character from source string before doing the conversion? such as: SCP_REPLACE_STRANGE_CHARS

      Thanks,

      Thien

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Pham.

      Implemented the FM 'SCP_REPLACE_STRANGE_CHARS'  . it is replacing the symbol with '.' and reading the next record without skipping successfully .  Thanks for the note.

      /wp-content/uploads/2014/07/5_490930.jpg

      Is there any way to remove the invalid symbol instead of replacing with some other.

      Thanks

      Prasanth Reddy.

      Author's profile photo Thien Pham Minh
      Thien Pham Minh

      Hi,

      There are function modules to delete the special characters from string. You can find them in SE37, this is just one example

      ES_REMOVE_SPECIAL_CHARACTER

      Thanks,

      Thien

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      This FM 'ES_REMOVE_SPECIAL_CHARACTER'  solved my issue.

      Thanks for the help.

      Thanks

      Prasanth Reddy.