cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete the Initialization records in 2LIS_03_BX

Former Member
0 Kudos

BW3.5 - R/3 4.6c - LO-Cockpit - SCM Implementation - Inventory Management 0IC_C04 InfoCube.

I wanted to use 2LIS_03_BX and RSA3 was showing zero records. I ran MCNB to collect records for this extract and it collected 815000 stock records. When I checked the extractor, I realized that the zero quantity records were not exactly what I was expecting for. I was looking for zero quantity records for valid/active bins. But it seems that we are receiving 100's of zero quantity record for every material that we don't really care for anylonger. I definitely want to see the zero quantities in case the bin is active but we've just run out of material.

I turned off the zero quantity collection in MCNB but at the end of run, it only over writen the 815000 records rather than deleting them all and collecting about 70,000 entries as expected.

My question is how can we delete the results of a previous initialization of open stock transfer structure (trans# MCNB)so I can run it again?

I'll appreciate any hints or comments.

Thanks a lot.

Bilal

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi bilal,

do u mean deleting the initial stock setup table for Inventory then in that case use Tcode OLIX and then give ur table name and delete versions.

Hope this helps

Anand Raj

former_member483612
Participant
0 Kudos

Hi,

I assume using OLIX, we will be able to delete the data from either 2LIS_03_BX or 2LIS_03_BF. As opposed to using LBWG, where if we select '03' the data is cleared off from the set up tables of both datasources.

If that is true, could you please mention the 'Info structure' to be used in OLIX for 2LIS_03_BX and 2LIS_03_BF?

Thanks a lot.


Regards,

Sri.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi...In SBIW theres a section in Parametrization for Data Sources->Logistics->Extraction Structures->Initialization->Delete Setup Tables There you set Application 03 and then delete the setup tables for 03 datasources...

Regards

Former Member
0 Kudos

Hi,

Please peform a LBWG with application component 03 and it will delete all records from set up tables of 2LIS_03_BX and 2LIS_03_BF.

Probably the run an init process with your correct choice of selection would fetch in the correct records.

Cheers

Raja