Tax calculation in SAP

[former_member629008]

Hi, everyone:

I'm confused by tax calculation of SAP.

I know:

1. Output tax (Condition type 'MWST') is included in SD pricing procedure, and tax code is determined from the condition records (maintained by TCODE: VK11).

2. In MM module, non-deduct. input tax is included in MM calculation schema, deduct. input tax is calculated by Tax procedure (maintained by TCODE: OBYZ) and we can see the analysis data on PO item tab 'Invoice'.

My problems are:

1. How does the tax code of VK11 relate with the tax code maintained by tocde: FTXP ?

2. Does the tax calculation in SD relate with the Tax procedure(tcode: OBYZ) ? If does, how do they relate with each other?

3. How does the tax calculation in PO related with the Tax procedure(tcode: OBYZ) ? (I know the tax code must be entered in 'Invoice' tab). If I delete the condition records of condition type MWVS  (maintained by TCODE: FV11), the deduct. input tax can not be calculated, why?

4. In SD, tax is determined by country of origin / destination country / customer tax classification ...  What are the determination factors of MM deduct. input tax ?
5. We can maintain tax percent rate both in TCODE: FTXP and FV11, what is the difference?

6. We can input Acct.Key both in Tax procedure(TCODE: OBYZ) and SD pricing procedure, what is the difference?

Thanks in advance.

[former_member198650 · Accepted solution]

HI,

1. First you have to create a tax code in FTXP. Later you have to maintain the tax code in VK11.

2 & 6. In SD tax calculations happened through pricing procedure. Hence you have to create a similar condition records which are exist in tax procedure. And also you have assign same account key to the condition type.

3. In MM tax calculation happened through tax procedure, here you have to maintain tax codes which are created in FTXP to tax conditions in FV11.

4. Tax determination will happened through access sequence which has maintained in the tax condition. These will be tax code or tax code/plant/material or material/plant etc. You can define the steps as per your desired.

5. In formula based tax procedure we maintain tax rates in FTXP and in condition based tax procedure we maintain tax rates in FV11 not in FTXP. Here we have created only tax code in FTXP.

Hope you are clear now.

Regards,

Mukthar

[former_member629008 · Accepted solution]

Mukthar Ali Ahamed N 撰写:

HI,

1. First you have to create a tax code in FTXP. Later you have to maintain the tax code in VK11.

2 & 6. In SD tax calculations happened through pricing procedure. Hence you have to create a similar condition records which are exist in tax procedure. And also you have assign same account key to the condition type.

3. In MM tax calculation happened through tax procedure, here you have to maintain tax codes which are created in FTXP to tax conditions in FV11.

4. Tax determination will happened through access sequence which has maintained in the tax condition. These will be tax code or tax code/plant/material or material/plant etc. You can define the steps as per your desired. 

5. In formula based tax procedure we maintain tax rates in FTXP and in condition based tax procedure we maintain tax rates in FV11 not in FTXP. Here we have created only tax code in FTXP.

Hope you are clear now.

Regards,
Mukthar

1.Tax codes in VK11 must be ones created by FTXP. Through which path does they related?

2. SD pricing procedure is different from Tax procedure. Through which path does they related?

    I have tested, account key of Tax procedure can be different from account key from SD pricing procedure.

3. Why must I maintain tax codes in FV11? There are two columns called 'tax code' in VF11, what is the difference? We enter tax code in PO, how does the system calculate tax? (the detail procedure)

5. I have tested: tax percent rate in FTXP and FV11 are synchronous.

[former_member198650 · Accepted solution]

1. You have to maintain tax code for the tax conditions maintained in OVK1 - Path - SPRO - SD - Basic functions - taxes - Define tax determination rules.

2. SPRO - SD - Pricing - define and assign pricing procedure. If you maintain different account key then it will through error message or it wont post tax postings

3. If you are using condition based tax procedure, then you have to maintain the tax rates in FV11.

If you are maintaining the tax codes by access sequence tax code, then it will display two columns for tax codes. You have to enter the same tax code in both the columns. It is a standard behaviour of the system.

If you enter the tax code in PO, then system will calculate the tax based on tax procedure. The system will calculated the tax which are maintained against the tax conditions which are maintained in FV11 or FTXP.

5. As I already explained the tax rates will be maintained in FTXP or FV11 based on tax procedure which are using.

[former_member629008 · Accepted solution]

How to distinguish condition based tax procedure and formula based tax procedure ? condition based tax procedure has access sequence, formula based tax procedure has condition formula calc.rule ? If does, why does the formula writen in VOFM (Menu: Formulas->Condition values) have no effect ? my code is :

FORM FRM_KONDI_WERT_996.
   LOOP AT XKOMV WHERE KSCHL = 'MWVS'.
   xkomv-kwert = '17000'.
   xkomv-kwert = '1000000'.
   MODIFY XKOMV.
   ENDLOOP.
ENDFORM.

[former_member629008 · Accepted solution]

I know hot to distinguish now: Cond.category of condition type

[kamalkumar_biswas2]

Hi

    Tax calculation have 2 process:

     1. MM-FI integration  for Purchase tax which is triggering through Tax Procedure > condition type > Condition records > tax Code > tax calculation > posting to GL a/c

      We use FTXP to create tax code for both the process because it's at country level

       We record tax rate at FV11 for MM-FI process at combination of Condition type+Access sequence parameters defined at condition type + tax code + rate of tax

     2. SD-FI integration for sales related tax calculation: Pricing procedure > condition type defined at SD > Condition records > Tax code > Tax calculation > posting to GL a/c

        We record tax rate at VK11 for SD-FI process at combination of Condition type+Access sequence parameters defined at condition type + tax code + rate of tax

[former_member629008]

There are two columns called 'Tax code'. What are the differences between them?

[former_member198650]

Both are same fields. You have to maintain the same tax code in both the columns.

[former_member629008]

In FTXP, one tax code can have multiple tax percent rates. So, I think the two columns are different.

[kamalkumar_biswas2]

Hi

  It is not for defining multiple tax %..

  First one is for original tax code and second one is target tax code...but same tax code is defined in both the field ...but some times it may require to define separate tax code for target tax code..that's why it is there.