Skip to Content
0
Jun 21, 2020 at 02:38 AM

Live Inventory Stock Batch & Warehouse Wise With Landed Cost Breakup as per batch Query

125 Views

Hello SAP Gurus!!

Can someone please help me complete this query from IPF1 & OIPF with the following information added:

Landed Cost breakup

  1. Base Doc price ( Price FOB )
  2. Projected Custom ( Custom )
  3. Expenditure (Cost )
  4. Whse Price ( Price At WH )
  • Here is the my Live Inventory Stock Batch & Warehouse Wise Query :

SELECT

T2.[ItemCode] AS "AZ Code", T2.[CodeBars], T4.ITMSGRPNAM AS "Family Name", T2.ItemName AS "Item / Service Description", T0.Quantity AS "Qty", T1.whscode AS "W/H Code",T1.WhsName AS "W/H Name", T0.ExpDate AS "EXP. Date", T0.BatchNum AS "Batch Number", T0.PrdDate AS "MFG. Date", T0.[InDate], T0.[CreateDate],T2.[LastPurDat] AS "Last P.P Date", T2.LastPurPrc AS "Last P. Price",TotalValue=(LastPurPrc*Quantity), T2.[IWeight1] AS "UOM In Kg",T5.[PriceList], T5.[Price]

FROM

OIBT T0 INNER JOIN OWHS T1 ON T0.WhsCode=T1.WhsCode INNER JOIN OITM T2 ON T0.ItemCode=T2.ItemCode INNER JOIN OITB T4 ON T4.ITMSGRPCOD = T2.ITMSGRPCOD INNER JOIN ITM1 T5 ON T2.ItemCode = T5.ItemCode

WHERE

T5.PriceList='[%0]'

GROUP BY

T2.[IWeight1], T2.[CodeBars], T2.[ItemCode], T0.[InDate], T0.[CreateDate], T2.[LastPurDat], T2.ItemName,BatchNum,Quantity,ExpDate,PrdDate,T1.whscode,T1.WhsName,T2.LastPurPrc,T4.ITMSGRPNAM,T5.[PriceList], T5.[Price]

ORDER BY

T1.WhsName



Regards,

Mohamamd Firoz