1. Home
  2. Resources
  3. SAP Tables
  4. RECD_CASHFLOW_OBJ_X - Cash Flow and Additional Fields (VICDCFOBJ)

SAP Table RECD_CASHFLOW_OBJ_X

Cash Flow and Additional Fields (VICDCFOBJ)

RECD_CASHFLOW_OBJ_X (Cash Flow and Additional Fields (VICDCFOBJ)) 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 RECD_CASHFLOW_OBJ_X to other SAP tables.

RECD_CASHFLOW_OBJ_X table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CFOBJGUID GUID (RAW16) for Object-Related Cash Flow RECDCFOBJGUID RAW 16 0
CONDGUID GUID (RAW16) for Conditions RECDCONDGUID RAW 16 0
CONDVALIDFROM Date from when condition is valid RECDVALIDFROM DATS 8 0
REFGUID GUID (RAW16) for Document References in Cash Flow RECDREFGUID RAW 16 0
INTRENO Internal Key of Real Estate Object RECAINTRENO CHAR 13 0
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
BBWHR Amount which changes position TFM_BBWHR CURR 23 2
BNWHR Nominal amount TFM_BNWHR CURR 23 2
DBERVON Start of Calculation Period DBERVON DATS 8 0
SEXCLVON Exclusive Indicator for the Start of a Calculation Period VVSEXCLVON NUMC 1 0
0 Inclusive
1 Exclusive
SULTVON Month-End Indicator for Start of a Calculation Period VVSULTVON CHAR 1 0
NULL
X Month-end date
DBERBIS End of Calculation Period DBERBIS DATS 8 0
SINCLBIS Inclusive Indicator for the End of a Calculation Period VVSINCLBIS NUMC 1 0
0 Exclusive
1 Inclusive
SULTBIS Month-End Indicator for the End of a Calculation Period VVSULTBIS CHAR 1 0
NULL
X Month-end date
DVALUT Calculation Date DVALUT DATS 8 0
SINCL Inclusive indicator for beginning and end of a period VVSINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SVINCL Inclusive indicator for value date VVSVINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SVULT Month-End Indicator for Value Date VVSVULT CHAR 1 0
NULL
X Month-end date
DFAELL Due date DFAELL DATS 8 0
SFINCL Inclusive Indicator for Due Date VVSFINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SFULT Month-End Indicator for Due Date SFULT CHAR 1 0
NULL
X Month-end date
DDISPO Payment Date DDISPO DATS 8 0
SINCLVERR Inclusive Indicator for Clearing Date VVSINCLVER NUMC 1 0
0 Exclusive
1 Inclusive
SULTVERR Month-End Indicator for Clearing Date VVSULTVERR CHAR 1 0
NULL
X Month-end date
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
STGMETH Daily Method VVSTGMETH NUMC 1 0
1 360E
2 Act
3 365
4 360
5 ActW
6 360 ISDA
7 m+act
8 m+30
9 360 German
STGBASIS Base Days Method VVSTGBASIS NUMC 1 0
1 0
2 360
3 365
4 366
5 ActP
6 ActY
7 252
8 364
9 ActE
SZBMETH Interest Calculation Method SZBMETH CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
DBPERIOD Period start VVDBPERIOD DATS 8 0
SPAEXCL Exclusive Indicator for Start Date of a Period TFMSPAEXCL NUMC 1 0
0 inclusive
1 exclusive
SPAULT Month-End Indicator for Start Date of a Period TFMSPAULT CHAR 1 0
NULL
X Month-end date
DEPERIOD Period End VVDEPERIOD DATS 8 0
SPEINCL Inclusive Indicator for End Date of a Period TFMSPEINCL NUMC 1 0
0 exclusive
1 inclusive
SPEULT Month-End Indicator for End of a Period TFMSPEULT CHAR 1 0
NULL
X Month-end date
SWHRKOND Currency of Condition Item TFMWHRKOND CUKY 5 0
BKOND Condition item currency amount TFM_BKOND CURR 17 2
SSTAFF Type of Scaled Calculation TFMSSTAFF NUMC 1 0
0 No incremental/interval calculation
1 Incremental calculation
2 Interval calculation
SBASIS Calculation Base Reference TFM_SBASIS CHAR 4 0
JSOFVERR Indicator for Immediate Settlement (Financial Mathematics) TFMSOFVERR CHAR 1 0
NULL Settlement According to Condition
X Immediate Settlement
Y Settlement on Due Date
Z Settlement on Calculation Date
P Settlement at End of Period
E Clearing on Calculation Date (Interest Calc. Capital Only)
AMMRHY Frequency in months AMMRHY NUMC 3 0
ATTRHY Frequency in Days ATTRHY NUMC 3 0
SSORTZIT Sort indicator for financial mathematic calculations TFM_SORT NUMC 2 0
SZEITANT Indicator for Pro Rata Temporis Calculations VVSZEITANT NUMC 1 0
0 Pro rate calculation in shortened/extended periods
1 No consideration taken in shortened/extended periods
2 Full consideration taken in shortened/extended periods
3 Start period: pro rate; End period: no consideration taken
4 Start period: pro rate; End period: full consideration taken
5 Start period: No consideration; End period: Pro rata
6 Start period: Full consideration; End period: Pro rata
7 Start period: No consideration; End period: full considerat.
8 Start period: Full consideration; End period: no considerat.
SSALBAS Indicator for debit position/incoming pmnt (internal FiMa) TFMSSALBAS CHAR 1 0
NULL Planned flow
1 (Posted) debit position
2 (Posted) incoming payment
SKONDGRP Condition group in cash flow calculator SKONDGRP NUMC 4 0
LCNETAMOUNT Net Amount of Cash Flow Item in Local Currency RECDCFLCVALUENET CURR 15 2
LCGROSSAMOUNT Gross Amount of Cash Flow Item in Local Currency RECDCFLCVALUEGROSS CURR 15 2
LCTAXAMOUNT Sales/Purch. Tax Amount of Cash Flow Item in Local Currency RECDCFLCTAXVALUE CURR 15 2
LOCALCURR Local Currency of Cash Flow Item RECDCFLCCURR CUKY 5 0
CCNETAMOUNT Net Amount of Cash Flow Item in Condition Currency RECDCFVALUENET CURR 15 2
CCGROSSAMOUNT Gross Amount of Cash Flow Item in Condition Currency RECDCFVALUEGROSS CURR 15 2
CCTAXAMOUNT Tax on Sales/Purch. of Cash Flow Item in Condition Currency RECDCFTAXVALUE CURR 15 2
CONDCURR Condition Currency of Cash Flow Item RECDCFCURR CUKY 5 0
TAXTYPE Tax Type RERATAXTYPE TIVRATAXTYPE CHAR 4 0
TAXGROUP Tax Group RERATAXGROUP TIVRATAXGROUP CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
ISGROSS Condition Amount Is Gross Amount RECDISGROSS CHAR 1 0
X Yes
NULL No
OBJNR Object Number RECAOBJNR CHAR 22 0
WHEREFROM Flow Origin RECDWHEREFROM CHAR 1 0
G Entered by TR - Generating Program (Financial Mathematics)
F Entered by RE - Generating Program (Follow-Up Postings)
O Entered by TR - Generating Program (One-Time Conditions)
P Entered by Process - One-Time Postings
A Entered by Process - Accruals/Deferrals
R Entered by RE - Generator (Differences)
S Entered by RE - Generator (Split)
E Entered by Process - Reservation/Continuous Occupancy
U Entered by Process - Sales-Based Settlement
FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
ORIGFLOWTYPE Original Flow Type RECDORIGFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL TIVCDREFFLOWREL CHAR 3 0
CFSTATUS Indicates Status of Flow RECDCFSTATUS CHAR 1 0
P Planned Record
I Actual Record
V Partially Canceled
FDLEV Planning level FDLEV CHAR 2 0
FDUPD Flag as to whether record enters cash management + forecast FDUPD CHAR 1 0
X Selection character
NULL Blank
FDELETE Deletion Indicator for Archiving RECAARDELETEIND CHAR 1 0
X Yes
NULL No
ORIGDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
CONDTYPE Condition Type RECDCONDTYPE TIVCDCONDTYPE CHAR 4 0
TERMNOPY Number of Posting Term RECDTERMNOPY CHAR 4 0
TERMNORH Number of Frequency Term RECDTERMNORH CHAR 4 0
TERMNOAJ Number of Adjustment Term RECDTERMNOAJ CHAR 4 0
TERMNOOA Number of Organizational Assignment Term RECDTERMNOOA CHAR 4 0
TERMNOSR Number of Sales Term RECDTERMNOSR CHAR 4 0
TERMNOMR Number of Peak Sales Term RECDTERMNOMR CHAR 4 0
TERMNOWT Number of Withholding Tax Term RECDTERMNOWT CHAR 4 0
ORIGEXDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
SEAPSTATUS Status of Advance Payment Relevant to SCS RERASEAPSTATUS CHAR 1 0
NULL Not Yet Considered
+ Simulation Mode
X Was Updated
POSTINGDATE Posting Date RECDPOSTINGDATE DATS 8 0
DOCUMENTDATE Document Date RECDDOCUMENTDATE DATS 8 0
VALUATIONDATE Date for Translation of Contract Currency to Local Currency RECDVALUATIONDATE DATS 8 0
REVERSAL_FOR GUID (RAW16) for 'Reversal for' References RECDREVERSALFORGUID RAW 16 0
REVERSAL_BY GUID (RAW16) for 'Reversed by' References RECDREVERSALBYGUID RAW 16 0
FOLLOWUP_FOR GUID (RAW16) for 'Follow-Up Posting for' References RECDFOLLOWUPFORGUID RAW 16 0
BOOK_FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
BOOK_REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL TIVCDREFFLOWREL CHAR 3 0
TAXDATE Date of Calculation of Sales/Purchase Tax RECDTAXDATE DATS 8 0
MODDUEDATE Modified Due Date RECDMODDUEDATE DATS 8 0
CALCDUEDATE Calculated Due Date RECDCALCDUEDATE DATS 8 0
CTRULE Currency Translation Rule RECACTRULE CHAR 20 0
CTLCNETAMOUNT Net Amount in Local Currency RECACTLCNETAMOUNT CURR 15 2
CTLCGROSSAMOUNT Gross Amount in Local Currency RECACTLCGROSSAMOUNT CURR 15 2
CTLCTAXAMOUNT Tax Amount in Local Currency RECACTLCTAXAMOUNT CURR 15 2
CTRATE Exchange Rate RECACTRATE DEC 9 5
CTRATEORIG Exchange Rate RECACTRATE DEC 9 5
CTPOSTCDCURR Post in Condition Currency RECACTPOSTCDCURR CHAR 1 0
X Yes
NULL No
CTDATEREQ Planned Translation Date RECACTDATEREQ DATS 8 0
CTDATEACT Actual Translation Date RECACTDATEACT DATS 8 0
CTDATEACTORIG Actual Translation Date RECACTDATEACT DATS 8 0
CTDATEFROMCFPOS Use Translation Date from Cash Flow RECDCTDATEFROMCFPOS CHAR 1 0
X Yes
NULL No
SPLANIST Plan/actual record/record to be released indicator SPLANIST CHAR 1 0
P Planned Record
I Actual Record
F Record to be Released
S Simulated Record
SWOHER Source of flow record TFM_SWOHER CHAR 1 0
NULL Non-condition FiMa flow record
K FiMa condition flow record
C Imputed FiMa flow record
SBEWEGRP Flow record group in cash flow calculator SBEWEGRP NUMC 4 0
SBERFIMA Calculation category for cash flow calculator SBEWFIMA CHAR 4 0
SAEND Change Indicator for FiMa Flow Records TFM_SAEND NUMC 1 0
0 Can be Changed
1 Cannot be Changed
2 Due Date and Payment Date Cannot be Changed
3 Application Part of Flow Record Cannot be Changed
9 To Be Deleted
BBWHR2 Amount TFMBBWHR2 DEC 26 5
BBASISUR Original calculation basis (e.g. for interval calculation) TFMBBASISU CURR 23 2
BBASIS Calculation Base Amount TFM_BBASIS CURR 23 2
TBERVON Time of Start of Calculation Period TFM_TBERVON TIMS 6 0
TBERBIS Time of End of Calculation Period TFM_TBERBIS TIMS 6 0
TVALUT Time of Calculation Date TFM_TVALUT TIMS 6 0
SRUNDVORF Rounding of interim results for prepayments VVSRUNDVF NUMC 1 0
0 Redemption is rounded up/down
1 Interest rounded up/down if >= 5
2 Interest rounded up/down if > 5
DVERRECH Settlement date VVDVERRECH DATS 8 0
ASEKUNDEN Number of Seconds TFMASEKUNDEN DEC 5 0
JEXPOZINS Exponential Interest Calculation TB_JZINSRE CHAR 1 0
X Yes
NULL No
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
KBKOND Currency-independent FiMa condition amount TFM_KBKOND DEC 15 6
BUGRENZ Lower Limit for Amount TFMBUGRENZ CURR 23 2
BOGRENZ Upper Limit for Amt TFMBOGRENZ CURR 23 2
BTIKALK Imputed annuity repayment amount (internal FiMa) TFM_TIKALK CURR 23 2
BKARZINS Interest amount on diff. betw. clearing/pmnt date (int.FIMA) TFMKARZINS CURR 23 2
ASTUECK No. of units for unit-quoted securities (fin. mathematics) TFMASTUECK DEC 15 5
SSTCKKZ Accrued interest method SSTCKKZ CHAR 1 0
P Plus accrued interest
M Minus accrued interest
O No accrued interest, next coupon only partial right
NULL Accrued int. determined automat. acc. to coupon cutting day
F Traded flat, accrued interest included in price
SSTCKTG Accrued interest: Daily method SSTCKTG CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
SSTCKNOT Internal FiMa indicator for unit-quoted securities TFMSTCKNOT NUMC 1 0
0 Not unit-quoted
1 Unit-quoted
SFLAT Indicator 'Traded flat',i.e.no accrued interest calculation VVSFLAT CHAR 1 0
X Yes
NULL No
JGESUCHT Int. indicator for alternative calculations VVJGESUCHT CHAR 1 0
SBERECH Grace Period Interest Method SBERECH CHAR 1 0
X Yes
NULL No
SBASFIX Indicator for fixing calculation base TFMSBASFIX NUMC 1 0
0 For each entry
1 At start of period
2 At end of period
3 At start of calculation
4 At end of calculation
SFANT Indicator for due date-related FiMa calculations VVSFANT NUMC 1 0
0 Do not use due date in calculation
1 Calculate using due date
RURKONDIND Reference index for an investment mathematical item VVRKONDIND INT4 10 0
RURBEWEIND Reference index for a FiMa flow record VVRBEWEIND INT4 10 0
SKALIDWT Interest Calendar TFMSKALIDWT CHAR 2 0
SROUND Rounding Category TFM_SROUND CHAR 1 0
NULL Round to the Nearest
- Round Down
+ Round Up
BROUNDUNIT Rounding Unit TFMPRUNIT DEC 13 7
BBASISUNIT Base Unit for Rounding TFM_BBASISUNIT CURR 17 2
PPAYMENT Payment Rate TFM_PPAYMENT DEC 11 7
SDISCOUNT Discounting Category TFM_SDISCOUNT NUMC 1 0
0 No Discounting
1 Discounting with Compounding Factor
2 Discounting with Discounting Factor
PDISCOUNT Percentage Discount Rate TFM_PDISCOUNT DEC 10 7
AMMRHYZV Interest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZV NUMC 2 0
00 Annual Interest Settlement
06 Interest Settlement Every Six Months
03 Quarterly Interest Settlement
01 Monthly Interest Settlement
52 Weekly Interest Settlement
97 Daily Interest Settlement (360)
98 Daily Interest Settlement (365)
99 Continuous Interest Settlement
ARHYREL Relative Frequency TFM_ARHYREL NUMC 3 0
JRATENFIX Keep Installment TFM_JRATENFIX CHAR 1 0
X Yes
NULL No
JANNVERR Settle Annuity Installment TFM_JANNVERR CHAR 1 0
NULL Settle Repayment Share
X Settle Annuity Installment
JSOFTILG Begin with Repayment Immediately TFM_JSOFTILG CHAR 1 0
NULL Begin With Repayment When Balance > Zero
X Begin with Repayment Immediately
SVKEYDAY Key Date for Update of Calculation Date TFM_SVKEYDAY NUMC 2 0
SFKEYDAY Key Date for Update of Due Date TFM_SFKEYDAY NUMC 2 0
JINTRADAY Intraday Interest Calculation TFM_JINTRADAY CHAR 1 0
X Yes
NULL No
JEFFZREL Relevant for Effective Interest Rate TFM_JEFFZREL CHAR 1 0
XCONDITION Condition Type Name RECDXCONDITION CHAR 30 0
XCONDCURR Condition Currency Name RECDXCONDCURR CHAR 40 0
XTAXTYPE Name of Tax Type RERAXMTAXTYPE CHAR 30 0
XTAXGROUP Name of Tax Group RERAXMTAXGROUP CHAR 30 0
XLOCALCURR Local Currency Name RECDXLOCALCURR CHAR 40 0
XFLOWTYPE Name of Flow Type RECDXFLOWTYPE CHAR 30 0
ICON_CFSTATUS Cash Flow Status RECDICONCFSTATUS CHAR 132 0
ICON_REFFLOWREL Relationship of Flow Type to Reference Flow Type RECDICONREFFLOWREL CHAR 132 0
BOOK_XFLOWTYPE Name of Flow Type RECDXFLOWTYPE CHAR 30 0
ICON_BOOK_REFFLOWREL Relationship of Flow Type to Posting Flow Type RECDICONBREFFLOWREL CHAR 132 0
PROCESSID Process Identification -> Accounting Reference Number RECAPROCESSID CHAR 16 0
XWHEREFROM Flow Origin RECDXWHEREFROM CHAR 60 0
OBJID General settlement receiver ABR_EMP CHAR 35 0
CONDDELETE Deletion Indicator for Condition RECDCONDDELETE CHAR 1 0
X Yes
NULL No

