SAP ABAP Table TIV20 (Rep.list of rents master data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	POOL	Pooled table
Pooled table	TIV20	Table Relationship Diagram
Short Description	Rep.list of rents master data

Delivery and Maintenance

Pool/cluster	ATAB
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SMIETSP	☑	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment
3	XLBEZ	☐	XMIETSPL	XTEXT50	CHAR	50	0	Description of representative list of rents
4	DGUELT	☐	DGUELT	DDAT	DATS	8	0	Valid-to date
5	JZUABK	☐	JZUABK	JANE	CHAR	1	0	Reduction/surcharge features indicator
6	JLAGEKL	☐	JLAGEKL	JANE	CHAR	1	0	Representative list of rents includes loc. class indicator
7	JGRUND	☐	JGRUND	JANE	CHAR	1	0	Base amount/value table indicator
8	JAUSKL	☐	JAUSKL	JANE	CHAR	1	0	RLR Indicator for fixtures/fittings category (indicator)
9	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
10	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
11	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
12	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
13	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
14	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
15	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
16	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
17	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
18	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
19	DGUELTB	☐	DGUELTB	DATS	DATS	8	0	Date from which representative list of rents is effective
20	FUNCT	☐	VVFUNCTMSP	CHAR30	CHAR	30	0	FM for calculating rep.list of rents average rent
21	JPUNKTE	☐	VVJPUNKTE	XFELD	CHAR	1	0	Indicator: Rent adjustment by points
22	SADJBASE	☐	VVSADJBASE	VVSADJBASE	CHAR	1	0	Selection of base rent acc.to representative list of rents
23	LANGU	☐	VVSMSLANGU	SPRAS	LANG	1	0	Maintenance language for representative list of rents	T002
24	JCTRLTAB	☐	VVJRACTRLTAB	XFELD	CHAR	1	0	Control table for RLR adjustment is inactive
25	JDEFCOMM	☐	VVJRADEFCOMM	XFELD	CHAR	1	0	Use default comment for control table
26	SMAINMSP	☐	VVSCONNMSP	SMIETSP	CHAR	6	0	Reference to main representative list of rents	TIV20

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TIV20	LANGU	T002	SPRAS	KEY	1	CN
2	TIV20	MANDT	T000	MANDT	KEY	1	CN
3	TIV20	SMAINMSP	TIV20	SMIETSP	KEY	1	CN
4	TIV20	WAERS	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in