1. Home
  2. Resources
  3. SAP Tables
  4. BAPI_FTR_GETDETAIL_IRATE - Read Interest Rate Instrument per BAPI

SAP Table BAPI_FTR_GETDETAIL_IRATE

Read Interest Rate Instrument per BAPI

BAPI_FTR_GETDETAIL_IRATE (Read Interest Rate Instrument per BAPI) 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 BAPI_FTR_GETDETAIL_IRATE to other SAP tables.

BAPI_FTR_GETDETAIL_IRATE table fields

Field Data element Checktable Datatype Length Decimals
CURRENCY Currency of transaction TB_WGSCHFT CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
START_TERM Term Start TB_DBLFZ DATS 8 0
END_TERM Term End TB_DELFZ DATS 8 0
NOMINAL_AMOUNT Amount or Balance BAPITM_BSALDO DEC 23 4
NOMINAL_AMOUNT_CHAR Amount as text field TM_XBETRAG CHAR 18 0
INTEREST_RATE_STRUCTURE Treasury: Interest Form TB_IRATE_STRUCTURE NUMC 1 0
1 Fixed
2 Variable
3 Amount
FLOW_TYPE Flow Type TB_SFHAZBA CHAR 4 0
INTEREST_CONDITION_TYPE Condition Type (Smallest Subdivision of Condition Records) SKOART NUMC 4 0
INTEREST_RATE_REFERENCE Reference Interest Rate SZSREF CHAR 10 0
INTEREST_RATE Interest rate TM_PZINS DEC 10 7
INTEREST_RATE_AMOUNT Interest Amount BAPITM_INTEREST_RATE_AMOUNT DEC 23 4
INTEREST_RATE_AMOUNT_CHAR Amount as text field TM_XBETRAG CHAR 18 0
INTEREST_CALC_METH Interest Calculation Method SZBMETH CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
FREQUENCY_CATEGORY Frequency Indicator TB_SRHYTHM NUMC 1 0
1 At end of term
5 On first day of month
2 On last day of month
3 Monthly
4 Daily
0 Manual input
FREQUENCY Defined Frequency in Days or Months TB_ARHYTM NUMC 3 0
START_INCLUSIVE Calculation Period: Start Inclusive vs. End Inclusive TB_SINCLBE CHAR 1 0
NULL Start inclusive
X End inclusive
INTEREST_CAPITAL Capitalize Interest TB_SZINSKAP CHAR 1 0
X Yes
NULL No
SHIFT_DUE_DATE_TO_END Shift Due Date Back to End of Term TB_SFRANZE CHAR 1 0
X Yes
NULL No
WKDAY_SHIFT_VALUE_DATE Working Day Shift for Calculation Day TB_SVWERK NUMC 1 0
0 No shift
1 Next Working Day
2 Next Working Day Modified
3 Previous Working Day
4 Previous Working Day Modified
5 Next Working Day in Same Calendar Year
6 Previous Working Day in Same Calendar Year
WKDAY_SHIFT_DUE_DATE Working Day Shift for Due Date TB_SFWERK NUMC 1 0
0 No shift
1 Next Working Day
2 Next Working Day Modified
3 Previous Working Day
4 Previous Working Day Modified
5 Next Working Day in Same Calendar Year
6 Previous Working Day in Same Calendar Year
ROUND_AMNT_GEN_FLOW Rounding Category TFM_SROUND CHAR 1 0
NULL Round to the Nearest
- Round Down
+ Round Up
INTEREST_CALENDAR_ID Interest Calendar TFMSKALIDWT CHAR 2 0
REPAY_STRUCTURE Treasury: Repayment Form TB_REPAYM_STRUCTURE NUMC 1 0
1 Final repayment
2 Instalment repayment
3 Annuity repayment
REPAY_CONDITION_TYPE Condition Type (Smallest Subdivision of Condition Records) SKOART NUMC 4 0
REPAY_AMOUNT Repayment Amount BAPITM_REPAYMENT_AMOUNT DEC 23 4
REPAY_AMOUNT_CHAR Amount as text field TM_XBETRAG CHAR 18 0
REPAY_FREQUENCY_CAT Frequency Indicator TB_SRHYTHM NUMC 1 0
1 At end of term
5 On first day of month
2 On last day of month
3 Monthly
4 Daily
0 Manual input
REPAY_FREQUENCY Defined Frequency in Days or Months TB_ARHYTM NUMC 3 0
REPAY_DAY_SHIFT_VALUE_DATE Working Day Shift for Calculation Day TB_SVWERK NUMC 1 0
0 No shift
1 Next Working Day
2 Next Working Day Modified
3 Previous Working Day
4 Previous Working Day Modified
5 Next Working Day in Same Calendar Year
6 Previous Working Day in Same Calendar Year
REPAY_SHIFT_DUE_DATE_TO_END Shift Due Date Back to End of Term TB_SFRANZE CHAR 1 0
X Yes
NULL No
EFFECTIVE_FROM Condition Item Valid From DGUEL_KP DATS 8 0
INTEREST_FIRST_DUE_DATE First Due Date for Interest TBFAELTZ DATS 8 0
INTEREST_CALCULATION_DATE Calculation Date DVALUT DATS 8 0
FREQUENCY_UNIT Treasury: Unit of Frequency TB_ARHYTM_UNIT NUMC 1 0
1 Days
2 Months
INTEREST_MARKUP_MARKDOWN Interest Markup/Markdown TB_ZZS DEC 10 7
INTEREST_RATE_FIRST_PERIOD Interest Rate for the First Period TFM_PKOND1STPER DEC 10 7
INTEREST_CALCULATION_EXPONENT Exponential Interest Calculation TB_JZINSRE CHAR 1 0
X Yes
NULL No
DATE_DETERMINATION_SHIFT_DAYS Shift due date towards end of interest period TBVFAETZ INT4 10 0
CALCULATION_UPDATE_RULE Treasury: Update for Calculation Date/Due Date TB_UPDATERULE NUMC 2 0
01 Regular
02 Unadjusted (Interest Rate Period)
03 Adjusted (Interest Rate Period)
04 Regular with Variable Dates/Unadjusted
05 Regular with Variable Dates/Adjusted
06 Single Dates/Unadjusted
07 Single Dates/Adjusted
08 Single Dates
09 Unadjusted
10 Adjusted
11 Regular/Due Date at Start of Period
FORMULA FTR: Interest Formula TB_IRATE_FORMULA CHAR 100 0
EFFECTIVE_INTEREST_RATE Effective Interest Rate TB_PYIELD DEC 10 7
EFFECTIVE_INTEREST_CALC_METH Effective Interest Method (Financial Mathematics) SEFFMETH NUMC 1 0
1 PAngV
2 AIBD/ISMA
3 Braess
4 Moosmueller
5 US method
6 EU Act/365
8 EU 30.42/365
9 Linear
REPAY_EFFECTIVE_FROM Condition Item Valid From DGUEL_KP DATS 8 0
REPAY_FIRST_DUE_DATE First Due Date for Interest TBFAELTZ DATS 8 0
REPAY_CALCULATION_DATE Calculation Date DVALUT DATS 8 0
REPAY_FREQUENCY_UNIT Treasury: Unit of Frequency TB_ARHYTM_UNIT NUMC 1 0
1 Days
2 Months
PAYMENT_AMOUNT Payment Amount BAPITB_BZBETR DEC 23 4
PAYMENT_AMOUNT_CHAR Amount as text field TM_XBETRAG CHAR 18 0
RATE_PERCENTAGE Price as percentage quotation TB_PWKURS DEC 10 7