Restrict the report to a time interval containing current date

[rama_krishna51]

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

[rama_krishna51]

thanks sreeni..

[Former Member]

Hi RK,

Use Query Key Date(give current date) then it will only pics data which falling into that perticulr interval(Valid from & Valid to).

You can add Key Date, at Query Properties--> show variable.

Please check : [Query Properties|http://help.sap.com/saphelp_nw04/Helpdata/EN/07/0ab63c71f41d5ce10000000a114084/content.htm]

Hope it Helps

Srini

[rama_krishna51]

thanks srini,

i thought of dragging the "Time Interval" into the filter and restrict it with 0DAT (Current calendar Day (SAP Exit)).

Will we get the same functionality with the above method...

thanks,

Rk

[Former Member]

RK,

Yes, you can do restriction based on time interval also but its better to use Keydate.

Create a variable or use existing variable for query Key Date and make it available for User Input. Based on input value(single value only, not range for key date) it will picks up records.

For default value(current date) create Customer exit variable and also make variable available for input.

Hope it Helps

Srini