ELM Issues

[Former Member]

Dear All,

I have couple of issues on ELM

-> We have got a file from external parties with BP Number in one column which could be either Person or Organisation. How to create one mapping format which can consider both PERS ID or ORG ID?

->We are doing lot of trails by creating External Lists and based on mapping errors,we are correcting the external file to suit ELM but as the READ File process is already executed, how do we reuse the same external list and have the ELM consider updated file for MAPPING Process?  currently we are creating new external list every time..

-> Is there a way to avoid entering Mapping format as BADI Filter? As our business is expected to create their own mapping formats and they will not be in a position to add mapping format as the BADI Filter

Best Regards

Sweta

[saminder]

Hi Shweta,

Ques1: It's easiest way to have two separate files.

Ques2: You can use the upload file to test mapping in the mapping format (Edit mode). You can make sure your file is correctly mapping to the fields in the mapping format. After this is correct, you can re-execute the mapping step if you get error. You can also try to debug the external list by setting a parameter and control the flow. There are some posts to check how to debug the external list.

If you have to upload new file then you will need a new external list.

Ques3: Mapping format is a filter for standard BAdI. It is normal to create your own mapping format and should not be an issue while calling BAdI. If you have a specific issue, can you please explain.

Hope this helps.

Regards,

Sam

[Former Member]

Hi Sweta

I'd start by asking the External Party supplying the file to separate it into 2 separate files. Surely not to much of a big ask for them as they would appear to be the master of the data they're supplying you.

Unfortunately a New ELM per upload as it is a separate Workflow process per upload.

Probably not the answers you want to hear, but hopefully a simple approach will be easier for your end users as well...the alternative I believe is going to involve quite a bit of coding and complexities for the users.

Regards

Arden

[Former Member]

Hello Adren,

Thank you for the response. Yes we have thought of this but unfortunately we want to avoid preparing two separate files.

Any feedback on other two issues?

Best Regards

Sweta

[Former Member]

Hi Sweta

The short answer to all of your questions is unfortunately lots of custom effort for you.

Regards

Arden

[Former Member]

Any feedback is appreciated