SAP VTBFINKO Transaction Condition Table
Overview
VTBFINKO is a standard SAP S/4HANA table that stores Transaction Condition data. There are total 116 fields in the VTBFINKO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBFINKO belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBFINKO to other SAP tables and standard CDS views available based on VTBFINKO table in S/4HANA 2020.
Techincal Settings of VTBFINKO
Below are technical details of the table VTBFINKO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBFINKO Fields
The following table gives you an overview of the fields available in VTBFINKO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RGATT | Class | TI_RGATT | CHAR | 13 | |
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 |
| RFHAZU | Transaction Activity | TB_RFHAZU | NUMC | 5 | |
| RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | |
| RKOND | Condition | TB_KOND | NUMC | 4 | |
| DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_CRTIM | CHAR | 6 | |
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 | |
| SALTKOND | Unit for supplementary condition items | TB_SALKOND | NUMC | 4 | |
| SZINSANP | Cross-referenced condition grp for interest rate adjustment | SZINSANP | NUMC | 4 | |
| JNULLKON | Condition Form | JNULLKON | CHAR | 1 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | TZK01 | NUMC | 4 |
| SSIGN | Direction of Flow | TB_SSIGN | CHAR | 1 | |
| SBKKLAS | Classification of Flows and Conditions | TB_SBKKLAS | CHAR | 1 | |
| SBKTYP | Category of Flows and Conditions | TB_SBKTYP | AT08 | CHAR | 2 |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| BKOND | Condition Item Currency Amount | BKOND | CURR | 13 | |
| SWHRKOND | Currency of Condition Item | SWHRKOND | TCURC | CUKY | 5 |
| SBASIS | Calculation Base Indicator | SBASIS | * | CHAR | 4 |
| BBASIS | Calculation Base Amount | TFM_BBASIS2 | CURR | 13 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SZSREF | Reference Interest Rate | SZSREF | T056R | CHAR | 10 |
| SFORMREF | Formula Reference | TB_XFORMBE | * | CHAR | 4 |
| SVARNAME | Variable Name | TB_VARNAME | CHAR | 4 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| SVULT | Month-End Indicator for Calculation Date | VVSBULT | CHAR | 1 | |
| SVWERK | Working Day Shift for Calculation Day | TB_SVWERK | NUMC | 1 | |
| SVMETH | Method for determining the next value date | TB_SVMETH | NUMC | 1 | |
| AVGSTAGE | Number of Days for Relative Calculation of Value Date | TB_AVGSTAG | INT4 | 10 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | |
| SFWERK | Working Day Shift for Due Date | TB_SFWERK | NUMC | 1 | |
| SFMETH | Method for determining the next due date | TB_SFMETH | NUMC | 1 | |
| AFGSTAGE | Number of days for rel. determination of due date | TB_AFGSTAG | INT4 | 10 | |
| SDWERK | Working Day Shift for Payment Date | TB_SDWERK | NUMC | 1 | |
| DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | |
| AZGSTAGE | No. of Days for Relative Determinatn of Interest Fixing | TB_AZGSTAG | INT4 | 10 | |
| DZSREF | Reference Interest Rate Fixing Date | TB_ZSREF | DATS | 8 | |
| SKALID | Factory calendar | SKALID | TFACD | CHAR | 2 |
| SKALID2 | Factory calendar | SKALID | TFACD | CHAR | 2 |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| SHERKUNFT | Display Area of Flow or Condition | TB_SHERK | CHAR | 4 | |
| SRHYTHM | Frequency Indicator | TB_SRHYTHM | NUMC | 1 | |
| SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | AT40 | CHAR | 4 |
| SZWERK | Shift to Working Day for Interest Fixing Date | VVSZWERK | NUMC | 1 | |
| RHANDPL | Exchange | VVRHANDPL | * | CHAR | 10 |
| SKURSART | Rate/Price Type - Treasury Instruments | TI_KURSART | CHAR | 2 | |
| SFVMETH | Update Method for Calculation Date/Due Date | TB_SFVMETH | NUMC | 2 | |
| SERBTERM | FiMa indicator: Date and frequency inheritance for condition | TFMERBTERM | CHAR | 1 | |
| SFRANZ | Shift Due Date | TFMSFRANZ | NUMC | 1 | |
| SEXCLGUEL | Exclusive indicator for start date of condition position | TFMSEXCLKP | NUMC | 1 | |
| JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | TFMSOFVERR | CHAR | 1 | |
| JEXPOZINS | Type of Compound Interest Calculation | TFM_SINTCOMP | CHAR | 1 | |
| SKALID3 | Factory calendar | SKALID | TFACD | CHAR | 2 |
| PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11 | |
| SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | |
| PKOND1STPER | Interest Rate for the First Period | TFM_PKOND1STPER | DEC | 10 | |
| SREFDISC | Referenced Condition Group Discounting | SREFDISC | NUMC | 4 | |
| SDISCOUNT | Discounting Category | TFM_SDISCOUNT | NUMC | 1 | |
| BROUNDUNIT | Rounding Unit | TFMPRUNIT | DEC | 13 | |
| SROUND | Rounding Category | TFM_SROUND | CHAR | 1 | |
| AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | |
| FACILITYLINE | Line of Credit | TB_CREDIT_LINE | * | CHAR | 3 |
| BGUEL_KP | Condition Item Effective from Amount | BGUEL_KP | CURR | 17 | |
| SULTGUEL | Month-end indicator for start date of condition position | TFMSULT_KP | CHAR | 1 | |
| BBASISUNIT | Base Unit for Rounding | TFM_BBASISUNIT | CURR | 17 | |
| RKONDREF | Reference Condition Type | TB_KONDREF | NUMC | 4 | |
| STTLM_FREQ_UNIT | COMS: Settlement Frequency Unit | FTR_COMS_SETTFRQ_UNIT | CHAR | 1 | |
| PAYDAT_OFFS_UNIT | COMS: Unit for Payment Date Offset | FTR_COMS_UNIT_PAYDATOFF | CHAR | 1 | |
| COMMON_PRICING | Indicates Whether Common Pricing Is Used for Average Pricing | FTR_COMS_AVG_COMMON_PRICING | CHAR | 1 | |
| FIXING_DATE_RULE | COMS: Fixing Date Rule for COMS | FTR_COMS_FIX_DAT_RULE | CHAR | 1 | |
| WEEKDAY | COMS: Day of Week for Price Fixing | FTR_COMS_FIX_WEEKDAY | CHAR | 1 | |
| QUAN | Quantity | FTR_QUAN | QUAN | 13 | |
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | * | UNIT | 3 |
| QUAN_RELATED_TO | Quantity Related To | FTR_COMS_QUAN_VAL_PER | CHAR | 1 | |
| FX_TRANSLATION | Defines when quotation crcy is converted into payment crcy | FTR_CURRENCY_CONV_POINT_IN_TIM | CHAR | 1 | |
| EXCH_RATE_TYPE | Exchange rate type | KURST_CURR | * | CHAR | 4 |
| CPCC_FLAG | COMS: Indicator for Consideration of Payment Crcy Calendar | FTR_COMS_CPCC_FLAG | CHAR | 1 | |
| JPROZR | Percentage Calculation | TB_JPROZR | CHAR | 1 | |
| SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | |
| JBMONAT | Indicator for calculating amount per month | JBMONAT | CHAR | 1 | |
| BUGRENZ | Lower Limit for Amount | TFMBUGRENZ | CURR | 23 | |
| BOGRENZ | Upper Limit for Amt | TFMBOGRENZ | CURR | 23 | |
| SSTAFF | Type of Scaled Calculation | TFMSSTAFF | NUMC | 1 | |
| LOGIC_RKOND | Condition Group | FTR_COND_GRP | NUMC | 4 | |
| SKALID4 | Factory calendar | SKALID | TFACD | CHAR | 2 |
| SKALID5 | Factory calendar | SKALID | TFACD | CHAR | 2 |
| SROUNDFACTOR | Rounding Category of a Factor | TFM_SROUNDFACTOR | CHAR | 1 | |
| ROUNDDECFACTOR | Number of Rounding Decimal Places for a Factor | TFM_ROUNDDECFACTOR | INT1 | 3 | |
| JEXPOINTFACTOR | Exponential Interest Calculation with Factor | TFM_JEXPOINTFACTOR | CHAR | 1 | |
| SROUNDBASEFACTOR | Rounding Category of a Factor | TFM_SROUNDFACTOR | CHAR | 1 | |
| ROUNDDECBASEFACTOR | Number of Rounding Decimal Places for a Factor | TFM_ROUNDDECFACTOR | INT1 | 3 | |
| SSEQUENCE | Processing Sequence of Conditions | TFM_SEQUENCE | NUMC | 2 | |
| SROUNDRATEFACTOR | Rounding Category of Interest Factor | TFM_SROUNDRATEFACTOR | CHAR | 1 | |
| ROUNDDECRATEFACTOR | Number of Rounding Decimal Places for Interest Factor | TFM_ROUNDDECRATEFACTOR | INT1 | 3 | |
| ADGSTAGE | Number of Days for Relative Payment Date Calculation | TFM_ADGSTAGE | INT4 | 10 | |
| JAVGCAP | Use Upper Limit of Average Interest Rate | TFM_JAVGCAP | CHAR | 1 | |
| PAVGCAP | Upper Limit of Average Interest Rate | TFM_PAVGCAP | DEC | 15 | |
| JAVGFLOOR | Use Lower Limit of Average Interest Rate | TFM_JAVGFLOOR | CHAR | 1 | |
| PAVGFLOOR | Lower Limit of Average Interest Rate | TFM_PAVGFLOOR | DEC | 15 | |
| PAVGSPREAD | Average Interest Rate Spread | TFM_PAVGSPREAD | DEC | 15 | |
| SROUNDAVGINTEREST | Rounding Category of Average Interest Rate | TFM_SROUNDAVGINTEREST | CHAR | 1 | |
| ROUNDDECAVGINTEREST | Number of Rounding Decimal Places for Average Interest Rate | TFM_ROUNDDECAVGINTEREST | INT1 | 3 | |
| SAVGWEIGHT | Weighting Category of Interest Rate | TFM_SWEIGHT | CHAR | 1 | |
| SFACTORRESET | Event for Resetting Factor Calculation | TFM_SFACTORRESET | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTBFINKO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBFINKO | BUKRS | 1: CN | T001 |
| VTBFINKO | MANDT | 1: CN | T000 |
| VTBFINKO | RFHA | 1: CN | VTBFHA |
| VTBFINKO | SBERFIMA | : | AT40 |
| VTBFINKO | SBKTYP | : | AT08 |
| VTBFINKO | SKALID | : | TFACD |
| VTBFINKO | SKALID2 | : | TFACD |
| VTBFINKO | SKALID3 | : | TFACD |
| VTBFINKO | SKALID4 | : | TFACD |
| VTBFINKO | SKALID5 | : | TFACD |
| VTBFINKO | SKOART | : | TZK01 |
| VTBFINKO | SWHRKOND | : | TCURC |
| VTBFINKO | SZSREF | : | T056R |