VTIFINKO SAP (Underlying transaction conditions) Table details

Dictionary Type: Table
Description: Underlying transaction conditions




ABAP Code to SELECT data from VTIFINKO
Related tables to VTIFINKO
Access table VTIFINKO




Table field list including key, data, relationships and ABAP select examples

VTIFINKO is a standard SAP Table which is used to store Underlying transaction conditions data and is available within R/3 SAP systems depending on the version and release level.

The VTIFINKO table consists of various fields, each holding specific information or linking keys about Underlying transaction conditions data available in SAP. These include RGATT (Class), RFHA (Financial Transaction), RFHAZU (Transaction activity), RKONDGR (Direction of Transaction).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VTIFINKO 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
RGATTClass TI_RGATTCHAR13ALPHAT_RGATTT04
RFHAFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
RFHAZUTransaction activity TB_RFHAZUNUMC5T_RFHAZUFAS
RKONDGRDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
RKONDCondition TB_KONDNUMC4T_KOND
DGUEL_KPCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFELevel number of condition item for recurring payments NSTUFENUMC2NUMC2
CRUSEREntered by TB_CRUSERCHAR12SYCHAR12
DCRDATEntered On TB_DCRDATDATS8DATUM
TCRTIMEntry Time TB_CRTIMCHAR6TIME06
UPUSERLast Changed by TB_UPUSERCHAR12SYCHAR12
DUPDATChanged on TB_DUPDATDATS8DATUM
TUPTIMTime changed TB_TUPTIMTIMS6UZEIT
SALTKONDUnit for supplementary condition items TB_SALKONDNUMC4SKONDGRP
SZINSANPCross-referenced condition grp for interest rate adjustment SZINSANPNUMC4SKONDGRP
JNULLKONCondition Form JNULLKONCHAR1SKONDF
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4TZK01SKOART
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
SBKKLASClassification of flows and conditions TB_SBKKLASCHAR1T_SBKKLAS
SBKTYPCategory of Flows and Conditions TB_SBKTYPCHAR2AT08T_SBKTYP
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
BKONDCondition item currency amount BKONDCURR13(2) WERTV7
SWHRKONDCurrency of Condition Item SWHRKONDCUKY5TCURCWAERS
SBASISCalculation base indicator SBASISCHAR4Assigned to domainVVSBASIS
BBASISCalculation Base Amount TFM_BBASIS2CURR13(2) TFM_WRTV7
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2Assigned to domainWFCIDH_TFACD
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SZSREFReference Interest Rate SZSREFCHAR10T056RZIREFKU
SFORMREFFormula Reference TB_XFORMBECHAR4Assigned to domainT_FORMBE
SVARNAMEVariable Name TB_VARNAMECHAR4T_XFELD04
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
ATTRHYFrequency in Days ATTRHYNUMC3NUMC03
DVALUTCalculation Date DVALUTDATS8DATUM
SVULTMonth-end indicator for calculation date VVSBULTCHAR1JFLAGG
SVWERKWorking Day Shift for Calculation Day TB_SVWERKNUMC1T_SWERK
SVMETHMethod for determining the next value date TB_SVMETHNUMC1T_SVMETH
AVGSTAGENumber of Days for Relative Calculation of Value Date TB_AVGSTAGINT410T_GSTAGE
DFAELLDue date DFAELLDATS8DATUM
SFULTMonth-End Indicator for Due Date SFULTCHAR1VVSULT
SFWERKWorking Day Shift for Due Date TB_SFWERKNUMC1T_SWERK
SFMETHMethod for determining the next due date TB_SFMETHNUMC1T_SFMETH
AFGSTAGENumber of days for rel. determination of due date TB_AFGSTAGINT410T_GSTAGE
SDWERKWorking Day Shift for Payment Date TB_SDWERKNUMC1T_SWERK
DZFESTInterest rate fixing date TB_DZFESTDATS8DATUM
AZGSTAGENo. of days for relative determinatn of interest fixing TB_AZGSTAGINT410T_GSTAGE
DZSREFReference interest rate fixing date TB_ZSREFDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
SKALID2Factory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
RANTYPContract Type RANTYPCHAR1RANTYP
SHERKUNFTDisplay Area of Flow or Condition TB_SHERKCHAR4T_XFELD04
SRHYTHMFrequency Indicator TB_SRHYTHMNUMC1T_SRHYTHM
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4AT40SBEWFIMA
SZWERKShift to working day for interest fixing date VVSZWERKNUMC1T_SWERK
RHANDPLExchange VVRHANDPLCHAR10Assigned to domainVVRHANDPLWHP
SKURSARTRate/Price Type - Treasury Instruments TI_KURSARTCHAR2Assigned to domainVVSKURSARTRATETYPE_F4
SFVMETHUpdate method for calculation date/due date TB_SFVMETHNUMC2T_SFVMETH
SERBTERMFiMa indicator: Date and frequency inheritance for condition TFMERBTERMCHAR1TFMERBTERM
SFRANZShift Due Date TFMSFRANZNUMC1TFMSFRANZ
SEXCLGUELExclusive indicator for start date of condition position TFMSEXCLKPNUMC1VVSEXCLVON
JSOFVERRIndicator for Immediate Settlement (Financial Mathematics) TFMSOFVERRCHAR1TFMSOFVERR
JEXPOZINSExponential Interest Calculation TB_JZINSRECHAR1XFELD
SKALID3Factory calendar SKALIDCHAR2TFACDWFCIDH_TFACD
PPAYMENTPayment Rate TFM_PPAYMENTDEC11(7) TFM_PPAYMENT
SZEITANTIndicator for Pro Rata Temporis Calculations VVSZEITANTNUMC1VVSZEITANT
PKOND1STPERInterest Rate for the First Period TFM_PKOND1STPERDEC10(7) DECV3_7
SREFDISCReferenced Condition Group Discounting SREFDISCNUMC4SKONDGRP
SDISCOUNTDiscounting Category TFM_SDISCOUNTNUMC1TFM_SDISCOUNT
BROUNDUNITRounding Unit TFMPRUNITDEC13(7) TFMSRUNIT
SROUNDRounding Category TFM_SROUNDCHAR1TFM_SROUND
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZVNUMC2TFM_AMMRHYZV
FACILITYLINELine of Credit TB_CREDIT_LINECHAR3Assigned to domainT_CREDIT_LINE
BGUEL_KPCondition Item Effective from Amount BGUEL_KPCURR17(2) T_POS_AMOUNT
SULTGUELMonth-end indicator for start date of condition position TFMSULT_KPCHAR1VVSULT
BBASISUNITBase Unit for Rounding TFM_BBASISUNITCURR17(2) TFM_WRTV9
RKONDREFReference Condition Type TB_KONDREFNUMC4T_KOND
STTLM_FREQCOMS: Settlement Frequency FTR_COMS_SETTLE_FREQUENCYINT13
STTLM_FREQ_UNITCOMS: Settlement Frequency Unit FTR_COMS_SETTFRQ_UNITCHAR1FTR_COMS_DSETTFRQ_UNIT
PAYDAT_OFFS_UNITCOMS: Unit for Payment Date Offset FTR_COMS_UNIT_PAYDATOFFCHAR1FTR_COMS_DUNIT_PAYDATOFF
COMMON_PRICINGIndicates Whether Common Pricing Is Used for Average Pricing FTR_COMS_AVG_COMMON_PRICINGCHAR1FTR_COMS_AVG_COMMON_PRICING
FIXING_DATE_RULECOMS: Fixing Date Rule for COMS FTR_COMS_FIX_DAT_RULECHAR1FTR_COMS_DFIX_DAT_RUL
WEEKDAY_NUMBERCOMS: Frequency of Occurrence of Weekday in Period FTR_COMS_OCCURE_OF_WDINT13
WEEKDAYCOMS: Day of Week for Price Fixing FTR_COMS_FIX_WEEKDAYCHAR1FTR_COMS_DFIX_WEEKDAY
AVERAGE_FREQCOMS: Frequency for Average FTR_COMS_AVERAG_FREQINT25
QUANQuantity FTR_QUANQUAN13(3) FTR_QUAN
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
QUAN_RELATED_TOQuantity Related To FTR_COMS_QUAN_VAL_PERCHAR1FTR_COMS_DQUAN_VAL_PER
REFERENCEReference FTR_REFERENCECHAR32
FX_TRANSLATIONDefines when quotation crcy is converted into payment crcy FTR_CURRENCY_CONV_POINT_IN_TIMCHAR1FTR_CURRENCY_CONV_POINT_IN_TIM
EXCH_RATE_TYPEExchange Rate Type KURST_CURRCHAR4Assigned to domainKURST
CPCC_FLAGCOMS: Indicator for Consideration of Payment Crcy Calendar FTR_COMS_CPCC_FLAGCHAR1FTR_COMS_CPCC_FLAG_D

Key field Non-key field



How do I retrieve data from SAP table VTIFINKO using ABAP code

The following ABAP code Example will allow you to do a basic selection on VTIFINKO to SELECT all data from the table
DATA: WA_VTIFINKO TYPE VTIFINKO.

SELECT SINGLE *
FROM VTIFINKO
INTO CORRESPONDING FIELDS OF WA_VTIFINKO
WHERE...

How to access SAP table VTIFINKO

Within an ECC or HANA version of SAP you can also view further information about VTIFINKO 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!