Problem with consignment stock in 0IC_C03 report
I am creating a stock report which includes "unrestricted stock" "Subcon Stock" , "Stock in Transit" "consignment stock " ect...My BW report is based on CALDAY and has a breakdown on storage location. I am getting perfect QTY for all other stock status but "consignment stock " in BW is incorrect .
I am using a restricted key figure for consignment stock where I am restricting the valuated consignment stock QTY "0CNSSTCKQTY" with Stock category "K" and calday.
If I remove the storage location from row in BEX query , I get the correct QTY at plant level. Only the QTY at storage loacation level is incorrect .
MY question :-
1. Is it possible to get the conssignment stock QTY at storage location level .
2. If yes , Is it possible that I can conmbine that in inventory stock report with othere stock status.
It's really very urgent. It would be really great if you can help me out in this.