Description Database for Real Estate Features: The VIGETTAB field string determines if other GET time points should beused in addition to those in the database hierarchy. Check thecorresponding table in the VIGETTAB field string for this (set thevalue of VIGETTAB-J
to 'X'). If you require a time-dependent selection, the RFVILSP structure has bedeclared with TABLES in the program. This ensures that a from-date, ato-date and a key date are in the selection. Use the VIGETTAB string to specify which tables are and are notevaluated with the from-date, to-date or key date. If the from-date,to-date or key date have been entered and no time-dependent selectioncan be made, set the value of the VIGETTAB-JDI
to 'X'. The from-date, to-date or key date are taken into account in tables(for which a JDI
field with a VIGETTAB string has beendesignated) as described below (in the overview 'following record'means that the to-date is derived from the from-date of the followingrecord with the same key) Table From-date To-date Features VZGPO DBEBEZ DENBEZ/unlim. SPAB1 GBDAT GEDAT/unlim. VIOB27 DGULTAB Following rec. JEZUORD is taken into account VIOB11 DGAB Following rec. VIOB40 DGULTAB Following rec. (also VIOB40_BD, _PY) VIKOKO DGUEL_KK Following rec. VZZKOPO DGUEL_KP Following rec. JNULLKON u DGUEL_KK dates aretaken into account VIMIMV DMIBEG DMIEND/DKUEZU//unlim. VIMI54 DGABANRT DBISANRT VIMI55 DGABANRT Following rec. VIMI38 DATAB Following rec. VIBEPP DBERVON DBERBIS *) VIAK03 DGUELEMP of DAEEND 1. VIAK05 record VIAK05 DGUELEMP Following rec. VIAK25 DPERBEG DPEREND VIVW01 DVWBEG DVWEND/unlim. *): As the VIBEPP can be selected using the due date (via selectoption), we recommend deactivating the selection via DBERVON/DBERBISvia VIGETTAB-JDIVIBEPP if the due date is also used as a selectioncriteria. The VIGETTAB field string does not have to be separate in the report.The higher-level VIGSMT field string supplies information about whichhierachical level is currently being processed. It contains the primaryand foreign keys of structure to which the data, which is currentlybeing processed, belongs. You can use the information from VIGSMT asdescribed in the following:
Example In a report the partner of a business entity and the partner of arental agreement are used. However, they have to be processed indifferent ways. GET VIOB01. ... VIGETTAB-JVZGPO = 'X'. ... GET VIMIMV. ... VIGETTAB-JVZGPO = 'X'. " Only necessary if the variable is " explicitely reset in the interim " period. For example GET VIMIO1 ... GET VZGPO. CASE VIGSMT-IMKEY. WHEN VIOB01-IMKEY. * BE partner WHEN VIMIMV-IMKEY. * Rental agreement partner