Pricing condition table field for item value

[former_member328731]

Dear colleagues,

I use MWST condition type for VAT. I need to set up such access sequence to take in consideration value of product. So if I sell products and their value is less than 50 EUR tax rate is 0% and if it is 50 EUR or more tax should be 17%.  Therefore I need to set up access sequence, but I do not know which field (for this purpose) to include in table which I will use in access sequence. Could you please advise me  which one to use.

Regards,

Harry

[Former Member · Accepted solution]

Hi,

an approach would be to create an additional VAT condition, let´s call it ZMWS and assign it to access sequence after your MWST , removing exclusive indicator. Add this new ZMWS to your pricing procedure after MWST. Create a Requirement formula for both conditions, first one contros if value is less than 50 and second one if bigger than 50 and apply those requirements to MWST and ZMWS.

In VK11 manintain 0% for MWST and 17% for ZMWS.

Regards,

JM

[jobis · Accepted solution]

Hi Joan,

This is just for information am asking..

Can this also be met by exploring possibilities of condition supplement in pricing,,? I would like to know that.

Thanks

Jobi

[Former Member · Accepted solution]

Hi Jobi,

I don´t think you´ll be able with condition supplement.

Regards,

JM

[former_member182378 · Accepted solution]

joan,

Certainly a interesting design! Thanks!

We have to include test scenario - when the amount is changed by the user, does the tax change accordingly? say first the price + discount etc. = more than 50. 17% tax populates. But then, user is manually changing the price + discount = less than 50, here the tax percentage should change to 0%.

Or will user have to redetermine the pricing manually?

TW

[former_member328731 · Accepted solution]

Hi Joan,

thanks for advice, but is it anyhow possible just to use only MWST as condition type. Without involving new condition type?

Thanks,

Harry

[former_member211108 · Accepted solution]

Hi Harry,

Well you can calculate the vat using only MWST.  What you have to do is to develop the new routine for alternate calculation type where in base price value will be compared and accordingly your tax will be calculated.

Hope this will help you.

Thanks and Regards

Atulkumar Dagade

[Former Member · Accepted solution]

Hi TW,

both conditions MWST an ZMWS would be redetermined automatically.

Regards,

JM

[Former Member]

Hi Harry,

Well you can calculate the vat using only one condition MWST or use a copy of this condition. However define it with scales:

One scale value - 0 for less then 50 euro

Second scale value - 17% for 50 euro and more.

Hope it helps.

Arkadi

[keyur_mistry1]

Follow below process:

First of create two condition type from MWST. (MWS1 & MWS2)

With the help of this two condition type. You create a Tax classification 1 & 2. For your country code you have to assign this two tax condition type first.

MWS1 - No VAT

MWS2 - 17% VAT

(Note: Same condition can be configure with two tax category)

Assign both Tax category to Material master sales org 1 Tab -> Tax Data.

TaxClass1-matl (MWS1) -> TaxClass1

TaxClass2-matl  (MWS2)-> TaxClass2

Above two filed in your condition table.

Assign this condition table to your condition type. Now you can create your condition record for the same.

For TaxClass1 "No tax" and TaxClass2 "17%Tax" Maintain condition record with both condition.

Now you can follow two process.

1. Manual work to trigger condition type or

2. with the help of Programmer.

Manual:

Every order line item has option to select the tax category at item level, Billing Document Tab.

Here you can keep manually Tax classification. 2, if price is more then 50 EUR. It will trigger condition type with 17% Tax, base on condition record.

Automatic:

With the help of programmer u can make automatic.

Suppose PR00 is base price, if it is higher then 50 EUR, program will read price and  it will set automatically 2. And respective to that condition type will trigger with 17% VAT.

Thanks,

[former_member182378]

http://scn.sap.com/people/keyur_one%40yahoo.com

keyur,

Thanks for your post! Nice to see you connecting Tax classification with this requirement.

For option: automatic: Where would you code the enhancement? in a userexit or....?

TW

[keyur_mistry1]

TW,

Sorry for the late reply.

I do not have Any Customer exits or through BADI right now. But on simple solution we can do, which I know.

We can do implicit enhancement here. Once Price will trigger, system will search the suggested screen number Table and filed name.

Base on screen number For XYZ have ABCD filed name value should set to 1 or 2.

And after that our Condition record will work for the Extra VAT Tax 17%.

Hope I am making sense.

Thanks,