2LIS_03_BX - How to Query Stock Init Values

[sap_cohort]

Hi,

I have just loaded/Initialized 0IC_C03 Inventory InfoCube with 2LIS_03_BX and would like to set up a query for users to validate just the Stock Init Values. From what I can tell it looks like Stock Init Values are not available for query due to record type 1.

Is there any way around this so I can have my users report and validate the 2LIS_03_BX Stock Init Values with a BW Query? (without having loaded 2LIS_03_BF)

Thanks!

[mahesh_mahi · Accepted solution]

Hi kenneth,

BX -- Data source is used for extracting an opining stock balence.

1. Do the Initialization of the stock(opining balence ) in ECC system T- Code MCNB.

2. Filling of setup tables.

3. After Initializing check the data source opening balence.

4. Run the infopackage.

5. After getting the request into cube compress the request containing the opening stock that was just uploaded.

Make sure the " No marker update " indicater is not set In Collapse tab.

After that ypur report.

All the best...........

Thanks & Regards,

Mahesh.

Edited by: mahesh mahi on Dec 21, 2011 5:47 AM

[anshu_lilhori]

Hi,

Please compress the request with marker update and once you are done with it then try making a query on cube.

Check if it works or not.

Hope it helps.

Regards,

AL