Hi Guys,
i need your suggestion for a query i'm creating.
this query is needed to retrieve data regarding the stock.
now i've created a query based on table MCHB MCH1 MAKT MSEG
my customer wants that all the batches that have been used and have not a stock balance should be excluded from the results.
my query extracts also the mov. type and i can include a new field to add the - symbol but the batches are not excluded because the movement type have a quantity.
so i've tried to add the MARD table to have the stock but the query extract the same values for all the batches for example:
material xxxxxx with 3 batches 1 2 and 3
batch 1 is empty batch 2 is empty and batch 3 has 10 kg.
now my query will extract this material with this batches with all the movement type but with stock 10 kg for all the batches.
do you have any idea? how can i exclude all the batches that have stock 0?
thanks
C.