Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table TRSS_FIMA_DATA

Treasury: Structure for Cash Flow Calculation - FiMa Data

TRSS_FIMA_DATA (Treasury: Structure for Cash Flow Calculation - FiMa Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TRSS_FIMA_DATA to other SAP tables.

TRSS_FIMA_DATA table fields

Field Data element Checktable Datatype Length Decimals Possible values
SBERFIMA
Calculation category for cash flow calculator
 SBEWFIMA AT40
CHAR
 4 0
SAEND
Change Indicator for FiMa Flow Records
 TFM_SAEND
NUMC
 1 0
SPLANIST
Plan/actual record/record to be released indicator
 SPLANIST
CHAR
 1 0
SWOHER
CFM: Origin Indicator TRS
 TPM_SWOHER_TRS
CHAR
 1 0
BBASIS
Calculation Base Amount
 TFM_BBASIS2
CURR
 13 2
SBASIS
Calculation Base Reference
 TFM_SBASIS
CHAR
 4 0
DBERVON
Start of Calculation Period
 DBERVON
DATS
 8 0
SEXCLVON
Exclusive Indicator for the Start of a Calculation Period
 VVSEXCLVON
NUMC
 1 0
SULTVON
Month-End Indicator for Start of a Calculation Period
 VVSULTVON
CHAR
 1 0
DBERBIS
End of Calculation Period
 DBERBIS
DATS
 8 0
SINCLBIS
Inclusive Indicator for the End of a Calculation Period
 VVSINCLBIS
NUMC
 1 0
SULTBIS
Month-End Indicator for the End of a Calculation Period
 VVSULTBIS
CHAR
 1 0
DVALUT
Calculation Date
 DVALUT
DATS
 8 0
SINCL
Inclusive indicator for beginning and end of a period
 VVSINCL
NUMC
 1 0
SVULT
Month-End Indicator for Value Date
 VVSVULT
CHAR
 1 0
DFAELL
Due date
 DFAELL
DATS
 8 0
SFULT
Month-End Indicator for Due Date
 SFULT
CHAR
 1 0
DVERRECH
Settlement date
 VVDVERRECH
DATS
 8 0
SINCLVERR
Inclusive Indicator for Clearing Date
 VVSINCLVER
NUMC
 1 0
SULTVERR
Month-End Indicator for Clearing Date
 VVSULTVERR
CHAR
 1 0
ATAGE
Number of Days
 TFMATAGE
INT4
 10 0
ABASTAGE
Amount in floating point format for recursive determination
 BITER
FLTP
 16 16
APERTAGE
No. of days of a (calculation) period in cash flow
 VVAPERTAGE
NUMC
 6 0
AMMRHY
Frequency in months
 AMMRHY
NUMC
 3 0
ATTRHY
Frequency in Days
 ATTRHY
NUMC
 3 0
STGMETH
Daily Method
 VVSTGMETH
NUMC
 1 0
STGBASIS
Base Days Method
 VVSTGBASIS
NUMC
 1 0
SZBMETH
Interest Calculation Method
 SZBMETH
CHAR
 1 0
JEXPOZINS
Exponential Interest Calculation
 TB_JZINSRE
CHAR
 1 0
DBPERIOD
Period start
 VVDBPERIOD
DATS
 8 0
SPAEXCL
Exclusive Indicator for Start Date of a Period
 TFMSPAEXCL
NUMC
 1 0
SPAULT
Month-End Indicator for Start Date of a Period
 TFMSPAULT
CHAR
 1 0
DEPERIOD
Period End
 VVDEPERIOD
DATS
 8 0
SPEINCL
Inclusive Indicator for End Date of a Period
 TFMSPEINCL
NUMC
 1 0
SPEULT
Month-End Indicator for End of a Period
 TFMSPEULT
CHAR
 1 0
SWHRKOND
Currency of Condition Item
 TFMWHRKOND
CUKY
 5 0
PKOND
Percentage rate for condition items
 PKOND
DEC
 10 7
DPKOND
Determination date for percentage rate of condition items
 VVDPKOND
DATS
 8 0
DZFEST
Interest rate fixing date
 TB_DZFEST
DATS
 8 0
BKOND
Condition item currency amount
 TFM_BKOND
CURR
 17 2
KBKOND
Currency-independent FiMa condition amount
 TFM_KBKOND
DEC
 15 6
SSTCKKZ
Accrued interest method
 SSTCKKZ
CHAR
 1 0
SSTCKTG
Accrued interest: Daily method
 SSTCKTG
CHAR
 1 0
SFLAT
Indicator 'Traded flat',i.e.no accrued interest calculation
 VVSFLAT
CHAR
 1 0
SKOART
Condition Type (Smallest Subdivision of Condition Records)
 SKOART TZK01
NUMC
 4 0
SKALIDWT
Interest Calendar
 TFMSKALIDWT
CHAR
 2 0
DGUEL_KP
Condition Item Valid From
 DGUEL_KP
DATS
 8 0
NSTUFE
Level number of condition item for recurring payments
 NSTUFE
NUMC
 2 0
PPAYMENT
Payment Rate
 TFM_PPAYMENT
DEC
 11 7
JSOFVERR
Indicator for Immediate Settlement (Financial Mathematics)
 TFMSOFVERR
CHAR
 1 0

TRSS_FIMA_DATA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TRSS_FIMA_DATA SBERFIMA TRSS_FIMA_DATA SBERFIMA AT40
Calculation Categories of Cash Flow Calculator
 SBERFIMA
TRSS_FIMA_DATA SKOART SYST MANDT TZK01
Condition types
 MANDT
TRSS_FIMA_DATA SKOART '2' TZK01
Condition types
 RANTYP
TRSS_FIMA_DATA SKOART TRSS_FIMA_DATA SKOART TZK01
Condition types
 SKOART