Automatic Price copying to a material from another FG Costing Price

[former_member218048]

Dears

We have a requirement :

We have a kind of Finished Goods AB0000* which are produced in a process like a bye-product.

We do not have BOM or routing for this material and we do not need that also.

we need to update the Standard Price of these materials from the costing result of another category of Finished Materials XY0000*

i.e. when the price of the material XY0000* is updated through CK40n, same price should be updated in the AB0000* also.

Is there any way to update this automatically (other than MR21 Manual update) ?

[bhaskar_basam · Accepted solution]

Hi Nikki,

You can acheive this by using special procurement key.

1) Create special procurement key and give sender & receiver plant combination in it(sender - XY0000 plant and receiver - AB0000 plant) - t-code: OMD9

You need to have a valid cost estimate for XY* material before running the cost estimate for AB* material.

Regards

Bhaskar

[former_member218048 · Accepted solution]

I think there has been some confusion.

I want this to happen in the same plant.

AB00000* & XY000000* are materials whose price should be identical.

I will have a valid cost estimate for AB00000* in each period. This price to be copied automatically to XY000000* on periodical basis.

If this is the case, do I need to create a special procurement key ?

If you can explain little bit more, it would be very helpful.

[kamalkumar_biswas2 · Accepted solution]

Hi Nikki

Other than manual update so far I think Transfer control and spl Pro Key is the option.. I didn't test it for same plant but I think I will work. Pl test

Kamal

[former_member218048 · Accepted solution]

Sir,

As you advised, I don't understand how the system will understand to copy the price from AB0000* material to XY0000* material ?

I can assign the special procurement key in the target material XY0000*. Where do I assign the Transfer Control key ?

As per the settings of Transfer Control :

Special Procurement Key (example):

Thanks

[kamalkumar_biswas2 · Accepted solution]

Hi nikki

In spl pro type take Transfer and plant and assign this key to receiving mat masfer

Kamal

[former_member218048 · Accepted solution]

Dear Sir

Do you mean the following settings in special procurement ?

But where the transfer control key is playing here ?

If you think this will resolve my requirement, please guide me with main steps so that I am not confused anymore.

Thanks

[kamalkumar_biswas2 · Accepted solution]

Hi nikki

yes....

Kamal

[kamalkumar_biswas2 · Accepted solution]

Hi nikki

Sorry..Ajay is correct ..in same plant this will not work to transfer standard cost from mat to mat ..if plant is not different...I have tested..not working

Please revert helpful answer because other will be confused..

Kamal

[Former Member]

Hi Nikki,

as Ajay wrote there is no standard functionality that automatically copys the price from a material X to another material Y.

Depending on the exact requirements you can choose one of the following work-around solutions:

1. Use of material cost estimate w/o quantity structure (t-code KKPAN) which will create a cost estimate that can be marked & released.
   
   
2. Update of future prices in material master data (accounting view 1) and price release via t-code CKME

In the first option you only need to enter a single costing item in the cost estimate. This costing item contains the referenced material/plant. Then the price and the CCS will be rolled-up into this cost estimate.

Option two is a much more simple.

For both options you can enter the data manually or by a custom program (BatchInput for MM02 or KKPA).

It is important to do this after the 'original' costing run to trigger the current cost estimate's values.

Regards,
  Johannes

[former_member218048]

Thanks Johannes.

[ajaycwa1981]

Hi Nikki

I would disagree with the opinions above..

There is no feature to copy the Std price of one material into another.. You can create a custom program which would read from XY0000 and update the same in AB0000 using MR21

Special Procurement Key applies when you transfer the Material from one plant to another.. It is not for transferring from one material to another

Rgds

Ajay M

[former_member218048]

Dear Ajay

I was planning about a manual MR21 update. But this needs to do periodically by the user and I want to avoid the user intervention max possible.

If I consider your option, could you please advise me little bit further about the 'custom program' you are talking about ? Is it a user exit or a program development ? I am not sure about the starting point of this program.

[ArturoSenosain]

Hi Nikki.

I did this stuff some time ago. My solution was:

0: Create a Special Procurement  'RM' (or whatever name you want), this special procurement have type F External. The Idea of this special Procurement is identify this material use this special logic. You can set this special procurement in the Costing View, so PP Boys dont bother about PP views in the material master.

1: In the Standard cost strategy set the UserExit Method at 1st (strategy U)

2: Create a Ztable, in this table fill the combination:

+ Source Plant

+ Source Material

+Recive Plant

+Recive Material

3: Write code in user exit COPCP005. In the exit, validate the Material-Plant you are processing have the special procurement "RM", and then read the Z table and fill. There are lot of examples in the internet about this exit so just google "sap + COPCP005'

4. Now, you can use CK11N/CK24 / CK40N like the standard system.

Arturo.

[former_member218048]

Dear Arturo

Thanks for the inputs.

From your inputs, I understand that :

1. I need to create a special procurement key with type 'F' (external)

2. Assign this key to the target material in the costing view

3. Create a new Costing Variant (ex.ZRM1) (please advise me whether a new one should be created?)

4. In the valuation variant I need to set the Mat Val strategy as U-valuation price with user exit

5. Create Z-table with source and target material details

6. Use the UserExit COPCP005 for further action.

Can I ask one doubt here ?

Where is the Costing Variant is accessed here ? In the User Exit ?

Thanks,

[ArturoSenosain]

Hi Nikki.

1. Correct

2. Correct

3. Create a newone is not necesary. You can use your current Costing Variant, and just add the UserExit step at the beguining

4. Correct

5. Correct

6. Correct.

The costing Variant is input in CK11N / CK40N

Arturo

[former_member218048]

Dear Arturo

Thanks.
I shall proceed the way you have proposed and come back with my feedback on the results.

I shall create a new Costing Variant because if I change my existing variant with the user exit as first option, I think it will affect the costing of other materials also. The materials for which I need to copy the price from other material comes first in the costing hierarchy. i.e. unless the source material is costed and updated with a price, there will not be a price to copy from. Hence I would run the costing of the source material with the existing Costing Variant. After that updation, I shall run the costing of the target materials using the newly created variant (just a copy of the existing).

I think this would be alright ?

Regards.

[ArturoSenosain]

Hi.

According your requirement, i think Yes. You  need to create a new costing variant and run both in sequence. In my case, we have ML active so we read the ActualCost of the previous month of the "other material", not a standard calculated in the same standard cost run. Thats why this solution work for me.

I still think is technically possible solution.

Arturo.

[Former Member]

Hello Nikki,

Please try using additive cost CK74 and give the material you want using item category M.

Thanks

V.S.Natarajan

[former_member218048]

I am not sure additive cost is helpful in this case.

We need automatic update and that too for all material altogether. Not one by one.

[Former Member]

Hai Nikki,

Why cant you use quantity structure with costing BOM?

Thanks

V.S.Natarajan

[kamalkumar_biswas2]

Hi Nikki

Though I have never tried but you can try with Transfer control and spl procurement key combination otherwise I don't see any other solution than manual update.

Kamal