Material Needed on Data Migration

[Former Member]

Hi All,

I am working on project as fresher.

The major work is on Data Migration.

Can I have get any material like Basic documents,

Sample programs/Codes Concept explanation

etc regarding Data Migration (BDC’s and LSMW)?

If so can you send me that personal mail id so that

it might be useful for me?

My personal mail id's are

1) jitendra_gujarathi@yahoo.co.in.

2) jitendra.gujarathi@gmail.com.

Thanks in Advance.

Points would be rewarded.

With Regards

Jitendra Gujarathi

[Former Member]

Hi

BDC:

Batch Data Communication (BDC) is the process of transferring data from one SAP System to another SAP system or from a non-SAP system to SAP System.

Features :

BDC is an automatic procedure.

This method is used to transfer large amount of data that is available in electronic medium.

BDC can be used primarily when installing the SAP system and when transferring data from a legacy system (external system).

BDC uses normal transaction codes to transfer data.

Types of BDC :

CLASSICAL BATCH INPUT (Session Method)

CALL TRANSACTION

BATCH INPUT METHOD:

This method is also called as ‘CLASSICAL METHOD’.

Features:

Asynchronous processing.

Synchronous Processing in database update.

Transfer data for more than one transaction.

Batch input processing log will be generated.

During processing, no transaction is started until the previous transaction has been written to the database.

CALL TRANSACTION METHOD :

This is another method to transfer data from the legacy system.

Features:

Synchronous processing. The system performs a database commit immediately before and after the CALL TRANSACTION USING statement.

Updating the database can be either synchronous or asynchronous. The program specifies the update type.

Transfer data for a single transaction.

Transfers data for a sequence of dialog screens.

No batch input processing log is generated.

For BDC:

http://myweb.dal.ca/hchinni/sap/bdc_home.htm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/bdc&;

http://www.sap-img.com/abap/learning-bdc-programming.htm

http://www.sapdevelopment.co.uk/bdc/bdchome.htm

http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm

http://help.sap.com/saphelp_47x200/helpdata/en/69/c250684ba111d189750000e8322d00/frameset.htm

http://www.sapbrain.com/TUTORIALS/TECHNICAL/BDC_tutorial.html

Check these link:

http://www.sap-img.com/abap/difference-between-batch-input-and-call-transaction-in-bdc.htm

http://www.sap-img.com/abap/question-about-bdc-program.htm

http://www.itcserver.com/blog/2006/06/30/batch-input-vs-call-transaction/

http://www.planetsap.com/bdc_main_page.htm

LSMW

1. Maintain Attributes:

Here you have to choose the second option and you can do the recording how this should work. Then assign the same to the Batch Input Recording name.

2. Maintain Source structure:

Create a structure name

3. Maintain Source field:

In this you have to create a structure same as that of the input file

eg: name

age

sex

4. Maintain structure relations:

This will link the structure to the input file.

5. Maintain field mapping and conversion rules:

Here is the place where you can do coding, depending upon the code you have written or assignment you have done the values will get picked up from the file and get processed.

6. Maintain field mapping and conversion rules:

If you have any fixed values you can define here.

7. Specify files:

Specify the input file path and type.

8. Assign files:

This will assign ur file to the Input file

9. Read Data:

This will read ur data from teh file.

10. Dispaly Read Data:

You can see the uploaded data

11. Convert Data

This will convert the data to the corresponding format for processing

12. Display Converted data:

13. Create batch input session

Here this will create a batch input session for processing

14. Run Batch Input session:

By clicking on the session and process the same you can do teh needfu.

http://www.sapbrain.com/TOOLS/LSMW/SAP_LSMW_steps_introduction.html

http://esnips.com/doc/8e732760-5548-44cc-a0bb-5982c9424f17/lsmw_sp.ppt

http://esnips.com/doc/f55fef40-fb82-4e89-9000-88316699c323/Data-Transfer-Using-LSMW.zip

http://esnips.com/doc/1cd73c19-4263-42a4-9d6f-ac5487b0ebcb/LSMW-with-Idocs.ppt

http://esnips.com/doc/ef04c89f-f3a2-473c-beee-6db5bb3dbb0e/LSMW-with-BAPI.ppt

http://esnips.com/doc/7582d072-6663-4388-803b-4b2b94d7f85e/LSMW.pdf

for Long texts Upload

Please take a look at this..

http://help.sap.com/saphelp_erp2005/helpdata/en/e1/c6d30210e6cf4eac7b054a73f8fb1d/frameset.htm

<b>

Reward points for useful Answers</b>

Regards

Anji