cancel
Showing results for 
Search instead for 
Did you mean: 

How to upload more than one email id record for a customer in LSMW

Former Member
0 Kudos

Hi

I have to upload more than one e mail id record for a customer and there are many such cases.

The issue is after the upload is done it shows only the last email id record for a given customer.

Like if i have uploaded email id no. 1, 2, 3 & 4 for a customer it shows only the last one ie email id no. 4 in the customer master.

How can i upload multiple email ID records for a customer.

Kindly help.

Regards

Atul

Accepted Solutions (1)

Accepted Solutions (1)

JL23
Active Contributor
0 Kudos

it depends how your source file looks like as well as on the import method you have chosen.

let me guess, you are using static recording and the source file is just Excel where the 2nd line looks like the first line, just with a different mail address.

Result you are actually loading all 4 email  addresses but always into the same field, hence only the very last stays (check the change log and you will see it)


If you want continue with recording, then you need 4 recordings, one for the first email address, then one for the second line of email address, one for the third line...

This means you need to  group and split your source file too

so that you have a source file for all customers with the first email address

another source file for all second email addresses, a third file with all third email addresses...


Alternative would be the BAPI import method for ADRMAS , which allows multiple email addresses at once. Here you can keep your source file sorted by customer number and make your break with "on_change_transfer_record" as I described in detail in my blog

Answers (3)

Answers (3)

Former Member
0 Kudos

Tried  with adding multiple email id in recording and it is working fine.

Thank you guyz.

former_member218017
Participant
0 Kudos

Hello,

I have passed for this in a project, and the solution provided  was in an abap program developed based in a SHDB.

We introduced the logic to keep the e-mail address in loop until all records were loaded to the customer which its linked to.

I can´t remember very well the logic, because this was done in 2011.

In this case we used ABAP programs because we loaded A LOT of data including customers, tax tables, vendors, info data e more. But in a single situation I don´t know if a new abap program would be the best solution.

ravi_kumar100
Active Contributor
0 Kudos

Hi,

You can upload multiple email id in the Customer Master - Communication Tab but only one email id will be displayed and only one email id will be available in your recording for LSMW.

Check if the individual email id's can be maintained in the contact person with name details in your recording.

Revert for any clarification.

Regards,

SRK.