cancel
Showing results for 
Search instead for 
Did you mean: 

Base table for BWVORG , BWAPPLNM , STOCKRELEV , CPQUABU in 2LIS_03_BF

Former Member
0 Kudos

Hi,

We are having an issue in BW. In source using MMBE tcode , it is showing unrestricted stock quantity 0 but where as in BW it is showing as 1. I went to find the base table which is feeding data to 2LIS_03_BF datasource in BW. MSEG is the base table. But in this datasource there are few fields like BWVORG , BWAPPLNM , STOCKRELEV , CPQUABU for whic logic is written like BW enrichment. Not sure what is the logic to populate this in BW side.

I just want to recheck in the base table what is the actual value for unrestricted stock in those tables.

Can anyone help me on this.

Thanks,

Snehasish

Accepted Solutions (1)

Accepted Solutions (1)

former_member186399
Active Contributor
0 Kudos

Dear Snehashish,

I think first you should check what has resulted in material showing 1 as inventory in BW. Check the movement type and stock type which has resulted in the inventory. In some cases you should not be considering the consumption stock or stock transfer stock as part of your inventory.

Regards

Gajesh

Former Member
0 Kudos

Thanks Gajesh for the reply.

I have checked in the lowest level of bw. In stock is showing 1502 and out stock is showing 1501. I have the data. Now I just want to cross check with source why it is showing as 0 in source. In MMBE tcode, I have seen for that particular material and plant combination UNSTOCK is showing as 0. Now I want detailed information in source to see when it becomes 0 in source. May be I have missed delta in bw so I just want to cross check with source why it is showing 0 and whether I have missed any delta from source in bw or not.

former_member186399
Active Contributor
0 Kudos

Hello,

Kindly check based on material document no , you can check BW material document and then with MB51 for the same material.

Regards

Gajesh

Former Member
0 Kudos

Hi Gajesh,

Thanks for your response. I went to MB51 tcode and able to find the material doc no which is missing in BI side. Done set up table fill up for that particular mat doc no and loaded repair full in bi side. Now the report is displaying proper sap value.

Thanks for your help.

Regards

Snehasish

Answers (0)