SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ISU-EDM Profile Value Import

Former Member

‎2010 Aug 27 8:42 AM

0 Kudos
999

Hi all,

While importing profile values from MS-Excel file (in transaction "Change profile header") the system is giving error "Error Importing Date, Check import file". I would like to know if any specific date format, different than exported file, is to be used. How do we import the profile values for test purposes i.e. without using BAPI/IDoc?

2 REPLIES 2

oliviawalsh
Product and Topic Expert
Product and Topic Expert

‎2010 Aug 30 10:40 AM

0 Kudos
441

Hello,

Please take note 646433 into account. User specific settings in R3 should be the same as regional settings of operating system.

To import profile data from EXCEL you should use internal actions (not status) e.g. UI12 (import valid values).

Hope this is helfpul.

Regards

Olivia

kvinkr
Participant

‎2011 May 19 10:34 AM

0 Kudos
441

Hi,

If the format in SAP is dd.mm.yyyy, you should also be having format dd.mm.yyyy in your OS. If your OS is Windows, then under Control Panel, you have to make the necessary changes under u201CChange the format of numbers, dates and timesu201D. This is likely to solve your problem.

With thanks & regards,

Vinodh