Create Graduated Interval Scales on Shipment Cost
We have a requirement from user to calculate special shipment cost, Interval Scale on Shipment Cost. Here is the scenario:
The base calculation is gross weight in kilogram (KG). For the first 10 Kg, the rate is fixed, i.e. Rp. 300.000. Then any weight above 10 Kg, the rate is Rp. 20.000 per Kg.
Sample calculation:
{code}
If total shipment weight = 9 Kg, then the cost is Rp. 300.000
If total shipment weight = 11 Kg, then the cost is Rp. 320.000 (Rp. 300.000 for the first 10 Kg + (11 – 10) x Rp. 20.000
If total shipment weight = 16 Kg, then the cost is Rp. 420.000 (Rp. 300.000 for the first 10 Kg + (16 – 10) x Rp. 20.000
{/code}
For the first time I try to set Scale Type on shipment cost condition type with D – Graduated to Interval Scale as I do on sales condition type. But system raise error message “Scale type D is not possible for freight condition”.
Next I try to use condition scale user exit, but before do it I must try another way without user exit. I am sure this scenario not only exists in our company, but other companies have the same scenario. So SAP as word wide system must have solutions about this problem. I am sure!
I open SAP Help, open my SAP books, browse to internet, trial error and here is the result: step by step create graduated interval scales on shipment cost.
Create graduated interval scales on shipment cost
Create shipment cost scale (tcode: VS01)
Input the Scale Basis Type. The scale base type defines how the system interprets the scale. The scale can refer to weight or volume, for example. In my case, I input D – Gross Weight.
Input Scale type = A – Base-Scale. On the All Scale Value, create two line scales (in my case). Fist line gross weight = 0, calculation type = A (Absolute). Second line, gross weight = 10, calculation type = C (continuation). It means 0 < kg <= 10 the cost is fixed, then the next kg cost is relative. Scale unit of measure is KG.
Calculation rule = D (gross weight) and price unit 1 Kg.
Assign Shipment Cost scale to condion type.
Select condition type, the double click “scale for condition”.
On next screen, input ref scale basis = D, and Scale ID we have created.
Create Condition Record Master Data (Transaction code TK11)
Input condition type that we want to create the scale and select appropriate access sequence.
Input any required data, then click icon “scale”.
On the popup windows, select scale ID we want to use and click “continue” or OK button.
Input amount for each scale and finally save the condition record.
After do all step to create graduated interval scales on shipment cost, next let us try to create shipment cost. In this case, the gross weight is 16 Kg so the rate must be Rp. 420.000.
Other people found this article using terms: sap vs01, shipment cost for customer on graduated scales in sap, Scale type D is not possible for freight condition, Scale Type on shipment cost condition type, sap shipping cost scale, sap scale conditions shipment cost, sap graduated scales in shipment cost, interval scales examples rate of graduatin, how to maintain the graduted-interval scale in tk11 sap, create new scale basis