Retrieve Serial Numbers for Stock

[Former Member]

HI Experts,

I have a report to implement: it is a Stock Aging Analysis report.

I have this problem when I want to tally the amount of stocks available for a certain material in a plant, the number of serial numbers are not the same with the tally.

I can see the Serial Numbers per material in tcode IQ03 but they had a lot of statuses on which I cannot tell if the serial number for that material should be defined as in stock or not.

1) Is it possible to tally the Serial Number available in the system for the Material with the available Material stock?

2) What are the in Stock Status (aside from ESTO) which I can consider that serial number as in Stock?

Thanks a lot!

[Former Member]

HI,

You try using IQ09 txn. there enter ur plant and Sloc.. It will show the Serial number based on Stk available at the Sloc.

Regards

GK.

[Former Member]

Used FM 'GET_SERNOS_OF_DOCUMENT' to get the Serial Numbers based on the Material Documents retrieved and get the status by FM 'BAPI_EQUI_GETSTATUS'. Since I have to get the Plant and Storage Location also, I have to do a query to EQBS.

[Former Member]

Hi,

Thank you for your answer. The entries EQUI does not indicate the Serial Numbers exactly that are in Stock especially when the Plant and Storage Location here are not maintained (I tried one material to get the serial numbers but unfortunately, the plant and storage location fields are blank)

[Former Member]

EQUI you can get the serial no detais. MMBE stock qty 4 means this table it will show 4 entries. Here you can get equipment

pass the equipment no in EQBS you can get the plant & stl loc.

Edited by: madansiva on Oct 27, 2010 9:48 AM

[Former Member]

Hi

Write a quey by joining two tables

EQUI and EQBS

EQUI is having the material number for that serial number

EQBS is the serial number stock table

in IQ09/IQ03 ESTO status indicates that the serial numbers are in stock

(in IQ09/IQ03 or EQBS consider 01 stock type as unrestricted,04 as intransit,07 as blocked,02 as quality inspection)

accordingly tally the material serial number stock with the MB52/MMBE stock report

Regards

Amuthan M

[Former Member]

You are able to get the serial nos through EQUI by giving the date range and material.

afterthat you pass the equipment no here you can get the plant and s loc.