Skip to Content
avatar image
Former Member

2LIS_03_BX

Dear All,

Is there a solution to load the stock initialization from 2LIS_03_BX, if it is not possible to block the postings during this initialization (MCNB) ? Since there will be postings during this initialization the stock initialization might be wrong.

Hence wanted to know if its possible to write a custom extractor for the stock initialization, similar to 2LIS_03_BX, but which could have the posting date as one of the parameters, so that the stock could be initialized for a date in the past, so that we do not have to worry about the postings done during initialization.

Tried to go through the code for MCNB, but was quite complex. Hence wanted to know if someone has created such a custom extractor, or knows the steps to get the stock qty and value for a material on a certain date ?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 22, 2008 at 03:08 PM

    Dear Dabre,

    I suggest instead of creating a new extractor, create a ODS/DSO and load in overwrite mode. this way you can easily manage and good for any recovery later.

    Or try loading using flat files...

    For historic moments(using BF) also posting has to be stopped.

    Or Instead of pulling BX and BF, you can pull only BF and compress with Marker update, you will get same result(try it out).

    Hope it Helps

    Srini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Srini,

      Thanks again. Even if the material movements are not archived, the issue is loading all the history to initialize the stocks correctly. We have around 400 million records in MSEG and hence we would like to avoid the entire history if possible. Also flat file as well since it might be a bit difficult to maintain this from an administrator point of view.

      Yes, inaddition to the transactions mentioned by you another transaction that i found was MB5B which gives the stock qty and value on a given posting day. But again the logic was a bit complex to follow in ABAP and hence thought of asking if anyone has done this before.

      Best Regards.

  • avatar image
    Former Member
    Sep 22, 2008 at 10:44 PM

    Hi,

    For BX, try to load a plant in the middle of the night when transactions should be low to none. Also, if you have downtime for backups, system maintainance on weekends, see if you can extend the window to cover your initialization. If it still takes a long time, try initializating two or three plants at a time (it should be much faster that way).

    For BF, you can pre-load all historical periods from 2 periods back (e.g., today = period 4/2008; load beginning of time up to 2/2008). You can do this on most systems since the current and previous periods are usually the only open periods (meaning you can no longer post a material document in a closed period). With the historical periods pre-loaded, you only need downtime for the current and previous periods. This will save you a major amount of time.

    I once chanced a reinitialization over a weekend ... and got very lucky! No postings during a two-hour window. You can find your double postings by running a delta right after your initialization. Check that delta run against your initialization and see if any of the documents are duplicates.

    Of course, since I do not know anything about your system, it is difficult to give specific help. Items that would help us out even more are: 1.) How long is too long? 2.) How many Plants? International/single country/single timezone/single plant? 3.) Continuous Operations (24/7) or 9-to-5? 4.) Approximate number of material docs created per month?

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Brian,

      Thanks for the reply.

      Another option that we are currently looking at is to intialize the stocks for a period in the past. This would help in not worrying about the downtime and the backpostings.

      Was trying to check the logic how the 2LIS_03_BX tries to get the current stock values. The code seems pretty complex, but does anyone have an idea on how this could be done. Or the logic in extracting the stock values at a given point in time.

      Thanks.