Freight condition type-With respect to kilometer

[former_member185462]

Hi,

I am working on freight related condition type,my requirement is we have to calculate freight cost based on kilometer or miles.But for us the standard condition type is KF00 which is with respect to Gross Weight.

Is there any condition type which calculates Freight based on miles/kilometer covered.If so kindly throw some ideas on it.

My doubt is do we require transportation management.

Pradeep

[Former Member · Accepted solution]

Hi Pradeep,

without transport management, maybe you need a different approach of calculating freight.

instead of calculating price per Km/Mile by distance, apply cost based on origin - destination of you sold-to and ship-to.

You know Price per km/Mile. You can ask distance between origin and destination points and calculate freight cost then.

The important point here is to determine the different origins and destinations, refine, group, regroup to end in something that may look like:

Origin: country-state-region-city-zip code... (and even sold-to)

Destination: country-state-region-city-zip code ... (and even ship-to)

Freigth cost: (unit cost x distance)

Once you´ve mapped this in an Excel file, you can think of creating a price condition for your freight costs in SAP based on your mapping.

Regards,

JM

[former_member185462 · Accepted solution]

Kindly advise ,what are the field to be maintained in condition type.

Pradeep

[Former Member · Accepted solution]

Hi,

have you identified what data you need for your requirements (origin-destination)? and cost for each combination?

Regards,

JM

[former_member185462 · Accepted solution]

The important point here is to determine the different origins and destinations, refine, group, regroup to end in something that may look like:

I did not understand all these.

So i decided to do like this,one condition type which will calculate freight based on Gross weight.

One more condition we will enter no of  kilometer required to dispatch the material.

Suppose Rs 10/- is per tonnage,my gross weight is 8 ton,then is Rs 80/-.

Then 8 Km is the distance,then 80x8=Rs 640/-.

We have developed a routine and assigned alternate calculation type to my freight condition type with kilometer.This 8 km distance we have to enter manually at condition level.

Pradeep

[moazzam_ali]

Hi

If you are using transportation module and shipment document process then this is possible to determine route and maintain distance in routes. Take help from following document.

http://www.google.nl/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=4&ved=0CGAQFjAD&url=http%3A%2F%2Fw...

Thank$

[former_member185462]

Hi,

We are not using transportation module and shipment document process,is there any other possibility,kindly advise.

Pradeep

[Lakshmipathi]

Even without Transportation, you can achieve this.  In condition type, maintain "R" for the field Scale basis so that in condition recoed, you can maintain the required distance as shown below:-

G. Lakshmipathi

[former_member185462]

I have maintained as what you said ,i have give 2 Eur per kilometer,but i dont know were to maintain the kilometer.Suppose from plant to ship to party location is 200 kms,were to give this 200 kms.Based on this only the calculation will be made.But i don't know from were this 200 kms will be fetched,were should i maintain,in order to do so any configuration setting is required.

Pradeep

[former_member185462]

Is there any other possibility kindly advise.

Pradeep M

[Former Member]

Hi,

   You have to give the KM in the sales order against the condition type.

Regards,

Senthil Venugopal

[former_member185462]

Could you please share the screen shot,were should it be entered.

Pradeep M

[Lakshmipathi]

Copy this standard condition type, change the Calculation type to "R" and retry the process.

G. Lakshmipathi

[former_member185462]

Hi,

R-Distance-Dependent

From were the distance value will be fetched.

Is route determination required for calculation of distance.Does the field distance of leg in shipment (V_TVRO_COM-DISTZ) will help in calculation of Freight charge

Pradeep