JBT_FTP_CALC_TRA SAP (Settings for Tranches for Calculation of Opp. Int. Rate) Table details
Description: Settings for Tranches for Calculation of Opp. Int. Rate
Related tables to JBT_FTP_CALC_TRA
Access table JBT_FTP_CALC_TRA
Table field list including key, data, relationships and ABAP select examples
JBT_FTP_CALC_TRA is a standard SAP Table which is used to store Settings for Tranches for Calculation of Opp. Int. Rate data and is available within R/3 SAP systems depending on the version and release level.
The JBT_FTP_CALC_TRA table consists of various fields, each holding specific information or linking keys about Settings for Tranches for Calculation of Opp. Int. Rate data available in SAP. These include COSTING_RULE (Costing Rule), CURRENCYCATEGORY (OI-Weighting, Division of Trans. and Local Currency), TRANCHE_NR (Number of Tranche), TRANCHE_WEIGHT (Tranche Weighting for Opportunity 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: Can be enhanced (character-type or numeric)
SAP JBT_FTP_CALC_TRA 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 | |||
COSTING_RULE | Costing Rule | JBRKALRG | CHAR | 8 | Assigned to domain | JBRKALRG | JB7 | ||
CURRENCYCATEGORY | OI-Weighting, Division of Trans. and Local Currency | JBROZWAE | CHAR | 1 | JBROZWAE | ||||
TRANCHE_NR | Number of Tranche | JBT_DTE_TRANCHE_NR | NUMC | 3 | NUMC3 | ||||
TRANCHE_WEIGHT | Tranche Weighting for Opportunity Interest Calculation | JBT_DTE_TRANCHE_WEIGHT | DEC | 10(9) | DEC1_9 | ||||
TRANCHE_SIGN | +/- Sign of Tranche for Opportunity Interest Calculation | JBT_DTE_TRANCHE_SIGN | CHAR | 1 | VVSEFFZIVZ | ||||
ADJBEGINDATESRC | Source of Adjustment Start Date | JBT_DTE_ADJUSTMNT_BEG_DATE_SRC | CHAR | 2 | JBT_ADJUSTMNT_BEG_DATE_SRC | ||||
ADJSTEPNRUNITS | Adjustment Step - Number of Units | JBT_DTE_ADJUSTMENT_STEP_NRUNTS | INT4 | 10 | INT4 | ||||
ADJSTEPUNIT | Time Unit | TIMEUNIT | CHAR | 1 | TIMEUNIT | ||||
REFERENCEDATESRC | Source of Reference Date | JBT_DTE_REFERENCE_DATE_SOURCE | CHAR | 2 | JBT_REFERENCE_DATE_SOURCE | ||||
REFERNCEINTRSTID | Reference Interest Rate | REFERENZ | CHAR | 10 | Assigned to domain | ZIREFKU | |||
YIELD_CURVE_TYPE | Yield Curve Type | JBSZKART | NUMC | 4 | Assigned to domain | JBSZKART | KURVENART | ||
INTERESTTERMSRC | Source of Opportunity Interest Rate | JBT_DTE_INTEREST_TERM_SOURCE | CHAR | 2 | JBT_INTEREST_TERM_SOURCE | ||||
INTRSTTRMNRUNITS | Opp. Int. Rate Term - Number of Units | JBT_DTE_FTP_INTRST_TERM_NRUNTS | INT4 | 10 | INT4 | ||||
INTRSTTRMUNIT | Time Unit | TIMEUNIT | CHAR | 1 | TIMEUNIT | ||||
INTERPOLATEORNOT | Interpolation of Opportunity Interest Rates | JBSOPPSU | CHAR | 1 | JBSOPPSU | ||||
AVRBEGOFFNRUNITS | Start of Averaging Period - Number of Units | JBT_DTE_AVRPERBEGOFFSET_NRUNTS | INT4 | 10 | INT4 | ||||
AVRBEGOFFUNIT | Time Unit | TIMEUNIT | CHAR | 1 | TIMEUNIT | ||||
AVRENDOFFNRUNITS | End of Averaging Period - Number of Units | JBT_DTE_AVRPERENDOFFSET_NRUNTS | INT4 | 10 | INT4 | ||||
AVRENDOFFUNIT | Time Unit | TIMEUNIT | CHAR | 1 | TIMEUNIT | ||||
AVRSTEPNRUNITS | Step Range for Averaging Period - Number of Units | JBT_DTE_AVER_PER_STEP_NR_UNITS | INT4 | 10 | INT4 | ||||
AVRSTEPUNIT | Time Unit | TIMEUNIT | CHAR | 1 | TIMEUNIT | ||||
INTMTHAVEFTRTHIS | Tranche Is Relevant to Interest Calculation Method | JBT_DTE_INTMETH_AVEFTR_THISTRA | CHAR | 1 | XFELD | ||||
EXCLFROMTOTALFTP | Exclusion Indicator for Opportunity Contribution | JBOPP_EXCL_FLG | CHAR | 1 | XFELD | ||||
AVER_VOL_VAL_FLD | Value Field for Average Volume | JBT_DTE_AVER_VOL_VALUE_FIELD | CHAR | 10 | CHAR010 | ||||
FTP_VALUE_FIELD | Value Field for Opportunity Contribution | JBT_DTE_FTP_VALUE_FIELD | CHAR | 10 | CHAR010 | ||||
FTP_VALUEFIELDLC | Value Field for Opportunity Contribution in LC | JBT_DTE_FTP_VALUE_FIELD_LC | CHAR | 10 | CHAR010 | ||||
USE_FTPCALC_BADI | Use BAdI for Weighted Independent Tranches | JBT_DTE_USE_FTPCALCULATOR_BADI | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table JBT_FTP_CALC_TRA using ABAP code
The following ABAP code Example will allow you to do a basic selection on JBT_FTP_CALC_TRA to SELECT all data from the tableDATA: WA_JBT_FTP_CALC_TRA TYPE JBT_FTP_CALC_TRA.
SELECT SINGLE *
FROM JBT_FTP_CALC_TRA
INTO CORRESPONDING FIELDS OF WA_JBT_FTP_CALC_TRA
WHERE...
How to access SAP table JBT_FTP_CALC_TRA
Within an ECC or HANA version of SAP you can also view further information about JBT_FTP_CALC_TRA 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