topic Re: regarding data transfer in Application Development and Automation Discussions

regarding data transfer

Former Member — Sat, 01 Dec 2007 07:55:25 GMT

hi guru

please tell me, my legacy data available in LIMS<labarotary information management system>,so i want to transfer it to the sap system.so

which method is suitable for me to do this.

thanks

subhaasis

Re: regarding data transfer

Former Member — Sat, 01 Dec 2007 10:37:09 GMT

hai subhasis,

Download the LIMS<labarotary information management system> data into excel sheet and then upload that excel sheet data in to sap system. IF there any table exits in the sap system to store the LIMS data or not? if not create on ztable for it and using function module ALSM_EXCEL_TO_INTERNAL_TABLE upload the excel sheet into one internal table.

after getting data in internal table use below sysntax to insert data in ztable.

loop at <internal table>

move-corresponding <internal table> to ztable.

ztable-mandt = sy-mandt.

modify ztable.

endloop.

Please find the below code to get records from Excel to an internal table

Data declarations to download data from excel

data : it_data type standard table of alsmex_tabline initial size 0,

is_data type alsmex_tabline.

Declaration of ty_tab

types : begin of ty_tab,

bukrs type anla-bukrs,

anln1 type anla-anln1,

anln2 type anla-anln2,

buy_back type anla-buy_back,

end of ty_tab.

Data declarations for ty_tab

data : it_tab type standard table of ty_tab initial size 0,

is_tab type ty_tab.

start-of-selection.

refresh : it_data, it_tab, it_anla, it_final, it_bdcdata.

Upload data from Excel to internal table format

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'

exporting

filename = p_ifname

i_begin_col = 1

i_begin_row = 1

i_end_col = 256

i_end_row = 65356

tables

intern = it_data

exceptions

inconsistent_parameters = 1

upload_ole = 2

others = 3.

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

Append EXCEL Data into a internal table

loop at it_data into is_data.

at new row.

clear is_tab.

endat.

if is_data-col = '001'.

move is_data-value to is_tab-bukrs.

endif.

if is_data-col = '002'.

move is_data-value to is_tab-anln1.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = is_tab-anln1

importing

output = is_tab-anln1.

endif.

if is_data-col = '003'.

move is_data-value to is_tab-anln2.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = is_tab-anln2

importing

output = is_tab-anln2.

endif.

if is_data-col = '004'.

move is_data-value to is_tab-buy_back.

endif.

at end of row.

append is_tab to it_tab.

clear is_tab.

endat.

clear : is_data.

endloop.

sort it_tab by bukrs anln1 anln2.

" Now ur data is in internal table.

reward if useful

regards,

sunil kairam.

Re: regarding data transfer

Former Member — Sun, 02 Dec 2007 06:09:18 GMT

In an SAP R/3 implementation the data from legacy system (non SAP R/3) needs to be transferred to the SAP system

Periodic data transfer between R/3 and other system (interfacing) is also required

Both of the above form a part of data migration

Significance of data migration

Data migration comes in the end of R/3 implementation.

To start with Data Migration first configuration should be fully completed

Data migration is about 20% to 40% of the total implementation expenses.

The tools for data migration are:-

BDC (Batch Data Communication)

LSMW (Legacy System Migration Workbench)

You can use BDC or LSMW

Reward if usefull

Re: regarding data transfer

Former Member — Thu, 21 Feb 2008 06:33:22 GMT

Hello Naresh,

The requirement is like this ,create data transfer tool to transfer material master data

from one version to other version(from 4.7 to Ecc 6.0).will u pls guide me,or if u have some idea how to do

it pls tell me or send any helpful document related to data transfer, data migration.

Regards,

Vidya