如何在SAP b1收货订单中显示仓位？

Question

如何使用Print Layout Document Designer (PLD)在Sap业务中显示仓位、收货采购订单和生产订单？

Answer 1

您可以使用此查询来获得所需的结果。

DECLARE @DocNum int;
SET @DocNum = 123999;
SELECT T1.ItemCode, T3.ItemName, T2.WhsName, T1.[Quantity], T4.[BinCode]

FROM OPDN T0
inner join PDN1 T1 on T1.DocEntry=T0.DocEntry
inner join OWHS T2 on T2.WhsCode=T1.WhsCode
INNER JOIN OITM T3 ON T3.[ItemCode] = T1.[ItemCode] 
INNER JOIN OBIN T4 ON T2.[DftBinAbs] = T4.[AbsEntry]

WHERE T0.[DocNum]=@DocNum

以上Query将导致按照我的数据库；

​