To view data in /lime/nquan table with respect to product

[shashirv6]

Hi All, Need a kind help here,

How to view data in /lime/nquan table with respect to product as I dont see product and batch field in selection screen.

Also not sure how to fetch Parent / Guid stock field to see the data.

Entry is not available in /scwm/aqua , (we have only physical stock in the system and available stock is zero, appreciate if anyone can suggest the action to be taken during such case)

Thanks,

Shashi

[Daniil]

you have guid_stock which represent the product and all attributes, you can find it in different tables, for example /scwm/ordim_c for confirmed warehouse tasks ( it should fit for analyse of such an issue ). You find correspondig wt in /scwm/mon first, and after you can take guid_stok, dguid_hu from this task to search in Lime table.

[yogananda]

shashirv6

To view data in /lime/nquan table with respect to product, you can follow these steps ¹:

1. Go to transaction SE16.
2. Enter the table name /LIME/NQUAN.
3. Click on the execute button.
4. In the selection screen, you can enter the product and batch fields.
5. To fetch Parent / Guid stock field to see the data, you can use the data element /LIME/GUID_STOCK ².

Regarding your second question, if the entry is not available in /scwm/aqua and you have only physic...¹.

I hope this helps. Let me know if you have any other questions.