How to use a Wildcard in LSMW
Today we spent about a half hour with 3 persons reading SAP’s documentation Using Wildcards and testing to understand how wildcards are used in LSMW
While searching SCN I found many unanswered questions and even wrong replies, so I decided to share this little piece of experience.
Our target is to provide one LSMW object to several users. Execution in parallel without overwriting other peoples work in .read and .conv files.
Open the LSMW step “Specify files” ,
add the star * as wildcard in the file name of your legacy data
add the star * as wildcard in the file name for Imported data
add the star * as wildcard in the file name for Converted data
Place the cursor on the Wildcard Value knot and click the icon for New entry
In the pop-up enter the wildcard value, in my example the user name, along with a description.
Don’t be confused from the appearance after you clicked okay, because the value is on the left and the description on the right, contrary to all other entries above in that screen (see first screen shot as example)
when you execute the LSMW step “Import data” , then you get entry fields for the values specified as wildcard. you can even use F4 search help to get all possible value to select.
Important to know: the source file on your PC or on the application server, has to have the wildcard value at the specified place.
It is possible to enter a different value than you see in the F4 list, you can even execute, but nothing happens, even your file name is equal to this value. SAP will not read data with a value that is not specified in the wildcard settings of “Specify files”.