on 04-21-2014 9:14 PM
Buenas tardes,
Necesito saber si es posible obtener la consulta que ejecuta SAP para el informe de auditoria de stocks, ya que necesito obtener un reporte de todos los articulos, y trabajarlo en una aplicacion que estoy haciendo con el SDK.
¿Por favor alguien me podria ayudar?
Muchas gracias.
Buena tarde Williams te comparto un query que espero que te sirva, donde debes poner el codigo de tu almacen y la fecha final que quieres ver tu stock.
SELECT T0.[ItemCode]'CODIGO SAP',
(SELECT (SUM(Y.InQty)-SUM(Y.OutQty))
FROM OINM Y WHERE Y.ItemCode = T2.ItemCode AND Y.Warehouse = T1.WhsCode AND Y.DocDate BETWEEN '20130101' AND '20140421') 'STOCK', T1.[WhsCode]'BODEGA', T1.WHSNAME'NOMBRE BODEGA', (SELECT (SUM(Y.TransValue))
FROM OINM Y WHERE Y.ItemCode = T2.ItemCode AND Y.Warehouse = T1.WhsCode AND Y.DocDate BETWEEN '20130101' AND '20140421')'Valor Acumulado'
FROM OITW T0
INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN OMRC T3 ON T2.FIRMCODE=T3.FIRMCODE
WHERE (SELECT (SUM(Y.InQty)-SUM(Y.OutQty)) FROM OINM Y WHERE Y.ItemCode = T2.ItemCode AND Y.Warehouse = T1.WhsCode AND Y.DocDate BETWEEN '20130101' AND '20140421' and (t0.whscode ='MP' )) != '0'
ORDER BY T0.[WhsCode], T0.[ItemCode]
Saludos cordiales
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
99 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.