mb52 and dipping sequence number

[Former Member]

Hello experts,

If possible i'd like help in a sap query i'm trying to create

I need a query similar to mb52 transaction that gives me total stock for a material in a determined moment and the addition of a field that i can only find in zpp_conf_records the field is dipping sequence number.

The problem is that i can't replicate the mb52 transaction.

Any help for it?

thks in advance

[Prasoon]

Hi,

   You can not simply create a query and replicate MB52. If you just want the stock based on custom field, you may check whether you can enhance the report MB52 to add additional fields. Refer the similar thread: Can I add a column to an itab via ENHANCEMENT-P... | SCN

Regards,

AKPT

[JL23]

What is a "dipping sequence number" ?

MB52 gives current stock, for historic stock you have to use MB5B, and you will never achieve historic MB52 stock  with a simple query .

zpp_conf_records is a homemade table, nobody outside your company can know what this is and how it is used, so you better ask your colleagues inhouse to know more about this table

[Former Member]

Hello thks for the reply.

Yeah dipping sequence number is a parameter only for my company.

But any chance of replicating the mb52 in a query?

I can't reach the unrestricted stock value.

[JL23]

Look into that wiki to know how much stock tables SAP has: Stock Tables and Stock Types - ERP SCM - SCN Wiki

I would not be able to get the information from all those tables  together with a simple query.

Maybe your local business is just so simple that you can get all you need from one table, but this is not what we can usually assume.

And if I understood your question correct then you are even want historic information, and this means you need to add and subtract goods movements to calculate the hypothetical stock situation at a certain date in the past. SAP does not store inventory figures per each day in a year. For this you would anyway need a program, this cannot be achieved with a query.

[Former Member]

Maybe i didn't explain right reggarding the stock.

But i want the stock available in the moment i run the query, so for that i will also need to calculate the goods movements?

thks for the answer

[JL23]

no