SAP table TIV35 (Regional locations)
SAP table TIV35 has 2 primary key fields being MANDT,SSTDORT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| SSTDORT | Regional location | CHAR | 10 | 0 | VVSSTDORT | ||
| XSTDORT | Regional location | CHAR | 35 | 0 | VVXSTDORT | ||
| SZSREFHP | Swiss rent adj.: Mortgage loan rate interest rate ref. | CHAR | 10 | 0 | T056R | VVSZSREFHP | |
| SINDUTBK | Swiss rent adj.: Maintenance + operating costs index | CHAR | 5 | 0 | T094A | VVSINDUTBK | |
| SINDTEU | Swiss rent adj.: Standard of living index | CHAR | 5 | 0 | T094A | VVSINDTEU | |
| SBASTEU | Swiss rent adj.: Base year for standard of living index | NUMC | 4 | 0 | T094B | VVSBASTEU | |
| BPKTEMSP | Specif.no.of points f. weighting of feature in repr.rnt list | DEC | 7 | 2 | VVBPKTEMSP | ||
| JBASOUE | CH rent adj.: Adjustment on basis of typical local rent | CHAR | 1 | 0 | VVJBASOUE | ||
| JBASBR | CH rent adjustm.: Adj. on basis of gross yield | CHAR | 1 | 0 | VVJBASBR | ||
| JBASHZ | CH rent adjustm.: Adj. on basis of mortgage loan rate change | CHAR | 1 | 0 | VVJBASHZ | ||
| JBASTI | CH rent adjustm.: Adj. on basis of standard of living index | CHAR | 1 | 0 | VVJBASTI | ||
| JBASUBK | CH rent adjustm.: Adj. on basis of maint./operat.costs index | CHAR | 1 | 0 | VVJBASUBK | ||
| JBASMOD | CH rent adjustment: Adj. on the basis of modernization | CHAR | 1 | 0 | VVJBASMOD | ||
| STDSPRAS | Language key for correspondence | LANG | 1 | 0 | T002 | VVSTDSPRAS | |
| GESCHVORF | Rent adjustment, correspondence activity | NUMC | 4 | 0 | TZKV | VVMANPKVT | |
| KUENDKVT | Notice, correspondence activity | NUMC | 4 | 0 | TZKV | VVKUENDKVT |
TIV35 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TIV35 | GESCHVORF | TZKV | Correspondence activities | MANDT |
| 1 TIV35 | KUENDKVT | TZKV | Correspondence activities | MANDT |
| 0 TIV35 | SBASTEU | T094B | Allowed base years per index series | MANDT |
| 1 TIV35 | STDSPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |
| 0 TIV35 | SZSREFHP | T056R | Interest reference definition | MANDT |
| 0 TIV35 | SZSREFHP | T056R | Interest reference definition | REFERENZ |