SBO库位查询

来源:这里教程网 时间:2026-03-02 10:36:08 作者:

点击(此处)折叠或打开

    SELECT T0.DocNum,T1.VisOrder,T1.ItemCode,T1.Dscription,T4.BinCode,T4.SL1Code
             FROM OPDN T0
             INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry
             INNER JOIN OILM T2 ON T2.TransType = T0.ObjType AND T2.DocEntry = T1.DocEntry AND T2.DocLineNum = T1.LineNum
             INNER JOIN OBTL T3 ON T3.MessageID = T2.MessageID --库位记录
             INNER JOIN OBIN T4 ON T4.AbsEntry = T3.BinAbs   --库位名称

相关推荐