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: 

VBRP table data issue for currency HUF (Hungary)

former_member588480
Participant
0 Kudos

The amount values are stored wrong in VBRP.

For an invoice with HUF there is no decimal values in VBRK , but in VBRP it is saved with decimals .

Ex: vbrk-netwr = 20.245.924

vbrp-netwr = 202.459,24

The condition values in vf03 is all without decimals and currency as HUF.

The sales order that is related to this invoice has Currency in EUR and with decimal places.

Ex: vbak-netwr = 64.700,00

Could you please suggest how entries in VBRP can be corrected or should i do a workaround in my vbrp extraction program for HUF currency involved invoices.

4 REPLIES 4

matt
Active Contributor
0 Kudos

All values are held in the database to two decimal places. To ensure they are correctly displayed, values should always be coupled to the actual currency. The decimals for a currency are defined in customising.

e.g. WRITE vbak-netwr CURRENCY vbak-waerk.

matt
Active Contributor
0 Kudos

"All values are held in the database to two decimal places."

That means if you are dealing with a currency that has no decimals places in TCURX with a value of 12345, it will be held in the database as 123.45

That means if you are dealing with a currency that has 3 decimals places in TCURX with a value of 12.345, it will be held in the database as 123.45

That means if you are dealing with a currency that has 2 decimals places in TCURX with a value of 123.45, it will be held in the database as 123.45

"To ensure they are correctly displayed, values should always be coupled to the actual currency.

e.g. WRITE vbak-netwr CURRENCY vbak-waerk."

0 Kudos

Okay . I will check and come back.

pokrakam
Active Contributor
0 Kudos

This is correct. Please review the difference between different data formats in the online help:

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenddic_currency_...