Adding BP Catalog info to Inventory Master Data>Inventory Data tab

[larryenet]

Hello SAP gurus,

#1

Is it possible to add the BP catalog number information for an item in the Inventory Master Data/Inventory Data tab?

The problem we are having is that several users find it hard to see if there is stock for an item that has stock under the BP catalog item.

Can two fields be added in the Inventory Data tab?

Field 1 = BP Catalog Item number

Field 2 = Total stock of parent/childs

I hope this makes sense.

#2

Is there a way to make it so that the part being searched also shows the stock from the BP cat items?

Thank you in advance for any help you provide.

[larryenet · Accepted solution]

SELECT T2.[ItemCode], T2.[ItemName],T1.[Substitute], T0.[OnHand] FROM [OITW]  T0 inner join  OSCN T1 on t0.itemcode = t1.itemcode INNER JOIN OITM T2 ON T0.[ItemCode] = T2.[ItemCode] WHERE t0.whscode = '01' and T2.[itemcode] =[%0]

This gives me the BP Catalog Numbers for an Item Number.

Can someone help add to this where it shows the stock of the BP Catalog Numbers?

This is the result I get from above. All I need is for the right side to have the correct stock of each BP Cat Number.

See attachment: BP Cat Number SFP-GE-S-ENC should have Qty. 365

Thank you so much for all of your help.

[former_member211473 · Accepted solution]

Hello Larry

stock quantity is always based on item code,  it is not possible to get quantity for specific catalog number. in your case you can get the quantity for SFE-1GE-SX-ENC that is your item code and not for SFP-GE-S-ENC

Regards

[larryenet · Accepted solution]

Hi Ranu,

If I create a Sales Order and enter in an Item No., there is a clickable "magnifying glass" icon that pops open the Parent-Child Inventory_V2 window. It shows the same ItemCode and quantities for all warehouses BUT the quantities include Parent-Child Inventory.

I will show you an example showing stock for SFP-1GE-SX-ENC.

Here is the BP Cat Numbers for SFP-1GE-SX-ENC.

Now take a look when I create a Sales Order and click on the magnifying glass icon next to Item No. SFP-1GE-SX-ENC. It will show stock quantities including Parent-Child Inventory from Item No. SFP-GE-S-ENC.

Now I will show you what the inventory is for SFP-GE-S-ENC which is listed as one of the BP Catalog Numbers.

How is the Parent-Child Inventory screen showing stock quantities?

How can I create a query that does the same thing?

[former_member211473 · Accepted solution]

HI Larry

please check, I think you were looking for such result. do reply if it helps you or you have few more requirements. 

SELECT t0.itemcode as 'main item', T1.[ItemCode] as ' bp catalog item', T1.[ItemName] as 'bp catalog discription', T1.[OnHand] as 'bp catalog quantity'  FROM OSCN T0  INNER JOIN OITM T1 ON T0.substitute= T1.[ItemCode] WHERE T0.[ItemCode] =[%0]

Thanks

[larryenet · Accepted solution]

Hello Ranu,

You are the man!!

Thank you.

[former_member211473]

Hi

you can try if this query is useful to you.

SELECT T1.[ItemName], T1.[OnHand] FROM OSCN T0  INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode] WHERE T0.[Substitute] = [%0]

Thanks

Ranu

[larryenet]

Hello Ranu,

Thank you for your help.

It listed all of the Items associated with BP cat. number.

Can you update the code to add "Item No." column to the left of Item Description?

[former_member211473]

Hi Larry

Check this

SELECT t1.itemcode, T1.[ItemName], T1.[OnHand] FROM OSCN T0  INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode] WHERE T0.[Substitute] = [%0]

Thanks

Ranu

[larryenet]

Getting closer Is it possible to make it so that it only looks for stock from Whse Code 01?

Thank you for your help.

Larry

[former_member211473]

Hello Larry

SELECT T2.[ItemCode], T2.[ItemName], T0.[OnHand] FROM [OITW]  T0 inner join  OSCN T1 on t0.itemcode = t1.itemcode INNER JOIN OITM T2 ON T0.[ItemCode] = T2.[ItemCode] WHERE t0.whscode = '01' and T1.[Substitute] =[%0]

Thanks

Ranu

[larryenet]

Hi Ranu,

That worked very nice but I was in error when asking what I am trying to look up.

The query basically needs to be backwards, where you put in the item number and it lists the BP Cat numbers (stocking parts) with stock quantities.

Also, is there a way the query can show the BP Cat stock quantity for each whse under each BP cat number? It is ok if there are more than one BP Cat number assigned to the main Item number.

I need it to show all stock assigned to the Item Number.

Thank you so much for all of your help.

[larryenet]

This is how our sales guys are checking to see if a part has inventory.

They are having to create a sales order so they can click on the Item Number magnifying glass icon

to open the Parent-Child Inventory_V2 window that shows the real stock.

What we really need is to add the "Item Number magnifying glass" like the edited image below:

[former_member211473]

Hi Larry

it is not possible to get stock quantity based on your  BP Cat numbers. The system store quantity for the main item code only.  BP Cat numbers is just to give catalog number.

you can use the following query where u need to pass actual item code and all BP Cat number for that item will list out. The quantity field shows all quantity from warehouse 1 .

SELECT T2.[ItemCode], T2.[ItemName],T1.[Substitute], T0.[OnHand] FROM [OITW]  T0 inner join  OSCN T1 on t0.itemcode = t1.itemcode INNER JOIN OITM T2 ON T0.[ItemCode] = T2.[ItemCode] WHERE t0.whscode = '01' and T2.[itemcode] =[%0] 

if you want to check your stock quantity warehouse wise, as I saw in your attachment then that is possible.

what is the use of BP Cat num in your attachment (item master data)  ???

Regards

[larryenet]

Hi Ranu,

I put in an item number in your query and this is the result which is almost right.

It lists the BP Catalog Numbers in the query result but I need the Stock Qty for the BP Catalog Number to be list to the right. They all say 0.00. Can you make that field show the actual stock the the BP Cat Item Number?

If I look up SFP-1GE-SX-ENC, I want to know if there is stock under SFP-GE-S-ENC.

In this query it shows 0.00 for all.

If I look up SFP-GE-S-ENC (stocking sku)  then I can see the actual stock available.

Here are the results looking up both of those number with this query:

SFP-1GE-SX-ENC

SFP-GE-S-ENC

Thanks for you help.

[Former Member]

Hi Larry,

Each SKU in the item masterdata can have multiple BP catalog numbers, so it might not be feasible to add those data in the item masterdata window.  What I can suggest that you do, is create a query with bp catalog number as parameter, and make the query available to users.

There is also a field in the marketing documents that shows the available quantity, you might want to make it visible.  If that doesn't work for you, you can additional UDFs and UDVs so that they will see exactly what they need to see.

Thanks,

Kao

[larryenet]

Could you please provide me a query so I can try it in SAP?

I need to look up an item and then have it show the BP catalog numbers with their stock in the query.

how can I add aditional UDFs and UDVs?

Need help.

[larryenet]

Can you help with this query?

Please see my last response to Ranu.

Thank you.