工单上加版本信息

query:

select        tisfc001.pdno,         | Production Order        tisfc001.mitm,         | Item        tcibd001.citg,         | Item Group        tisfc001.osta,         | Order Status        tisfc001.qrdr,         | Quantity Ordered        tisfc001.qtdl,         | Quantity to Deliver        tisfc001.qdlv,         | Quantity Delivered        tisfc001.qrjc,         | Quantity Rejected        tisfc001.efdt,      |referce date        tisfc001.prdt,         | Production Start Date and Ti        tisfc001.dldt          | (Re) Planned Delivery Date from        tcibd001,              | General Item Data        tisfc001               | Production Orders  |tiedm100 where        tisfc001.mitm >= tisfc001.mitm.f and        tisfc001.mitm <= tisfc001.mitm.t and        tcibd001.citg >= tcibd001.citg.f and        tcibd001.citg <= tcibd001.citg.t and        tisfc001.efdt >= tisfc001.efdt.f and        tisfc001.efdt <= tisfc001.efdt.t and

       tisfc001.mitm = tcibd001.item and        tisfc001.osta <> tcosta.closed and        tisfc001.osta <> tcosta.completed order by        tisfc001.mitm

report script:

declaration:  table ttiedm100 |engineering item revisions  table ttisfc001 |production orders extern domain tiedm.revi order.revi

Detail.1: before.layout:  order.revi = ""  select tisfc001.efdt  from tisfc001  where tisfc001.pdno = :tisfc001.pdno  selectdo  endselect   select tiedm100.revi  from tiedm100  where tiedm100.eitm = :tisfc001.mitm and   tiedm100.indt <= :tisfc001.efdt and   (tiedm100.exdt >= :tisfc001.efdt or tiedm100.exdt = 0)  selectdo   order.revi = tiedm100.revi  selectempty  endselect