topic Re: Checking Material Stock ? in Application Development and Automation Discussions

Checking Material Stock ?

Former Member — Fri, 24 Jun 2005 18:36:59 GMT

Hi All,

I think this question is little bit functional.And my question is :

"How can i check for a given Material there is Stock ?"

Regards,

vamshi

Re: Checking Material Stock ?

RichHeilman — Fri, 24 Jun 2005 18:41:04 GMT

Transactionally,.........MMBE

Programmically...........the data is keep in table MARD. For sales order stock, the table is MSKA.

Regards,

Rich Heilman

Re: Checking Material Stock ?

Former Member — Fri, 24 Jun 2005 18:47:56 GMT

Hi,

Thanks Rich. And can you please tell me how can i check if there is any Open Purchase Order / Sales Order for the given material.

I think we have to check this things before blocking a material....

Regards,

vamshi

Re: Checking Material Stock ?

RichHeilman — Fri, 24 Jun 2005 18:54:58 GMT

Whoa, that's going to be a little more difficult. You would have to look at the po tables, EKKO, EKPO, EKET for that material and the sales order table VBAK, VBAP. Don't think that there is an easy way to determine if a PO is open or not, same with a sales order. It really depends on your companies business process. Example, one company way say that the PO is closed at the time that you recieve everything on the PO in full, another company may say the PO is close after you pay for the goods on the PO.

Regards,

Rich Heilman

Re: Checking Material Stock ?

Former Member — Fri, 24 Jun 2005 19:14:27 GMT

Hi Rich,

I am asking you some more queries regarding this.

we are basically doing an integration project where

I have an option for Blocking a Material in Purchase View and Sales View

As per our client requirement he is asking for the following things to be checked before blocking a material :

1. Check for a given Material there is Stock.

2. Check for a given Material there is open Purchase Orders / Sales Order.

3. Check there is a valid BOM's, Routings, Selling Price, Info record and Inspection Plan for a given Material.

Is this possible....

Thanks & Regards,

vamshi

Re: Checking Material Stock ?

RichHeilman — Fri, 24 Jun 2005 19:35:57 GMT

Sounds like a huge task.

Anyway here are some more tables.

Bill of Materials, - MAST, STKO, STPO

Routings, - MAPL, PLKO, PLPO.

Info Records, - EINE, EINA.

If selling price is standard price, then you can find that in table MBEW.

Not sure about inspection plan.

Regards,

Rich Heilman