topic Re: Query on Data Conversion in Application Development and Automation Discussions

Query on Data Conversion

Former Member — Mon, 13 Apr 2009 03:55:10 GMT

Hello All,

We are trying to build a generic tool which could help the conversion process in data migration.

For eg, If the material name in legacy starts with AB (AB6790), the same has to be referred in SAP as SQ6790.

So its replacing initial few characters during the conversion process.

Like this, I am expected to collect possible scenarios and

develop a generic tool, which can cover some possible conversion conditions.

Can you please help me with such scenarios, which you may have come across in project needs.

Thank you.

Meenakshi

Re: Query on Data Conversion

Former Member — Mon, 13 Apr 2009 12:28:15 GMT

The easiest would be to create a mapping table which holds the legacy value and the SAP value

e.g. Legacy AB => SAP SQ

Then you write a function module which accepts the legacy string AB6790 (changing parameter) and based on the mapping table converts it into SQ6790.

You can extend your mapping table with field lengths (e.g. first 4 char or first 5 char) or other conditions which you would need to read and evaluate in your FM. You can get as complex as the requirements ask for.

You also need to think about error handling, what happens if no mapping value can be found, how would it be reported back to the user, etc.

In terms of performance you might want to think about buffering the mapping table .

Hope that helps,

Michael

Re: Query on Data Conversion

Former Member — Mon, 20 Apr 2009 09:27:57 GMT

You can maintain Ztable for this purpose that will contain your old material number and new material number .

write conversion program that will read this material number conversion table .