工单上加版本信息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