topic Re: Quantity at storage location in Application Development and Automation Discussions

Quantity at storage location

Former Member — Wed, 06 Oct 2004 15:44:59 GMT

It must be simple, but we just can't find the BAPI call to get the current quantity on hand for a particular material in a specified storage location in MM. Does someone know the call?

Thanks.

Re: Quantity at storage location

nablan_umar — Wed, 06 Oct 2004 16:18:54 GMT

Have you tried BAPI_MATERIAL_GET_ALL?

Re: Quantity at storage location

Former Member — Fri, 08 Oct 2004 20:16:53 GMT

We have looked at this but cannot find the quantity as displayed on the Stock Overview screen. We are looking for the unrestricted use stock. Are we just overlooking something?

Re: Quantity at storage location

RichHeilman — Sat, 09 Oct 2004 21:51:28 GMT

these values can be found in table MARD.

Regards,

Rich Heilman

Re: Quantity at storage location

Former Member — Mon, 11 Oct 2004 07:24:02 GMT

Hi,

Rich is right; just a complementary remark: in case you also need figures from other periods than the previous period you van use FM 'MARD_EXTEND'.

Regards,

John.

Re: Quantity at storage location

Former Member — Tue, 12 Oct 2004 14:38:30 GMT

Thank Rich. We did find these values in the MARD table, but when we access this table using .NET Connector and TABLE_READ_ALL function we get the following errors:

ASSIGN_CASTING_UNKNOWN_TYPE CX_SY_ASSIGN_CAST_UNKNOWN_TYPE

ASSIGN_BASE_WRONG_ALIGNMENT

Any suggestions?

Re: Quantity at storage location

Former Member — Tue, 12 Oct 2004 14:41:48 GMT

We have also tried the RFC_READ_TABLE function with the same results.

Re: Quantity at storage location

nablan_umar — Tue, 12 Oct 2004 15:06:39 GMT

The size of MARD is probably longer than 512 bytes, the size of returned internal table DATA from function module RFC_READ_TABLE.

Re: Quantity at storage location

Former Member — Tue, 12 Oct 2004 17:44:57 GMT

Nablan:

Any other way to get this data with .NET Connector?

Dean

Re: Quantity at storage location

RichHeilman — Tue, 12 Oct 2004 18:09:05 GMT

Oh...never used .net connector.....just jCo. I'm assuming that they are pretty much the same, so my suggestion, if .net can not handle it, is to create your own RFC enabled function module with your import parameters, MATNR WERKS LGORT and exporting only the fields that you need. In the function module source, just hit table MARD with your parameters. Then just call this Function module in your .net program.

Good luck,

Rich Heilman

Re: Quantity at storage location

nablan_umar — Tue, 12 Oct 2004 18:47:50 GMT

Just do like what Rich suggested. Create a custom RFC function module that just read the fields you want in MARD.

Re: Quantity at storage location

Former Member — Tue, 12 Oct 2004 18:59:35 GMT

Thanks all. I was hoping for another solution, but we'll work on this.

Dean