Show TOC

Object documentationTime-Dependent Table/View Locate this document in the navigation structure

 

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

 

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 begin 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 begin 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

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.