SAP ABAP Table TIPAL (RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.)

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	TRANSP	Transparent table
Transparent table	TIPAL	Table Relationship Diagram
Short Description	RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.

Delivery and Maintenance

Pool/cluster
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	*
2	SMIETR	☑	SMIETR	SMIETR	CHAR	5	0	Tenancy law	TIV03
3	AJHRANP	☐	AJHRANP	DEC2	DEC	2	0	No. of years increase in percent. refer to (before key date)
4	PERHJHR	☐	PERHJHR	DEC5_2	DEC	7	2	Normal rent cap in percentage (apartments after key date)
5	PPROJHR	☐	PPROJHR	DEC5_2	DEC	7	2	Legally permitted percentage increase per year
6	PZUABMAX	☐	VVPZUABMAX	DEC2_2	DEC	4	2	Max. surch./reduct. for rental unit for rep. rent list adj.
7	DSTCHERH	☐	VVDSTCHERH	DATUM	DATS	8	0	Key date for reduced limit
8	AJHRANPR	☐	VVAJHRANPR	DEC2	DEC	2	0	No. yrs which reduced increase refers to on percentage basis
9	PERHJHRR	☐	VVPERHJHRR	DEC5_2	DEC	7	2	Reduced limit in percent (apartments before key date)
10	BFEKAPAB	☐	VVBFEKAPAB	WERT5	CURR	9	2	Minimum rent per square unit for reduced capping limit
11	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
12	BFEABS	☐	VVBFEABS	WERT5	CURR	9	2	Max.capping limit for apartm. before key date/under min.amnt
13	AMONMIND	☐	VVAMONMIND	NUMC03	NUMC	3	0	Minimum interval between two rent adjustments in months
14	SBESANPA	☐	VVSBESANPA	VVSBESANPA	NUMC	2	0	Special Features of Tenancy Law
15	SKOARTOU	☐	VVSKOARTOU	SKOART	NUMC	4	0	Swiss adjustment: Condition type for typical local rent	TZK01
16	SKOARTRS	☐	VVSKOARTRS	SKOART	NUMC	4	0	Adjustment Switzerland: Cond.type reserve from ref./apprec.	TZK01
17	AJAHRNEU	☐	VVAJAHRNEU	DEC2	DEC	2	0	Rnt adj. by points: No.of years w/o building age reduction
18	PMAXUSURY	☐	VVPMAXUSURY	DEC3_2	DEC	5	2	Excessive Rent Limit
19	PDEFUSURY	☐	VVPDEFUSURY	DEC3_2	DEC	5	2	Default value for excessive rent limit
20	SKOTYPBK	☐	VVSKOTYPBK	SKOTYP	NUMC	3	0	Condition category "Operating costs" for rent adjustment	TIK02
21	SKOTYPAO	☐	VVSKOTYPAO	SKOTYP	NUMC	3	0	Condition cat "Surcharges" for rent adjustment	TIK02
22	SKOARTFB	☐	VVSKOARTFB	SKOART	NUMC	4	0	Condition type "False occupancy charge"	TZK01
23	SKOARTAZ	☐	VVSKOARTAZ	SKOART	NUMC	4	0	Condition type "Settlement payment"	TZK01
24	JMONMIND	☐	VVJMONMINDDE	FLAG	CHAR	1	0	Always calculate minimum interval from beginning of month
25	JINDBASE	☐	VVJINDBASE	FLAG	CHAR	1	0	Index-Linked Adj. Based on Index Level, Rent at Rental Start

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TIPAL	SKOARTAZ	TZK01	SKOART	KEY	1	CN
2	TIPAL	SKOARTFB	TZK01	SKOART	KEY	1	CN
3	TIPAL	SKOARTOU	TZK01	SKOART	KEY	1	CN
4	TIPAL	SKOARTRS	TZK01	SKOART	KEY	1	CN
5	TIPAL	SKOTYPAO	TIK02	SKOTYP	KEY	1	CN
6	TIPAL	SKOTYPBK	TIK02	SKOTYP	KEY	1	CN
7	TIPAL	SMIETR	TIV03	SMIETR	KEY	1	C
8	TIPAL	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in