SAP ABAP Table VTIPAL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VTIPAL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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

History

Last changed by/on	SAP	20130529
SAP Release Created in