Different Item Description in Sales Documents

[Former Member]

Hi,

In SAP Reports, I want to print the same day item description and item details (user defined field) in sales documents on the day of SO, DO, AR Inv creation.

I have a item code with different accy and parts for every transaction (User overwrite the description), want to display the ItemName and parts details from table AITM on the day of sales documents created.

eg, If i print a old invoice (Created in Jan 2011) today, the latest (Oct 2011) item description and details appeared. But i want to print the old item description of Invoice date.

for clear picture run below query SELECT T1.[ItemCode], T1.[ItemName], T1.[UpdateDate], T1.[U_SI7_ITMDTLS] FROM [dbo].[AITM] T1 WHERE T1.[ItemCode] =[%0] ORDER BY T1.[UpdateDate]

thanks

Jagadeesh

[Former Member]

Hi Jagadeesh，

Try:

SELECT Distinct T1.ItemCode, T1.Dscription, T1.DocDate, T1.U_SI7_ITMDTLS, Case T1.ObjType WHEN '13' THEN 'Invoice' WHEN '15' THEN 'Delivery' When '17' THEN 'SO' END 'Type'

FROM dbo.ADO1 T1 WHERE T1.ItemCode =[%0\] AND T1.ObjType IN ('13','15','17')

ORDER BY T1.DocDate

Thanks,

Gordon

[Former Member]

Hi Jagadeesh.......

Try this.....

SELECT T1.ItemCode, T1.ItemName, T1.UpdateDate, T1.U_SI7_ITMDTLS 
FROM dbo.AITM T1 WHERE T1.ItemCode ='[%0]' and T1.UpdateDate='[%1]' 
ORDER BY T1.UpdateDate

Regards,

Rahul

[Former Member]

Hi Rahul,

My aim to retrive the item description and details in SAP reports (Not Crystal Report)

when T1.UpdateDate = date Near to posting date of my Sales docs(AR Inv)