0% found this document useful (0 votes)
8 views1 page

SAP Data Migration Techniques Guide

The document outlines methods for data migration and conversion in SAP, specifically focusing on Batch Data Communication (BDC) and the Legacy System Migration Workbench (LSMW). BDC allows for the upload of mass data from non-SAP systems to SAP using various methods, while LSMW is a tool designed for migrating legacy system data through a structured 14-step process. Both methods are essential for transferring data efficiently into the SAP system.

Uploaded by

ajaya.freelance
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views1 page

SAP Data Migration Techniques Guide

The document outlines methods for data migration and conversion in SAP, specifically focusing on Batch Data Communication (BDC) and the Legacy System Migration Workbench (LSMW). BDC allows for the upload of mass data from non-SAP systems to SAP using various methods, while LSMW is a tool designed for migrating legacy system data through a structured 14-step process. Both methods are essential for transferring data efficiently into the SAP system.

Uploaded by

ajaya.freelance
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

&&& DATA MIGRATION/CONVERSION.

## A).Batch Data Communication.(BDC).


==> Created Using T-Code:( SM35,SHDB )
==> It is batch interface technique which is used to upload
mass data into sap system.
==> It is designed by technical consultant.
==> It is used to collect the data from non-sap to sap
systems.
==> To upload data from flat file to sap system.(Flat file
contains vendor name,no & Search terms).
==> File is either text or excel formate.
==> To automate the existing transaction code.

& A).Call Transaction Methode.


B).Session Methode.
1).Call transation can process only one transation at time.
1).Session method can process multiple transation at a time.
2).The ABAP statement 'Call Transation'is used.
2).The standard function module used (BDC_CLOSE_GROUP)
3).The data is updated in both synchronous and
(BDC_OPEN_GROUP) (BDC_INSERT) Used to work session method.
asynchronous modes.
3).The data is updated in synchronously mode(Record by record).
4).Call transation methode is faster.
4).Session Methode is slower.

## B).Legacy System Migration Workbench.(LSMW).


==> It is the system provided tool to migrate or convert the
legacy system data.
==> Using T-Code: LSMW.
==> It is designed functional consultant.
==> It is system provided tool.
==> LSMW is a R/3 based tool which is used to transfering data
from non-sap system to sap system.
==> Mostly used for both Large & Small amount of data.

&.There are totally 14 steps in LSMW.


1).Maintain object attributes.
2).Maintain source structure.
3).Maintain source fields.
4).Maintain structure relation.
5).Maintain field mapping conversion rules.
6).Maintain fixed values,transation & user-defined routines.
7).Specify fiels.
8).Assign fiels.
9).Read Data.
10).Display read data.
11).Convert data.
12).Display converted data.
13).Create batch input session.
14).Run batch input session.

Common questions

Powered by AI

One would prefer to use the Session Method over the Call Transaction Method in scenarios that involve processing multiple transactions at once, as the Session Method is capable of handling numerous transactions simultaneously. This method is advantageous for extensive data volume migrations where batch processing efficiency outweighs the need for speed. Since the Session Method updates data synchronously record by record, it provides a more reliable batch update process for complex and voluminous data migration tasks .

Some potential challenges when using the Session Method for Batch Data Communication include slower processing speed due to its record-by-record synchronous update mode and possible complexities in handling error logs within sessions. These challenges can be mitigated by scheduling session executions during off-peak hours to optimize system performance and by implementing effective error monitoring and resolution strategies. Additionally, providing adequate training for handling exceptions can improve the efficiency of using this method for large data volumes .

The purpose of maintaining field mapping conversion rules in the LSMW process is to ensure that source data fields are accurately transformed and mapped to the corresponding target fields in the SAP system. This step is crucial for data integrity, as it dictates how data is interpreted and transferred from the non-SAP system to the SAP system, allowing for accurate data conversion and minimizing errors during the migration process .

The advantage of using the Call Transaction Method in terms of processing speed is its capability to update data both synchronously and asynchronously, which enhances operational efficiency and speed. This method processes transactions one at a time, allowing it to execute faster compared to the record-by-record update of the Session Method. The flexibility to choose between synchronous and asynchronous data updates can optimize processes according to the specific needs of the data migration task, potentially reducing time delays in system-focused operations .

A technical consultant might prefer using BDC over LSMW for data migration due to the greater control it offers over the transaction processing. BDC allows the use of custom scripts for structuring the data upload process, which can be advantageous when precise control over transaction execution and error handling is needed. Moreover, since BDC can be automated using specific transaction codes like SM35 and SHDB, it might better fit technical consultants who frequently work with these transactional tools and require customizable scripting capabilities for complex data loads .

The Legacy System Migration Workbench (LSMW) facilitates data migration from non-SAP to SAP systems by providing a structured tool that consists of 14 steps. These steps include maintaining object attributes, defining source structures and fields, setting structure relations, and maintaining field mapping conversion rules. After these preparations, the tool reads, converts, and displays data before creating and running batch input sessions in the SAP system. This R/3 based tool is suitable for transferring both large and small amounts of data, and it is designed by functional consultants .

Yes, LSMW can be effectively employed for a minor data transfer task because it is a flexible R/3 based tool designed to manage transfers of both small and large volumes of data. The systematic approach provided by its 14-step process allows for organized and precise data transfer, ensuring data integrity and correctness even when dealing with small quantities of data. This makes LSMW versatile and suitable for various migration tasks regardless of the data size .

The transaction code SHDB plays a role in the BDC process by allowing the recording of transactions in the SAP system. This recording serves as a template for automating similar transactions in batch mode. SHDB captures the sequence of transactional steps and the associated data entries required to replicate the transaction, thus facilitating the mass upload of corresponding data from non-SAP to SAP systems through a structured BDC process .

The primary differences between the Call Transaction Method and the Session Method in SAP's Batch Data Communication (BDC) techniques include their processing capabilities, data update modes, speed, and implementation details. The Call Transaction Method processes only one transaction at a time using the ABAP statement 'Call Transaction', and it supports both synchronous and asynchronous data updates, making it faster. In contrast, the Session Method can process multiple transactions simultaneously using standard function modules like BDC_CLOSE_GROUP, BDC_OPEN_GROUP, and BDC_INSERT, but it only updates data synchronously record by record, which makes it slower .

LSMW differs from BDC in terms of design and purpose by being a system-provided tool aimed at facilitating ease of data migration, primarily designed by functional consultants and providing a comprehensive 14-step process to handle both large and small data volumes. In contrast, BDC is a batch interface technique created by technical consultants for uploading mass data, often requiring custom scripting for specific transaction automation. LSMW's design supports a more straightforward, predefined pathway for data migration, while BDC allows for greater customization and control during the migration process .

You might also like