data transfer

[Former Member]

hii

experts

The scenario is like this

One mainframe system and one Sap system

now my requirement is to transfer data from mainframe server to sap server.how shall i do ?? What will be the Concept?

plz help

thanx and regards

[Former Member]

Hi,

One of the methods will be,

Download all the legacy data into flat files, convert it and upload it into SAP system using LSMW.

Thanks,

Asif Ali Khan

[Former Member]

Hi,

To convert programatically,

There should be connector(third party tools) between two servers which will convert non sap data into sap data.

(OR)

If possible to get all the mainfram server data into some file(excel, notepad....)

keep that file in application server (OR) presentation server and upload the data into SAP

by BDC or LSMW.

Pls. reward if useful...

[Former Member]

hi ,

do one this. first take the data from Mainframe system into text file and use LSMW to load the data.

procedure to load data is as follows.-

uploading vendor master data using recording method.

Go to transaction LSMW.

Click on “Create Entry”.

Create Project:

Click on “Continue”.

Create ‘Subproject’:

Click on “Continue” and create Object.

Click on Continue.

Click on Continue again.

Select the first step “Maintain Object Attributes” and click on “Execute”.

Select the check box “Batch input Recording” and click on :

Create a recording for the transaction XK01 with the required fields. In this example, only mandatory fields are used.

Save the recording.

<Once the recording is done, please remember to mention the field name for each field by double-clicking on it and removing the default value that appears in the recording (the default values shown are the values you entered during your recording). See the screenshot below>

Come back to the earlier screen and mention the name of the recording.

SAVE and click on “Back”.

Select the check box “Maintain Source Structures” and click on Execute:

Select the “Source Structures” and click on “Create”:

Click on “Continue”.

SAVE and click on “Back”.

Select the radio button “Maintain Source Fields” and click on Execute

Select the Source structure and click on “Create Field”

In our scenario for creating vendor master records, we would define only the mandatory fields.

Save and click on Back.

Select “Maintain Structure Relations” and click on “Execute”.

Save and go back to the previous screen

Now select ‘Maintain Field Mapping and Conversion Rules’ and click Execute

Now we need to assign the relationship between source structure (of the input file) and the target structure (from the recording).

Select the field from the list and click on “assign source field”:

Save and go back to the previous screen.

Select the option “Specify files” and click on Execute.

Select the option “Legacy Data” (on the PC) and click on Add entry.

Provide the location of the test data file and other details as shown below:

Click on Continue, next SAVE.

If you get any error like this:

Then click on Converted data file, and reduce the file name.

Now select the option “Assign files” and click on Execute:

Since we have only one file to upload, the file is already assigned to the structure.

Save and go back to the previous screen.

Now click on Read data and select Execute button

Click on Execute

The file is successfully read.

To see the data that is read, use “Display read data” on the main screen.

Double-click on the record.

Now come back to the main screen and select “Convert data”

To check, if the data has successfully converted from source structure to target structure, select “Display Converted data”

Double-click on the record.

Now create batch input session and the run the same.

Now run the session to upload the data.