Bhanu I can't tell you how many times I've looked for this. You want to see a condition record, it's value and validity periods without having to look each one up individually, correct? So you can look at all the prices in a price list, for example, all at the same time. Well sorry m8 but it's not so easy. About the best way I've founds takes a little work in Excel with a vlookup. I'll share it, but it's not the silver bullet you're looking for. If you want something simple you'll have to write a query and join the tables you use in your access sequences with KONP using ConditionRecNo as the key between them. If you don't want to use a query/report you can dump all the contents of your tables in Excel and do a join using a vlookup on ConditionRecNo. That gets messy because SAP tends to dump when you pass 3000 records from the clipboard into a field in se16. So do it 1500 records at a time... it's still faster than looking each record up individually.
Good luck and please share if you find something easier.
Johnny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.