Mass Uploading of Derivation Rule Values in FMDERIVE

[meet_waseem]

Dear Experts,

I have got derivation rules values in excel at mass level which needs to be inserted/uploaded in FMDERIVE.

Manual way allows me to copy-paste only 22 values at a time which is really a cumbersome job when there are around 800 values for each derivation rule.

Please advise for any available tool which may allow to upload all values of a derivation rule at once.

Regards

[iklovski]

Hi,

Behind every derivation rule, which is based on a 'lookup' type, there is a technical table. You can see its name by going to Extras - Overview. So, you can fill this table via SE16N in the required format copying the data from Excel.

Regards,

Eli

[meet_waseem]

Dear Eli,

System has shown table name as FMFMOAERP5000021. I have tried to copy excel data in SE16N but could not found a way there to link with spreadsheet.

Can you please elaborate exactly where to insert data.

Regards

[iklovski]

You don't link it. You have to enter to SE16N in edit mode (&sap_edit), copy lines from Excel file (Ctrl+C) and paste it to the table (Ctrl+V). Make sure that the fields in your Excel file are in the same format and order as the fields in this temporary table.

[meet_waseem]

Dear Eli,

Thanks so much for your comprehensive response, seems I am missing some point causing me stuck in SE16N.

By default SE16N is in edit mode but I could not found the table format (having blank columns & rows accepting data) where to paste the excel data. Please have a look at the following screenshot of SE16N.

Clicking the Execute button (Short Key F8) gives an error message "No Values Found".

Regards

[iklovski]

You should type &sap_edit in the command window. Search SCN for information how to modify tables.

[meet_waseem]

Dear Eli,

I have noticed from couple of SCN documents that "&sap_edit" is by default disabled by SAP.

My ABAPER colleague though used ABAP debugger but it seems a bit complicated option for me at functional end.

Alternative by Mars (to activate Business function) has worked smooth.

I am really grateful for your consistent helpful suggestions. Expecting same in future too.

Regards

[iklovski]

Yes, indeed, there is a note 1420281 - CO-OM tools: SE16N: Deactivating &SAP_EDIT which deactivates this function, but in most clients this function is deliberately restored as it could be essential for fast corrections in Production system. Mar's solution is indeed more conventional; I didn't know that you have sufficient release package to apply it.

[mar_novalbos · Accepted solution]

Hi Muhammad

If you are using the enhanced FMDERIVE maintenance feature (it comes with Business Function PSM_FM_CI_1 if I remember well) , you can copy and paste directly from the clipboard in this way:

access your derivation step, click on'Edit', then create entries, and use the ALV function for Inserting:

hope this helps too

regards,
Mar

[meet_waseem]

Dear Mar,

Your proposed solution has worked seamlessly.Thanks so much.

Regards