Time-Dependent Table/View 

Definition

The entries of time-dependent tables or views depend on a date. A validity time interval is assigned to each data record.

Use

In a time-dependent table/view, you can create data records with identical logical keys, which only differ in the additional date field in the key. You can enter different field values for these entries, which are valid in different periods.

Structure

The table/view must contain two fields for the start and end dates. One of these fields must be in the key, the other must be the first non-key field in the table/view.
The field name must be specified.

The following data elements must be assigned to the fields:

·        for the start date

Field name BEGDA   or

Data element BEGDATUM   or

Data element VIM_BEGDA   or

Data element BEGDA

·        for the end date

Field name ENDDA   or

Data element ENDATUM   or

Data element VIM_ENDDA   or

Data element ENDDA.

All four data elements are in the domain DATUM.

Integration

In a time-dependent table with text table, the text table itself can also be time-dependent. This means that each time interval of a data record has its own text table entry. The date fields ENDDA and BEGDA must be only in the definition of the time-dependent text table, not in the text table itself. If the date fields ENDDA and BEGDA are only in the definition of the time-dependent text table, the system creates a common text table entry for all validity intervals of a table data record.