Query in abap database tables

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi,

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

thanks

regards,

Ashok.