condition table

[Former Member]

hi gurus

ifaced a broblem whene i creating condition table: shipping point/transporation zone/order quantity. whene i get save the table the error message apeare that: activation in iterrupted and order quantity field set to text field by the radio button.

any ideas

[moazzam_ali]

Hello Islam

Why are you taking quantity field in your condition table? Order quantity field is not there in allowed fields. Have you added this field KWMENG there?

One suggestion for you is that whenever you post your query here please always share error message number or screenshot for better understanding. Apart from this share what settings you have done till now.

Thank$

[Former Member]

Hello Moazzam

thnak you a lot for your reply, do you know if i can explain my issue here or administration roles reject that.

[moazzam_ali]

Hi

You can explain your query in detail with business back ground. Moderators only reject the post that violates forum rules and your query doesn't violate the rules. Explain the query in detail so that we can suggest you something.

Thank$

[Former Member]

hi moazzam

my client neede to determine shipping amount in sales order based on quantity for example:

shipping point: 1000

transportation zone: 1000000001

quantity: from 1 Ton to 40 Ton = 4000 fixed amount

                                             OR

shipping point: 1000

transportation zone: 1000000001

quantity: from 40.01 Ton to any quantity = 100 per Ton

as you see it's the same transportation zone but with 2 probabilities if the quantity in order 40 Ton or less the shipping amount will be fixed value and if the quantity in order over 40 Ton the shipping amount will be calculated per Ton.

[moazzam_ali]

Hi

For this you don't need to add quantity field in condition table. This can be done with scales. Just maintain your condition record with scales. Search in Google for how to use scales in condition record.

Thank$

[Former Member]

hi

i can't use scales cause of the freight price for 1 Ton = freight price for 40 Ton = 4000 so if customer buy 1 Ton he will pay 4000 for freight and if he buy 40 Ton he will pay 4000 too and any quantity between 1 Ton and 40 Ton he will pay 4000 for its freight. over 40 Ton he will pay 100 for each Ton. this criteria how can i create it by scales

[moazzam_ali]

Hi

You are saying that from 1 ton to 40 ton price is same and after 40 ton 100 ix extra for each ton? Am I right?

[Former Member]

hi

yeah u r right from 1 ton to 40 ton is same price but after 40 ton customer will pay 100 for each ton wich mean for example 45 ton × 100

[Former Member]

Hello Islam,

To cater this requirement , you need to maintain the scale and Alt calc type routine.

Maintain Scale as mentioned below

Scale type as A  in V/06

Condition record:-

From  1       10 USD

           41    100 USD 

Please write a piece of code in the  Alt Calc type Routine by taking help from an ABAPPER

If the quantity is less than or equal to  40

Make quantity as 1

ENDIF.

Note :- The above solution is based on the assumption that your Sales Unit is TON

Thank you for your time.