tibom000 ti bom BOM Parameters
tibom010 ti bom Production BOMs
tibom020 ti bom Reference Designators
tibom030 ti bom Locations
tcibd000 tc ibd Segmentation Parameters
tcibd001 tc ibd General Item Data
tcibd002 tc ibd General Item Data (Defaults)
tcibd003 tc ibd Conversion Factors
tcibd007 tc ibd Item Costing Data
tcibd008 tc ibd Item Costing Data (Defaults)
tcibd011 tc ibd Cost-Component Structure by Item
tcibd012 tc ibd Effective Cost-Component Structure by Item
tcibd099 tc ibd Item Base Parameters
tcibd100 tc ibd Item Inventory
tcibd200 tc ibd Item Ordering Data
tcibd201 tc ibd Item Ordering Data (Defaults)
Multi Level BOM
select
tibom010.mitm, | Manufactured Item
tibom010.sitm, | Item
tibom010.pono, | Position
tibom010.seqn, | Sequence Number
tibom010.qana, | Net Quantity
tibom020.mitm, | Manufactured Item
tibom020.pono, | Position
tibom020.seqn, | Sequence Number
tibom020.lcid, | Location
tibom020.qana | Net Quantity
from
tibom010, | Production BOMs
tibom020 | Reference Designators
where
tibom010.mitm >= tibom010.mitm.f and
tibom010.mitm <= tibom010.mitm.t
order by
tibom010.pono,
tibom010.seqn
Sigle Level BOM
正在整理中!

订阅我的BLOG(RSS)