SAP Table TIV35
Regional locations
TIV35 (Regional locations) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TIV35 to other SAP tables.
TIV35 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
SSTDORT
Regional location
|
VVSSTDORT |
CHAR
|
10 | 0 | ||||||||
|
XSTDORT
Regional location
|
VVXSTDORT |
CHAR
|
35 | 0 | ||||||||
|
SZSREFHP
Swiss rent adj.: Mortgage loan rate interest rate ref.
|
VVSZSREFHP | T056R |
CHAR
|
10 | 0 | |||||||
|
SINDUTBK
Swiss rent adj.: Maintenance + operating costs index
|
VVSINDUTBK | T094A |
CHAR
|
5 | 0 | |||||||
|
SINDTEU
Swiss rent adj.: Standard of living index
|
VVSINDTEU | T094A |
CHAR
|
5 | 0 | |||||||
|
SBASTEU
Swiss rent adj.: Base year for standard of living index
|
VVSBASTEU | T094B |
NUMC
|
4 | 0 | |||||||
|
BPKTEMSP
Specif.no.of points f. weighting of feature in repr.rnt list
|
VVBPKTEMSP |
DEC
|
7 | 2 | ||||||||
|
JBASOUE
CH rent adj.: Adjustment on basis of typical local rent
|
VVJBASOUE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
JBASBR
CH rent adjustm.: Adj. on basis of gross yield
|
VVJBASBR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
JBASHZ
CH rent adjustm.: Adj. on basis of mortgage loan rate change
|
VVJBASHZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
JBASTI
CH rent adjustm.: Adj. on basis of standard of living index
|
VVJBASTI |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
JBASUBK
CH rent adjustm.: Adj. on basis of maint./operat.costs index
|
VVJBASUBK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
JBASMOD
CH rent adjustment: Adj. on the basis of modernization
|
VVJBASMOD |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
STDSPRAS
Language key for correspondence
|
VVSTDSPRAS | T002 |
LANG
|
1 | 0 | |||||||
|
GESCHVORF
Rent adjustment, correspondence activity
|
VVMANPKVT | TZKV |
NUMC
|
4 | 0 | |||||||
|
KUENDKVT
Notice, correspondence activity
|
VVKUENDKVT | TZKV |
NUMC
|
4 | 0 | |||||||
TIV35 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TIV35 | GESCHVORF | TIV35 | MANDT |
TZKV
Correspondence activities
|
MANDT |
| TIV35 | GESCHVORF | '3' |
TZKV
Correspondence activities
|
RANTYP | |
| TIV35 | GESCHVORF | TIV35 | GESCHVORF |
TZKV
Correspondence activities
|
KORRVORF |
| TIV35 | KUENDKVT | TIV35 | KUENDKVT |
TZKV
Correspondence activities
|
KORRVORF |
| TIV35 | KUENDKVT | TIV35 | MANDT |
TZKV
Correspondence activities
|
MANDT |
| TIV35 | KUENDKVT | '3' |
TZKV
Correspondence activities
|
RANTYP | |
| TIV35 | MANDT | TIV35 | MANDT |
T000
Clients
|
MANDT |
| TIV35 | SBASTEU | TIV35 | MANDT |
T094B
Allowed base years per index series
|
MANDT |
| TIV35 | SBASTEU | TIV35 | SINDTEU |
T094B
Allowed base years per index series
|
WBIND |
| TIV35 | SBASTEU | TIV35 | SBASTEU |
T094B
Allowed base years per index series
|
YBASISJ |
| TIV35 | SINDTEU | TIV35 | MANDT |
T094A
Index series for replacement values
|
MANDT |
| TIV35 | SINDTEU | TIV35 | SINDTEU |
T094A
Index series for replacement values
|
WBIND |
| TIV35 | SINDUTBK | TIV35 | MANDT |
T094A
Index series for replacement values
|
MANDT |
| TIV35 | SINDUTBK | TIV35 | SINDUTBK |
T094A
Index series for replacement values
|
WBIND |
| TIV35 | STDSPRAS | TIV35 | STDSPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| TIV35 | SZSREFHP | TIV35 | MANDT |
T056R
Interest reference definition
|
MANDT |
| TIV35 | SZSREFHP | TIV35 | SZSREFHP |
T056R
Interest reference definition
|
REFERENZ |