谨此内容写给正在实施和已经实施SAPBO朋友们的,以下语句不见得都适用大家,不过举一反三稍加变通即可使用,不啰嗦了希望对大家有所帮助:
BOM损耗量计算
SELECT $[itt1.u_standqty]*(1+t1.u_consurate/100) from itt1 t0
inner join oitm t1 on t1.itemcode=t0.code
where t1.itemcode=$[$3.1.1]
采购订单当前仓库库存
SELECT t0.onhand FROM OITW T0 where t0.itemcode=$[$38.1.1] and t0.whscode=$[$38.24.1]
采购订单同一供应商同一物料历史最低价
SELECT t1.cardcode,t0.itemcode,t0.price from por1 t0 inner join opor t1 on t1.donum=t0.docentry where t1.cardcode=$[$4.1.1] and t0.itemcode=$[$38.1.1]
采购订单同一物料历史最低价
SELECT min(t0.price) from por1 t0 where t0.itemcode=$[$38.1.1]
查询当天日期
select convert(varchar(10),getdate(),120)
库存发货-当前仓库库存量
SELECT t0.onhand FROM OITW T0 where t0.itemcode=$[$13.1.1] and t0.whscode=$[$13.15.1]
库存发货科目自动
declare @acctcode nvarchar(8)
select @acctcode=$[ige1.U_wouttype]
select @acctcode
库存收货科目自动
declare @acctcode nvarchar(8)
select @acctcode=$[ign1.U_wintype]
SELECT @acctcode
库存转储外协功能生产订单号选择
SELECT t0.docnum, t0.itemcode,t1.itemname,t0.plannedqty from owor t0 inner join oitm t1 on t1.itemcode=t0.itemcode where status='r'
库存转储外协功能生产订单下父件选择
SELECT t0.itemname from oitm t0 inner join owor t1 on t1.itemcode=t0.itemcode where t1.docum=$[owtr.address]
库存转储外协功能生产订单下物料数量选择
SELECT t0.plannedqty from wor1 t0 inner join owor t1 on t1.docnum=t0.docentry where t1.docentry=$[owtr.address] and t0.itemcode=$[$23.1.1]
库存转储外协功能生产订单下物料选择
SELECT t0.itemcode from wor1 t0 inner join owor t1 on t1.docnum=t0.docentry where t1.docentry=$[owtr.address]
库存转储源仓库库存
SELECT t0.onhand FROM OITW T0 where t0.itemcode=$[$23.1.1] and t0.whscode=$[$18.1.1]
请购单价格等级查询
SELECT t0.SWW FROM OITM T0 where t0.itemcode=$[$M1.c1.1]
请购单最小采购量
SELECT t0.PURPACKUN FROM OITM T0 where t0.itemcode=$[$M1.c1.1]
日记账个人名称显示
SELECT T0.PrcName FROM OPRC T0 where t0.Prccode=$[$76.2006.1]
日记账个人名称显示
SELECT T0.PrcName FROM OPRC T0 where t0.Prccode=$[$76.2003.1]
生产订单仓库库存
SELECT t0.onhand FROM OITW T0 where t0.itemcode=$[$37.4.1] and t0.whscode=$[$37.10.1]
退货利润中心自动连接
Select u_lrzx from oslp where oslp.slpcode =$[ordn.slpcode]
物流费用
SELECT T0.U_weight * T0.U_price FROM ODLN T0
显示物料描述
SELECT T0.ItemName FROM OITM T0 WHERE T0.ItemCode = $[OCLG.u_gfypyz5]
销售报价利润中心
Select u_lrzx from oslp where oslp.slpcode =$[oqut.slpcode]
销售订单当前仓库存库
SELECT t0.onhand FROM OITW T0 where t0.itemcode=$[$38.1.1] and t0.whscode=$[$38.24.1]
销售订单利润中心自动连接
Select u_lrzx from oslp where oslp.slpcode =$[ordr.slpcode]
销售项目名称自动连接
SELECT t0.ocrname FROM OOCR T0 where t0.datasource=$[$7.v_9.1] and t0.ocrcode=$[$7.V_4.1]
销售项目显示
SELECT T0.PrcName FROM OPRC T0 where t0.Prccode=$[$38.2002.1]
应收发票利润中心自动连接
Select u_lrzx from oslp where oslp.slpcode =$[oinv.slpcode]
转载于:https://blog.51cto.com/38641581/287049