I am trying to create list of all new materials adding every day in database to check some data avaliable in tables MARA MVKE MAKT MARC. In SQVI all my joins are with materials.As I want to see only new materials I am using creation_date (MARA) as search criteria.
Problem is when I am running report I am getting duplicate data...actually if data is changed after creating material )eg: say feild volume rebate group is changed from 01 to 02 using mm02.) i am gettig two lines in report for same material one havinng 01 volume rebate group and other having 02. From this I cannot identify which is correct data because there is only date of change is avaliable not time of change.
Can anyone help please?