Inventory in SAP at Alternate Units of Measure

[Former Member]

Hey Gurus,

I have a situation at my client where they have material ABC123 which has these units of measure configured.  PC is the base unit of measure

1 PC = 1 PC

1 PAC = 6 PC

1 CAR = 10 PC

The issues comes up where they inventory each of these units of measure differently in the warehouse and assign a UPC to that specific unit of measure.

The inventory that they have on the floor is as such:

300 PC

200 PAC

100 CAR

When we go look in MMBE, MMBE is showing that we have (300X1 + 200X6 + 100X10)= 2500 PC.  This is accurate at the base unit of measure, but it doesn't show them what they actually have in inventory based on the alternate unit of measure inventory.

The issue comes up when we try to do an ATP check.  For some of the customers,  the Sales order Quantity is in PACs or CARs.  They can't ship PC. so that inventory is not available to that customer based on the unit of measure in inventory.

Is there a way of showing the inventory in SAP based on the alternate unit of measure that is scanned in based on the UPC, or does this have to be another material in the system?

Also, we are not using IS-Retail here.  Just standard SAP ECC.

[former_member183424]

If you want to see stock as per unit (which is used in alternative unit in material master), then you have a option in MMBE.

It will take the conversion which is maintained in material master..

If your sales order is PAC and you want to see the stock as on PAC, then just enter the Display Unit of Measure as PAC. System will show the stock quantity as unit PAC.

You can also save the "Display Unit of Measure" in your variant (if you want to set it default)

Just enter the "Display Unit of Measure" and then press save as variant.

Regards

Dev

[joao_sousa2]

That only provides a convertion according to the master data. What he wants is to able to know how many physical crates he has, how many individual pieces, etc, according to the physical packing in the warehouse.

If 10 pieces and packed in 1 box, he wants to see 1 box, not 10 pieces.

[former_member183424]

If you have 10 pcs in your warehouse and you have PC as base unit of measure and your material has the alternative unit of measure as 1 BOX = 10 PC.

Then if you enter BOX in "Display Unit of Measure" in MMBE, then you will able to see only 1 BOX not 10 pcs.

Regards

Dev

[joao_sousa2]

I know that. What I'm saying is that doing that doesn't mean that the pieces are actually packed inside a box, it only means that you have 10 pieces = 1 box.

What he wants is the stock to show the physical packing, not theoretical conversions.

[former_member183424]

Ah okay..

My understanding was wrong.

OP said that

When we go look in MMBE, MMBE is showing that we have (300X1 + 200X6 + 100X10)= 2500 PC.  This is accurate at the base unit of measure, but it doesn't show them what they actually have in inventory based on the alternate unit of measure inventory.

It means he want to know the physical packing stock

Like as

300 PC

200 PAC

100 CAR

I have misunderstood that..

Regards

Dev

[Former Member]

This message was moderated.

[Former Member]

Hi Krish,

Creating individual material for each alternate unit is the only option you have without development.

Regards

Raja

[Former Member]

Its  possible  to see  the  stock  in  alternative  UOM .

In MMBE ,   you  can  check  with

Here  You  can  check  with  Required  UOM  and  stock  will  be  displayed  .

[joao_sousa2]

The issue comes up when we try to do an ATP check.  For some of the customers,  the Sales order Quantity is in PACs or CARs.  They can't ship PC. so that inventory is not available to that customer based on the unit of measure in inventory.

He wants physical packing, not theoretical conversions. What you are saying doesn't match the above requirement.

[Former Member]

Do you have sales Unit maintained in sales view in MMR.

[Prasoon]

Hi,

   Please check the similar thread: The possible solutions are discussed there.

Regards,

AKPT

[Former Member]

If you just want to display the stock in different UoMs, you can enter the UoM in MMBE display and check the stock.

If you want your ATP to be correct, you will have to enable Handling Unit Management/ Stock Keeping Unit (if WM is enabled)

[former_member222204]

Hi,

I think if you want to track at the Alt UoM level you may want to look at Warehouse management Module.

Regards,

Brock

[joao_sousa2]

He has problems at the ATP level and SD doesn't take WM into consideration. And far as I know WM doesn't do what the wants either.

When you have the requirement to ship diferent UoM to certain customers, you should create different Material Codes. SKU is Stock Keeping Unit. If you want to keep stock at different units, create different SKUs.

[former_member183155]

Hi Kris ;

I understand that you want to check stock with their production units. But, your example is that ABC123 material have alternative unit of measure. This provides you only transformation unit to my knowledge.

If you want to control ATP , you have to create different material master for different units.

Regards.

M.Ozgur Unal

[Former Member]

Hello

There is no report that will show inventory in alternate UOM. General speaking inventory is shown in base UOM. In MMBE, you have the option of checking the inventory in the desired unit. In the list display input the desired UOM in 'Display UOM' to get the stock figures.

Alternatively you can develop a custom report if required.

Thank you.