版权声明：本文是博客的原创文章，未经博客许可不得转载。
createorreplaceviewoes _ material _ series _ refas
select t.productgroup，o.id nrk材质代码，t.series代码
from oes_park_priority t
innerjoinoms _ hm _ MTL _ general _ viewv
ont.material code=v.material _ code
left join oms_modelbom_noderela o
on t.materialcode=o.matnr
where 1=1
and v.primary _ uom=‘Tao’
group by t.productgroup，t.materialcode，o.idnrk，t.seriescode
统一号
选择t.product group，t.materialcode，t.seriescode
from oes_park_priority t
innerjoinoms _ hm _ MTL _ general _ viewv
ont.material code=v.material _ code
组by t.product group，t.materialcode，t.seriescode；
commentoncolumnoes _ material _ series _ ref.productgroupis“产品组”；
commentoncolumnoes _ material _ series _ ref .傻黑裤子is ‘料号‘；
commentoncolumnoes _ material _ series _ ref.hsjdbyis‘系列‘；