谨此内容写给正在实施和已经实施SAPBO朋友们的，以下语句不见得都适用大家，不过举一反三稍加变通即可使用，不啰嗦了希望对大家有所帮助：

物料价格对比表
select t0.itemcode,t1.itemname,t0.whscode,t0.onhand,t0.avgprice,T1.LstEvlPric, T1.LastPurPrc, T1.LastPurDat  from oitw t0
inner join oitm t1 on  t1.itemcode=t0.itemcode
and  t1.dfltwh=t0.whscode

查询BOM子父项
SELECT  T0.Father,T0.Code, T0.Quantity AS '组件数量', T1.ItemName FROM ITT1 T0  INNER JOIN OITM T1 ON T0.Code = T1.ItemCode WHERE T0.Code =[%0] OR  T0.Father =[%0]

查询物料创建日期
SELECT T0.ItemCode, T0.createDate  FROM OITW T0 WHERE T0.ItemCode =[%0]

查询物料主数据全部信息
SELECT T0.ItemCode, T1.ItemName, T0.WhsCode, T0.OnHand, T0.IsCommited as '已承诺', T0.OnOrder ,T0.MinStock,T1.SWW,  T1.LeadTime, T1.PurPackUn, T1.MinOrdrQty,t1.u_cptype,t1.u_bcptype  FROM OITW T0  INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode and  t1.dfltwh=t0.whscode

核查生产订单供应商与转储外协供应商一致性
SELECT T0.DocNum, T0.U_transtype, T0.U_ssupp, T0.Comments, T1.DocNum, T1.Comments, T1.U_ssupp, T1.U_wxfl FROM OWTR T0 , OWOR T1 WHERE T1.Comments =  T0.Comments and T0.U_transtype ='001'

按时间统计成品生产入库数量
SELECT T0.DocNum, T0.ItemCode, T1.ITEMNAME,T0.Status, T0.Type, T0.PlannedQty, T0.CmpltQty, T0.PostDate, T0.DueDate, T0.Comments, T0.CloseDate, T0.U_project, t0.u_scddfl,t0.u_hth FROM OWOR T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode WHERE  T0.ItemCode LIKE '15%%'  AND  T0.CmpltQty<>0

标准生产订单物料多于分装生产订单物料行差异
select t0.itemcode 原订单物料,t0.plannedqty 原订单数量  from wor1 t0
left join wor1 t1 on t1.itemcode=t0.itemcode and t1.docentry=N'[%0]'
where t0.docentry=N'[%1]' and t1.itemcode is null
order by t1.itemcode

标准生产订单物料与分装生产订单相同物料数量差-先录标准订单，后分装订单
select  t0.itemcode  分装订单物料,t0.plannedqty  分装订单数量,t1.itemcode  原订单物料,t1.plannedqty  原订单数量,(t0.plannedqty-t1.plannedqty)  差异  from  wor1  t0
right  join  wor1  t1  on  t1.itemcode=t0.itemcode  and  t1.docentry  =N'[%1]'
where  t0.docentry  =N'[%0]'
order  by  t1.itemcode

查询单颗物料生产计划已承诺用量
SELECT T1.DocNum, T1.Status, T1.Type, T1.PostDate, T1.DueDate, T1.Comments, T0.ItemCode, T0.PlannedQty, T0.IssuedQty, T0.wareHouse, T0.U_defonhand FROM WOR1 T0  INNER JOIN OWOR T1 ON T0.DocEntry = T1.DocEntry WHERE T0.ItemCode =[%0] and T1.Type <>'D' and  T1.Status<>'C' and T1.Status<>'L'  and T0.PlannedQty<>T0.IssuedQty

分装生产订单物料多于标准生产订单物料行差异（退料）
select t0.itemcode 分装物料,t0.plannedqty 分装数量  from wor1 t0
left join wor1 t1 on t1.itemcode=t0.itemcode and t1.docentry=N'[%1]'
where t0.docentry=N'[%0]' and t1.itemcode is null
order by t1.itemcode

查询生产订单详细信息
SELECT T0.DocNum, T0.ItemCode, T1.ITEMNAME,T0.Status, T0.Type, T0.PlannedQty, T0.CmpltQty, T0.PostDate, T0.DueDate, T0.Comments, T0.CloseDate, T0.U_project FROM OWOR T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode

查询生产报工信息
SELECT T0.ClgCode, T0.CardCode,T1.CardName, T0.cardcode,T0.ATTENDUSER,t0.cntctdate,t0.cntcttime,t0.docnum AS '生产订单号',t0.u_team,T0.U_RTIME,T0.U_PLQTY,t0.u_fiqty,t0.u_wtqty FROM OCLG T0  INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE t0.cntcttype = '1'

查询生产成品入库信息
SELECT T0.DocNum, T0.ItemCode, T1.ITEMNAME,T0.Status, T0.Type, T0.PlannedQty, T0.CmpltQty, T0.PostDate, T0.DueDate, T0.Comments, T0.CloseDate, T0.U_project,T0.U_scddfl, T0.U_thdh, T0.U_hth  FROM OWOR T0 INNER JOIN OITM T1 ON T0.ItemCode = T1.ItemCode  where T0.Status <>'C' and T0.ItemCode like '15%%' and  T0.Type <> 'D' AND T0.CmpltQty <> 0