Skip to Content
avatar image
Former Member

Function Module to determine tax code

I need to determine a Tax Code when I have a set of conditions and tax rates.

Business Scenario:

I have an invoice created with SD Tax Code and I need to post a Credit Memo in FI with exactly the same taxes.

From BSET table, it's possible to get the conditions and tax rates of all the taxes in the document.

Is there any function module that provides me the correct Tax Code when I input a combination of Condition and Rates??

Thank you very much!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 13, 2011 at 08:05 PM

    Dear,

    please check links bellow :

    Tax Rate Determination

    http://wiki.sdn.sap.com/wiki/display/Snippets/FunctionModuletoCalculateTaxinPurchaseorderbasedoncondition+type

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2011 at 08:20 PM

    Thank you Marissel. However, those links are not useful in my scenario.

    One refers to tax code in purhcase order, and I need a sales taxes code.

    The other is trying to get the tax rate from the tax code and my case is in the opposite direction.

    I need to get the tax code that matches SD Tax Conditions and Tax Rates.

    Any other suggestion? Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2011 at 02:38 AM

    Hi Federico,

    Try to use function module "GET_TAX_PERCENTAGE" with below parameters :

    ALAND = [Country ID]

    DATAB = 00.00.0000

    MWSKZ = [Tax Code]

    TXJCD = [Tax Procedure], you can get this field by using FTXP, and enter your tax code.

    Good Luck !

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2011 at 02:49 PM

    Hi Federico Ochoa,

    I don''t get your point. If you have invoice, that mean you will be able to get tax codes of all lines item from table BSEG/BSET-MWSKZ.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I have an invoice posted from SD module, hence it has Tax Code (msksz) 'SD'

      Now, I need to post a credit memo, not related to the sales order, in other words directly in FI module, with the exact same taxes as the invoice.

      How can I determine, automatically, which is the correct Tax Code in FI to be used so as it has the same tax conditions as the invoice?