08-10-2018 11:19 AM
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.
08-10-2018 1:12 PM
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.
08-17-2018 1:57 PM
"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."
08-17-2018 1:57 PM
08-17-2018 1:59 PM
This is correct. Please review the difference between different data formats in the online help: