Sales order costing - Price control in sales order BOM

[former_member195434]

Hi,

In sales order BOM, we have materials which are marked with price control 'V'. However in sales order costing, the price is getting picked from the standard price. This behaviour is probably due to transfer control in the costing variant which reads the current material cost estimate before picking the price as per price control. Is this behavior normal? Should the material cost estimate be read before reading the price control in material master?

Also, when we delete the current cost estimate (using CKR1) the sales order costing picks up some other cost estimate from past instead of reading the price control V in the material master. We dont understand how this is happening.

Also, one the cost estimates that sales order costing is picking does not even exist in CKIS table. We have no clue where the cost estimate comes from. Is there any other table where cost estimates are saved? Specifically, any table that stores sales order cost estimate?

Our main concern is that when a material is marked with V, it should pick the moving avg price, not standard price or any cost estimate.

Strategy sequence in the valuation variant is completely fine.

Regards

[ajaycwa1981 · Accepted solution]

Hi Abhinav

Out of curiousity, are these V materials - Raw materials externally procured or Internally manufactured?? The reason I am asking this is you are searching teh costs for them in CKIS...

Ideally, the costing variant you are using for Sales Order cost estimate, that can be configured to look for "Price as per price control" in its valuation variant... If that is Strategy Sequence 1, then system should look at the price from Material Master as per price control... If the system is ignoring that, thats surprising to me as well

Second, if these BOM materials are internally manufactured specifically for this sales order, then the probable reason I see is that the system is considering the Planned Production order cost estimate of these BOM materials

Can you check these things and reply?

br. Ajay M

[former_member195434 · Accepted solution]

Hi Ajay,

Yes, these V materials are in-house produced - procurement type E. They had price control 'S' until last year. So they have existing cost estimates from past residing in CKIS.

Strateggy sequence 1 is "Price as per price control". So no problem there.

And BOM materials are not manufactured for the specific sales order.

1. I am guessing that if transfer control is set as Sales order KDN' system will first look for an existing current cost estimate then go for "Price as per price control". If someone can validate this it would be helpful.

2. If current stf cost estimate is deleted it picks an old std cost estimate. This is strange behaviour.

3. Also, one of the cost estimates that is being picked for a component does not exist in CKIS. How is that possible?

Any comment?

[ajaycwa1981 · Accepted solution]

Hi Abhi

1. Transfer control KDN says transfer costs for "Collective requirement material"... So, if a valid cost estimate exists for your SFG and because you say it is In-House Mfd, then system looks for the Std cost for sure.. So, this is probably the reason..

2. May be you can untick the "With Qty Str" indicator for these SFG items in material master and try again

3. Price contrl V for SFG is not recommended.. This will lead you to a greater trouble

Br. Ajay M

[former_member195434 · Accepted solution]

Hi Ajay,

1. I am guessing this too. But as per KDN, only current std cost estimate should be picked. If we delete the current std cost estimate, it should pick as per price control. However in our case it is picking any previous cost estimate. Is there any way by which we can override the transfer of cost estimate if the price control is 'V'?

Another observation here is that 'price strategy' for these BOM components when viewed within the sales order costing screen is showing as 'Valuation Price According to Price Control in Mat. Master'. And yet the cost estimate number from which it is transferred is also displaying.

2.  I tried to untick "with Qty Str" but that doesn't help. It still takes cost estimate for SFGs.

3. I understand V for SFG is bad idea and we've been trying to convince the business to avoid it. But as of know we have to continue using this.

Regards

[ajaycwa1981 · Accepted solution]

Hi Abhi

In Std ssytem, the Ttransfer control is not dependant on Price control

May be you should now raise an OSS message as to why the system is behaving like this

Br, Ajay  M

[former_member195434 · Accepted solution]

Hi Ajay,

When I changed the ind/collective indicator in MRP4 of a BOM component, then the moving avg price is picked correctly. This is obviously due to KDN transfer control where 'Transfer only with collective requirements material' is ticked.

However, I feel that the system is considering the transfer control before going into the valuation variant of the costing variant. I am looking for a way so that system checks the valuation variant first and then goes into the transfer control settings.

We will raise an OSS message if required.

Thanks

[ajaycwa1981 · Accepted solution]

Hi Abhi

Thats what I said.. Your transfer control is dependant on whether or not the material is Collective req material... If you make your SFG an individual req, it will work.. But the Question is will you be able to manage the actual MRP process with that indicator for SFG???

System is correct in accessing Transfer control first before the valuation variant.. Thats how it is designed to be... Val Variant is meant to be used for Valuating a Qty Structure... however, if the existing cost estimate itself is transferred (due to trf control), there is no question of using Val Variant then

br, Ajay M

[former_member195434 · Accepted solution]

Hi Ajay,

Yes, if that is the case the system is behaving normally. Also if I delete the current std cost estimate now for new sales orders, then the system is picking the moving avg price rather than previous cost estimate.

The problem of picking previous previous cost estimates was occuring only for one order for which delivery already completed.

Anyway this solves our problem now.

Thanks.

[Former Member]

Hi Abhinav,

As per my understanding, Sales order costing is calculated and update to Condition Record :EK01.Please refer the table EKEW with reference to sales order.Based on this table , System will pick the values for sales order costing.

Once Sales Order costing has completed, it will be updated to table EKEW.

I hope This info might help you..

Rgrds Sami

[former_member195434]

Hi Sami,

There is no table called EKEW. You are probably referring to EBEW. In EBEW the only material showing up agains the given sales order is the the final product being produced. There are no lines for subcomponents.

So the subcomponent prices are not being picked from this table.

Any other setting to look for?