topic Re: extracting data in Application Development and Automation Discussions

extracting data

Former Member — Mon, 14 Apr 2008 15:10:55 GMT

hi friends,

i am supposed to extract data from 4.7 system into legacy or application server, and upload them into ecc 6

first how do i extract, material master data

and how do i extract BOMs.

thanks

Re: extracting data

Former Member — Mon, 14 Apr 2008 15:18:33 GMT

Hi sanjana ,

First i suggest to go with ALE . This is teh best option for Master data upload between systems.

Still if you prefer to go with ABAP then do the following :

1)Write a two seperate programs . One of Material master and another one for Bill of Materials.

2)Write al the data to a flatfile in according to the ECC6.0 BDC upload program using the DATASET concepts in ABAP.

Hope this helps.

Thanks,

Greetson

Re: extracting data

Former Member — Mon, 14 Apr 2008 15:50:53 GMT

i qam sorry greeetson,

i should have been more specific.

how do i extract all the BOMs from previous system.

will i be using select * from ....

i cannot use ale bcos, i need to do lot of changes before i upload.

thanks

Re: extracting data

Former Member — Mon, 14 Apr 2008 15:57:23 GMT

Hi Sanjana,

First identify all the fields that you need to extract . Then identify the tables and retrieve the data into an internal table from the tables and then using the DATASET option wrire into a flat file.

Hope this helps.

Thanks,

Greetson

Re: extracting data

Former Member — Mon, 14 Apr 2008 16:18:41 GMT

hi greetson, the dataset aspect is ok,

but is it the best practise to identify the fields and tables and then create bapis,

no it doesnt sound a best practise.

Re: extracting data

Former Member — Mon, 14 Apr 2008 16:25:24 GMT

Hi Sanjana,

If you talk about Best practice then I won't recomend to go for ABAP Programming instead of I recommend to you to go with ALE. As this is not fit for you I suggest to go with what I told you in my earlier thread. this is the best way for you as far as I know according to your current requirement.

Hope this helps.

Thanks,

Greetson