extracting data

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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