How to Create LSMW in SAP Explained in Simple Steps | LSMW for Condition Records in SAP SD Module

#AllAboutSAP #LSMW #BulkMasterData
Please subscribe to #AllAboutSAP for more SAP Videos
LSMW is a tool that supports the transfer of data from non-SAP systems ("Legacy Systems") to SAP R/3 systems. This can be a one-time transfer as well as a periodic one.
LSMW also supports conversion of data of the legacy system in a numerous way. The data can then be imported into the SAP R/3 system via batch input, direct input, BAPIs or IDocs.
Furthermore, the LSM Workbench provides a recording function that allows generating a "data migration object" to enable migration from any required transaction.
LSMW can be used for following 3 functions -
The main functions of the LSM Workbench are:
Import data (legacy data in spreadsheet tables and/or sequential files)
Convert data (from source format to target format)
Import data (into the database of the R/3 application)
LSMW workbench shows the following information-
Project: An ID with a maximum of 10 characters to name your data transfer project. If you want to transfer data from several legacy systems, you may create a project e.g. for every legacy system.
Subproject: An ID with a maximum of 10 characters that is used as a further structuring attribute.
Object: An ID with a maximum of 10 characters to name the business object.
There are four Modes of Data Transfer:
Standard/ Batch Input: Standard upload Programs
Batch Input Recording: Here you can create a recording of your own and use it to upload/change data
BAPIs: Standard BAPIs are used to upload Data
IDOCs: Any Inbound IDOC function modules can be used to process the data
Source Filed is used to identify whether a certain record should go to the specified structure. Eg: Suppose a file contains header rows and item rows, we can specify the first field as the indicator say 'H' for a header and 'I' for Item. Thus when the file is being read, it checks the first field, if it is 'H' then it is read into the Header source structure else it is written to the item source structure.
The Source fields can be easily maintained in the form of a table maintenance.
Here the 3 reusable functions are maintained:
Fixed Values: Fixed values are values which are fixed across the project eg: Company Code. We can assign a fixed value to BUKRS and this fixed value can be used in all the objects in this project. So if the value changes we can only change at one place i.e. in the fixed values instead of changing in each and every object.
Translations: Here you can maintain the fixed translation for any legacy field and the translation can be assigned to the filed, in Field Mapping and Conversion Rules. Translation can be 1:1 or many: 1 etc.
User Defined Routines: These are user defined subroutines that are used in the object for processing the data.
Standard batch input or recording:
Generate batch input session
Run batch input session
Standard direct input:
Start direct input session
BAPI or IDoc:
Start IDoc creation
Start IDoc processing
Create IDoc overview
Start IDoc post processing
This completes a detailed overview of steps to transfer your data using LSMW in SAP.
Source: www.guru99.com...

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html
Check this Video for Sales Order Creation Using LSMW with simple trick

[@praveenadavelly1084]

I have learned LSMW and created by your video. Thanks a lot.

[@AllAboutSAP]

You are most welcome

[@venkat7523]

VERY VERY NICELY EXPLAINED.THANK YOU SO MUCH.

[@AllAboutSAP]

Thanks, It means a lot.

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html

[@travellingdiaries7326]

Thanks For Explaining I have learned LSMW here, Very smooth Explanation

[@sachingupta-ou8sm]

I have learned LSMW with your video.. Thanks for your great effort... Keep it up !!!!!

[@AllAboutSAP]

Great to hear!

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html

[@sapconsultantjha7085]

For fresher in consulting, this is probably good video

[@ravikirangudepu]

Good explanation

[@johnnyyang2728]

Thanks for your explanation. You can also use the transaction SM35 to manage batch input

[@rg3915]

Good JOB... This video is very well done for folks, who knows SAP already !

[@9028albr]

Smooth and clear explanation. Thank you

[@AllAboutSAP]

Thanks 😊

[@mostafaali7782]

your explanation was very useful for me , thanks so much for you sir.

[@shouryaworld2082]

It saves time really well n simple.

[@sancybhakta7797]

I was able to use this process for MEK1 tcode. Thank you so much for the tutorial.

[@AllAboutSAP]

Glad it helped!

[@amandaamazone8878]

Thank you so much!😀😊😀

[@priyafabwani4301]

very helpful video. thankyou so such.

[@AllAboutSAP]

Glad it was helpful!

[@nitinchawla6101]

Good Work and explanation

[@AllAboutSAP]

Thanks and please do share

[@kunalmondal532]

Well Explained...I have a issue, its working fine in foreground. But not working at background. What to do in that case ???

[@ivandomaia]

Excelent! Best explain ever!

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html

[@dietersandra5439]

Why do you use recording for condition records? Using standard batch input gives you a lot more flexibility. Only use recordings in LSMW when it's not possible to use other methods

[@BalaSubramaniamzinda]

Thank you so much 😊

[@Sandeep-bb1on]

You plzz make a video how to find object from TR...
Also tell how we find what configuration we done in that TR with ghe help of se16n tcode

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html

[@AlToor7]

good content

[@prasadreddy7330]

Useful tutorial.

[@AllAboutSAP]

Please do share and subscribe for more videos

[@prasadreddy7330]

@@AllAboutSAP Subscribed. Thanks for the tutorial.

[@AllAboutSAP]

@@prasadreddy7330 th-cam.com/video/tY-whjHGP38/w-d-xo.html

[@sushmaashtekar6095]

Can we change purchasing organization of some vendors...in vendor master data ...by thisethod LSMW

[@achuthkumarchitla279]

NICE VIDEO

[@user-lo9le3rt1q]

Can You please upload the Video of creation of sales order with BAPI method in LSMW.

[@vinayaqu]

Can you please share Direct input method for condition change?

[@kovvurikarthik7768]

Hello sir, can you make a video on sales order upload using lsmw... As no video is available on this

[@AllAboutSAP]

Surely try to😊

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html
I made as you requested

[@harmeetsingh1991]

Hi there,
can we create LSMW for mass Text elements update via t code SO10

[@AllAboutSAP]

Better do with bdc

[@raghuveer9990]

how did you set this sounds?

[@AllAboutSAP]

Go to GUI Options --> Interaction Design --> Sound Settings --> Activate Audio signals

[@AllAboutSAP]

th-cam.com/video/tY-whjHGP38/w-d-xo.html

[@Unheardstories801]

Hi sir, good evening, query related to LSMW. please consider sir.
During data conversion, I'm getting an error.
Generation cancelled. Reason: No Field target
****Message no. /SAPDMC/LSMW_OBJ_070031
please give me solution for this sir