Step by step to create time dependent view

简介: Step1: Create your transparent table as usual. The only special task is to include two additional fields for start and end date. Use predefined VIM_BEGDA and VIM_ENDDA.

Step1: Create your transparent table as usual. The only special task is to include two additional fields for start and end date. Use predefined VIM_BEGDA and VIM_ENDDA.

image.png

Step2: go to tcode SE54, choose “Edit Table/View->Generated Objects”, then click create button:

image.png

Choose “Environment->Generate Time-Dep.”:

image.png

Maintain Function group name:

image.png

Make sure the table maintenance dialog is generated successfully:

image.png

Step3: now you can maintain time dependent table entries via tcode SM30.

I have maintained totally 4 entries with different valid from and valid to date and reviewed them in SE16:

image.png

In SM30, if I mark “No Restrictions” and click Display button:

image.png

the entry with valid from = 01/19/2014 and valid to = 01/20/2014 will not be displayed by default.

image.png

Instead, we have to click “Expand <-> Collapse” to make it visible:

image.png

It is also possible to specify a time range of valid from or valid to date to get a list of a subset of entries:

image.png

For example, I would like to see only those entries whose valid from date fall into the range between 01/16/2014 and 01/19/2014:

image.png

and only these two entries meet the condition:

image.png

相关文章
Sap Ds Data is not available. Increase the time-out interval values in Debug | Options
Sap Ds Data is not available. Increase the time-out interval values in Debug | Options
103 0
|
SQL Java 数据库连接
JPA异常:Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
JPA异常:Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
1831 0
|
Shell
History displays the time information
For those of you who use terminals a lot, one of the most common commands is probably history, which allows you to view the history of terminal commands executed
99 0
2015-03-18 current note update logic in my task
2015-03-18 current note update logic in my task
77 0
2015-03-18 current note update logic in my task
2015-03-17 current note creation logic in my task
2015-03-17 current note creation logic in my task
94 0
2015-03-17 current note creation logic in my task
custom field further usage - add into UI and report
custom field further usage - add into UI and report
122 0
custom field further usage - add into UI and report
How to create unit test for product determination function module
How to create unit test for product determination function module
123 0
How to create unit test for product determination function module
test case id - hash generation logic
Created by Wang, Jerry, last modified on Jul 06, 2016
110 0
test case id - hash generation logic