How to Include VAT percentage rate in the Invoice Print Output

10-11  Source: Network gathering  Views:1 

Advertisement
Hi All,
I have a question here. My client wants the VAT rate in percentage form to appear in the invoice print output. But, I have no idea where to pull out the vat percentage rate from or which table I should refer to.
Appreaciate all of your inputs.
Thanks a lot!
Hello,
You can fetch the VAT rate either from the Sales order or the Billing document
Getting it from Billing document is more relevant.
First goto the Table  VBRK and get the KNUMV  field from the vbrk
Then goto KONV table which is the pricing table for conditions and give the input values as the KNUMV and KSCHL
KNUMV  is the DOCUMENT CONDITION which is independent for each document
KSCHL is the condition type ( in this case it is your VAT condition type )
You can get the Rate from the  the field  KBETR.
KBETR is the RATE % of the KSCHL in KONV
Hope it is clear.
Regards,
santosh
Related articles
  • How to Include VAT percentage rate in the Invoice Print Output 10-11

    Hi All, I have a question here. My client wants the VAT rate in percentage form to appear in the invoice print output. But, I have no idea where to pull out the vat percentage rate from or which table I should refer to. Appreaciate all of your inputs

  • How to include in table of contents the list of figures and list of tables? 10-11

    How to include in table of content the "Table of contents", "List of figures" and "List of tables"? All are generated with function Table of contents, but they will not appear in generated table of contents even if they have

  • Which table stores the Tax percentage rate of commercial invoice? 11-30

    Which data base table stores the tax percentage rate of the items in a commercial invoice? Or which FM can return the tax percentage rate?HI, Don't post the duplicate threads for same requirement...it against to the SCN rules. Moderator can delete th

  • Derivation of Exch Rate from the invoice item 11-30

    Hi When we are using F-28 (Incoming Payment)transaction to receive from customer we can receive an amount which is to be applied partially to many line items. In this case when the system creates a residual line item it valuates this item based on th

  • Investigation on the problem why the exchange rate in the invoice is not u 11-30

    Hi, Informed by customer that the exchange rate (HKD-MOP) of ULP has been changed to 1.0309 from 1.03 since 26 Aug. The corrected exchange rate should be 1.03 Would you do the investigation on the problem why the exchange rate in the invoice is not u

  • Color management settings for the best print output 10-11

    Color Management while Printing has been one of the challenging areas which has been discussed a lot over user forums and has been a painful area in terms of clear understanding while taking print outputs. Here is an easy-to-understand KB (Knowledge

  • I just found All the Hyperlink in the Safari Print Output are gone ! 11-30

    Hi Everyone, My Macbook Air is Mac OS X Version 10.6.8 and Safari is 5.1 (6534.50). In previous, I could find and use the Hyperlink in the Safari Print Output (after I printed the Web Page to PDF). Hours ago, I found All the Hyperlink in the Safari P

  • How to include WS-Security Header in the WSDL 10-11

    hi how to include WS-Security Header which have username and password as i had seen the below link it deals with just hello world which is not using any Services(DBAdapter) is it possible to use DBAdapter as the steps present in the below link how to

  • How to include a js file in the JSP page 10-11

    Hi i have included a script tag like the following in the JSP file <SCRIPT language="JavaScript">vDateFormat='mm/dd/yyyy';</SCRIPT> while deploying i am getting an error 'vDateFormat' unidentified Can any one help meunder view put a

  • How to include input user parameter values in XML report output? 10-11

    How can i include input user parameter values in XML report output. I a have a report which can be run by providing start date and end date. I would like to include value of these parameters in XML output to enable me to figure out dates for report,

  • How to include Batch Number in Inventory Counting and Print Countsheet 10-11

    Hi, Could someone let us know how to include the batch number from Inventory Counting and include them in the count sheet when printed? Thank you! RamonHi Pam...... Try this and modify as you want...... SELECT Distinct T3.[DocDate], T0.[ItemCode], T2

  • How can I get Apple to send the invoice of one of my orders? 10-11

    I ordered a MacBook Air 13 at apple store online but I haven't get the invoice of the product. How can I ask apple to send it to me? Thank you, LuizaThank you for your response, Dominic. I'm in Brazil now and unfortunately I'm not able to call the 1-

  • How can I start a loop before the DAQ Assistand outputs a value? 10-11

    Hi everybody, I created a VI (See attachment) to Measure the speed of a turning wheel. (A optical detector outputs pulses which are proportional to the speed) The DAQ Assistant measures the frequency and the values are written to a log file. To log e

  • Hp laserjet pro 400 m401 dw - how do you get it to recognize the second print tray? 10-11

    We just bought this printer a month ago, and we love it, so we bought the second tray (or drawer, however you want to think of it) because my biggest complaint everyday is reloading paper trays. WE have tried everything we can think of to get the pri

  • How can I make Apple Earphones be the Input and Output for Audio 10-11

    I have some older headphones and they aren't compatible with a Mid 2010 (Intel Core i3) 21.5 Inch iMac Is there some way to make Apple Earphones be the Input and Output for Audio in the iMac This is a problem for me personally as when I am talking to

  • Contact name is wrong in the invoice print out 11-30

    Hi folks, contact person name is wrong in the invoice pint out,but in sales doc the sales group number and name is correct. what is the solution for tha above issue? Regards srinivasDear Srinivas, Please check the name of the contact person in the Cu

  • How to include original InDesign filename in the PDF properties? 10-11

    In CS3, I used to make postscript files and distill them to PDFs in Acrobat Distiller. When I did this the finished PDF would include info about the author and original filename. In CS5 I export directly to PDF. Is there any way to include this data

  • How to include non database item in the query 10-11

    Hi I have a Master-Detail form. where in the detail block one of the field is text item 'X' attached the list of values(Y). Master block includes non database items which is based in the decoding result of the database items for example: Gender(Male,

  • How to include partner number dynamically in the archive filename ? 10-11

    Hi, I am working on IDOC archiving. Since we have a lots of IDOCs with the same Master IDOC name but coming from different partners, it would make sense to generate as much archive files as there are different partners. I have seen that the archive f

  • How to include a response element in the ESB database adapter. 10-11

    hi, i am using the dbadapter to insert the data into the table successfully. The problem is when i am using a db adapter it doesnot include a response element in its wsdl.I want to send a response to the client as and when the data got inserted from