Hi,
I have generated a query in sq01 for list material document for movment type 301 (Transfer posting) using below tables :
MSEG Material No. MATNR, Movt. - BWART, Qty. -MENGE
MKPF Material doc. field MBLNR
MARC Stock in Transit UMLMC
some times it is generating the output as i want i.e.
Material document material no. qty. movt. stock in transit
4001 1xx 1 301 0
4002 2xx 2 301 0
but some time it is repeating the same line in output ie..
Material document material no. qty. movt. stock in transit
4001 1xx 1 301 0
4001 1xx 1 301 0
4001 1xx 1 301 0
4001 1xx 1 301 0
Please let me know the reason. is there any control in sq01.
Thanks