OTC_CONV_IFINKO - Backup Table for Financial Transaction Underlying Conditions

Backup Table for Financial Transaction Underlying Conditions information is stored in SAP table OTC_CONV_IFINKO.
It is part of development package FTA in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "R/3 appl. development for Treasury money,forex,forward gen".

Fields for table OTC_CONV_IFINKO

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
RGATTClassXTI_RGATTCHAR26
RFHAFinancial TransactionXTB_RFHACHAR26
RFHAZUTransaction ActivityXTB_RFHAZUNUMC10
RKONDGRDirection of TransactionXTB_RKONDGRNUMC2
RKONDConditionXTB_KONDNUMC8
DGUEL_KPCondition Item Effective FromXDGUEL_KPDATS16
NSTUFELevel number of condition item for recurring paymentsXNSTUFENUMC4
.INCLUDEFTRS_VTBFINKO0
CRUSEREntered ByTB_CRUSERCHAR24
DCRDATEntered OnTB_DCRDATDATS16
TCRTIMEntry TimeTB_CRTIMCHAR12
UPUSERLast Changed ByTB_UPUSERCHAR24
DUPDATChanged OnTB_DUPDATDATS16
TUPTIMTime ChangedTB_TUPTIMTIMS12
SALTKONDUnit for supplementary condition itemsTB_SALKONDNUMC8
SZINSANPCross-referenced condition grp for interest rate adjustmentSZINSANPNUMC8
JNULLKONCondition FormJNULLKONCHAR2
SKOARTCondition Type (Smallest Subdivision of Condition Records)SKOARTNUMC8TZK01
SSIGNDirection of FlowTB_SSIGNCHAR2
SBKKLASClassification of Flows and ConditionsTB_SBKKLASCHAR2
SBKTYPCategory of Flows and ConditionsTB_SBKTYPCHAR4AT08
PKONDPercentage rate for condition itemsPKONDDEC6
BKONDCondition Item Currency AmountBKONDCURR7
SWHRKONDCurrency of Condition ItemSWHRKONDCUKY10TCURC
SBASISCalculation Base IndicatorSBASISCHAR8*
BBASISCalculation Base AmountTFM_BBASIS2CURR7
SZBMETHInterest Calculation MethodSZBMETHCHAR2
SKALIDWTInterest CalendarTFMSKALIDWTCHAR4
SINCLInclusive indicator for beginning and end of a periodVVSINCLNUMC2
SZSREFReference Interest RateSZSREFCHAR20T056R
SFORMREFFormula ReferenceTB_XFORMBECHAR8*
SVARNAMEVariable NameTB_VARNAMECHAR8
AMMRHYFrequency in monthsAMMRHYNUMC6
ATTRHYFrequency in DaysATTRHYNUMC6
DVALUTCalculation DateDVALUTDATS16
SVULTMonth-End Indicator for Calculation DateVVSBULTCHAR2
SVWERKWorking Day Shift for Calculation DayTB_SVWERKNUMC2
SVMETHMethod for determining the next value dateTB_SVMETHNUMC2
AVGSTAGENumber of Days for Relative Calculation of Value DateTB_AVGSTAGINT44
DFAELLDue dateDFAELLDATS16
SFULTMonth-End Indicator for Due DateSFULTCHAR2
SFWERKWorking Day Shift for Due DateTB_SFWERKNUMC2
SFMETHMethod for determining the next due dateTB_SFMETHNUMC2
AFGSTAGENumber of days for rel. determination of due dateTB_AFGSTAGINT44
SDWERKWorking Day Shift for Payment DateTB_SDWERKNUMC2
DZFESTInterest rate fixing dateTB_DZFESTDATS16
AZGSTAGENo. of Days for Relative Determinatn of Interest FixingTB_AZGSTAGINT44
DZSREFReference Interest Rate Fixing DateTB_ZSREFDATS16
SKALIDFactory calendarSKALIDCHAR4TFACD
SKALID2Factory calendarSKALIDCHAR4TFACD
RANTYPContract TypeRANTYPCHAR2
SHERKUNFTDisplay Area of Flow or ConditionTB_SHERKCHAR8
SRHYTHMFrequency IndicatorTB_SRHYTHMNUMC2
SBERFIMACalculation category for cash flow calculatorSBEWFIMACHAR8AT40
SZWERKShift to Working Day for Interest Fixing DateVVSZWERKNUMC2
RHANDPLExchangeVVRHANDPLCHAR20*
SKURSARTRate/Price Type - Treasury InstrumentsTI_KURSARTCHAR4
SFVMETHUpdate Method for Calculation Date/Due DateTB_SFVMETHNUMC4
SERBTERMFiMa indicator: Date and frequency inheritance for conditionTFMERBTERMCHAR2
SFRANZShift Due DateTFMSFRANZNUMC2
SEXCLGUELExclusive indicator for start date of condition positionTFMSEXCLKPNUMC2
JSOFVERRIndicator for Immediate Settlement (Financial Mathematics)TFMSOFVERRCHAR2
JEXPOZINSType of Compound Interest CalculationTFM_SINTCOMPCHAR2
SKALID3Factory calendarSKALIDCHAR4TFACD
PPAYMENTPayment RateTFM_PPAYMENTDEC6
SZEITANTIndicator for Pro Rata Temporis CalculationsVVSZEITANTNUMC2
PKOND1STPERInterest Rate for the First PeriodTFM_PKOND1STPERDEC6
SREFDISCReferenced Condition Group DiscountingSREFDISCNUMC8
SDISCOUNTDiscounting CategoryTFM_SDISCOUNTNUMC2
BROUNDUNITRounding UnitTFMPRUNITDEC7
SROUNDRounding CategoryTFM_SROUNDCHAR2
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc.TFM_AMMRHYZVNUMC4
FACILITYLINELine of CreditTB_CREDIT_LINECHAR6*
BGUEL_KPCondition Item Effective from AmountBGUEL_KPCURR9
SULTGUELMonth-end indicator for start date of condition positionTFMSULT_KPCHAR2
BBASISUNITBase Unit for RoundingTFM_BBASISUNITCURR9
RKONDREFReference Condition TypeTB_KONDREFNUMC8
STTLM_FREQCOMS: Settlement FrequencyFTR_COMS_SETTLE_FREQUENCYINT11
STTLM_FREQ_UNITCOMS: Settlement Frequency UnitFTR_COMS_SETTFRQ_UNITCHAR2
PAYDAT_OFFS_UNITCOMS: Determination Logic of Payment Date OffsetFTR_COMS_UNIT_PAYDATOFFCHAR2
COMMON_PRICINGIndicates Whether Common Pricing Is Used for Average PricingFTR_COMS_AVG_COMMON_PRICINGCHAR2
FIXING_DATE_RULECOMS: Fixing Date Rule for COMSFTR_COMS_FIX_DAT_RULECHAR2
WEEKDAY_NUMBERCOMS: Frequency of Occurrence of Weekday in PeriodFTR_COMS_OCCURE_OF_WDINT11
WEEKDAYCOMS: Day of Week for Price FixingFTR_COMS_FIX_WEEKDAYCHAR2
AVERAGE_FREQCOMS: Frequency for AverageFTR_COMS_AVERAG_FREQINT22
QUANQuantityFTR_QUANQUAN7
UNIT_OF_MEASUREUnit of Measure for the CommodityTPM_CTY_UOMUNIT6*
QUAN_RELATED_TOQuantity Related ToFTR_COMS_QUAN_VAL_PERCHAR2
REFERENCEReferenceFTR_REFERENCECHAR120
FX_TRANSLATIONDefines when quotation crcy is converted into payment crcyFTR_CURRENCY_CONV_POINT_IN_TIMCHAR2
EXCH_RATE_TYPEExchange Rate TypeKURST_CURRCHAR8*
CPCC_FLAGCOMS: Indicator for Consideration of Payment Crcy CalendarFTR_COMS_CPCC_FLAGCHAR2
JPROZRPercentage CalculationTB_JPROZRCHAR2
SFINCLInclusive Indicator for Due DateVVSFINCLNUMC2
JBMONATIndicator for calculating amount per monthJBMONATCHAR2
BUGRENZLower Limit for AmountTFMBUGRENZCURR12
BOGRENZUpper Limit for AmtTFMBOGRENZCURR12
SSTAFFType of Scaled CalculationTFMSSTAFFNUMC2
LOGIC_RKONDCondition GroupFTR_COND_GRPNUMC8
SKALID4Factory calendarSKALIDCHAR4TFACD
SKALID5Factory calendarSKALIDCHAR4TFACD
SROUNDFACTORRounding Category of a FactorTFM_SROUNDFACTORCHAR2
ROUNDDECFACTORNumber of Rounding Decimal Places for a FactorTFM_ROUNDDECFACTORINT11
JEXPOINTFACTORExponential Interest Calculation with FactorTFM_JEXPOINTFACTORCHAR2
SROUNDBASEFACTORRounding Category of a FactorTFM_SROUNDFACTORCHAR2
ROUNDDECBASEFACTORNumber of Rounding Decimal Places for a FactorTFM_ROUNDDECFACTORINT11
SSEQUENCEProcessing Sequence of ConditionsTFM_SEQUENCENUMC4
SROUNDRATEFACTORRounding Category of Interest FactorTFM_SROUNDRATEFACTORCHAR2
ROUNDDECRATEFACTORNumber of Rounding Decimal Places for Interest FactorTFM_ROUNDDECRATEFACTORINT11
ADGSTAGENumber of Days for Relative Payment Date CalculationTFM_ADGSTAGEINT44
JAVGCAPUse Upper Limit of Average Interest RateTFM_JAVGCAPCHAR2
PAVGCAPUpper Limit of Average Interest RateTFM_PAVGCAPDEC8
JAVGFLOORUse Lower Limit of Average Interest RateTFM_JAVGFLOORCHAR2
PAVGFLOORLower Limit of Average Interest RateTFM_PAVGFLOORDEC8
PAVGSPREADAverage Interest Rate SpreadTFM_PAVGSPREADDEC8
SROUNDAVGINTERESTRounding Category of Average Interest RateTFM_SROUNDAVGINTERESTCHAR2
ROUNDDECAVGINTERESTNumber of Rounding Decimal Places for Average Interest RateTFM_ROUNDDECAVGINTERESTINT11
SAVGWEIGHTWeighting Category of Interest RateTFM_SWEIGHTCHAR2
SFACTORRESETEvent for Resetting Factor CalculationTFM_SFACTORRESETCHAR2
JUGRENZUse Lower Limit of AmountTFM_JUGRENZCHAR2
JOGRENZUse Upper Limit of AmountTFM_JOGRENZCHAR2
INDEX_INTERPOLATEIndex Interpolation MethodTFM_INDEX_INTERPOLATECHAR8
PRICEINDEX_APPLYPrice Index Application MethodTFM_PRICEINDEX_APPLYCHAR8
INDEX_BASE_VALUEIndex Base ValueTFM_INDEX_BASEVALUED34R16
INDEX_BASE_DATEIndex Base DateTFM_INDEX_BASEDATEDATS16
INDEX_FIX_DATE_HIGHIndex Fixing DateTFM_INDEX_FIXDATEHIGHDATS16
INDEX_FIX_DATE_LOWIndex Fixing DateTFM_INDEX_FIXDATELOWDATS16
INDEX_ADJ_DATE_RELATIONReference Date for Index Adjustment DateTFM_INDEX_RELDATENUMC2
PRICEINDEX_RKONDREFReference Condition TypeTB_KONDREFNUMC8
SROUNDDAYFRACTIONDay Fraction Rounding CategoryTFM_SROUNDDAYFRACTIONCHAR2
ROUNDDECDAYFRACTIONNumber of Rounding Decimals for Day FractionTFM_ROUNDDECDAYFRACTIONINT11
PRICEINDEX_COMPOUND_FREQUENCYCompounding Frequency of Price Index FactorsTFM_PRICEINDEX_COMPOUNDFREQNUMC6
INDEX_FIX_DATE_DATESHIFTWorking Day Shift for Calculation DayTB_SVWERKNUMC2
INDEX_FIX_DATE_SHIFTDAYSNumber of Days for Relative Calculation of Value DateTB_AVGSTAGINT44
Privacy Policy