Sitemap

Amicuk Programming Answers

Changing Decimal Places for Currencies (Table V_TCURX)

-0001-11-30   Views:2

Advertisement

The instance is ECC 6.0 We need to change the decimal places for a currency from 0 to 2 decimal places. Is there any impacts of doing that? Also need to add some currencies which are not in the table. Is there anything need to be careful while doing

The instance is ECC 6.0
We need to change the decimal places for a currency from 0 to 2 decimal places. Is there any impacts of doing that?
Also need to add some currencies which are not in the table. Is there anything need to be careful while doing this. If this table is updated, do we need to update any other tables also which may be impacted?

The replay answer
Advertisement
Hi,
It is not recommended that when postings have already been made, that a change in the currency be done, as amounts posted can become invalid or incorrect as a result (ie USD 100->1.00), which is most critical in production environment Please go through the note 137626 When you made changes via OY04, the effect of which is across all clients.
To change the number of decimal places for a currency already in use, you must convert all the tables in the R/3 System that contain currency fields, so that the data integrity remains. This cannot, however, for both organizational reasons and under the runtime aspect, in a productive system.
You must never change decimal places in a productive system if you have documents posted with this currency. Such a change could lead to inconsistencies in these documents already posted.
In case you really decide to use decimals you may consider to use SAP conversion services for them to convert all documents aready posted as explained in note 434349.
Additional inforamtion:
Note No.  137626 - FAQ: Decimal places for currency codes
                 126857 - Display of amts with correct decimal places in SE16
                   53206 - Processing of currency fields
                     9574 - Currency fields on selection screens
Regards
Ravinagh Boni

Go to See the other 3 answers

Changing Decimal Places for Currencies (Table V_TCURX)

Category:DefaultRelease time:-0001-11-30Views:130

The instance is ECC 6.0 We need to change the decimal places for a currency from 0 to 2 decimal places. Is there any impacts of doing that? Also need to add some currencies which are not in the table. Is there anything need to be careful while doing[More]

Problem with decimal in Japan currency

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, I have a problem with Japan currency that when When i take the printout of  document with JPY 5,168,277 it is wrongly printing as 51,682.77 but in document  display it is showing correclty as 5,168,277.  But when i check this in BSEG  table[More]

Decimal Places in Currencies

Category:DefaultRelease time:2015-10-11Views:130

Dear gurus, What is the decimal places in currencied? how it works in table tcurx. Regards R.RajendranHello, During operation, you must neither delete currencies used nor change their definition of decimal places. Amounts in posted documents could be[More]

Decimal change in currencies

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We have an issue related to our SAP Production system. At the time of raising Billing invoices to customers in USD currency, we are using currency SAR with  two decimal places currently. Now our requirement is to bring three decimal places to USD[More]

Changing decimal places for currencies

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone, I'm a complete begginer to SAP BI and I need to change a value in SPRO > General Settings > Currencies > Set Decimal Places for Currencies, but the option that I want doesn't exist. I need to add a new entry with the value: currency[More]

Question about decimal places for currencies

Category:DefaultRelease time:-0001-11-30Views:130

hi ,experts ,    here is the problem , when i use mb5s, i found the net price has been enlarged 1000 times . I  also found the data of the table EKPO has been enlarged 1000 times. So ,i check the decimal places for currencies , i found there are five[More]

Decimal Notation IDR Currency on SAP Fiori

Category:DefaultRelease time:-0001-11-30Views:130

Dear Expert, I had trouble with decimal notation on SAP Fiori. While I look My Spend on SAP Fiori, amount is different in ECC SAP with decimal notation. In SAP Fiori : 98.130 IDR In ECC SAP : 9.813.000 IDR That's different on SAP Fiori and ECC SAP. I[More]

Change decimal digit in currency setup

Category:DefaultRelease time:-0001-11-30Views:130

Dear All we used SBO 2007 B for japan country we used 2 digit decimal for JPY currency and JPY is also maintained as local currency we have already inputed transactions in the database but now we need to change the decimal digit from 2 digits to be w[More]

The EURO currency table (EWUCURRS) could not be set up.

Category:DefaultRelease time:-0001-11-30Views:130

Hi, When I create a PO while using AED as currency, I get message Pricing/euro: Attention: Euro Customizing not maintained Message no. VH777 Diagnosis The EURO currency table (EWUCURRS) could not be set up. Procedure Check EURO Customizing (see OSS n[More]

Transaction Currency Tables

Category:DefaultRelease time:-0001-11-30Views:130

Monthly wise GL Balances ( DEBIT , CREDIT Separately) in Transaction currency tables i required if any body knows pls  help me.HI anu, The transaction currency tables are  KEKO , BKPF , BSEG         Changing quantity into debit or credit           IF[More]

Currency Table.

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I need to get TCURR Currency table from ECC to BI. Please suggest me a way. The TCURR table has the following fields. KURST GDATU UKURS FFACT FCURR TFACT TCURR What are the suitable info objects for these fields. Please help. ThanxHi, Below i[More]

Hot
guys, I have a raw socket server on a local computer communicating with its client on the same machine. Unfortunately, I can not use Wireshark or Ethereal because they will only works from the local TCP point to the outside world. In my case, all is [More]
Hi all I recently bought a 1.5 Powerbook computer from someone. I was told before I bought it; that the screen was dim and you can faintly see things in the Finder. The person that I bought it from told me that she took it to the apple store and they [More]
Hello to everyone, Is there any way i can connect to a MySQL database without using JDBC? My web host does not support Java unless i go and buy a dedicated Server package which costs a small fortune so i am trying to find a work-around solution. Is t [More]
Hi All What is the default username and password to login to a newly built ACS Server V3.3.2 ? Thanks in advanced. DarrenDarren, You need to log in to ACS on the console of the Windows server (assuming it's not an ACS Solution Engine). If you do that [More]
All, I've installed Sun One Studio 5 on a Windows 2000 Server SP3 machine. Whenever I try to start the Application Server I get the following error message in the console: Could not start the instance: domain1:admin-server server failed to start: abn [More]
Hi,      We are trying to send 110MB file from R/3 to Legacy thru XI. It is failing in XI inbound queue with error <b>Internally required memory not available</b>. When i saw memory usage in XI server it is using full 3GB of extended memory an [More]
After upgrading to LabVIEW 8.2 from LabVIEW 8.0 I am continously getting a system reboot on my PXI (8187) when attempting to run my real time loops which worked fine with LabVIEW 8.0.  The loops seem to start, and within less than a 30 seconds the sy [More]
I prefer not to automatically load images, to discourage spam. So, when a message arrives, I click "Load Images", and they appear. All good, so far. But as soon as I move away from that message, the images disappear again. This has only been hap [More]
Hi @all, I'm trying to build firefox-gtk3 from the AUR. Sadly, it fails with this error message: checking for gcc c++0x headers bug without rtti... yes configure: error: Your toolchain does not support C++0x/C++11 mode properly. Please upgrade your t [More]
Hi all,     I want link betwwn draw and qmsm or qmel tables means for particular notification number (notification type is repair means ZC) i want document number and document type. how i get this information from draw table .Hi Himmam,   a good way [More]