SAP table RECD_CASHFLOW_PAY (Cash Flow (VICDCFPAY))

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

RECD_CASHFLOW_PAY foreign key relationships

Table Field Check Table Check Field
0 RECD_CASHFLOW_PAY BOOK_FLOWTYPE TIVCDFLOWTYPE Flow Type MANDT
1 RECD_CASHFLOW_PAY CONDTYPE TIVCDCONDTYPE Condition Type MANDT
1 RECD_CASHFLOW_PAY CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
0 RECD_CASHFLOW_PAY FLOWTYPE TIVCDFLOWTYPE Flow Type MANDT
1 RECD_CASHFLOW_PAY ORIGFLOWTYPE TIVCDFLOWTYPE Flow Type MANDT
0 RECD_CASHFLOW_PAY TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
1 RECD_CASHFLOW_PAY TAXTYPE TIVRATAXTYPE Tax Types COUNTRY
1 RECD_CASHFLOW_PAY TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE