TIPAL SAP (RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.) Table details
Description: RE: Tenancy Law/Country-Dependent Parameters for Rent Adj.
Table field list including key, data, relationships and ABAP select examples
TIPAL is a standard SAP Table which is used to store RE: Tenancy Law/Country-Dependent Parameters for Rent Adj. data and is available within R/3 SAP systems depending on the version and release level.
The TIPAL table consists of various fields, each holding specific information or linking keys about RE: Tenancy Law/Country-Dependent Parameters for Rent Adj. data available in SAP. These include SMIETR (Tenancy law), AJHRANP (No. of years increase in percent. refer to (before key date)), PERHJHR (Normal rent cap in percentage (apartments after key date)), PPROJHR (Legally permitted percentage increase per year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TIPAL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
SMIETR | Tenancy law | SMIETR | CHAR | 5 | TIV03 | SMIETR | |||
AJHRANP | No. of years increase in percent. refer to (before key date) | AJHRANP | DEC | 2 | DEC2 | ||||
PERHJHR | Normal rent cap in percentage (apartments after key date) | PERHJHR | DEC | 7(2) | DEC5_2 | ||||
PPROJHR | Legally permitted percentage increase per year | PPROJHR | DEC | 7(2) | DEC5_2 | ||||
PZUABMAX | Max. surch./reduct. for rental unit for rep. rent list adj. | VVPZUABMAX | DEC | 4(2) | DEC2_2 | ||||
DSTCHERH | Key date for reduced limit | VVDSTCHERH | DATS | 8 | DATUM | ||||
AJHRANPR | No. yrs which reduced increase refers to on percentage basis | VVAJHRANPR | DEC | 2 | DEC2 | ||||
PERHJHRR | Reduced limit in percent (apartments before key date) | VVPERHJHRR | DEC | 7(2) | DEC5_2 | ||||
BFEKAPAB | Minimum rent per square unit for reduced capping limit | VVBFEKAPAB | CURR | 9(2) | WERT5 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
BFEABS | Max.capping limit for apartm. before key date/under min.amnt | VVBFEABS | CURR | 9(2) | WERT5 | ||||
AMONMIND | Minimum interval between two rent adjustments in months | VVAMONMIND | NUMC | 3 | NUMC03 | ||||
SBESANPA | Special Features of Tenancy Law | VVSBESANPA | NUMC | 2 | VVSBESANPA | ||||
SKOARTOU | Swiss adjustment: Condition type for typical local rent | VVSKOARTOU | NUMC | 4 | TZK01 | SKOART | |||
SKOARTRS | Adjustment Switzerland: Cond.type reserve from ref./apprec. | VVSKOARTRS | NUMC | 4 | TZK01 | SKOART | |||
AJAHRNEU | Rnt adj. by points: No.of years w/o building age reduction | VVAJAHRNEU | DEC | 2 | DEC2 | ||||
PMAXUSURY | Excessive Rent Limit | VVPMAXUSURY | DEC | 5(2) | DEC3_2 | ||||
PDEFUSURY | Default value for excessive rent limit | VVPDEFUSURY | DEC | 5(2) | DEC3_2 | ||||
SKOTYPBK | Condition category 'Operating costs' for rent adjustment | VVSKOTYPBK | NUMC | 3 | TIK02 | SKOTYP | |||
SKOTYPAO | Condition cat 'Surcharges' for rent adjustment | VVSKOTYPAO | NUMC | 3 | TIK02 | SKOTYP | |||
SKOARTFB | Condition type 'False occupancy charge' | VVSKOARTFB | NUMC | 4 | TZK01 | SKOART | |||
SKOARTAZ | Condition type 'Settlement payment' | VVSKOARTAZ | NUMC | 4 | TZK01 | SKOART | |||
JMONMIND | Always calculate minimum interval from beginning of month | VVJMONMINDDE | CHAR | 1 | FLAG | ||||
JINDBASE | Index-Linked Adj. Based on Index Level, Rent at Rental Start | VVJINDBASE | CHAR | 1 | FLAG |
Key field | Non-key field |
How do I retrieve data from SAP table TIPAL using ABAP code
The following ABAP code Example will allow you to do a basic selection on TIPAL to SELECT all data from the tableDATA: WA_TIPAL TYPE TIPAL.
SELECT SINGLE *
FROM TIPAL
INTO CORRESPONDING FIELDS OF WA_TIPAL
WHERE...
How to access SAP table TIPAL
Within an ECC or HANA version of SAP you can also view further information about TIPAL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects