TIV20
Rep.list of rents master dataExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TIV20.
SAP table TIV20 has 2 primary key fields: MANDT,SMIETSP.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
TIV20 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| Key SMIETSP | Representative list of rents assignment | CHAR | 6 | 0 | SMIETSP | ||||||||
| XLBEZ | Description of representative list of rents | CHAR | 50 | 0 | XMIETSPL | ||||||||
| DGUELT | Valid-to date | DATS | 8 | 0 | DGUELT | ||||||||
| JZUABK | Reduction/surcharge features indicator | CHAR | 1 | 0 | JZUABK | ||||||||
| JLAGEKL | Representative list of rents includes loc. class indicator | CHAR | 1 | 0 | JLAGEKL | ||||||||
| JGRUND | Base amount/value table indicator | CHAR | 1 | 0 | JGRUND | ||||||||
| JAUSKL | RLR Indicator for fixtures/fittings category (indicator) | CHAR | 1 | 0 | JAUSKL | ||||||||
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |||||||
| RERF | Entered By | CHAR | 12 | 0 | RERF | ||||||||
| DERF | First Entered On | DATS | 8 | 0 | DERF | ||||||||
| TERF | Time of Creation | TIMS | 6 | 0 | TERF | ||||||||
| REHER | Source of Initial Entry | CHAR | 10 | 0 | REHER | ||||||||
| RBEAR | Employee ID | CHAR | 12 | 0 | RBEAR | ||||||||
| DBEAR | Last Edited On | DATS | 8 | 0 | DBEAR | ||||||||
| TBEAR | Last Edited At | TIMS | 6 | 0 | TBEAR | ||||||||
| RBHER | Editing Source | CHAR | 10 | 0 | RBHER | ||||||||
| DGUELTB | Date from which representative list of rents is effective | DATS | 8 | 0 | DGUELTB | ||||||||
| FUNCT | FM for calculating rep.list of rents average rent | CHAR | 30 | 0 | VVFUNCTMSP | ||||||||
| JPUNKTE | Indicator: Rent adjustment by points | CHAR | 1 | 0 | VVJPUNKTE | ||||||||
| SADJBASE | Selection of base rent acc.to representative list of rents | CHAR | 1 | 0 | VVSADJBASE | ||||||||
| |||||||||||||
| LANGU | Maintenance language for representative list of rents | LANG | 1 | 0 | T002 | VVSMSLANGU | |||||||
| JCTRLTAB | Control table for RLR adjustment is inactive | CHAR | 1 | 0 | VVJRACTRLTAB | ||||||||
| JDEFCOMM | Use default comment for control table | CHAR | 1 | 0 | VVJRADEFCOMM | ||||||||
| SMAINMSP | Reference to main representative list of rents | CHAR | 6 | 0 | TIV20 | VVSCONNMSP | |||||||