Skip to Content
0
Former Member
Jun 18, 2010 at 11:33 AM

FETCHING SERILA NUMBERS ON THE BASIS OF WAREHOUSE AND STATUS IN SAP 8.8

21 Views

Hi

I have following questions regarding serial number :

Firstly , whether OSRI table in sap8.8 has been made obsolete ?

secondly , I noticed that the STATUS field in table OSRN is not getting updated when an inventory transfer is made for a specific serial number of an item but the status field in OSRI table gets updated to value 1 .

Earlier status field in OSRI could have 0 or 1 value (0 to indicate that the serial number is present in the warehouse mentioned in WHSCODE field and 1 to indicate that the serial number has been transfered to some other warehouse and is not in the ware house mentioned in WHSCODE field).

So, If I need to fetch the all the serisl numbers of an item which are present in lets say X warehouse and having status set to value 0 then do I need to apply Join with OSRI table .I mean is it correct to have join with OSRI table or not?

please reply me back as soon as possible.

Regards

Mandeep