conversion spec

[Former Member]

hi,

can anybody help me with this problem.

i need to write a conversion technical spec and the scenario is regarding

moving all the sales order details of certain order types (return orders) from the past 6 months, from 3.1 to 5.0 system. i need to write one tech spec for extraction of data from 3.1 and one for loading into 5.0.

thank you.

[Former Member]

<b>Hi

I can suggest that,

1. First download all the salesorders from 3.1 system into one excel sheet

2.Make one BDC session method to upload all these salesoders from the excel sheet into 5.0 system.

While uploading do all the conversions bcoz 5.0 sys is completely different from 3.1 sys.So fisrt have a look into 5.0 sys hw it has been congigured and then upload.

Mark points if helpful.

Regs

Manas Ranjan Panda</b>

[Former Member]

thank you manas,

can you tell me how do i download salesorders from 3.1 into excel?

i mean, do i have to download data from the database tables? if yes, then what tables? because sales order page has a lot of information - header...item...schedule lines...partners, etc etc.

and do i download everything into one excel sheet?

please tell me the steps involved in this.

thank you.

[Former Member]

Hi

Check SAP TAble-

VBAK-Sales Order Header

and VBAP-Salesorder Items

Download it into Excel.

Regs

Manas Ranjan Panda

[Former Member]

I dont prefer to go for BDCs as there are advanced options like BAPI's ..Use of these would be a better choice.

BAPI_SALESDOCU_CREATEFROMDATA

BAPI_SALESORDER_CREATEFROMDAT1

BAPI_SALESORDER_CREATEFROMDAT2

BAPI_SALESORDER_CREATEFROMDATA

Vicky

[Former Member]

ok vicky,

considering we use bapi - BAPI_SALESORDER_CREATEFROMDAT2.

i have the same question. tell me a way of exctracting sales order data from 3.1.

if i use bapi, i think i will have to look for mapping structures, etc etc.

so, tell me if i have to download into one excel file. do i use excel or .txt flat file? and from where and how do i extract this data?

thank you.