extracting data from tables

[Former Member]

hi friends,

i need to extract complete material master data from 4.7 and upload to ecc 6.0.

to extract the material master data, which is the best way, how do i do that

is query a good way of extracting this data, are there any disadvantages.

thanks & rgds.

[Former Member]

I think some one has replied to u r question earlier.

Cheers,

Chaithanya

[Former Member]

Hello,

The best way to transfer Materials Master data from one system to another is through ALE. SAP provides transaction BD10 for this. You need to setup RFC Destination (SM59), tRFC port (WE21), Customer Distribution Model (BD64), Partner Profile (WE20) in Sending and Receiving systems. Now, you can execute BD10. MATMAS04 IDOCs will be generated and passed on to the receiving system.

Thanks,

Venu

[Sm1tje]

For uploading the data, you might want to consider LSMW (legacy system migration workbench) using the file you created.

EDI solution is not what I would suggest, since this is not really meant / developed for migration but more for exchange of electronic data. Which, in a way is exactly what you are doing, however not for mass data like migration.

another option would be Batch Input processing for downloading data which is also transferring large amounts of data.

[Former Member]

hello friends thank you for the replies,

actually, here i cannot use idocs, due to some reasons,

i was asked to do a query or report program, so that later user can execute it as a tool for many other plants himself.

how do i start with,

i have identified all the fields which neeed to be extracted out of the system,

but they are spread out among various tables, and also mara table has lot of records,

extracting them all at a time would be huge burden,

i heard there will be some groups of materials, so that we can extract groupwise.

please give some suggestions.

thanks and regards.

[Sm1tje]

When extracting the data take the groups as your starting point. Make a report where on the selection screen the user can enter the material group. Create a job for this report (SM36) and schedule it in background, since it will probably be running for quite some time, especially when you have loads and loads of materials.

You can extract the data from several database tables in ONE report and put them together in ONE internal table using an INNER JOIN select. But depending on the data it could (again) take some time for the report to be done. Another option would be to do several selects from different database tables and put them into separate internal tables. After selecting all the data you can collect them in ONE internal table again, and download the data to application server.

You can also download all internal tables separately to application server. For linking the files together for upload again use an identifier in the file name. This has the disadvantage that when uploading them other system, you will have to link all records together (like you would do when collecting them from database at first). So all the data that you download must have some fields with which can identify that row 1 from internal table A, belongs to row x from internal table B.

There are many ways which lead to the correct result, now it is up to you to select one. And maybe other people have other (better) suggestions, which will only make it harder for you.

So I wish you all the best for this.