Formula in getting the exact quantity

[#1]

Hi all,

Good Day

Im new in qlikview please help me how to get the exact report.

This is my qvw file.This is my concern.the DELIVERY QTY. has a exact qty.my problem is the QTY REDUCED are not tally.but the others are correct qty.

To make my concern clear...When i select the puchasing doc 4600005585 the delivery qty and the qty reduced are all tally based on the report of SAP.but when i select the puchasing doc 4600003085 the delivery qty is correct qty but the qty reduced are not.

i dont know how to get the exact qty in QUANTITY REDUCED.i already mix my script but i dont get what i need to see in my report.

And also how to get the total qty in delivery qty , qty reduced and the picking qty.This is also my problem.

Please help me.

Thank you so much for your help.

Teles

[#2]

Hi,

No MATNR field name in EKES table.

Teles

[#3]

Hi,

My Problem with this concern is what should be the Material Number in quantity reduced (DABMG).

I think this should be what i need to be able to identity and get the rows of the different material number .

What should be the TABLE NAME for that?

Thanks for helping,

Teles