Multi level BOM

[Former Member]

I need the multi level Bill of material as per attachment, please help me

		Item	Item Description	M/P	UoM	Quantity	Price	Amount	L	W	T	Wt	Material	Type	Comments
		101000471	A13108P054008 POW BEAM M150 1.6 - 2200MM (50mm WELDING) WITH L BRACKET	M	NO	1	975.35	975.35	100	150	10	6 Kg	HDPE	Frame
2		201000337	A13108P054007 BEAM M150 1.6 - 2200MM (50mm WELDING) WITH L BRACKET	M	NO	1	876.11	876.11	100	150	3	3 Lg	HDPE	Frame
	3	201000340	CB15021941603 C BEAM PROFILE 150 1.6 - 2194MM	P	NO	2	320.58	641.16	100	200	10	6 Kg	HDPE
	3	201000015	MBR4024503004 BEAM END CONNECTOR RIGHT M	P	NO	1	22.22	22.22	200	150	10	8. Kg	LD
	3	201000014	MBL4024503004 BEAM END CONNECTOR LEFT M	P	NO	1	22.22	22.22	180	150	10	2 Kg	LDPE
	3	201000341	A13108P055003 L-BRACKET 180X110X5	P	NO	2	55.94	111.88	100	150	10	2. Kg	HDPE
	3	501000021	Electricity Cost for Welding	C	MIN	10.75	4.56	49.02
	3	501000022	Labour Cost for Welding	C	MIN	11.75	2.52	29.61
2		301000118	RAL2001000008 POWDER RAL 2001-ORANGE	P	KG	0.196	160	31.36	180	150	10	1.5 kg	LTPE
	3	501000029	Electricity Cost for 30TN Press	C	MIN	0.392	4.19	1.65
2		501000007	Power coating  process charge 0-6 mtr / Sq Mtr	C	SqMtr	1.002	64.6	64.73
2		501000009	Power coating  Transport charge 0-6 mtr / Sq Mtr	C	SqMtr	1.002	11.54	11.57

[kothandaraman_nagarajan]

Hi,

Any update?

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Any update?

Thanks & Regards,

Nagarajan

[Former Member]

Provide you contact number, I will call you.

My number is 9845721048

[kothandaraman_nagarajan]

Hi,

Sorry. We can discuss through forum itself.

1. Do you want create BOM as above?

2. Do you want query to pull multilevel BOM?

Thanks & Regards,

Nagarajan

[KennedyT21]

Hi Anantha...

Try This

SELECT T0.[Father] as 'Assembly',T0.[code] as 'Component1', t10.[ItemName] 'Description1',T1.[Code] as 'Component2', t11.[ItemName] 'Description2', T2.[Code] as 'Component3', t12.[ItemName] 'Description3', T3.[Code] as 'Component4', t13.[ItemName] 'Description4',T4.[Code] as 'Component5', t14.[ItemName] 'Description5', T5.[Code] as 'Component6', t15.[ItemName] 'Description6' FROM ITT1 T0 LEFT OUTER JOIN ITT1 T1 on T0.Code = T1.Father LEFT OUTER JOIN ITT1 T2 on T1.Code = T2.Father LEFT OUTER JOIN ITT1 T3 on T2.Code = T3.Father LEFT OUTER JOIN ITT1 T4 on T3.Code = T4.Father LEFT OUTER JOIN ITT1 T5 on T4.Code = T5.Father LEFT OUTER JOIN ITT1 T6 on T5.Code = T6.Father left outer join oitm t20 on t0.father = t20.itemcode left outer join oitm t10 on t0.code = t10.itemcode left outer join oitm t11 on t1.code = t11.itemcode left outer join oitm t12 on t2.code = t12.itemcode left outer join oitm t13 on t3.code = t13.itemcode left outer join oitm t14 on t4.code = t14.itemcode left outer join oitm t15 on t5.code = t15.itemcode

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Please advice your exact requirement.

Thanks & Regards,

Nagarajan