VTBFINKO

Transparent Table Application Table
139 Fields 8 CDS Views

Transaction Condition

VTBFINKO is an SAP database table in S/4HANA. Transaction Condition. It contains 139 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_DebtInvmtCondition view inner COMPOSITE
P_FINTRANSINTCOND view from COMPOSITE
P_TFTRANSFEECOND view from COMPOSITE
R_FinTransCndnFmlaVarbl view union_all BASIC Fin. Trans. Condition: Formula Variable
R_FinTransCondition view from BASIC Financial Transaction Condition
R_FinTransCshFlwActyMainCndn view inner BASIC Cash Flow Activity Main Condition
R_FinTransHasParallelCondition view from COMPOSITE Fin Transaction Has Parallel Conditions
R_InterestConditionEndDate view_entity from BASIC OTC Interest Conditions with End Date

Fields (139)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY rgatt TI_RGATT Class
KEY rfha TB_RFHA Transaction
KEY rfhazu TB_RFHAZU Activity
KEY rkondgr TB_RKONDGR Direction
KEY rkond TB_KOND Condition
KEY dguel_kp DGUEL_KP Item Eff. From
KEY nstufe NSTUFE Level Number
cruser TB_CRUSER Entered By
dcrdat TB_DCRDAT Entry Date
tcrtim TB_CRTIM Entry time
upuser TB_UPUSER Changed By
dupdat TB_DUPDAT Changed On
tuptim TB_TUPTIM Time Changed
saltkond TB_SALKOND AltCond
szinsanp SZINSANP Int.rt adj.
jnullkon JNULLKON Condition Form
skoart SKOART Condition Type
ssign TB_SSIGN Direction
sbkklas TB_SBKKLAS Classification
sbktyp TB_SBKTYP Category
pkond PKOND Percentage Rate
bkond BKOND Condition Amnt
swhrkond SWHRKOND Currency
sbasis SBASIS Calculat. Base
bbasis TFM_BBASIS2 Base amount
szbmeth SZBMETH Int.calc.method
skalidwt TFMSKALIDWT Int. Calendar
sincl VVSINCL Inclusive Ind.
szsref SZSREF Ref. Int. Rate
sformref TB_XFORMBE Formula Ref.
svarname TB_VARNAME Variable
ammrhy AMMRHY Freq. in months
attrhy ATTRHY Freq.in days
dvalut DVALUT Calculat. date
svult VVSBULT Month-End Calc.
svwerk TB_SVWERK WorkingDayShift
svmeth TB_SVMETH Val.date method
avgstage TB_AVGSTAG Wrk.dys val.dte
dfaell DFAELL Due Date
sfult SFULT Month-End DueDt
sfwerk TB_SFWERK WorkingDayShift
sfmeth TB_SFMETH Due Date Method
afgstage TB_AFGSTAG WorkDaysDueDate
sdwerk TB_SDWERK WorkingDayShift
dzfest TB_DZFEST Int.Fixing Date
azgstage TB_AZGSTAG WrkDays Int.Fix
dzsref TB_ZSREF Ref. Int. Date
skalid SKALID Calendar
skalid2 SKALID Calendar
rantyp RANTYP Contract Type
sherkunft TB_SHERK Source
srhythm TB_SRHYTHM Frequency
sberfima SBEWFIMA Calc. Category
szwerk VVSZWERK Workday
rhandpl VVRHANDPL Exchange
skursart TI_KURSART Rate/Price Type
sfvmeth TB_SFVMETH Update Method
serbterm TFMERBTERM TransDateFreq.
sfranz TFMSFRANZ Shift due date
sexclguel TFMSEXCLKP CondPoStart_Excl.
jsofverr TFMSOFVERR Immed.Settlemnt
jexpozins TFM_SINTCOMP Exponential
skalid3 SKALID Calendar
ppayment TFM_PPAYMENT Payment Rate
szeitant VVSZEITANT Pro Rata Temp.
pkond1stper TFM_PKOND1STPER First Int Rate
srefdisc SREFDISC Referenced Condition Group Discounting
sdiscount TFM_SDISCOUNT Discounting
broundunit TFMPRUNIT Rounding unit
sround TFM_SROUND Rounding Cat.
ammrhyzv TFM_AMMRHYZV Int.Sttlm.Freq
facilityline TB_CREDIT_LINE Credit Line
bguel_kp BGUEL_KP Eff. from Amount
sultguel TFMSULT_KP CondPoValFrom_MthEnd
bbasisunit TFM_BBASISUNIT Base Unit
rkondref TB_KONDREF Ref. Cond. Type
sttlm_freq FTR_COMS_SETTLE_FREQUENCY Settlemt Freq.
sttlm_freq_unit FTR_COMS_SETTFRQ_UNIT Settlmt Freq. Unit
paydat_offs_unit FTR_COMS_UNIT_PAYDATOFF PyDateOffsetUnit
common_pricing FTR_COMS_AVG_COMMON_PRICING Common Pricing
fixing_date_rule FTR_COMS_FIX_DAT_RULE Fixing Date Det.
weekday_number FTR_COMS_OCCURE_OF_WD Ordinal Number
weekday FTR_COMS_FIX_WEEKDAY Day of Week
average_freq FTR_COMS_AVERAG_FREQ Frequency
quan FTR_QUAN Qty
unit_of_measure TPM_CTY_UOM Unit of Measure
quan_related_to FTR_COMS_QUAN_VAL_PER Qty Related To
reference FTR_REFERENCE Reference
fx_translation FTR_CURRENCY_CONV_POINT_IN_TIM FX Translation
exch_rate_type KURST_CURR Exch. Rate Type
cpcc_flag FTR_COMS_CPCC_FLAG COMS: Indicator for Consideration of Payment Crcy Calendar
jprozr TB_JPROZR Percent. Calc.
sfincl VVSFINCL Incl. Due Date
jbmonat JBMONAT Amount/Month
bugrenz TFMBUGRENZ Lower Limit
bogrenz TFMBOGRENZ Upper Limit
sstaff TFMSSTAFF Scaled Calc.
logic_rkond FTR_COND_GRP Condition Group
skalid4 SKALID Calendar
skalid5 SKALID Calendar
sroundfactor TFM_SROUNDFACTOR Factor RC
rounddecfactor TFM_ROUNDDECFACTOR Dec. Fac. Round
jexpointfactor TFM_JEXPOINTFACTOR Expo Int Factor
sroundbasefactor TFM_SROUNDFACTOR Factor RC
rounddecbasefactor TFM_ROUNDDECFACTOR Dec. Fac. Round
ssequence TFM_SEQUENCE Sequence Number
sroundratefactor TFM_SROUNDRATEFACTOR Int. Factor RC
rounddecratefactor TFM_ROUNDDECRATEFACTOR Dec. Int. Fac.
adgstage TFM_ADGSTAGE No.Working Days
javgcap TFM_JAVGCAP Upper Limit
pavgcap TFM_PAVGCAP Upper Limit
javgfloor TFM_JAVGFLOOR Lower Limit
pavgfloor TFM_PAVGFLOOR Lower Limit
pavgspread TFM_PAVGSPREAD Spread
sroundavginterest TFM_SROUNDAVGINTEREST RC of AIR
rounddecavginterest TFM_ROUNDDECAVGINTEREST AIR Round. Dec.
savgweight TFM_SWEIGHT Weighting Cat.
sfactorreset TFM_SFACTORRESET Reset
jugrenz TFM_JUGRENZ Lower Limit
jogrenz TFM_JOGRENZ Upper Limit
index_interpolate TFM_INDEX_INTERPOLATE IdxInterpolate
priceindex_apply TFM_PRICEINDEX_APPLY PriceIdxApply
index_base_value TFM_INDEX_BASEVALUE IndexBaseVal
index_base_date TFM_INDEX_BASEDATE IndexBaseDate
index_fix_date_high TFM_INDEX_FIXDATEHIGH IdxFixDateHigh
index_fix_date_low TFM_INDEX_FIXDATELOW IdxFixDateLow
index_adj_date_relation TFM_INDEX_RELDATE ReferRelatDate
priceindex_rkondref TB_KONDREF Ref. Cond. Type
srounddayfraction TFM_SROUNDDAYFRACTION DayFrac.Round
rounddecdayfraction TFM_ROUNDDECDAYFRACTION Dec. DayFr. Rnd
priceindex_compound_frequency TFM_PRICEINDEX_COMPOUNDFREQ CompoundFreq
index_fix_date_dateshift TB_SVWERK WorkingDayShift
index_fix_date_shiftdays TB_AVGSTAG Wrk.dys val.dte
index_adj_date_dateshift TB_SVWERK WorkingDayShift
index_adj_date_shiftdays TB_AVGSTAG Wrk.dys val.dte
sum_rkond TB_SUM_RKOND Accum. Cond.Grp
update_rule_entry_type TB_UPDATE_RULE_ENTRY_TYPE Update Rule

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Transaction Condition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTBFINKO (
    MANDT,                          -- Client [MANDT]
    BUKRS,                          -- Company Code [BUKRS]
    RGATT,                          -- Class [TI_RGATT]
    RFHA,                           -- Transaction [TB_RFHA]
    RFHAZU,                         -- Activity [TB_RFHAZU]
    RKONDGR,                        -- Direction [TB_RKONDGR]
    RKOND,                          -- Condition [TB_KOND]
    DGUEL_KP,                       -- Item Eff. From [DGUEL_KP]
    NSTUFE,                         -- Level Number [NSTUFE]
    CRUSER,                         -- Entered By [TB_CRUSER]
    DCRDAT,                         -- Entry Date [TB_DCRDAT]
    TCRTIM,                         -- Entry time [TB_CRTIM]
    UPUSER,                         -- Changed By [TB_UPUSER]
    DUPDAT,                         -- Changed On [TB_DUPDAT]
    TUPTIM,                         -- Time Changed [TB_TUPTIM]
    SALTKOND,                       -- AltCond [TB_SALKOND]
    SZINSANP,                       -- Int.rt adj. [SZINSANP]
    JNULLKON,                       -- Condition Form [JNULLKON]
    SKOART,                         -- Condition Type [SKOART]
    SSIGN,                          -- Direction [TB_SSIGN]
    SBKKLAS,                        -- Classification [TB_SBKKLAS]
    SBKTYP,                         -- Category [TB_SBKTYP]
    PKOND,                          -- Percentage Rate [PKOND]
    BKOND,                          -- Condition Amnt [BKOND]
    SWHRKOND,                       -- Currency [SWHRKOND]
    SBASIS,                         -- Calculat. Base [SBASIS]
    BBASIS,                         -- Base amount [TFM_BBASIS2]
    SZBMETH,                        -- Int.calc.method [SZBMETH]
    SKALIDWT,                       -- Int. Calendar [TFMSKALIDWT]
    SINCL,                          -- Inclusive Ind. [VVSINCL]
    SZSREF,                         -- Ref. Int. Rate [SZSREF]
    SFORMREF,                       -- Formula Ref. [TB_XFORMBE]
    SVARNAME,                       -- Variable [TB_VARNAME]
    AMMRHY,                         -- Freq. in months [AMMRHY]
    ATTRHY,                         -- Freq.in days [ATTRHY]
    DVALUT,                         -- Calculat. date [DVALUT]
    SVULT,                          -- Month-End Calc. [VVSBULT]
    SVWERK,                         -- WorkingDayShift [TB_SVWERK]
    SVMETH,                         -- Val.date method [TB_SVMETH]
    AVGSTAGE,                       -- Wrk.dys val.dte [TB_AVGSTAG]
    DFAELL,                         -- Due Date [DFAELL]
    SFULT,                          -- Month-End DueDt [SFULT]
    SFWERK,                         -- WorkingDayShift [TB_SFWERK]
    SFMETH,                         -- Due Date Method [TB_SFMETH]
    AFGSTAGE,                       -- WorkDaysDueDate [TB_AFGSTAG]
    SDWERK,                         -- WorkingDayShift [TB_SDWERK]
    DZFEST,                         -- Int.Fixing Date [TB_DZFEST]
    AZGSTAGE,                       -- WrkDays Int.Fix [TB_AZGSTAG]
    DZSREF,                         -- Ref. Int. Date [TB_ZSREF]
    SKALID,                         -- Calendar [SKALID]
    SKALID2,                        -- Calendar [SKALID]
    RANTYP,                         -- Contract Type [RANTYP]
    SHERKUNFT,                      -- Source [TB_SHERK]
    SRHYTHM,                        -- Frequency [TB_SRHYTHM]
    SBERFIMA,                       -- Calc. Category [SBEWFIMA]
    SZWERK,                         -- Workday [VVSZWERK]
    RHANDPL,                        -- Exchange [VVRHANDPL]
    SKURSART,                       -- Rate/Price Type [TI_KURSART]
    SFVMETH,                        -- Update Method [TB_SFVMETH]
    SERBTERM,                       -- TransDateFreq. [TFMERBTERM]
    SFRANZ,                         -- Shift due date [TFMSFRANZ]
    SEXCLGUEL,                      -- CondPoStart_Excl. [TFMSEXCLKP]
    JSOFVERR,                       -- Immed.Settlemnt [TFMSOFVERR]
    JEXPOZINS,                      -- Exponential [TFM_SINTCOMP]
    SKALID3,                        -- Calendar [SKALID]
    PPAYMENT,                       -- Payment Rate [TFM_PPAYMENT]
    SZEITANT,                       -- Pro Rata Temp. [VVSZEITANT]
    PKOND1STPER,                    -- First Int Rate [TFM_PKOND1STPER]
    SREFDISC,                       -- Referenced Condition Group Discounting [SREFDISC]
    SDISCOUNT,                      -- Discounting [TFM_SDISCOUNT]
    BROUNDUNIT,                     -- Rounding unit [TFMPRUNIT]
    SROUND,                         -- Rounding Cat. [TFM_SROUND]
    AMMRHYZV,                       -- Int.Sttlm.Freq [TFM_AMMRHYZV]
    FACILITYLINE,                   -- Credit Line [TB_CREDIT_LINE]
    BGUEL_KP,                       -- Eff. from Amount [BGUEL_KP]
    SULTGUEL,                       -- CondPoValFrom_MthEnd [TFMSULT_KP]
    BBASISUNIT,                     -- Base Unit [TFM_BBASISUNIT]
    RKONDREF,                       -- Ref. Cond. Type [TB_KONDREF]
    STTLM_FREQ,                     -- Settlemt Freq. [FTR_COMS_SETTLE_FREQUENCY]
    STTLM_FREQ_UNIT,                -- Settlmt Freq. Unit [FTR_COMS_SETTFRQ_UNIT]
    PAYDAT_OFFS_UNIT,               -- PyDateOffsetUnit [FTR_COMS_UNIT_PAYDATOFF]
    COMMON_PRICING,                 -- Common Pricing [FTR_COMS_AVG_COMMON_PRICING]
    FIXING_DATE_RULE,               -- Fixing Date Det. [FTR_COMS_FIX_DAT_RULE]
    WEEKDAY_NUMBER,                 -- Ordinal Number [FTR_COMS_OCCURE_OF_WD]
    WEEKDAY,                        -- Day of Week [FTR_COMS_FIX_WEEKDAY]
    AVERAGE_FREQ,                   -- Frequency [FTR_COMS_AVERAG_FREQ]
    QUAN,                           -- Qty [FTR_QUAN]
    UNIT_OF_MEASURE,                -- Unit of Measure [TPM_CTY_UOM]
    QUAN_RELATED_TO,                -- Qty Related To [FTR_COMS_QUAN_VAL_PER]
    REFERENCE,                      -- Reference [FTR_REFERENCE]
    FX_TRANSLATION,                 -- FX Translation [FTR_CURRENCY_CONV_POINT_IN_TIM]
    EXCH_RATE_TYPE,                 -- Exch. Rate Type [KURST_CURR]
    CPCC_FLAG,                      -- COMS: Indicator for Consideration of Payment Crcy Calendar [FTR_COMS_CPCC_FLAG]
    JPROZR,                         -- Percent. Calc. [TB_JPROZR]
    SFINCL,                         -- Incl. Due Date [VVSFINCL]
    JBMONAT,                        -- Amount/Month [JBMONAT]
    BUGRENZ,                        -- Lower Limit [TFMBUGRENZ]
    BOGRENZ,                        -- Upper Limit [TFMBOGRENZ]
    SSTAFF,                         -- Scaled Calc. [TFMSSTAFF]
    LOGIC_RKOND,                    -- Condition Group [FTR_COND_GRP]
    SKALID4,                        -- Calendar [SKALID]
    SKALID5,                        -- Calendar [SKALID]
    SROUNDFACTOR,                   -- Factor RC [TFM_SROUNDFACTOR]
    ROUNDDECFACTOR,                 -- Dec. Fac. Round [TFM_ROUNDDECFACTOR]
    JEXPOINTFACTOR,                 -- Expo Int Factor [TFM_JEXPOINTFACTOR]
    SROUNDBASEFACTOR,               -- Factor RC [TFM_SROUNDFACTOR]
    ROUNDDECBASEFACTOR,             -- Dec. Fac. Round [TFM_ROUNDDECFACTOR]
    SSEQUENCE,                      -- Sequence Number [TFM_SEQUENCE]
    SROUNDRATEFACTOR,               -- Int. Factor RC [TFM_SROUNDRATEFACTOR]
    ROUNDDECRATEFACTOR,             -- Dec. Int. Fac. [TFM_ROUNDDECRATEFACTOR]
    ADGSTAGE,                       -- No.Working Days [TFM_ADGSTAGE]
    JAVGCAP,                        -- Upper Limit [TFM_JAVGCAP]
    PAVGCAP,                        -- Upper Limit [TFM_PAVGCAP]
    JAVGFLOOR,                      -- Lower Limit [TFM_JAVGFLOOR]
    PAVGFLOOR,                      -- Lower Limit [TFM_PAVGFLOOR]
    PAVGSPREAD,                     -- Spread [TFM_PAVGSPREAD]
    SROUNDAVGINTEREST,              -- RC of AIR [TFM_SROUNDAVGINTEREST]
    ROUNDDECAVGINTEREST,            -- AIR Round. Dec. [TFM_ROUNDDECAVGINTEREST]
    SAVGWEIGHT,                     -- Weighting Cat. [TFM_SWEIGHT]
    SFACTORRESET,                   -- Reset [TFM_SFACTORRESET]
    JUGRENZ,                        -- Lower Limit [TFM_JUGRENZ]
    JOGRENZ,                        -- Upper Limit [TFM_JOGRENZ]
    INDEX_INTERPOLATE,              -- IdxInterpolate [TFM_INDEX_INTERPOLATE]
    PRICEINDEX_APPLY,               -- PriceIdxApply [TFM_PRICEINDEX_APPLY]
    INDEX_BASE_VALUE,               -- IndexBaseVal [TFM_INDEX_BASEVALUE]
    INDEX_BASE_DATE,                -- IndexBaseDate [TFM_INDEX_BASEDATE]
    INDEX_FIX_DATE_HIGH,            -- IdxFixDateHigh [TFM_INDEX_FIXDATEHIGH]
    INDEX_FIX_DATE_LOW,             -- IdxFixDateLow [TFM_INDEX_FIXDATELOW]
    INDEX_ADJ_DATE_RELATION,        -- ReferRelatDate [TFM_INDEX_RELDATE]
    PRICEINDEX_RKONDREF,            -- Ref. Cond. Type [TB_KONDREF]
    SROUNDDAYFRACTION,              -- DayFrac.Round [TFM_SROUNDDAYFRACTION]
    ROUNDDECDAYFRACTION,            -- Dec. DayFr. Rnd [TFM_ROUNDDECDAYFRACTION]
    PRICEINDEX_COMPOUND_FREQUENCY,  -- CompoundFreq [TFM_PRICEINDEX_COMPOUNDFREQ]
    INDEX_FIX_DATE_DATESHIFT,       -- WorkingDayShift [TB_SVWERK]
    INDEX_FIX_DATE_SHIFTDAYS,       -- Wrk.dys val.dte [TB_AVGSTAG]
    INDEX_ADJ_DATE_DATESHIFT,       -- WorkingDayShift [TB_SVWERK]
    INDEX_ADJ_DATE_SHIFTDAYS,       -- Wrk.dys val.dte [TB_AVGSTAG]
    SUM_RKOND,                      -- Accum. Cond.Grp [TB_SUM_RKOND]
    UPDATE_RULE_ENTRY_TYPE,         -- Update Rule [TB_UPDATE_RULE_ENTRY_TYPE]
    PRIMARY KEY (MANDT, BUKRS, RGATT, RFHA, RFHAZU, RKONDGR, RKOND, DGUEL_KP, NSTUFE)
);

Learn More