Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inventory load with 2lis_03_bf 2lis_03_bx to 0ic_C03 doesn't work in BI 7

Hi Experts

I've implemented the inventory How to in several projects without any problem, but always on BI 3.5, never in BI 7.

I'm working with BI 7 (cube 0ic_c03 and standard transformations -no update rules- ) after loading I get unexpected data. Is there any new issue that should I address when loading inventory in BI 7, as I said I've performed the load before an never had an issue.

Mi steps (as they are performed in R3dev, there is no problem with closing the system, inventory almost never is updated, only when I request a movement for testing) are:

In R3

0. Delete previous data: TC lbwg, application 03.

1. Stock initialization: TC MCNB, structure 2lis_03_bx, system is closed during this run

2. Statistical setup of mat movements: TC OLI1BW or sbiw path

3. further check with TC LBWQ in case there were stock movements.

In BI

3. Load initial stock: datasource 2lis_03_bx (i have transformations and DTPs)

4. Compress request with marker update (check box not selected)

5. Delta init for 2lis_03_BF; compress the request WITHOUT marker updated (check BOX SElected)

And that's it, right?

What I've noted is that after compressing 2lis_03_BF, the data in 0IC_C03 is messed up.

If I load only 2lis_03_Bx and compare with R3, stock figures match

If I load only 2lis_03_Bf ins and outs match with those of R3

But if I load both bx and bf and perform compression as stated above data is messed up in the cube

thank you for any clue on this

regards

Former Member
Former Member replied

Hi,

See

Treatment of historical full loads with Inventory cube

Setting up material movement/inventory with limit locking time

The steps in BI 7.

In R3

0. Delete previous data: TC lbwg, application 03.

1. Delete Queue in LBWQ/SMQ1 related to 03.

2. Lock the system, don't allow any transactions from Users.

3. Stock initialization: TC MCNB, structure 2lis_03_bx. (Here Select All Stocks(Including Non-Valuated)).

4. Statistical setup of mat movements: TC OLI1BW or sbiw path

5. Statistical setup of mat movements: TC OLIZBW or sbiw path for 2LIS_03_UM load.

In BI

0. Load initial stock: datasource 2lis_03_bx using InfoPackage and then Run DTP with the following options.

In DTP: Extraction Tab--->Extraction Mode = Initial Non-Cumulative for Non-Cumulative..select this and then Execute.

1. Cube>Manage>Collaps-->Don't select "No Marker Updating indicator" and then compress.

2. Load 2LIS_03_BF and 2LIS_03_UM Initial runs using InfoPackages and then Cube>Manage>Collaps-->Select "No Marker Updating indicator" and then compress.

Now check the data with MB5B In ECC and recon data with Report on 0IC_C03 Cube.

Thanks

Reddy

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question