Skip to Content
author's profile photo Former Member
Former Member

S_ALR_87011990 date format


I need to estract date of depreciation start and date of asset capitalization.

I created a Sort Variant with dates from ANLAV and ALNB but they seems like SAP format (YYYYMMDD). There is another asset capitalization date that is displayed in the correct format: DD.MM.YYYY.

how to change the display format of all dates?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 10, 2014 at 09:37 AM


    please have a look into SAP note 1496486. If the changes of this note are not included in your system, then your described problem will occur.

    The simple solution to that is in any case to not include the date field via a sort variant, but rather include the field as explained in note 335065 into structure CI_REPRAGITT. That works in any case and in any release.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 09, 2012 at 04:00 AM


    I think the display of date depends upon the format you have specified in defaults of user profile. Please check settings of date under default tab in t code SU0 and change accordingly.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Kiril

      I do not know why it did not work for Giovanni, but, it works for me. I go into Su3, change the data format for my user id and log off. When I log in again, I am able to see the table entries in the new date format. Please try at your end.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.