Facing Problem while uploading BP Master Data Through ELM in CRM 7.0

[Former Member]

Hi All,

I want to upload a text file which contains the following details

Title Name City BDate

Mr Ankur Meerut 19850525

I have properly mapped the fields as below

Title with PERS_TITLE_KEY

Name with PERS_TITLE_KEY

City with PERS_CITY

BDate with PERS_BIRTHDATE

While creating External List and starting it immediately i am getting these problems

a. In Mapping date:

1 Title Data for target field PERS_TITLE_KEY is longer than the maximum allowed length

1 Date of birth Date . .Date contains invalid characters

2 Title Title key Mr for person not defined in customizing

b. In Maintaining Business Partner:

0 0 business partners maintained

0 2 record(s) not processed while maintaining business partners

0 Step Maintain Business Partners started at 11 February 2010 21:41:59 CET and ended at 11 February 2010 21:41:59 CET

Kindly suggest what needs to be done.

Thanks in advance

Deep

[Former Member · Accepted solution]

Hi Deep

What I observe in your mapping is that you have mapped the same field (PERS_TITLE_KEY) in SAP to both Title and Name in your text file. Please change the mapping to Name to PERS_FIRSTNAME.

Secondly, you also need to check if the date format in your system is same as what you have given in your file. Kindly check it in any existing PERSON business partner in your system.

Lastly, are you sure you have defined the first record in your text file properly and have given it as a sample to ELM?

Please tkae care of the above and ELM should work fine for you. You can award points if this solution works for you....

[Former Member]

Dear deep,

The error "Title Data for target field PERS_TITLE_KEY is longer than the maximum allowed length " has come because the PERS_TITLE_KEY(Mr/Ms) is mapped against name instead map PERSN_FIRSTNAME (against name).Kindly the correct the same.This error will go

secondly the mapping rule for title i.e., Mr/Ms is not dfined .do define the same in mapping rule

thirdly do check the date format in the sytem and accordingly map the same.

the other errors will be removed one this correction are made

Hope this is help ful for you

regards

Hrishikesh

Edited by: Hrishikesh Molkar on Mar 2, 2010 7:46 AM

[former_member382337]

Hi,

1.) Check the date format in SU3. You might have defined a date format in "Defaults" tab. Maintain the date in the same format.

Open mapping format in edit mode. Choose the Person_title_key field and click on "Add Mapping Rule" button.

In the next screen choose the possible values from the drop down list. List of possible valules will be displayed. You have to

mention on of these possible values in your file.

2.) Once you mapping step is done. BP creation will be executed succesfully.

BR, Sathish R