select LMS_NO , ITEM_NO ,
    sum(LEGAL_I_QTY) 入库数,
    sum(LEGAL_O_QTY) 出库数,
       sum(LEGAL_I_QTY-LEGAL_O_QTY)  理论库存 
from ecssent.STORE_BILL_GOODS_LIST 
where  LMS_NO = 'S4611I000207'
       --and item_no = 'D00135702006073' and 
       AND INPUT_DATE >= to_date('20140910', 'yyyyMMdd')
       AND INPUT_DATE <= to_date(CONCAT('20150909', '235959'), 'yyyyMMddHH24miss')
group by  LMS_NO,ITEM_NO
order by item_no


带计量单位的账册统计，可能会有重复

select a.* ,b.unit from 
(select LMS_NO , ITEM_NO ,
    sum(LEGAL_I_QTY) 入库数,
    sum(LEGAL_O_QTY) 出库数,
       sum(LEGAL_I_QTY-LEGAL_O_QTY)  理论库存 
from ecssent.STORE_BILL_GOODS_LIST 
where  LMS_NO = 'S4611I000207'
       --and item_no = 'D00135702006073' and 
       AND INPUT_DATE >= to_date('20140910', 'yyyyMMdd')
       AND INPUT_DATE <= to_date(CONCAT('20150909', '235959'), 'yyyyMMddHH24miss')
group by  LMS_NO,ITEM_NO
order by item_no) a,(select distinct m.lms_no, m.item_no,m.unit from  ecssent.STORE_BILL_GOODS_LIST m) b
where a.lms_no = b.lms_no
and  a.item_no = b.item_no ;