Skip to Content

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

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (0) 
    1. Prasanth Reddy 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.

      (0) 
      1. 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

        (0) 

Leave a Reply