06-05-2009 11:28 AM
Hi all!
I am looking for a way to determine the tax rate from an invoice.
I use the BAPI BAPI_INCOMINGINVOICE_GETDETAIL.
The structure TAXDATA return only the tax code (eg: V9) and the amount but not the rate.
I know that I can use the table T007V to determine the tax rate (T007V-KBETR) associated to the tax code but how to find the table key of this table?
An other way could be to calculate the tax rate but by using this way I could find 19.60119 or 19.5911.
Do you know a way to round the value to 19.60 wich is the tax rate of the tax code V9 (eg)?
I must find the simpliest way for this because the program is not optimize and i do not want to have time out.
David
06-05-2009 11:34 AM
Rounding issue: make sure just two decimals get printed the rounding will then work automatically.
you got an invoice.
this invoice has conditions, probably even a TAX condition.
Table VBRK field KNUMV is needed as a key to get to table konp or maybe you already got an internal table tkomvd or such. just ask you consultant for the konditionname of your tax condition.
06-05-2009 11:34 AM
Rounding issue: make sure just two decimals get printed the rounding will then work automatically.
you got an invoice.
this invoice has conditions, probably even a TAX condition.
Table VBRK field KNUMV is needed as a key to get to table konp or maybe you already got an internal table tkomvd or such. just ask you consultant for the konditionname of your tax condition.
06-05-2009 11:35 AM
See some of the function module to Round the decimal places or amount
HR_NZ_ROUNDING_DECIMALS Round decimals places
HR_TH_ROUND_AMOUNT_DIRECT Round an amount by the rounding rules passed as parameter HR_TH_ROUND_AMOUNT_FEATURE Round a Specified Amount using a Feature for rounding rules
Edited by: sekhar manda on Jun 5, 2009 12:35 PM