BOM - Child product lines instead of further product

[shahafei2]

Hi all,

I'm loading  3 tables as part of my script(As describe below)

My question is, if there is a way to replace in one table only a field and to generate new lines according to the BOM 

for example :

BOM

product ID =1

BOM = 123

Child product: 11

Child product Quantity: 2

product ID =1

BOM = 123

Child product: 12

Child product Quantity: 5

I would like to replace the Order Lines that contains Product ID = 1

and to present the child products instead 

so instead of 

Orders

Order ID = 1234

ProductID = 1

Quantity  = 1

Ill see 

Orders

Order ID = 1234

ProductID = 11

Quantity  = 2

...

Order ID = 1234

ProductID = 12

Quantity  = 5

...

The data structure:

Item master data

Product ID

Dimensions 

Regulation information

BOM Control (Y/N Field)

Etc.

BOM

Product ID

BOM ID

Child product

Child product Quantity

Orders

Order ID

ProductID

Quantity 

CustomerID

Etc.

[marcus_sommer · Accepted solution]

Maybe this helpful in any way: Bill-of-Materials.

- Marcus

[shahafei2 · Accepted solution]

Thanks,

I solved it with simple left join between the order  and the BOM tabels

and than i replaced the product ID with the Child product

and the Quantity   with Quantity  * Child product Quantity

for not isnull (Child product)