JBT_FTP_CALC_TRA SAP (Settings for Tranches for Calculation of Opp. Int. Rate) Table details

Dictionary Type: Table
Description: Settings for Tranches for Calculation of Opp. Int. Rate




ABAP Code to SELECT data from JBT_FTP_CALC_TRA
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 cust
Display/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
MANDTClient MANDTCLNT3Assigned to domainMANDT
COSTING_RULECosting Rule JBRKALRGCHAR8Assigned to domainJBRKALRGJB7
CURRENCYCATEGORYOI-Weighting, Division of Trans. and Local Currency JBROZWAECHAR1JBROZWAE
TRANCHE_NRNumber of Tranche JBT_DTE_TRANCHE_NRNUMC3NUMC3
TRANCHE_WEIGHTTranche Weighting for Opportunity Interest Calculation JBT_DTE_TRANCHE_WEIGHTDEC10(9) DEC1_9
TRANCHE_SIGN+/- Sign of Tranche for Opportunity Interest Calculation JBT_DTE_TRANCHE_SIGNCHAR1VVSEFFZIVZ
ADJBEGINDATESRCSource of Adjustment Start Date JBT_DTE_ADJUSTMNT_BEG_DATE_SRCCHAR2JBT_ADJUSTMNT_BEG_DATE_SRC
ADJSTEPNRUNITSAdjustment Step - Number of Units JBT_DTE_ADJUSTMENT_STEP_NRUNTSINT410INT4
ADJSTEPUNITTime Unit TIMEUNITCHAR1TIMEUNIT
REFERENCEDATESRCSource of Reference Date JBT_DTE_REFERENCE_DATE_SOURCECHAR2JBT_REFERENCE_DATE_SOURCE
REFERNCEINTRSTIDReference Interest Rate REFERENZCHAR10Assigned to domainZIREFKU
YIELD_CURVE_TYPEYield Curve Type JBSZKARTNUMC4Assigned to domainJBSZKARTKURVENART
INTERESTTERMSRCSource of Opportunity Interest Rate JBT_DTE_INTEREST_TERM_SOURCECHAR2JBT_INTEREST_TERM_SOURCE
INTRSTTRMNRUNITSOpp. Int. Rate Term - Number of Units JBT_DTE_FTP_INTRST_TERM_NRUNTSINT410INT4
INTRSTTRMUNITTime Unit TIMEUNITCHAR1TIMEUNIT
INTERPOLATEORNOTInterpolation of Opportunity Interest Rates JBSOPPSUCHAR1JBSOPPSU
AVRBEGOFFNRUNITSStart of Averaging Period - Number of Units JBT_DTE_AVRPERBEGOFFSET_NRUNTSINT410INT4
AVRBEGOFFUNITTime Unit TIMEUNITCHAR1TIMEUNIT
AVRENDOFFNRUNITSEnd of Averaging Period - Number of Units JBT_DTE_AVRPERENDOFFSET_NRUNTSINT410INT4
AVRENDOFFUNITTime Unit TIMEUNITCHAR1TIMEUNIT
AVRSTEPNRUNITSStep Range for Averaging Period - Number of Units JBT_DTE_AVER_PER_STEP_NR_UNITSINT410INT4
AVRSTEPUNITTime Unit TIMEUNITCHAR1TIMEUNIT
INTMTHAVEFTRTHISTranche Is Relevant to Interest Calculation Method JBT_DTE_INTMETH_AVEFTR_THISTRACHAR1XFELD
EXCLFROMTOTALFTPExclusion Indicator for Opportunity Contribution JBOPP_EXCL_FLGCHAR1XFELD
AVER_VOL_VAL_FLDValue Field for Average Volume JBT_DTE_AVER_VOL_VALUE_FIELDCHAR10CHAR010
FTP_VALUE_FIELDValue Field for Opportunity Contribution JBT_DTE_FTP_VALUE_FIELDCHAR10CHAR010
FTP_VALUEFIELDLCValue Field for Opportunity Contribution in LC JBT_DTE_FTP_VALUE_FIELD_LCCHAR10CHAR010
USE_FTPCALC_BADIUse BAdI for Weighted Independent Tranches JBT_DTE_USE_FTPCALCULATOR_BADICHAR1XFELD

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!