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

[Former Member]

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

[former_member204969]

The serial and batch management tables changed for the 8.8. See this document:

[https://websmp204.sap-ag.de/~sapidb/011000358700000682562009E.pdf]

[Former Member]

The mentioned link is asking for username and password

what information am i suppose to provide here ?

I am not able to access the mentioned document .

Regards

Mandeep

Edited by: mandeep mann on Jun 18, 2010 2:44 PM

[former_member204969]

Yes, it requires S-user id and password.

[Former Member]

I entered my sap portal login id and password but its not working .

is there any other id that i need to get or can you send this document copy at the following email address.

email Id :mandeep.mann26 at hotmail.

Regards

Mandeep