How to Change the Date Format in SAP to Day Format

Learn how to change the SAP date format from month format to day format using user profile settings. If you're working on a Rebate Agreement in SAP and notice that the date format displays in the month format (MM.YYYY) instead of the desired day format (DD.MM.YYYY), you’re not alone. Many users encounter this formatting issue, especially during rebate payments drill-downs. Fortunately, SAP provides a built-in option to update the date format at the user profile level. This tutorial will walk you through the process of changing the SAP date format to day format using the Own Data settings.

Common SAP T-Codes to Know

Before diving in, it's helpful to understand two key SAP transaction codes:
  • T-code SU01 – Used for User Maintenance Role.
  • T-code SU53 – Used for User Authorization Checks.
While these T-codes aren’t directly used to change the date format, they’re useful for managing and troubleshooting user access.

Step-by-Step Instructions to Change Date Format in SAP

Follow the steps below to update the date format for your user profile:
  1. Log in to SAP and go to the main menu screen.
  2. Look at the top right-hand side of the screen and click on the System tab.
  3. A drop-down menu will appear. From this, select User Profile.
  4. In the next drop-down list, click on Own Data.
  5. This opens the Maintain User Profile screen.
  6. You'll see several tabs: Address, Defaults, and Partners.
  7. Click on the Defaults tab.
  8. Under this tab, locate the section labeled Date Format.
  9. Here you will find three radio button options representing different date formats.
  10. Select the option that shows the day format (e.g., DD.MM.YYYY).
  11. After selecting, click the Save button.
  12. Once saved, your SAP interface and related transactions (like rebate payments) will now display dates in day format.

Quick Navigation Summary

Here’s a simplified path for future reference:

System → User Profile → Own Data → Defaults Tab → Date Format → Select Day Format → Save

See Also
Reports in Sales and Distribution Modules

Goto:
SAP SD Pricing

Goto:
Billing / Shipping

Back to :-
SAP SD (Sales and Distribution) Configuration Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips

(c) www.gotothings.com All material on this site is Copyright.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
All product names are trademarks of their respective companies.  The site www.gotothings.com is in no way affiliated with SAP AG.
Any unauthorised copying or mirroring is prohibited.