topic Re: Issue in using SY-DATUM in Application Development and Automation Discussions

Issue in using SY-DATUM

Former Member — Sun, 10 Feb 2008 08:24:06 GMT

Hi.. Im finding difficulty in using SY-DATUM to the date field in transaction F-26 thru BDC. Bcoz the date format should be given as mm-dd-yyyy and also the date format may change as mm/dd/yyyy in differnt server.

server to server date format will change.. how can i solve this issue by using SY-DATUM.

<REMOVED BY MODERATOR>

Thanks in advance

Edited by: Alvaro Tejada Galindo on Feb 18, 2008 2:01 PM

Re: Issue in using SY-DATUM

Former Member — Sun, 10 Feb 2008 10:14:58 GMT

Hi,

When running the program using table USR01 and the user who is executing the batch job (SY-UNAME) get the date format from the table.

Each format has a single digit identifier, based on the same, format the date field into the string used in the BDC.

Hope this helps.

Cheers,

Aditya

p.s. you can view the format from SU3 or SU01D.

Re: Issue in using SY-DATUM

Former Member — Sun, 10 Feb 2008 14:38:25 GMT

Hi,

You can set the default system date format by going to TCode SU01 --> Default Parameters tab --> Date field.

Thanks,

Sriram Ponna,.

Re: Issue in using SY-DATUM

Clemenss — Sun, 10 Feb 2008 16:28:58 GMT

Hi aslam,

in BDC date input is expected in the format the user has set in user details. It will be converted to SAP internal date format (YYYYMMDD).

If you use WRITE <YYYYMMDD> to BDCDATA-FVAL it will be written in the format you need. This is always correct if the user creating the BDC hast the same date format settings as the user executing the BDC.

Regards,

Clemens

Re: Issue in using SY-DATUM

Former Member — Sun, 10 Feb 2008 19:05:57 GMT

Hi Aslam,

DATA LV_DATE(10) TYPE C.

WRITE SY-DATUM TO LV_DATE.

write statement will convert the date format as per the user setting.

Regards,

Ali

Re: Issue in using SY-DATUM

Former Member — Mon, 18 Feb 2008 12:42:47 GMT

Hi Thanks 4 ur rply...

i have solvd the issue by splitng the sy-datum into a variable (as per the formate of the transaction then ) and i passed to bdc. That was wrkng fine

Re: Issue in using SY-DATUM

Former Member — Thu, 23 Jun 2016 13:37:08 GMT

Great answer. Thanks