Stock qty of serialized material in past period

[Former Member]

Dear MM gurus.

I’d like to retrieve stock qty of Serialized material in past period.

If current perio is Mar, I'd like to retrieve stock data of end of Feb.

In table MARD or MARDH, I could retrieve qty with stock type such as

“how many qty is unrestricted” and “how many qty is QI”.

However, there is no history table for serialized material.

So, I cannot know which serial number is unresricted or QI in Feb.

Table EQBS display only "Current status", not histrical status.

And, EQBS cannot create change document.

Is there any good way?

Yoshi

[former_member218251]

Did you have a look at MC.9 transaction? I think you can use that for this purpose.

[Former Member]

Hofman,

I couldn't find serial number information in MC.9.

Could you give me detail step?

Yoshi

[former_member218251]

You are right, I did not see the serialized part of your request. Sorry. And I assume IQ09 is not showing you the right stock levels, just the timing of the serial numbers?

IQ09 should be able in theory to do the trick, using the stock type (01, 02...) to see if it is unrestricted or blocked stock.

[Former Member]

Hofman,

Thanks.

As long as I tested IQ09, it displays "Current stock type" of serials, not historical one.

So, for example, if stock type was changed from "QI" to "Unrestricted" on 01/Apr/2015,

and even I specified the date on selection screen of IQ09 as "to 31/Mar/2015",

stock type of IQ09 is "Unrestricted", not QI, but actually stock status on 31/Mar/2015 was QI...

Yoshi

[former_member218251]

I think you will have to go create an ABAP report for this. You can use SER03 table with the tables as mentioned in this note: https://service.sap.com/sap/support/notes/193554

You will have to calculate back the stock levels per serial number, since SER03 only provides a history.

I think this is due to the way serial numbers are set up; Basically serial numbers do not have stock, it is the other way around (stock can have a serial number). For this there will be history for stock, and history for serial numbers, but the combination is not available.

[Former Member]

Hofman,

Thanks.

My problem is that in SER03, there is no stock type information.

So, if I create ABAP report, I have to identify from movement type

in SER03 how many serialized stocks is unrestricted or QI in particular period.

(But, if stock type is entered in MIGO directly, it might be difficult to identify from
movement type...)

Correct?

Yoshi

[JL23]

What do you actually want to achieve with such a report on past stock?

If you create a report for current stock and download it and look at it next month, then you  can see you past stock

I am actually serious with the question what such report is really giving to the user?

Do you plan to run this report for all your stock, or shall it just be an information for a single material (I am thinking about performance, SAPs standard MB5B is not even the quickest and it does not cover the serial numbers yet.)