Consignment stock changes

[Former Member]

Dear All expert,

I meet a problem about the consignment stock changes.

I need find the consignment stock changes (every day not every period).But I do not want to process the stock movement, because in our system the MSEG is too huge.

Do you have any suggestion about this topic ?

[Former Member]

Hi,

1/Create custom table ZTXX that will have save consignment stock at the end of day

MATNR

day

Stock

2/Create program ZRXXX that will save at the end stock level to table ZTXX

3/Create background job runnig program ZRXXX daily

4/Find how far history you need keep story about changes

5/Delete records in table ZTXX, that older then required, it keep table not to grow and be selectable in fast time, put it to ZRXXX program

Bye Jan

[Former Member]

Thanks for your reply.

But if I did in this way, I need process 5000 customer and 2000 material number totally 1000,000 records every day to compare and find what were changed.

It will cause performance problem

[Former Member]

Hi Edward,

you don't need to process daily 1000000 records.

Your program has to go just through MKPF and MSEG for current day and maybe you can filter by movement type or other nearowing criteria. Then you will get list of materials that were change current day and it will be probably significamntly less materials and customer combination and you just post changes for this materials, that were change current day.

Bye Jan

[Former Member]

Hi,

I already metioned for our company MSEG is too huge.

By the way,for mkpf we can not link it with material number customer number and movement type.Then I need process it with posting date or some other date.It will create performance issue.