1. a. Product engineering table BOM_table_master ID name EMger 001 cars 002 002 engine parts 003 003 chassis parts 003.1 003.1 sensor components 003.2.1 connector accessories 003.2.1 BOM query recursive query if an order has several products should be how to query BOM_Detail_part ID name parent_BOM 001 002 engine parts 001 003 chassis parts 004 engine cover 001 002.01 cylinder block of 002 002.02 piston ring of 002 002.03 piston driving arm of 002 002.04 inlet pipe of 002 003.1 sensor parts of 003 003.2.1 connector accessories, 003 003.2.2 solid 003 pieces 003.1.1 ABS induction line of 003.1 Allen 003.2.1 003.2.1.1 fasteners |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 11 Sep '13, 12:51
question was seen: 1,222 times
last updated: 13 Sep '13, 13:55
Does that sample from the docs help - it seems rather similar:
Parts explosion problem