Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

(Back to A-AD Administration Module SQL Posted to Wiki Listing - A-AD Administration Module SQL Posted to Wiki  )

TYPE: Frequently Requested SQL

AUTHOR NAME: Zal Parchem

PURPOSE AND BACKGROUND:  This SQL was created in Version 8.8 PL16.  This SQL shows those products which have a negative inventory balance in at least one warehouse within the company.  If a product has negative figues in two warehouses, the SQL will show the product two times with the different negative "In Stock" for each warehouse.  SQL also includes a total of all warehouse in stock figures (in case an Inventory Transfer can be done to resolve the situation).  You can use "copy and paste" to move this Alert Message into your system and set the Alert Message to "Hourly" or whatever frequency is good for your company.

Here is a screen print of the SQL results:

 A-AD Alert Mess Negative Inventory In Stock by Warehouse and Total.png

Copy and Paste this SQL:

--A-AD Alert Mess Negative Inventory In Stock by Warehouse and Total Ver 1 ZP 2011 02 19

--DESCRIPTION:  SQL shows only those products having a negative balance in a warehouse and another balance for the entire company.

--AUTHOR(s):
--Version 1 Zal Parchem 2011 02 19

SELECT

T0.ItemCode AS 'Product',
T1.ItemName AS 'Description',
T0.WhsCode AS 'Whs',
T0.OnHand AS 'Whs Qty',
T1.OnHand AS 'Comp Qty'

 FROM OITW T0 

LEFT OUTER JOIN OITM T1
ON T0.ItemCode = T1.ItemCode

WHERE
T0.OnHand < 0

FOR BROWSE

  • No labels