in material issue for prod order having multiple prod. order by main item. i want to sum total by sub item wise. pls provide the solution

In 4c4 I would just select the main order in tisfc001 and link it to ticst001 and sum which ever quantity or cost I wanted - something like:

select tisfc001.mitm, ticst001.sitm, sum(ticst001.qucs)
from tisfc001, ticst001
where tisfc001._index = .....
and ticst001._index1 = {tisfc001.pdno}
group by tisfc001.mitm, ticst001.sitm

Of course with you having ln it could be different tables, etc.