Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
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: 

BDC

former_member778253
Active Participant

‎07-18-2007 6:38 AM

0 Kudos

Hi,

Suppose i have a flat file data with fields:

Empno name dept date

Now i want to migrate this data into SAP R/3 database. But the date field

format is in german mode. How can it will be converted to our SAP R/3

date format, while uploading to internal table, without changing the settings?

4 REPLIES 4

Former Member

‎07-18-2007 7:02 AM

0 Kudos

Hi

Always you have to pass the date field in SAP format 'YYYYMMDD'

then only data will be correctly uploaded into the system,

Irrespective of the format what you have with you.

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member

‎07-18-2007 7:40 AM

0 Kudos

You have to change date field to SAP internal format YYYYMMDD

and u may have to convert it into user-profile format..

Regards

Prax

Former Member
In response to Former Member

‎07-18-2007 8:08 AM

0 Kudos

Call the Function Module CONVERT_DATE_TO_INTERNAL before the BDC.

Thanks,

S S K

former_member235056
Active Contributor

‎07-18-2007 8:27 AM

0 Kudos

Hi,

Set sy-langu to 'en' or set system language to english and by the way there's no effect of german mode on data uploading may be data may be uploaded in english or in german format u can change it later on to any language.

Regards,

Ameet