Site icon SAP Human Resources Experts And Solutions

Step-by-step SAP LSMW User Guide

<p>Last time we discussed SAP Step-by-step LSMW Developer Guide&comma; which you can find here <a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;step-by-step-sap-lsmw-developer-guide&sol;" target&equals;"&lowbar;blank" rel&equals;"noopener">Step-by-step SAP LSMW Developer Guide<&sol;a><&sol;p>&NewLine;<p>Today let&&num;8217&semi;s have a look at the User Guide&period;<&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533437"><&sol;a>Basics<&sol;h2>&NewLine;<p>LSMW is a standard SAP tool to do any kind of mass data changes&period;<&sol;p>&NewLine;<p>In 99&percnt; cases&comma; we use Batch Recording which works like macros in MS Excel&sol;Word&period; The system follows user’s steps&comma; recording screen by screen&period; Once done we map data file to these screens and data fields&period; Than system repeats the same steps like the user would be doing manually&period;<&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533438"><&sol;a>Organizing LSMW projects<&sol;h2>&NewLine;<p>In LSMW transaction we have projects&comma; subprojects&comma; and objects&period;<&sol;p>&NewLine;<div id&equals;"attachment&lowbar;1313" style&equals;"width&colon; 597px" class&equals;"wp-caption alignnone"><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;1&period;png"><img aria-describedby&equals;"caption-attachment-1313" class&equals;"wp-image-1313 size-full" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;1&period;png" alt&equals;"SAP LSMW Initial Screen" width&equals;"587" height&equals;"210" &sol;><&sol;a><p id&equals;"caption-attachment-1313" class&equals;"wp-caption-text">SAP LSMW<&sol;p><&sol;div>&NewLine;<p>Ideally&comma; there should be one global project for routine updates&comma; one for data migration&period;<&sol;p>&NewLine;<p>The subproject is something meaningful&comma; like OM&comma; PA&comma; PT&comma; and PY for different HR areas&period; Or it could be one subproject for all infotypes&comma; no matter&period;<&sol;p>&NewLine;<p>An object usually represents what’s being changed&colon; infotype&comma; table or something else&period;<&sol;p>&NewLine;<p>To start we need to choose from all three entities&colon; project&comma; subproject&comma; object&period;<&sol;p>&NewLine;<p>Here is the main LSMW window&period; Steps &OpenCurlyDoubleQuote;Define Object Attributes” to &OpenCurlyDoubleQuote;Assign Files” are settings&comma; other for execution for the end-user&period;<&sol;p>&NewLine;<p><&excl;--more--><&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;2&period;png"><img class&equals;"alignnone size-full wp-image-1314" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;2&period;png" alt&equals;"" width&equals;"890" height&equals;"531" &sol;><&sol;a><&sol;p>&NewLine;<p>As a user you need to perform just 4 steps&colon; specify file&comma; read data&comma; convert data&comma; upload data&period;<&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533439"><&sol;a>Specify Files<&sol;h2>&NewLine;<p>Here we create a file reference&period; Change file path to your local PC&period; Keep all other parameters the same<&sol;p>&NewLine;<div id&equals;"attachment&lowbar;1315" style&equals;"width&colon; 1148px" class&equals;"wp-caption alignnone"><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;3&period;png"><img aria-describedby&equals;"caption-attachment-1315" class&equals;"wp-image-1315 size-full" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;3&period;png" alt&equals;"SAP LSMW Specify File" width&equals;"1138" height&equals;"731" &sol;><&sol;a><p id&equals;"caption-attachment-1315" class&equals;"wp-caption-text">SAP LSMW Specify File<&sol;p><&sol;div>&NewLine;<p>Save and exit&period;<&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533440"><&sol;a>Read Data<&sol;h2>&NewLine;<p>Here the system reads the file and converts to internal format on the server&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;4&period;png"><img class&equals;"alignnone size-full wp-image-1316" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;4&period;png" alt&equals;"" width&equals;"566" height&equals;"187" &sol;><&sol;a><&sol;p>&NewLine;<p>If the file is large and we want to test our LSMW project&comma; delimit a number of records to read and process&period;<&sol;p>&NewLine;<div id&equals;"attachment&lowbar;1317" style&equals;"width&colon; 899px" class&equals;"wp-caption alignnone"><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;5&period;png"><img aria-describedby&equals;"caption-attachment-1317" class&equals;"wp-image-1317 size-full" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;5&period;png" alt&equals;"SAP LSMW Read Data Preview" width&equals;"889" height&equals;"500" &sol;><&sol;a><p id&equals;"caption-attachment-1317" class&equals;"wp-caption-text">SAP LSMW Read Data Preview<&sol;p><&sol;div>&NewLine;<h2><a name&equals;"&lowbar;Toc515533441"><&sol;a>Display Read Data<&sol;h2>&NewLine;<p>Here we can double check ourselves if the file was organized correct and data placed into right fields&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;6&period;png"><img class&equals;"alignnone size-full wp-image-1318" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;6&period;png" alt&equals;"" width&equals;"655" height&equals;"185" &sol;><&sol;a><&sol;p>&NewLine;<p>If you click on the data record&comma; it shows record content parsed into source structure&period;<&sol;p>&NewLine;<div id&equals;"attachment&lowbar;1319" style&equals;"width&colon; 382px" class&equals;"wp-caption alignnone"><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;7&period;png"><img aria-describedby&equals;"caption-attachment-1319" class&equals;"wp-image-1319 size-full" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;7&period;png" alt&equals;"SAP LSMW Display Read Data Record" width&equals;"372" height&equals;"220" &sol;><&sol;a><p id&equals;"caption-attachment-1319" class&equals;"wp-caption-text">SAP LSMW Display Read Data Record<&sol;p><&sol;div>&NewLine;<h2><a name&equals;"&lowbar;Toc515533442"><&sol;a>Convert Data<&sol;h2>&NewLine;<p>The system converts data from the source structure to the recording structure including all kind of mapping we’ve done on &OpenCurlyQuote;Define Field Mapping and Conversion Rules’ step&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;8&period;png"><img class&equals;"alignnone size-full wp-image-1320" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;8&period;png" alt&equals;"" width&equals;"903" height&equals;"423" &sol;><&sol;a><&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533443"><&sol;a>Display Converted Data<&sol;h2>&NewLine;<p>The same as display read data step but shows already converted data&period; This data will be entered during simulation &lpar;batch input&rpar;&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;9&period;png"><img class&equals;"alignnone size-full wp-image-1321" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;9&period;png" alt&equals;"" width&equals;"377" height&equals;"359" &sol;><&sol;a><&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533444"><&sol;a>Create Batch Input Session<&sol;h2>&NewLine;<div id&equals;"attachment&lowbar;1322" style&equals;"width&colon; 599px" class&equals;"wp-caption alignnone"><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;10&period;png"><img aria-describedby&equals;"caption-attachment-1322" class&equals;"wp-image-1322 size-full" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;10&period;png" alt&equals;"SAP LSMW Create Batch Recording" width&equals;"589" height&equals;"207" &sol;><&sol;a><p id&equals;"caption-attachment-1322" class&equals;"wp-caption-text">SAP LSMW Create Batch Recording<&sol;p><&sol;div>&NewLine;<p>If you want to keep all recordings for your records&comma; tick &OpenCurlyQuote;Keep batch input folders’&period; Otherwise&comma; the system deletes all successful recordings&period; Only failed will remain in the system until they are processed&period;<&sol;p>&NewLine;<h2><a name&equals;"&lowbar;Toc515533445"><&sol;a>Run Batch Input Session<&sol;h2>&NewLine;<p>SAP opens a SM35 transaction with Batch Input sessions&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;11&period;png"><img class&equals;"alignnone size-full wp-image-1323" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;11&period;png" alt&equals;"" width&equals;"1029" height&equals;"259" &sol;><&sol;a><&sol;p>&NewLine;<p>Select the recording and click &OpenCurlyQuote;Process’&period;<&sol;p>&NewLine;<div id&equals;"attachment&lowbar;1324" style&equals;"width&colon; 501px" class&equals;"wp-caption alignnone"><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;12&period;png"><img aria-describedby&equals;"caption-attachment-1324" class&equals;"wp-image-1324 size-full" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;12&period;png" alt&equals;"SAP SM35 Start Processing Screen" width&equals;"491" height&equals;"255" &sol;><&sol;a><p id&equals;"caption-attachment-1324" class&equals;"wp-caption-text">SAP SM35 Start Processing Screen<&sol;p><&sol;div>&NewLine;<p>For 1 record to test it’s recommended to use &OpenCurlyQuote;Process&sol;foreground’ as the system shows every step on the screen with the data filled in&period;<&sol;p>&NewLine;<p>Display error only is to run the process in the foreground and stop only on errors&comma; so that user could react somehow&period;<&sol;p>&NewLine;<p>In case of a large volume&comma; it’s better to run in the background&period; It’s the fastest way&period;<&sol;p>&NewLine;<p>To update the screen with the current status click &OpenCurlyQuote;Enter’ on a keyboard&period;<&sol;p>&NewLine;<p>If the record was not processed it would show errors in the log&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;13&period;png"><img class&equals;"alignnone size-full wp-image-1325" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;13&period;png" alt&equals;"" width&equals;"794" height&equals;"236" &sol;><&sol;a><&sol;p>&NewLine;<p>If we double-click on the recording there is a tab with a log&period; Once errors fixed &lpar;most common the employee or OM object is locked by another user&rpar; you can restart recording process&period; It will run ONLY for incorrect records&period;<&sol;p>&NewLine;<p>Once all errors are fixed and recording is processed it will disappear from the list&period;<&sol;p>&NewLine;<p>It means no more error occurred and we can verify the data&period;<&sol;p>&NewLine;<p><a href&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;14&period;png"><img class&equals;"alignnone size-full wp-image-1326" src&equals;"https&colon;&sol;&sol;saphcmsolutions&period;com&sol;wp-content&sol;uploads&sol;2018&sol;12&sol;tug&lowbar;lswm&lowbar;14&period;png" alt&equals;"" width&equals;"887" height&equals;"273" &sol;><&sol;a><&sol;p>&NewLine;

Exit mobile version