Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Restrict the report to a time interval containing current date

hi all,

we have a time dependent master data object, for which there are two records in the master data for two different time interval for example

comp valid_to valid_from amount

ab00 10/12/2006 01/01/100 100

ab00 31/12/9999 11/12/2006 200

now we want to show only those record for which the current date lies in the time interval (valid_to and valid_from) i.e only the second record should be present in the report.

how can we achieve this at the query level.

any help will be appreciated.

thanks,

Rk

Not what you were looking for? View more on this topic or Ask a question