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]