WM-inventory > block WM inventory booking of materials that are out of use

[csaba_szommer]

Dear All,

Sorrowfully, our part numbers change frequently. To avoid mistakes, we mark the old part numbers (that are out of use) with deletion flag at client level (MM06).

This is good to ban the IM inventory booking of 'old' materials.

But this deletion flag doesn't help in WM: WH workers execute the inventory bookings in WM without any problem, after this, when the IM inventory booking comes, the old part numbers cannot be booked (in IM).

How can we block the WM-inventory booking of these materials (materials are marked with deletion flag at warehouse level as well)?

Thanks for your help.

Csaba

(Of course we should use proper p/n during inventory and have a stable p/n system, but it doesn't depend on me)

[Former Member · Accepted solution]

Hi

Yes The material can be marked for deletion at warehouse level

In MM06 enter the warehouse number on the front screen and then select the warehouse number and save

I hope that this helps

[csaba_szommer · Accepted solution]

Dear Frenchy,

Thank you for your answer.

What I wanted to emphasize that though the parts are marked with deletion flag (at client level, at plant level, at warehouse level, etc) this doesn't mean any problem for SAP during WM-inventory booking.

So, deletion flag can't solve this problem.

How is it possible to block the WM inventory booking of materials?

Thanks.

Csaba

[Former Member]

do you nhave batch management. If so you could restrict the batch of the old material by setting the batch to restricted in the batch master using MSC2N and not allowing restricted batches to be moved in WM

In SPRO in Logistics general>Batch management > Batch status management > Activate batch status checking in warehouse management ensure that the stst re field is not ticked for any movement types that you use in WM and then you should not be able to move it.

[csaba_szommer]

Hi Frenchy,

I'm not sure I totally understand your solution.

Do you mean that we should restrict all the batches that were in use for old part numbers?

But this couldn't solve to do inventory booking for old part numbers with new batch (e.g. material01 + batch 07/001 is blocked; material02 [new version] + batch 07/002 is in use >> then during inventory because of mistake WH workers book material01 with batch 07/002).

The SPRO - batch restriction means that we generally block batch-use in WM for old part numbers (+ all batch), or it means that we restrict the use of old part numbers with batches that batches were already in use.

Thank you for your help.

Csaba

[Former Member]

Csaba

In the material master you can set the Plant-Specific Material Status which can be cross plant in the basic data view or plant specific in either the ourchasing view or the MRP1 view. Using this should stop any movements or receipts of this material.

Cheers

[csaba_szommer]

Dear Frenchy,

Really thanks for your help.

I executed a test-inventory booking in SAP. I set the field suggested by you to '05' ('blocked for WHS only') but there was 'no problem' (I mean SAP should have indicated that this part number is not in use but it allowed the booking) during WM-inventory booking. (I was able to execute inventory booking though that field was set to '05').

I made other tests:

MB1B 309 >> not allowed by SAP

LT01 >> allowed by SAP

Is this blocking valid only in IM?

thx

Csaba

[Former Member]

Csaba,

Which transaction do you use to do your WM inventory booking?

I don't think the plant-specific material status would work in your case to prevent a WM inventory booking. You can prevent the material from being used in a TR or a TO by setting the indicator within the material status config but this will not prevent WM inv. booking.

I was thinking on the lines of assigning ONE fixed bin (warehouse management 2 view) to all your 'old version' material master records and then creating a physical inventory document for that bin in SAP. Keep this physical inventory document as is in the system (you can always delete it at a later time). As long as this physical inventory document is active, system will issue an error message when users try to do a WM inv. booking for the 'old version' materials.

Would this serve the purpose? Let me know what you think.

Hope this helps.

H Narayan

[csaba_szommer]

Hi Narayan,

Thanks for your suggetion.

It seems to be a very crafty idea:).

I haven't found found on 'WM view 2' the field you mentioned, but I can imagine that it is not displayed because of background settings (what is the name of this field?).

To assign the old part numbers to a fixed bin in material master can solve that the active physical inventory document would block part numbers without stock?

I'm not sure this kind of solution should be a standard / exact (solution) but till now I haven't found any other.So, I think it's worth a test.

Thanks for your advice!

Csaba

[Former Member]

Csaba,

You need to first <i>extend</i> all your 'old version' materials to a suitable storage type (say fixed bin storage type 005) using MM01 or other mass extension methods.

Then, you will see the field 'Storage Bin' (MLGT-LGPLA) in the WM 2 view. Here, you can enter the FIXED bin for the material.

It would not matter if the material has stock or not. The active WM physical inv. document should block the users from doing another WM physical. inv. booking for the bin that is tied to the material.

You may want to check with WM experts like Svetja or Sackman in <a href="http://www.sapfans.com">http://www.sapfans.com</a> to see if they have a better recommendation.

Hope this helps.

H Narayan

[csaba_szommer]

Hi,

I tried your suggetion but the active WM inventory document blocks only the fixed bin, but we want to block inventory bookings of old p/n for our whole warehouse (for all bin).

I tried the link you recommended but till now they couldn't answer this question.

(Svetja recommended the setting of field 'X-plant matl st' [like you] but the value:

05 - 'Blocked for WHS only' doesn't work.

Only

'Transfer requirement msg'

'Transfer order message'

can be set in customizing as error messages in WM. These error messages can't prevent WM inventory booking [I tested]).

So, I don't know how to close out wrong inv-bookings in WM.

thx

Csaba

[Former Member]

Csaba,

Ok, I think I see your problem a little more clearly now although I am out of options to address your issue other than proper user training for the warehouse staff to prevent such inv. misbookings.

Can you tell me which transaction you are using do the WM physical inv. booking?

I will revert back if I find something.

H Narayan

[csaba_szommer]

Hi,

Thank you for your perseverance.

The transactions are the following:

LX15 / LI01N

(LI04)

LI11N

LI20

LI21

(You're right totally, our WH should operate properly, but their knowledge on warehousing is 'limited' and it's difficult to advise them...)

Thank you!

BR

Csaba

[Former Member]

Csaba

you can put a block on the material using either LS06 or LS07 One is for the bin and one is for the material.

This will block the material wherever it is in the warehouse for removal or placement.

[csaba_szommer]

Hi,

Thank you, but your solution cannot be adopted to this problem (I guess).

Our part number structure is the following:

material01 >> material02

'material01' and 'material02' are the same parts, the difference is the part number ('*02' is the latest version).

So, we don't use 'material01' (we used it but now we use 'material02') but during inventory WH workers tend to mix the part numbers and use *01 as well.

We'd like to ban 'material01' in SAP. We'd like to block WM invetory booking of old versions (like 'material01').

So, the situation is that we don't have stock from 'material01' but despite this WH workers can book 'material01' during inventory because of mistake.

To avoid such mistakes we'd like to block old versions in WM, but deletion flag couldn't solve this.

(In LS07 we can block an existing quant I guess, but from 'material01' we don't have stock. We want to PREVENT misbookings during inventory)

BR

Csaba