Programme SAP SAPDBIDF - Real Estate Logical Database

Description
Complete database for Real Estate
Features:
Using the VIGETTAB field string, you can decide if you will implementGET events to the GETs that correspond to the database hierarchy. Ifyou decide to do this, you have to check (set the VIGETTAB-J

value to 'X') in the corresponding table.
If you require a time-dependent selection, the RFVILSP structure mustbe specified in the program with TABLES. This ensures that a from-date,a to-date and a key date are given as selection options.
You can use the VIGETTAB field string to specify the tables in whichthe from-to-date or the key date is/is not evaluated for thetime-dependent tables. If no time-dependent selection is made even oncethe from-to date or key date has been entered, set theVIGETTAB-JDI
value to "X".
The from/to-date or the key date is taken into account for tables inwhich a JDI
field is planned in the VIGETTAB field string: (Inthe overview below, "next record" means that the to-date results fromthe from-date of the next record with the same key)
Table From date To date Features
VZGPO DBEBEZ DENBEZ/unlimited
SPAB1 GBDAT GEDAT/unlimited
VIOB27 DGULTAB Next record JEZUORD is taken
into account
VIOB11 DGAB Next record
VIOB40 DGULTAB Next record (also VIOB40_BD, _PY)
VIKOKO DGUEL_KK Next record
VZZKOPO DGUEL_KP Next record JNULLKON and change
DGUEL_KK-date is taken
into account
VIMIMV DMIBEG DMIEND/DKUEZU/unlimited
VIMI54 DGABANRT DBISANRT
VIMI55 DGABANRT Next record
VIMI38 DATAB Next record
VIBEPP DBERVON DBERBIS *)
VIAK03 DGUELEMP of the DAEEND
1. VIAK05 record
VIAK05 DGUELEMP Next record
VIAK25 DPERBEG DPEREND
VIVW01 DVWBEG DVWEND/unlimited
*):
Since VIBEPP can also be selected by the due date (in Selectoption), it is recommended deactivating the selection withDBERVON/DBERBIS via VIGETTAB-JDIVIBEPP if you are selecting accordingto due date.
The VIGETTAB field string does not need to be separate in the report.The lower-level VIGSMT field string provides information about thehierarchy branch currently being processed. This contains the primaryand third-party key of the structure to which the data that iscurrently being delivered belongs. The VIGSMT information can be usedas follows:

Example
The partner of a business entity as well as the partner for a rentalagreement are used in a report. They should be processed in differentways.
GET VIOB01.
...
VIGETTAB-JVZGPO = 'X'.
...
GET VIMIMV.
...
VIGETTAB-JVZGPO = 'X'. " Only necessary if the variable is
" explicitly set back to the point in
" time such as GET VIMI01
... "
GET VZGPO.
CASE VIGSMT-IMKEY.
WHEN VIOB01-IMKEY.
* Partner for the BE
WHEN VIMIMV-IMKEY.
* Partner for the rental agreement

