SAP Table TIV20
Rep.list of rents master data
TIV20 (Rep.list of rents master data) 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 TIV20 to other SAP tables.
TIV20 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| SMIETSP | Representative list of rents assignment | SMIETSP | CHAR | 6 | 0 | |||||||||
| XLBEZ | Description of representative list of rents | XMIETSPL | CHAR | 50 | 0 | |||||||||
| DGUELT | Valid-to date | DGUELT | DATS | 8 | 0 | |||||||||
| JZUABK | Reduction/surcharge features indicator | JZUABK | CHAR | 1 | 0 |
Possible values
|
||||||||
| JLAGEKL | Representative list of rents includes loc. class indicator | JLAGEKL | CHAR | 1 | 0 |
Possible values
|
||||||||
| JGRUND | Base amount/value table indicator | JGRUND | CHAR | 1 | 0 |
Possible values
|
||||||||
| JAUSKL | RLR Indicator for fixtures/fittings category (indicator) | JAUSKL | CHAR | 1 | 0 |
Possible values
|
||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||
| RERF | Entered by | RERF | CHAR | 12 | 0 | |||||||||
| DERF | First Entered on | DERF | DATS | 8 | 0 | |||||||||
| TERF | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||||
| REHER | Source of initial entry | REHER | CHAR | 10 | 0 | |||||||||
| RBEAR | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||||
| DBEAR | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||||
| TBEAR | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||||
| RBHER | Editing Source | RBHER | CHAR | 10 | 0 | |||||||||
| DGUELTB | Date from which representative list of rents is effective | DGUELTB | DATS | 8 | 0 | |||||||||
| FUNCT | FM for calculating rep.list of rents average rent | VVFUNCTMSP | CHAR | 30 | 0 | |||||||||
| JPUNKTE | Indicator: Rent adjustment by points | VVJPUNKTE | CHAR | 1 | 0 |
Possible values
|
||||||||
| SADJBASE | Selection of base rent acc.to representative list of rents | VVSADJBASE | CHAR | 1 | 0 |
Possible values
|
||||||||
| LANGU | Maintenance language for representative list of rents | VVSMSLANGU | T002 | LANG | 1 | 0 | ||||||||
| JCTRLTAB | Control table for RLR adjustment is inactive | VVJRACTRLTAB | CHAR | 1 | 0 |
Possible values
|
||||||||
| JDEFCOMM | Use default comment for control table | VVJRADEFCOMM | CHAR | 1 | 0 |
Possible values
|
||||||||
| SMAINMSP | Reference to main representative list of rents | VVSCONNMSP | TIV20 | CHAR | 6 | 0 | ||||||||
TIV20 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TIV20 | LANGU | TIV20 | LANGU | T002 | Language Keys (Component BC-I18) | SPRAS |
| TIV20 | MANDT | TIV20 | MANDT | T000 | Clients | MANDT |
| TIV20 | SMAINMSP | TIV20 | MANDT | TIV20 | Rep.list of rents master data | MANDT |
| TIV20 | SMAINMSP | TIV20 | SMAINMSP | TIV20 | Rep.list of rents master data | SMIETSP |
| TIV20 | WAERS | TIV20 | WAERS | TCURC | Currency Codes | WAERS |
| TIV20 | WAERS | TIV20 | MANDT | TCURC | Currency Codes | MANDT |
