Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tables for Time zone and Currency at system level

0 Kudos

Hi ,

Do we have any table available in SAP for Time zone & Currency at system instance level? Not at the country or company code level.

1 ACCEPTED SOLUTION

raymond_giuseppi
Active Contributor
0 Kudos
For client (MANDT) 000
  • Group Currency is contained in the column MWAER in the database table T000
  • System Time zone is contained in the column TZONESYS in the database table TTZCU.
7 REPLIES 7

sergei-u-niq
Active Contributor

Tables like TCURC and TCURT for Currencies?

michael_piesche
Active Contributor

These are the tables you might be looking for. You should get that information from the data elements -> domains -> value table:

  • TTZZ - Time zones
  • TCURC - Currencies

They are on client level. Is that what you mean by 'system instance level'. Or were you hoping for client independent tables?

Side note: In case you need the values in all clients, you can copy the data from one client to the other, e.g. by creating transportation request for these tables with all data (*) and then copy it from source to target client with Trx. SCC1.

Sandra_Rossi
Active Contributor

You mean the list of all time zones and currency codes?

What would mean one country code for the whole SAP system? It's like choosing randomly one country...

Concerning the time zone, there's one time zone defined for the operating system/SAP system (TTZCU), but what meaning are you looking for? Or are you choosing randomly any time zone?

VeselinaPeykova
Active Contributor

There is currency at client level (T000-MWAER), but it is unclear what you are trying to achieve.

Your FI consultant can give you more details on the importance of this setting (I hope you do not plan on changing it).

kartikrajag
Participant
0 Kudos

Two time zones are preconfigured in AS ABAP: System & User.

System Time Zone : ABAP runtime environment clock of an AS instance is synchronized with the clocks of all other AS instances and with the database system clock, and therefore shows the system time and system date of the entire AS ABAP. Refer sy-uzeit, sy-datum & Table TTZCU

User Time Zone: Local date & time of current user, which are calculated from the system time and the user time zone, refer sy-timlo and sy-datlo.

More on this at SAP Help

michael_piesche
Active Contributor
0 Kudos

Since your question is too vague, you are getting a lot of different answers and information, because everybody interprets your question differently.

Be more specific and you will get better answers. Give examples and screenshots of what you currently 'have', why it doesnt work for you, and what you would expect differently in order to solve your problem, also, what is your problem?

raymond_giuseppi
Active Contributor
0 Kudos
For client (MANDT) 000
  • Group Currency is contained in the column MWAER in the database table T000
  • System Time zone is contained in the column TZONESYS in the database table TTZCU.