topic Re: Consignment stock changes in Application Development and Automation Discussions

Consignment stock changes

Former Member — Wed, 27 Oct 2010 02:18:29 GMT

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 ?

Re: Consignment stock changes

Former Member — Thu, 28 Oct 2010 06:31:06 GMT

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

Re: Consignment stock changes

Former Member — Fri, 29 Oct 2010 00:51:29 GMT

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

Re: Consignment stock changes

Former Member — Fri, 29 Oct 2010 05:50:45 GMT

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

Re: Consignment stock changes

Former Member — Fri, 29 Oct 2010 07:44:28 GMT

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.