RECD_CASHFLOW_OBJ_X foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RECD_CASHFLOW_OBJ_X BOOK_FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
RECD_CASHFLOW_OBJ_X BOOK_FLOWTYPE RECD_CASHFLOW_OBJ_X BOOK_FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
RECD_CASHFLOW_OBJ_X BOOK_REFFLOWREL RECD_CASHFLOW_OBJ_X BOOK_REFFLOWREL TIVCDREFFLOWREL Type of Relationships Between Flow Types REFFLOWREL
RECD_CASHFLOW_OBJ_X CONDTYPE SYST MANDT TIVCDCONDTYPE Condition Type MANDT
RECD_CASHFLOW_OBJ_X CONDTYPE RECD_CASHFLOW_OBJ_X CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
RECD_CASHFLOW_OBJ_X FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
RECD_CASHFLOW_OBJ_X FLOWTYPE RECD_CASHFLOW_OBJ_X FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
RECD_CASHFLOW_OBJ_X ORIGFLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
RECD_CASHFLOW_OBJ_X ORIGFLOWTYPE RECD_CASHFLOW_OBJ_X ORIGFLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
RECD_CASHFLOW_OBJ_X REFFLOWREL RECD_CASHFLOW_OBJ_X REFFLOWREL TIVCDREFFLOWREL Type of Relationships Between Flow Types REFFLOWREL
RECD_CASHFLOW_OBJ_X TAXGROUP SYST MANDT TIVRATAXGROUP Tax Group MANDT
RECD_CASHFLOW_OBJ_X TAXGROUP RECD_CASHFLOW_OBJ_X TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
RECD_CASHFLOW_OBJ_X TAXTYPE SYST MANDT TIVRATAXTYPE Tax Types MANDT
RECD_CASHFLOW_OBJ_X TAXTYPE * TIVRATAXTYPE Tax Types COUNTRY
RECD_CASHFLOW_OBJ_X TAXTYPE RECD_CASHFLOW_OBJ_X TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE