Table storing tax codes and tax rates

Source: Internet
Author: User

The tax code and tax rate are stored in Table t007v, which are linked to the request number. If you cannot find more sap explanations, just use them.

When the system is installed, the table contains some standard data. The trkorr field value is pl0k008530. If it is modified in the configuration, the field will become the actual custom transmission request number.

The value of the price field kbetr is multiplied by 1000. For example, if the tax rate is 17%, the value of this field in the database is 170, which should be divided by 1000 during calculation.

Mandt clnt 3 0 Client
Trkorr char 20 0 request/task
Aland char 3 0 shipping country (by this country)
Mwskz char 2 0 Sales/purchase taxCode
Txjcd char 15 0 Tax Code
Datam DATs 8 0 effective from
Kschl char 4 0 Condition Type
Kbetr curr 11 2 price (condition amount or percentage)
Knumh char 10 0 condition Record Number
Kotabnr numc 3 0 condition table
Datum DATs 8 0 date
Uzeit TIMS 6 0 time

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.