Skip to Content
author's profile photo Former Member
Former Member

Multi level BOM

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
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jan 22, 2014 at 07:12 AM

    Hi,

    Please advice your exact requirement.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 22, 2014 at 07:52 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 28, 2014 at 09:14 AM

    Hi,

    Any update?

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 17, 2014 at 08:24 AM

    Hi,

    Any update?

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.