Data Conversion

[Former Member]

Hi Experts,

I need to prepare functional specs for uploading Vendor Open Items.(Data Conversion from JD Edwards to SAP)

How to map this data in Spread Sheet, what are the fields i need to maintain,

Pls Help me out on this issue,

thanks in advance

Regards

Stuti

[Former Member · Accepted solution]

Dear Sutti,

1. First you would identify all the mandatory fields that are associated with the transaction in question.

Check if all the mandatory fields are supplied from JD Edwards. If not you would have to use constant values or some kind of logic to fetch them from the database.

2. Check the lengths of the fields. Make sure they are compatible.

3. Similarly check if you want to populate any other fields that are not mandatory.

Regards,

Naveen.

[Former Member · Accepted solution]

Hi Naveen,

Thank you for the reply. You explained it very clearly for me. I understood the process. I am interested in a sample of how to write the data conversion functional spec, especially the fields. Which transaction code would be used?

If you have a sample excel file with field items for AP, Vendor Open items or just the spec, can you send it to me? sapstuti@gmail.com

Thanks ,

Stuti

[Former Member]

This depends on your business requirements.

The vendor tables are here:

http://www.erpgenie.com/abap/tables_fi.htm

LFA1, LFBK, LFB1, LFM2, LFB5 to name but some.