Skip to Content
author's profile photo Former Member
Former Member

What is the impact 2LIS_03_BF first than 2LIS_03_BX?

Hi,

During init of Inventory Cubes, two extractors are actively

involve (2LIS_03_BF and 2LIS_03_BX). But the question is are they interchangeable? Can BF go first then BX or it should be strictly BX first than BF???

--Jkyle

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2005 at 08:22 AM

    Hi Jkyle,

    2LIS_03_BX replaces the function of datasource 2LIS_40_S278 and is used to extract the stock data from MM (and not from the tables MSEG or BSEG) for initialization to a BW system.

    Instead, 2LIS_03_BF is used to extract the material movement data.

    When you want to use both extractors (inventory management with non-cumulative KF), you have to start with the opening balance, that is with 2LIS_03_BX !

    Take a look to the doc in www.service.sap.com/BW -> SAP BW InfoIndex -> How to... Handle inventory management scenarios in SAP BW 3.x (pdf) in which all stock init procedure(s) and scenarios are explained in detail.

    Hope it helps !

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jkyle,

      MCNB and OLI1BW can run together without problem (as already mentioned, BX doesn't work on MSEG and BSEG tables...).

      However, take a look to SELECT statements into ABAP programs behind setup transactions to have a better view of the entire process...

      Hope it helps !

      Bye,

      Roberto

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2005 at 09:11 AM

    Hello Jkyle,

    the BX loads a SnapShot of a certain stock from R/3.

    BF loads the movements.

    BX can initialize the delta.

    The delta is loaded after this via BF!

    The V2/V3 booking needs to be stopped via loading the BX, so no movement can be created in R/3 to ensure the data quality.

    This is the reason, why the BX should always loaded BEFORE BF!

    Kind regards

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You are right. I reread my procedures, sorry I was not precise.

      You can <i>extract </i>in parallel, and <i>load </i>to the PSA in parallel. But you must load from the PSA to the cube and compresss (with the markers as I mentioned) ONE AT A TIME, to avoid what you noticed happening (or at least with the same 'no marker update' per run).

      This is becasue the 'no marker update' flag is not a setting for each load, but is a setting that is fixed for the cube(you set/reset it each time you change it) that can also be transported (for example, if your system is non modifiable, you have to transport the setting). So any compression is done with the current setting.

      I also found this out the hard way (which is why I'm pleased to write this to help you)!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.