Add freight cost in a cross company code scenario using a costing sheet

[kimhjorth_poulsen]

Dear Forum,

I will like to add freight cost to a material using a costing sheet. The freight percentage is very easy to add and works fine when the cost is added in the company code costing. My problems start when I want to add the freight in the cross-company code costing. I want to setup a cross-company code costing where the freight cost is added to the material in the buying company code and not on the selling company code. The cross-company code costing is setup using special procurement costing keys. 

In below costing (CK11N) the procurement costing key is not used.

From the itemization it is shown that purchase info.record 5300067643 is read and the price of 12,97 is determined. There is added 10% in freight coming from the costing sheet.

The freight is shown in the cost component structure as well.

The special procurement type is now changed from ‘20’ to ‘AT´ on the MRP2 screen in the material master. The procurement is now pointing to an internal plant called ‘DCN’.

The costing of material 105050 is now repeated. I get the expected result from changing the procurement key, as I can now see the material is sourced from plant ‘DCN’. DCN is sourcing the material from BJ07, but that is not relevant for the example.

  

If I now look at the itemization again on the costing in BGA1 I now see that the price is not coming from the info.record. It is the costing in DCN that is used.

I will still like to add the freight cost in BGA1.

How do I add freight cost in BGA1 when I at the same time want to have the costing to be taken from plant DCN?

Please let me know if you need additional information on the customizing setup of the system.

Best regards,

Kim Hjorth Poulsen

[Former Member · Accepted solution]

Hi,

Add the Special Procurement Key in Costing view, In Special Procurement Key Configuration specify the Source Plant is "DCN".

Regards

Srinu

[kimhjorth_poulsen · Accepted solution]

Hi Srinu,

Thank You for a prompt feedback.

I have tried to follow Your advise. The special procurement costing key is customized like below.

I have updated the special procurement costing key on the costing 1 view of the material master. When costing the material it is using the special procurement key. This can be seen from the qty. structure tab in CK11N.

It is also costing cross company as intended.

The itemization looks like below.

and the cost component structure looks like below.

Unfortunately the freight is not added in the costing in BGA1.

I noticed that when the costing is made without special procurement key the costing sheet used in the costing is for material components. If the costing is made with the special procurement keys the costing sheet used is for finished and semi-finished materials. The customizing in both of the costing sheets are the same, but only when costing is without the special procurement keys the freight is added.

So unfornutely Your suggestion did not solve the problem.

Best regards,

Kim

[ajaycwa1981 · Accepted solution]

Hi Kim

You have 2 options

1. Additive cost estimate to add freight.

2. Costing sheet. For this, you need to implement this Badi.

"ENHANCEMENT 1  ZSUR_STOCK_TRANSFER_CK.    "active version

* always Calculate Overhead

   ex_surcharges_Active = 'X'.

There is a sap note which explains this. You can search it using the badi name

Br. Ajay M

[Former Member · Accepted solution]

Hi Kim,

You can try the following option:

1. In BGA1 create a BOM for material 105050 with one component: material 105050 from plant DCN.

2. Don't use special procurement keys.

3. Define a costing sheet in BGA1 for freight.

Regards,

Szymon

[kimhjorth_poulsen · Accepted solution]

Hi Ajay,

Thank You for feedback. Looks to me like Your proposal will solve my problem. I am on summervaccation now so I do not have the possibility to test it.

I have one additional question. I was trying to add the mark up using purchase order price via condition tables. Here again I have the same problem, that the markup is not read if I use group costing or cross-company code costing. Can I use the same enhancement to activate this functionality?

Best regards,

Kim