cancel
Showing results for 
Search instead for 
Did you mean: 

Freight charges in Quantity Contract when implementing Transportation

Former Member
0 Kudos

Dear Gurus,

Our sales cycle is: Quantity Contract (VA41)

Sales Order (VA01)

Delivery (VL01n)

Shipping document (VT01n)

Shipping Costing document (VI01)

Billing document (VF01)

The issue is, when the Quantity Contract (QC) is made, the Marketing HOD has to approve it and only then a Sales Order can be created. And for the Mrkt HOD to approve the QC, he needs to see the Net after deducting all the costs incurred.

For Example: Invoice Value - 1000

Excise Duties - 100

Freight Charges - 150

Commission - 50

Sales Tax - 125

Other expenses - 75

Here we have to show the Net as (1000 - 100 - 150 - 50 - 125 - 75) = 500

But since Freight charges are being generated in the Shipping Document, I am not able to bring that value into the QC to show the correct Net value.

Freight charges are maintained in TK11 and are based on the 'Route' as determined in the QC according to the Customer's Transportation Zone.

How can I populate Freight condition type ZB00 in the QC with the value as maintained per the Route which is determined in the QC under Shipping.

I tried to search in the Forum, but unfortunately did not find a suitable thread. Any help from your side is HIGHLY appreciated.

Best regards.

Venkat - Hyd.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Closing the thread since no more replies. Appreciate all the efforts.

Former Member
0 Kudos

Hi venkat

U can use a pricing condition type for freight .Define a new condition type , a new access seq.

U can check the no.of options are avialble in filed catalog in t.code OV24,LZONEZ(Destination zone),Target postal code (PSTLZZ) or TRFZNZ Tarif zone of destination. Using any of these fileds along with Ship to party , plant u ca set acc seq and condition records.Through which at the time of Sales order Value of freight can be derived.

If Trnasportaion zone is filed needed u can add the same using append structure to KOMK or KOMP table.U will need help of abaper for that ,as after filed addition ,code is to be written in exit to capture value in filed.

and routine to update same in pricing.

Check the solution most suitable to u

Regards

Mandar

reazuddin_md
Active Contributor
0 Kudos

Hi,

Try from another way, Hope it may work.

Make sure Freight Condition type in Sales Pricing Procedure & Shipment cost Pricing procedure is same.

Else,

Create Freight condition type in V/06, with the same properties as shipment cost Freight Condition type(T_06). Use same access sequence with the tables . Assign this access sequence in respective condition types.

Assign Shipment cost condition type in SD freight condition type in V/06 in Ref Condtype field / Ref.Application "F"-shipment costs.

OR

you can do the same in viceversa,

assign SD freight condtion type / application(V) in shipment cost condition type inT_06.

it may help you.

Test & revert

Former Member
0 Kudos

Hi,

Here is my opinion.

Assign service vendor to partner function of customer master.

Create a condition record for freight charges where in condition records for the same has to be determined through condition technique.

ZFRE - freight condition type to be included in your pricing procedure.

Create a new access sequence for the above condition type (ZFRE)

Now create a z condition table to be assigned to above access sequene.

This condition table should include the fields as below (Select from field catalog):

Customer city code - CITYC

Vendor Number - LIFNR

And if required u can add some more fields in this new condition table.

Maintain condition records for condition type ZFRE.

Create a sales order and check condition record for the ZFRE is being derived or not....if it gets...hope this would resolve your issue.

Regards,

Praveen