Skip to Content


Jan 26, 2017 at 05:34 PM


avatar image

Hello Experts,

I'm developing a report on MM Inventory management. System SAP BW/HANA 7.4 SP 13 / Eclipse Tool.

I have loaded data for 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM and I'm looking for the following:

1. How to get or calculate initial balance is this the value for 0RECTOTSTCK IN 2LIS_03_BX or is this

something I have to calculate? if so, how do I do that with formula? Where do i write this formula

universe or report level in webi?

2. Part of the requirements is to calculate the future Total receipts over the next 12 months based on

field DELKZ(MRP ELEMENT INDICATOR). The values I have to select from this field for this calculation

are; PA, BA, BE, LE, FE, and LA. This data is based on custom data source and target is ADSO. I'm

using IDT to create universe and finally export this to Webi. So would I write the formula for this

at universe level or report level in Webi?
I have searched this site most of the web references are not working(page can't be opened) and I can't find any answers.

Thanking you in advance for your help!


10 |10000 characters needed characters left characters exceeded

**PS: So the date range for the future receipts has to be dynamic where it can calculate the next 12 months regardless of when it's being do I do that?


And the other fields I need for future receipts are ZDELKZ (MRP Element) , DAT00 (receipt/ requirement date), WERKS (Plant) and MATNR (material number)

* Please Login or Register to Answer, Follow or Comment.

0 Answers