Product Structure Cost Analysis

This query report will give extend out the costs of each assembly.

select assy_product_code "Assembly", pa.description_1 "Assembly Name", sequence_code "Seq",
  comp_product_code "Component", pc.description_1 "Compenent Name",
  pa.standard_cost "Assembly Cost", qty_assembly "Qty",pc.standard_cost "Comp Unit Cost",
  pc.standard_cost*qty_assembly "Comp Ext Cost"
from artprstr s
  inner join artprod pa on pa.product_code = s.assy_product_code
  inner join artprod pc on pc.product_code = s.comp_product_code
where artprod.plant_no = :PLANT 
order by assy_product_code,sequence_code

Break/Group:

1/1: Assembly,Assembly Name

Total:

Comp Ext Cost