1. Home
  2. Resources
  3. SAP Tables
  4. TIPAL - RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.

SAP Table TIPAL

RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.

TIPAL (RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.) 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 TIPAL to other SAP tables.

TIPAL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
SMIETR Tenancy law SMIETR TIV03 CHAR 5 0
AJHRANP No. of years increase in percent. refer to (before key date) AJHRANP DEC 2 0
PERHJHR Normal rent cap in percentage (apartments after key date) PERHJHR DEC 7 2
PPROJHR Legally permitted percentage increase per year PPROJHR DEC 7 2
PZUABMAX Max. surch./reduct. for rental unit for rep. rent list adj. VVPZUABMAX DEC 4 2
DSTCHERH Key date for reduced limit VVDSTCHERH DATS 8 0
AJHRANPR No. yrs which reduced increase refers to on percentage basis VVAJHRANPR DEC 2 0
PERHJHRR Reduced limit in percent (apartments before key date) VVPERHJHRR DEC 7 2
BFEKAPAB Minimum rent per square unit for reduced capping limit VVBFEKAPAB CURR 9 2
WAERS Currency Key WAERS TCURC CUKY 5 0
BFEABS Max.capping limit for apartm. before key date/under min.amnt VVBFEABS CURR 9 2
AMONMIND Minimum interval between two rent adjustments in months VVAMONMIND NUMC 3 0
SBESANPA Special Features of Tenancy Law VVSBESANPA NUMC 2 0
00 No particular procedure
01 Swiss adjustment procedure
02 Italien specifications
03 Netherlands specifications
SKOARTOU Swiss adjustment: Condition type for typical local rent VVSKOARTOU TZK01 NUMC 4 0
SKOARTRS Adjustment Switzerland: Cond.type reserve from ref./apprec. VVSKOARTRS TZK01 NUMC 4 0
AJAHRNEU Rnt adj. by points: No.of years w/o building age reduction VVAJAHRNEU DEC 2 0
PMAXUSURY Excessive Rent Limit VVPMAXUSURY DEC 5 2
PDEFUSURY Default value for excessive rent limit VVPDEFUSURY DEC 5 2
SKOTYPBK Condition category "Operating costs" for rent adjustment VVSKOTYPBK TIK02 NUMC 3 0
SKOTYPAO Condition cat "Surcharges" for rent adjustment VVSKOTYPAO TIK02 NUMC 3 0
SKOARTFB Condition type "False occupancy charge" VVSKOARTFB TZK01 NUMC 4 0
SKOARTAZ Condition type "Settlement payment" VVSKOARTAZ TZK01 NUMC 4 0
JMONMIND Always calculate minimum interval from beginning of month VVJMONMINDDE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
JINDBASE Index-Linked Adj. Based on Index Level, Rent at Rental Start VVJINDBASE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

TIPAL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TIPAL SKOARTAZ TIPAL MANDT TZK01 Condition types MANDT
TIPAL SKOARTAZ '3' TZK01 Condition types RANTYP
TIPAL SKOARTAZ TIPAL SKOARTAZ TZK01 Condition types SKOART
TIPAL SKOARTFB TIPAL SKOARTFB TZK01 Condition types SKOART
TIPAL SKOARTFB TIPAL MANDT TZK01 Condition types MANDT
TIPAL SKOARTFB '3' TZK01 Condition types RANTYP
TIPAL SKOARTOU TIPAL MANDT TZK01 Condition types MANDT
TIPAL SKOARTOU '3' TZK01 Condition types RANTYP
TIPAL SKOARTOU TIPAL SKOARTOU TZK01 Condition types SKOART
TIPAL SKOARTRS '3' TZK01 Condition types RANTYP
TIPAL SKOARTRS TIPAL SKOARTRS TZK01 Condition types SKOART
TIPAL SKOARTRS TIPAL MANDT TZK01 Condition types MANDT
TIPAL SKOTYPAO TIPAL MANDT TIK02 Condition categories MANDT
TIPAL SKOTYPAO TIPAL SKOTYPAO TIK02 Condition categories SKOTYP
TIPAL SKOTYPBK TIPAL MANDT TIK02 Condition categories MANDT
TIPAL SKOTYPBK TIPAL SKOTYPBK TIK02 Condition categories SKOTYP
TIPAL SMIETR TIPAL MANDT TIV03 Country-specific tenancy law MANDT
TIPAL SMIETR TIPAL SMIETR TIV03 Country-specific tenancy law SMIETR
TIPAL WAERS TIPAL MANDT TCURC Currency Codes MANDT
TIPAL WAERS TIPAL WAERS TCURC Currency Codes WAERS