TPI02 SAP (Interest Calculation Profile and Interest Indicator) Table details
Description: Interest Calculation Profile and Interest Indicator
Table field list including key, data, relationships and ABAP select examples
TPI02 is a standard SAP Table which is used to store Interest Calculation Profile and Interest Indicator data and is available within R/3 SAP systems depending on the version and release level.
The TPI02 table consists of various fields, each holding specific information or linking keys about Interest Calculation Profile and Interest Indicator data available in SAP. These include ZSCHM (Interest Profile for Project/Order Interest Calculation), VZSKZ (Interest calculation indicator), WAERS (Currency Key), MDAYS (Minimum runtime in days for project interest calculation).. 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 TPI02 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 | T000 | MANDT | |||
ZSCHM | Interest Profile for Project/Order Interest Calculation | PS_ZSCHM | CHAR | 7 | TPI01 | PS_ZSCHM | |||
VZSKZ | Interest calculation indicator | PS_VZSKZ | CHAR | 2 | T056 | VZSKZ | |||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
MDAYS | Minimum runtime in days for project interest calculation | PS_MDAYS | NUMC | 3 | NUM3 | ||||
MAMNT | Threshold value, from which interest is calculated in the | PS_MAMNT | CURR | 15(2) | WERT15 | ||||
MINOP | Ind. And connection between threshold and runtime | PS_MINOP | CHAR | 1 | XFELD | ||||
PERBSL | Period control for compound interest calculation | PS_PERBSL | CHAR | 2 | T090R | PERBSL | |||
INVIN | Indic.interest calc. by invoice date | PS_INVIN | CHAR | 1 | XFELD | ||||
AFAPL | Chart of depreciaton for asset valuation | AFAPL | CHAR | 4 | T096 | AFAPL | AFP | H_AFAPL | |
AFABE | Depreciation Area of Base Value for Interest Calculation | PS_ZAFABE | NUMC | 2 | T093 | AFABE |
Key field | Non-key field |
How do I retrieve data from SAP table TPI02 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TPI02 to SELECT all data from the tableDATA: WA_TPI02 TYPE TPI02.
SELECT SINGLE *
FROM TPI02
INTO CORRESPONDING FIELDS OF WA_TPI02
WHERE...
How to access SAP table TPI02
Within an ECC or HANA version of SAP you can also view further information about TPI02 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