Table name and Field name for remaining quantity after goods issuance

[dr]

Dear Experts, User wants to display the Issued Quantity (MSEG-DMBTR) and Remaining Quantity of a material in Goods Issue Number print out form in MIGO. We can find the Issued quantity (MSEG-DMBTR) for a particular material document in MSEG. In which table we can find the remaining quantity of Unrestricted Stock? Please help me with table name and field name...

Please help.

[BijayKumarBarik · Accepted solution]

Refer RESB table for withdrawal quantity on reservation

Cannot you decide with same table on calculation of total quantity minus withdrawal quantity is balance quantity to be issued!

[dr · Accepted solution]

In which table we can find the remaining quantity of Unrestricted Stock? Please help me with table name and field name...

Goods against for Reservation.

Can I use MBEW-LBKUM?

[BijayKumarBarik · Accepted solution]

As your requirement specific to reservation number and you need to use above mentioned reservation table for balance quantity having your own logic to subtract withdrawal quantity from total reservation quantity.

MBEW refer to material valuation for all*

[former_member197616]

Please check Mard table.

[sanilbhandari]

Hi ddsapanswers

I am hoping that you are talking about a sales order. If yes, the below should help you check it.

https://answers.sap.com/questions/7540771/from-which-table-can-i-display-pgi-material-and-qu.html

Best Regards

Sanil Bhandari

[dr]

No Mr. Sanil... In SAP MM.. Please help if you know the table and field name in MM

[sanilbhandari]

Hi ddsapanswers

Can you share specific details about your scenario? Do you need these details for a Sales Order or issue of RM to Production Order etc? If you are specific in question, than only you should expect the right answer. Currently, your question is very generic !

Regards

Sanil Bhandari

[dr]

User wants to display the Issued Quantity (MSEG-DMBTR) and Remaining Quantity of a material in Goods Issue Number print out form in MIGO. We can find the Issued quantity (MSEG-DMBTR) for a particular material document in MSEG. In which table we can find the remaining quantity? Please help me with table name and fiend name...

[sanilbhandari]

Hi ddsapanswers

May I ask you against which object you are doing Goods Issue for - Production Order, Process order etc. MIGO can be used for multiple things, however, the way data structured is designed depends on what process?
Best Regards

Sanil Bhandari

[dr]

Dear Mr. Sanil, We are doing goods issue against Reservation

[dr]

In which table we can find the remaining quantity of Unrestricted Stock? Please help me with table name and field name...

Goods against for Reservation.

Can I use MBEW-LBKUM