topic Re: Currency and date data types in Application Development and Automation Discussions

Currency and date data types

Former Member — Fri, 15 Feb 2008 13:44:20 GMT

Hi,

I have to upload data from text file into sap.

Date: How will the data stored in sap? Will this always stored in DATS format(YYYYMMDD).

Currency: I have data coming as 123,78. Will SAP accept currency data with coma or it has to come with decimal only like 123.78

Regards

Re: Currency and date data types

Former Member — Fri, 15 Feb 2008 13:47:55 GMT

Hi Ashish,

All the dates are stred in SAP internally in YYYYMMD format only.

SAP will take the , as decimal separator if the user profile has a similar definition for decimal formats.

Regards,

Ravi Kanth Talagana

Re: Currency and date data types

Former Member — Fri, 15 Feb 2008 13:54:21 GMT

Hi Ravi,

Thanks for your quick reply.

I changed my user settings as 1.234.567,89 and tried to send value 1233,89 into sap. But this value is not accepted in sap. Please tell the solution for this problem.

Regards

Re: Currency and date data types

Former Member — Fri, 15 Feb 2008 15:51:41 GMT

Suppose value is 10,000.50 then you should send it to sap as 10000.50

-Regards,

Pranjali

Re: Currency and date data types

Former Member — Fri, 15 Feb 2008 17:40:02 GMT

Hello Ashish,

Date: Internally SAP considers the date as YYYYMMDD format.

Currency: Internally SAP considers the decimal separator as '.' irrespective of the user settings. The user settings are only to display or to enter amounts in screen fields while making a transaction (an FI posting in FB01 for example). If you directly updating the database you can use '.' as seperator. But if you are making any manual trasaction or using a BDC then you have to follow the user settings.

You can check how SAP internally considers the date and currency fields by executing any program in debug mode. Date will 'YYYYMMDD' and for cuurrency the decimal seperator would be ''.' irrespective of the user settings.

Please verify the same.

Regards,

Pavan