Hello SAP Gurus!!
Can someone please help me complete this query from IPF1 & OIPF with the following information added:
Landed Cost breakup
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