Qlik Community

QlikView Connectors

Not applicable

SAP STOCK REPORT IN QV- similar to MB5B

Dear members,

In our company we are trying to make a stock report based on "MSEG" table of SAP in QV.  we had Successful down loaded  the MSEG and all the information is flowing correctly.

issue we are facing is

1. the data start date is 31.03.2008 and when we calculate opening stock on any given date it has to calculate from the date of initial upload(31.03.2008).

2. when a certain period is selected then  we should be able to calculate opening balance as on that date , receipts in selection period , issues in selection period and closing balance as on the end date.

I had tried few combinations but not getting correct values. Any input will be very helpful.

attaching the QVW for  reference.

Community Browser