Skip to Content
avatar image
Former Member

inventory audit with bin

Dear All Master,

Any master give me a hand to make a custom report as follow format ?

| Item code | Binloc | whs| Qty | Unit price | Cost |

thanks b4.

Best regards,

harry

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 03, 2017 at 10:23 AM

    Hi Harry,

    Check if this query helps you(if you need more information tell me and I will help you):

    SELECT 
    	T0.ItemCode, 
    	T5.ItemName, 
    	T0.WhsCode, 
    	T4.DistNumber,
    	SUM(T3.OnHandQty) as 'Batch Quantity',
    	SUM(T2.OnHandQty) as 'Total Stock Bin',
    	SUM(T0.OnHand) AS 'Total Stock Warehouse',
    	T1.BinCode
    FROM 
    	OITW T0
    	INNER JOIN OBIN T1 ON T0.WhsCode = T1.WhsCode
    	INNER JOIN OIBQ T2 ON T2.WhsCode = T0.WhsCode AND T1.AbsEntry = T2.BinAbs AND T0.ItemCode = T2.ItemCode
    	INNER JOIN OBBQ T3 ON T3.ItemCode = T0.ItemCode AND T3.BinAbs = T1.AbsEntry AND T3.WhsCode = T2.WhsCode
    	INNER JOIN OBTN T4 ON T4.AbsEntry = T3.SnBMDAbs
    	INNER JOIN OITM T5 ON T5.ItemCode = T0.ItemCode
    WHERE 
    	T2.OnHandQty > 0 
    	AND T1.BinCode between [%0] and [%1] 
    	AND T3.OnHandQty > 0
    	AND T2.OnHandQty > 0
    GROUP BY 
    	T0.ItemCode, T5.ItemName, T0.WhsCode, 
    	T0.WhsCode, T1.BinCode, T4.DistNumber
    ORDER BY T0.ItemCode, T0.WhsCode, T1.BinCode

    Source: https://answers.sap.com/questions/84872/index.html

    Kind Regards,

    Diego Lother

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2016 at 04:40 AM

    Hi,

    Please check this thread to write own query,

    https://archive.sap.com/discussions/thread/3932035

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Nagarajan,

      i have cheked , but the value of "DftBinAbs" is NULL, so could display the Query

      any idea for it please?

      Thx.

      Best regards,

      Harry.P

  • avatar image
    Former Member
    Jan 02, 2017 at 11:55 PM

    Dear Nagarajan K,

    I didnt find yet for this format, any other ideas master ?

    Thanks

    Best regards,

    Add comment
    10|10000 characters needed characters exceeded