ABAP TIP time dependency table

ABAP time dependency table

If there is a master data that should be maintained on time-based, it’s very efficient to use Time Dependency function.

For test, you need to create table and add extra columns – ENDDA and BEGDA and set the ENDDA column as a key.

In order to create Table Maintenance, move to Menu Utilities -> Table Maintenance Generator.

And you need to choose Menu : Menu : Environment -> Generate Time-Dep.

For test, execute T-CODE:SM30 and enter table name and click the button ‘Maintain.

Let’s create a data that has a value from 2014/01/20 to 2014/01/31 .

And, if you try to create another data that has a overlapping period, the system displays an error message and data is not created.

“Overlapping records are deleted or delimited”

In case you want to change the date period, select the line and click the ‘Delimit’ icon on the toolbar.

On the base of default Key value, 2 data is created automatically. These are split after and before‘2014/01/25/ .

If you go to T-CODE:SM30, there is only one available data

To display all time dependency history data, you need to click the ‘Expand <-> Collapse’ button.