Download - LSMW by Recording Method
![Page 1: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/1.jpg)
![Page 2: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/2.jpg)
ENTERENTER
![Page 3: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/3.jpg)
CREATE NEWCREATE NEW
![Page 4: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/4.jpg)
![Page 5: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/5.jpg)
Enter the data & CLICK hereEnter the data & CLICK here
![Page 6: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/6.jpg)
![Page 7: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/7.jpg)
![Page 8: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/8.jpg)
![Page 9: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/9.jpg)
Enter data & CLICK hereEnter data & CLICK here
![Page 10: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/10.jpg)
Enter TRANSACTION CODE and CLICK hereEnter TRANSACTION CODE and CLICK here
![Page 11: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/11.jpg)
Enter Data and proceed filling all Enter Data and proceed filling all data relevant for recording.data relevant for recording.SAVE at the end.SAVE at the end.
![Page 12: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/12.jpg)
CLICK HereCLICK Here
![Page 13: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/13.jpg)
SAVE & Click for BACK (Twice)SAVE & Click for BACK (Twice)
![Page 14: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/14.jpg)
![Page 15: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/15.jpg)
![Page 16: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/16.jpg)
![Page 17: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/17.jpg)
Select – Batch Input RecordingSelect – Batch Input RecordingInput – Correct NameInput – Correct NameSave &Save &BackBack
![Page 18: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/18.jpg)
![Page 19: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/19.jpg)
![Page 20: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/20.jpg)
Click at a place.Click at a place.Press Ctrl-YPress Ctrl-YUsing Cross wire select all fieldsUsing Cross wire select all fields
![Page 21: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/21.jpg)
Copy by Ctrl-CCopy by Ctrl-C
![Page 22: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/22.jpg)
Open New Excel Sheet and paste by Ctrl-VOpen New Excel Sheet and paste by Ctrl-V
![Page 23: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/23.jpg)
Select column ASelect column AData Data Text To Columns Text To Columns
![Page 24: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/24.jpg)
![Page 25: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/25.jpg)
Select all columns and CLICK for TEXT OptionSelect all columns and CLICK for TEXT Option
![Page 26: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/26.jpg)
Copy Columns A, C & D in another sheet.Copy Columns A, C & D in another sheet.
![Page 27: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/27.jpg)
Change all values in Column B to “C”Change all values in Column B to “C”Return to LSMW windowReturn to LSMW window
![Page 28: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/28.jpg)
Back Back
![Page 29: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/29.jpg)
![Page 30: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/30.jpg)
![Page 31: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/31.jpg)
Fill in data & CLICK hereFill in data & CLICK here
![Page 32: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/32.jpg)
![Page 33: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/33.jpg)
![Page 34: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/34.jpg)
![Page 35: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/35.jpg)
![Page 36: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/36.jpg)
Select and copy by Ctrl-CSelect and copy by Ctrl-CReturn to LSMWReturn to LSMW
![Page 37: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/37.jpg)
Paste by Ctrl-VPaste by Ctrl-VDo not forget to press-Do not forget to press-ENTERENTER
![Page 38: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/38.jpg)
SAVE & BackSAVE & Back
![Page 39: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/39.jpg)
Save & BackSave & Back
![Page 40: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/40.jpg)
![Page 41: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/41.jpg)
![Page 42: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/42.jpg)
1. Click Here1. Click Here
2. Click Here2. Click Here
3. Save3. Save
4. Back4. Back
![Page 43: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/43.jpg)
![Page 44: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/44.jpg)
![Page 45: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/45.jpg)
11
2233
44
![Page 46: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/46.jpg)
![Page 47: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/47.jpg)
Generally, CLICK here or Press ENTER… Again & Again.Generally, CLICK here or Press ENTER… Again & Again.
![Page 48: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/48.jpg)
Click hereClick hereThen Save & BackThen Save & Back
![Page 49: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/49.jpg)
![Page 50: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/50.jpg)
1
2
3
4 Back4 Back
![Page 51: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/51.jpg)
![Page 52: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/52.jpg)
Select Columns A & B (If you want description for reference)Select Columns A & B (If you want description for reference)Copy by Ctrl-CCopy by Ctrl-COpen a new Excel workbookOpen a new Excel workbook
![Page 53: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/53.jpg)
![Page 54: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/54.jpg)
Select Cell A1Select Cell A1Right Click and choose Paste SpecialRight Click and choose Paste Special
![Page 55: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/55.jpg)
![Page 56: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/56.jpg)
This becomes a worksheet for entering data.This becomes a worksheet for entering data.Save it at a suitable location with suitable name.Save it at a suitable location with suitable name.Then delete 2Then delete 2ndnd Row. Row.
![Page 57: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/57.jpg)
![Page 58: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/58.jpg)
![Page 59: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/59.jpg)
Save at convenient location, by simple name – as Text (Tab Delimited)Save at convenient location, by simple name – as Text (Tab Delimited)Close the file.Close the file.
![Page 60: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/60.jpg)
• Return to LSMW Window
![Page 61: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/61.jpg)
Double CLICK hereDouble CLICK here
![Page 62: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/62.jpg)
![Page 63: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/63.jpg)
![Page 64: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/64.jpg)
![Page 65: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/65.jpg)
![Page 66: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/66.jpg)
Important: Select TABULATOR Important: Select TABULATOR
Important: Select Important: Select Field Names at Start of File Field Names at Start of File
Important: De-Select Important: De-Select Field Order Matches Source Structure Definition Field Order Matches Source Structure Definition
![Page 67: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/67.jpg)
![Page 68: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/68.jpg)
![Page 69: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/69.jpg)
![Page 70: LSMW by Recording Method](https://reader033.vdocuments.us/reader033/viewer/2022061118/5468dce7b4af9f2e738b45cf/html5/thumbnails/70.jpg)