Extended structure due to the field string VIGETTAB
The branchs used for the VIGETTAB field string are highlighted.
VIGSMT
|
|---JEST
|---VZGPO
| |
| |---BP000
| |
| |---BPADR
| |---BP030
|
|---VIEIGE
|---VIOB39
|---VZSORT
|---SANO1
| |
| |---SANS1
|
|
|---VIOB01
| |
| |---VIOB24
| |---VIOB27
| |---VIOB07
| |---VIOB02
| | |
| | |---VIOB40_PY
| | |---VIGBUCH
| | | |
| | | |---VIGBSTD
| | | | |
| | | | |---VIGBFLS
| | | | |---VIGBZAB
| | | |
| | | |---VIGBA1
| | | |---VIGBA2
| | | | |
| | | | |---VIGB2A
| | | |
| | | |---VIGBA3
| | | |
| | | |---VIGB3A
| | | If GET VIOB02:
| | |---JEST VIGETTAB-JJEST = 'X'
| | |---VZGPO VIGETTAB-JVZGPO = 'X'
| | | |
| | | |---BP000
| | | |
| | | |---BPADR
| | | |---BP030
| | |
| | |---VIEIGE VIGETTAB-JVIEIGE = 'X'
| | |---VIOB38 VIGETTAB-JVIOB38 = 'X'
| | |---VIOB39 VIGETTAB-JVIOB39 = 'X'
| | |---VZSORT VIGETTAB-JVZSORT = 'X'
| | |---SANO1 VIGETTAB-JSANO1 = 'X'
| | | |
| | | |---SANS1
| | |
| | |---VIOB24 VIGETTAB-JVIOB24 = 'X'
| | |---VIOB27 VIGETTAB-JVIOB27 = 'X'
| | |---VIMI01 VIGETTAB-JVIMI01 = 'X'
| | |
| | |--- ... (with all substructures)
| |
| | If GET VIOB01:
| |---JEST VIGETTAB-JJEST = 'X'
| |---VZGPO VIGETTAB-JVZGPO = 'X'
| | |
| | |---BP000
| | |
| | |---BPADR
| | |---BP030
| |
| |---VIEIGE VIGETTAB-JVIEIGE = 'X'
| |---VIOB38 VIGETTAB-JVIOB38 = 'X'
| |---VIOB39 VIGETTAB-JVIOB39 = 'X'
| |---VZSORT VIGETTAB-JVZSORT = 'X'
| |---SANO1 VIGETTAB-JSANO1 = 'X'
| | |
| | |---SANS1
| |
| |---VIOB03
| | |
| | |---VIOB40_BD
| | |---VIOB04
| | |---VIOB20
| | |---VIOB05
| | |---VIOB22
| | | |
| | | |---VIOB11
| | | |---VIOB21
| | | |---VIOB23
| | |
| | | If GET VIOB03:
| | |---JEST VIGETTAB-JJEST = 'X'
| | |---VZGPO VIGETTAB-JVZGPO = 'X'
| | | |
| | | |---BP000
| | | |
| | | |---BPADR
| | | |---BP030
| | |
| | |---VIEIGE VIGETTAB-JVIEIGE = 'X'
| | |---VIOB38 VIGETTAB-JVIOB38 = 'X'
| | |---VIOB39 VIGETTAB-JVIOB39 = 'X'
| | |---VZSORT VIGETTAB-JVZSORT = 'X'
| | | |
| | | |---SANS1
| | |
| | |---VIOB24 VIGETTAB-JVIOB24 = 'X'
| | |---VIOB27 VIGETTAB-JVIOB27 = 'X'
| | |---VIMI01 VIGETTAB-JVIMI01 = 'X'
| | |
| | |--- ... (with all substructures)
| |
| |---VIMI01
| |
| |---VIMI03
| |---VIMI08
| |---VIOB40
| |---VIOB10
| |---VIMI38
| |---VIKOKO
| | |
| | |---VZZKOPO
| | |
| | |---RBEZFLART
| |
| |---VIMIMV
| | |
| | |---VIBEPP
| | |---VIMI54
| | |---VIMI55
| | |---VIMI07
| | |---VIMI23
| | |---VIMI24
| | |---VIMI25
| | |---VIMI28
| | |---VIMI16
| | |---VIMI18
| | |---VIMI56
| | |---VIMI26
| | | If GET VIMIMV
| | |---JEST VIGETTAB-JJEST = 'X'
| | |---VZGPO VIGETTAB-JVZGPO = 'X'
| | | |
| | | |---BP000
| | | |
| | | |---BPADR
| | | |---BP030
| | |
| | |---VZSORT VIGETTAB-JVZSORT = 'X'
| | |---VIKOKO VIGETTAB-JVIKOKO = 'X'
| | | |
| | | |---VZZZKOPO
| | |
| | |---VIMI38
| | If GET VIMI01:
| |---JEST VIGETTAB-JJEST = 'X'
| |---VZGPO VIGETTAB-JVZGPO = 'X'
| | |
| | |---BP000
| | |
| | |---BPADR
| | |---BP030
| |
| |---VIEIGE VIGETTAB-JVIEIGE = 'X'
| |---VIOB38 VIGETTAB-JVIOB38 = 'X'
| |---VIOB39 VIGETTAB-JVIOB39 = 'X'
| |---VZSORT VIGETTAB-JVZSORT = 'X'
| |---SANO1 VIGETTAB-JSANO1 = 'X'
| |
| |---SANS1
|
|---VIAK03
| |
| |---VIAK05
| | |
| | |---VIAK23_DB
| | |
| | |---VIAK23
| | |
| | |---VIAK24
| | |
| | |---VIAKME
| |
| |---VIAK04
| | |
| | |---VIAK21
| |
| |---VIAK25
|
| --VIVW01
|
|---VIVW02
| |
| |---VIVW03_P
|
|---VIVW06
| |
| |---VIVW03_E
|
|---VIVW05
| |
| |---VIVW07
|
|---VIVW08
|---VIVW09 If GET VIVW01
|---VZGPO VIGETTAB-JVZGPO = 'X'
|---BP000
|
|---BPADR
|---BP030