topic Re: Query in abap database tables in Application Development and Automation Discussions

Query in abap database tables

Former Member — Mon, 30 Oct 2006 09:57:51 GMT

hello Experts,

Is there any System table to get the Year.For Example to get the Month we can use T247 database table like this any system table to get year.

thanks

regards,

Ashok.

Re: Query in abap database tables

Former Member — Mon, 30 Oct 2006 10:32:09 GMT

Sorry can you explain what do you mean to get year ??

The below would give you the year.

Year = Sy-datum(4).

If you wish to convert it into words you can use SPELL_WORD and make sure to use currency with zero decimails..in that case it would return two thousand six in words.

Re: Query in abap database tables

Former Member — Mon, 30 Oct 2006 10:42:54 GMT

hi,

Problem solved by myself.Thank you very much for your Answer.

thanks

regards,

Ashok.