conversion tool with rules

[Former Member]

Hi guys!

We are moving our old SAP system to another (also old and running) system. I have a task to create a MM conversion tool which should not just collect all data. Main purpose is to prepare and export data in form ready for direct input to the new system.

Idea is to create a several Z tables with conversion rules structured like this:

FIELD | MAT TYPE | OPER | VAL

MTART | FERT | convertto | MAT

so ... in this simple example system should check material type and if it is FERT it should use method convertto and set value of field MTART to MAT (rule in new system is to use MAT instead of FERT). I planed to create "rules table" for every master data table (MARA, MARD, MARC....) and use same keys + some additional (like MTART for ZMARA_RULES).

With this conversion rules in database tables I'm more flexible to define rules, but I'm not sure if this is a really good idea? what do you think? Any experience with this? How to organize this rules? Anything!?

Regards,

T.

[abdul_hakim]

Hi

Welcome to SCN.

This is not the right procedure to do so.

You need to extract the data from source system,cleanse it(may be using your excel sheet), transform it(by writing conversion rules in LSMW or may be in your ABAP Program) then load it using direct input or whatever method you prefer.

Regards,

Hakim

[Former Member]

Hi Hakim,

what you wrote ... that was my plan actually.

All data will be cleaned in old system before transfer. ABAP written tool should be used on source system to download all necessary data to excel file ... Only question is now how to organize writing conversion rules so that this data is suitable (in right structure and form) for upload to destination system. Reason why we want to have it that way is because we have both (source and destination) systems alive. Conversion from one to another system should be done in period of one or two days max. thats why we don't want have any "editable" excel files. Our excel file will be used only for upload not for maintaining data.

i hope you understand now.

Regards

t.