Advertisement
Guest User

SAP - Quantidade Estoque/Posição

a guest
Nov 22nd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. SELECT T0.ItemCode,
  2.        T1.ItemName,
  3.        T0.WhsCode,
  4.        'Quantidade no Estoque' AS 'Posição',
  5.        T0.OnHand
  6. FROM OITW T0
  7. INNER JOIN OITM T1 ON T1.ItemCode = T0.ItemCode
  8.  
  9. UNION ALL
  10.  
  11. SELECT T0.ItemCode,
  12.        T0.ItemName,
  13.        T2.WhsCode,
  14.        T2.BinCode,
  15.        T1.OnHandQty
  16. FROM OITM T0
  17. INNER JOIN OIBQ T1 ON T1.ItemCode = T0.ItemCode
  18. INNER JOIN OBIN T2 ON T2.AbsEntry = T1.BinAbs
  19.  
  20. ORDER BY 1, 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement