1. Home
  2. Resources
  3. SAP Tables
  4. TIV20 - Rep.list of rents master data

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
NULL No
X Yes
JLAGEKL Representative list of rents includes loc. class indicator JLAGEKL CHAR 1 0
NULL No
X Yes
JGRUND Base amount/value table indicator JGRUND CHAR 1 0
NULL No
X Yes
JAUSKL RLR Indicator for fixtures/fittings category (indicator) JAUSKL CHAR 1 0
NULL No
X Yes
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
X Yes
NULL No
SADJBASE Selection of base rent acc.to representative list of rents VVSADJBASE CHAR 1 0
L Lower limit of representative list of rents field
M Average value of representative list of rents field
H Upper level of representative list of rents field
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
X Yes
NULL No
JDEFCOMM Use default comment for control table VVJRADEFCOMM CHAR 1 0
X Yes
NULL No
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