Skip to Content

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

4 Comments
You must be Logged on to comment or reply to a post.
  • 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

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

      • 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