How to calculate the acutal qnty
we are on BI 7.0 and ECC 6.0...we are using the 2lis_11_vakon and vaitm data sources . Now we have to report the quantity as nr of items ( which we are getting from KWMENG) in to BI. This KWMENG value is coming from VBAP table and there is some internal calculation for this. When we extract the data from ECC we are getting this value including the spares. but we want to exclude the spares when we display the report...Does any one know about how it works...I mean how to find the exact qty excluding the spares...