SAP ABAP Table RECD_CASHFLOW_PAY (Cash Flow (VICDCFPAY))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-CN (Application Component) Real Estate Contract
     ⤷ RE_CD_CF (Package) RE: Cash Flow

Basic Data

Table Category	INTTAB	Structure
Structure	RECD_CASHFLOW_PAY	Table Relationship Diagram
Short Description	Cash Flow (VICDCFPAY)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Payment-Related Cash Flow
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Payment-Related Cash Flow - Key Fields
4	CFPAYGUID	☐	RECDCFPAYGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Payment-Related Cash Flow
5	.INCLUDE	☐				0	0	Payment-Related Cash Flow - Non-Key Fields
6	CONDGUID	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
7	CONDVALIDFROM	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
8	REFGUID	☐	RECDREFGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Document References in Cash Flow
9	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
10	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
11	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
12	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
13	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
14	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
15	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
16	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
17	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
18	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
19	.INCLUDE	☐				0	0	FIMA Flow Records: Database Part
20	BBWHR	☐	TFM_BBWHR	TFM_WRTV12	CURR	23	2	Amount which changes position
21	BNWHR	☐	TFM_BNWHR	TFM_WRTV12	CURR	23	2	Nominal amount
22	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
23	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
24	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
25	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
26	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
27	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
28	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
29	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
30	SVINCL	☐	VVSVINCL	VVSINCL	NUMC	1	0	Inclusive indicator for value date
31	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
32	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
33	SFINCL	☐	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
34	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
35	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
36	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
37	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
38	ATAGE	☐	TFMATAGE	INT4	INT4	10	0	Number of Days
39	ABASTAGE	☐	BITER	BFLTP	FLTP	16	16	Amount in floating point format for recursive determination
40	APERTAGE	☐	VVAPERTAGE	INT6	NUMC	6	0	No. of days of a (calculation) period in cash flow
41	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
42	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
43	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
44	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
45	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
46	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
47	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
48	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
49	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
50	SWHRKOND	☐	TFMWHRKOND	TFM_WAERS	CUKY	5	0	Currency of Condition Item	*
51	BKOND	☐	TFM_BKOND	TFM_WRTV9	CURR	17	2	Condition item currency amount
52	SSTAFF	☐	TFMSSTAFF	TFMSSTAFF	NUMC	1	0	Type of Scaled Calculation
53	SBASIS	☐	TFM_SBASIS	TFM_SBASIS	CHAR	4	0	Calculation Base Reference
54	JSOFVERR	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
55	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
56	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
57	SSORTZIT	☐	TFM_SORT	NUMC2	NUMC	2	0	Sort indicator for financial mathematic calculations
58	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
59	SSALBAS	☐	TFMSSALBAS	TFMSSALBAS	CHAR	1	0	Indicator for debit position/incoming pmnt (internal FiMa)
60	SKONDGRP	☐	SKONDGRP	SKONDGRP	NUMC	4	0	Condition group in cash flow calculator
61	.INCLUDE	☐				0	0	Amounts and Amount Context of Cash Flow
62	LCNETAMOUNT	☐	RECDCFLCVALUENET	RECACURR	CURR	15	2	Net Amount of Cash Flow Item in Local Currency
63	LCGROSSAMOUNT	☐	RECDCFLCVALUEGROSS	RECACURR	CURR	15	2	Gross Amount of Cash Flow Item in Local Currency
64	LCTAXAMOUNT	☐	RECDCFLCTAXVALUE	RECACURR	CURR	15	2	Sales/Purch. Tax Amount of Cash Flow Item in Local Currency
65	LOCALCURR	☐	RECDCFLCCURR	WAERS	CUKY	5	0	Local Currency of Cash Flow Item	*
66	CCNETAMOUNT	☐	RECDCFVALUENET	RECACURR	CURR	15	2	Net Amount of Cash Flow Item in Condition Currency
67	CCGROSSAMOUNT	☐	RECDCFVALUEGROSS	RECACURR	CURR	15	2	Gross Amount of Cash Flow Item in Condition Currency
68	CCTAXAMOUNT	☐	RECDCFTAXVALUE	RECACURR	CURR	15	2	Tax on Sales/Purch. of Cash Flow Item in Condition Currency
69	CONDCURR	☐	RECDCFCURR	WAERS	CUKY	5	0	Condition Currency of Cash Flow Item	*
70	TAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
71	TAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
72	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
73	ISGROSS	☐	RECDISGROSS	RECABOOL	CHAR	1	0	Condition Amount Is Gross Amount
74	WHEREFROM	☐	RECDWHEREFROM	RECDWHEREFROM	CHAR	1	0	Flow Origin
75	FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
76	ORIGFLOWTYPE	☐	RECDORIGFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Original Flow Type	TIVCDFLOWTYPE
77	REFFLOWREL	☐	RECDREFFLOWREL	RECDREFFLOWREL	CHAR	3	0	Type of Relationship Between Flow Type and Refer.Flow Type	TIVCDREFFLOWREL
78	CFSTATUS	☐	RECDCFSTATUS	RECDCFSTATUS	CHAR	1	0	Indicates Status of Flow
79	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
80	FDUPD	☐	FDUPD	KENZX	CHAR	1	0	Flag as to whether record enters cash management + forecast
81	FDELETE	☐	RECAARDELETEIND	RECABOOL	CHAR	1	0	Deletion Indicator for Archiving
82	ORIGDUEDATE	☐	RECDORIGDUEDATE	DATUM	DATS	8	0	Original Due Date
83	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
84	PARTNEROBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
85	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
86	TERMNOPY	☐	RECDTERMNOPY	RETMTERMNO	CHAR	4	0	Number of Posting Term
87	TERMNORH	☐	RECDTERMNORH	RETMTERMNO	CHAR	4	0	Number of Frequency Term
88	TERMNOAJ	☐	RECDTERMNOAJ	RETMTERMNO	CHAR	4	0	Number of Adjustment Term
89	TERMNOOA	☐	RECDTERMNOOA	RETMTERMNO	CHAR	4	0	Number of Organizational Assignment Term
90	TERMNOSR	☐	RECDTERMNOSR	RETMTERMNO	CHAR	4	0	Number of Sales Term
91	TERMNOMR	☐	RECDTERMNOMR	RETMTERMNO	CHAR	4	0	Number of Peak Sales Term
92	TERMNOWT	☐	RECDTERMNOWT	RETMTERMNO	CHAR	4	0	Number of Withholding Tax Term
93	ORIGEXDUEDATE	☐	RECDORIGDUEDATE	DATUM	DATS	8	0	Original Due Date
94	SEAPSTATUS	☐	RERASEAPSTATUS	RERASEAPSTATUS	CHAR	1	0	Status of Advance Payment Relevant to SCS
95	POSTINGDATE	☐	RECDPOSTINGDATE	RECADATE	DATS	8	0	Posting Date
96	DOCUMENTDATE	☐	RECDDOCUMENTDATE	RECADATE	DATS	8	0	Document Date
97	VALUATIONDATE	☐	RECDVALUATIONDATE	RECADATE	DATS	8	0	Date for Translation of Contract Currency to Local Currency
98	REVERSAL_FOR	☐	RECDREVERSALFORGUID	RECAGUID	RAW	16	0	GUID (RAW16) for 'Reversal for' References
99	REVERSAL_BY	☐	RECDREVERSALBYGUID	RECAGUID	RAW	16	0	GUID (RAW16) for 'Reversed by' References
100	FOLLOWUP_FOR	☐	RECDFOLLOWUPFORGUID	RECAGUID	RAW	16	0	GUID (RAW16) for 'Follow-Up Posting for' References
101	BOOK_FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
102	BOOK_REFFLOWREL	☐	RECDREFFLOWREL	RECDREFFLOWREL	CHAR	3	0	Type of Relationship Between Flow Type and Refer.Flow Type	TIVCDREFFLOWREL
103	TAXDATE	☐	RECDTAXDATE	RECADATE	DATS	8	0	Date of Calculation of Sales/Purchase Tax
104	MODDUEDATE	☐	RECDMODDUEDATE	DATUM	DATS	8	0	Modified Due Date
105	CALCDUEDATE	☐	RECDCALCDUEDATE	DATUM	DATS	8	0	Calculated Due Date
106	CFSPLITFORGUID	☐	RECDCFSPLITFORGUID	RECAGUID	RAW	16	0	GUID (RAW16) of Cash Flow Record That Was Split
107	CFSPLITBASIS	☐	RECDCFSPLITBASIS	RECABOOL	CHAR	1	0	Cash Flow Record Was Basis for Split
108	CDSPLITNO	☐	RETMCDSPLITNO	NUMC4	NUMC	4	0	Number of Condition Split
109	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
110	CMCFGROUP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	*
111	CTRULE	☐	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
112	CTLCNETAMOUNT	☐	RECACTLCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Local Currency
113	CTLCGROSSAMOUNT	☐	RECACTLCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Local Currency
114	CTLCTAXAMOUNT	☐	RECACTLCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
115	CTRATE	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
116	CTRATEORIG	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
117	CTPOSTCDCURR	☐	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
118	CTDATEREQ	☐	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
119	CTDATEACT	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
120	CTDATEACTORIG	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
121	CTDATEFROMCFPOS	☐	RECDCTDATEFROMCFPOS	RECABOOL	CHAR	1	0	Use Translation Date from Cash Flow
122	.INCLUDE	☐				0	0	FIMA Flow Records: Maintenance Extension
123	SPLANIST	☐	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
124	SWOHER	☐	TFM_SWOHER	TFM_SWOHER	CHAR	1	0	Source of flow record
125	SBEWEGRP	☐	SBEWEGRP	SBEWEGRP	NUMC	4	0	Flow record group in cash flow calculator
126	SBERFIMA	☐	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
127	SAEND	☐	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
128	BBWHR2	☐	TFMBBWHR2	TFMBBWHR2	DEC	26	5	Amount
129	BBASISUR	☐	TFMBBASISU	TFM_WRTV12	CURR	23	2	Original calculation basis (e.g. for interval calculation)
130	BBASIS	☐	TFM_BBASIS	TFM_WRTV12	CURR	23	2	Calculation Base Amount
131	TBERVON	☐	TFM_TBERVON	SYTIME	TIMS	6	0	Time of Start of Calculation Period
132	TBERBIS	☐	TFM_TBERBIS	SYTIME	TIMS	6	0	Time of End of Calculation Period
133	TVALUT	☐	TFM_TVALUT	SYTIME	TIMS	6	0	Time of Calculation Date
134	SRUNDVORF	☐	VVSRUNDVF	TFMSRUNDVF	NUMC	1	0	Rounding of interim results for prepayments
135	DVERRECH	☐	VVDVERRECH	DATUM	DATS	8	0	Settlement date
136	ASEKUNDEN	☐	TFMASEKUNDEN	TFM_INT5	DEC	5	0	Number of Seconds
137	JEXPOZINS	☐	TB_JZINSRE	XFELD	CHAR	1	0	Exponential Interest Calculation
138	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
139	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
140	DZFEST	☐	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
141	KBKOND	☐	TFM_KBKOND	TFM_KBKOND	DEC	15	6	Currency-independent FiMa condition amount
142	BUGRENZ	☐	TFMBUGRENZ	TFM_WRTV12	CURR	23	2	Lower Limit for Amount
143	BOGRENZ	☐	TFMBOGRENZ	TFM_WRTV12	CURR	23	2	Upper Limit for Amt
144	BTIKALK	☐	TFM_TIKALK	TFM_WRTV12	CURR	23	2	Imputed annuity repayment amount (internal FiMa)
145	BKARZINS	☐	TFMKARZINS	TFM_WRTV12	CURR	23	2	Interest amount on diff. betw. clearing/pmnt date (int.FIMA)
146	ASTUECK	☐	TFMASTUECK	TFMASTUECK	DEC	15	5	No. of units for unit-quoted securities (fin. mathematics)
147	SSTCKKZ	☐	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
148	SSTCKTG	☐	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
149	SSTCKNOT	☐	TFMSTCKNOT	TFMSTCKNOT	NUMC	1	0	Internal FiMa indicator for unit-quoted securities
150	SFLAT	☐	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
151	JGESUCHT	☐	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
152	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
153	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
154	SFANT	☐	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
155	RURKONDIND	☐	VVRKONDIND	SYST_LONG	INT4	10	0	Reference index for an investment mathematical item
156	RURBEWEIND	☐	VVRBEWEIND	SYST_LONG	INT4	10	0	Reference index for a FiMa flow record
157	SKALIDWT	☐	TFMSKALIDWT	WFCID	CHAR	2	0	Interest Calendar	*
158	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
159	BROUNDUNIT	☐	TFMPRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
160	BBASISUNIT	☐	TFM_BBASISUNIT	TFM_WRTV9	CURR	17	2	Base Unit for Rounding
161	PPAYMENT	☐	TFM_PPAYMENT	TFM_PPAYMENT	DEC	11	7	Payment Rate
162	SDISCOUNT	☐	TFM_SDISCOUNT	TFM_SDISCOUNT	NUMC	1	0	Discounting Category
163	PDISCOUNT	☐	TFM_PDISCOUNT	DECV3_7	DEC	10	7	Percentage Discount Rate
164	AMMRHYZV	☐	TFM_AMMRHYZV	TFM_AMMRHYZV	NUMC	2	0	Interest Settlement Frequency for Exponential Interest Calc.
165	ARHYREL	☐	TFM_ARHYREL	NUMC3	NUMC	3	0	Relative Frequency
166	JRATENFIX	☐	TFM_JRATENFIX	XFELD	CHAR	1	0	Keep Installment
167	JANNVERR	☐	TFM_JANNVERR	TFM_JANNVERR	CHAR	1	0	Settle Annuity Installment
168	JSOFTILG	☐	TFM_JSOFTILG	TFM_JSOFTILG	CHAR	1	0	Begin with Repayment Immediately
169	SVKEYDAY	☐	TFM_SVKEYDAY	TFM_SKEYDAY	NUMC	2	0	Key Date for Update of Calculation Date
170	SFKEYDAY	☐	TFM_SFKEYDAY	TFM_SKEYDAY	NUMC	2	0	Key Date for Update of Due Date
171	JINTRADAY	☐	TFM_JINTRADAY	XFELD	CHAR	1	0	Intraday Interest Calculation
172	JEFFZREL	☐	TFM_JEFFZREL	CHAR1	CHAR	1	0	Relevant for Effective Interest Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RECD_CASHFLOW_PAY	BOOK_FLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE	REF	1	CN
2	RECD_CASHFLOW_PAY	BOOK_REFFLOWREL	TIVCDREFFLOWREL	REFFLOWREL	REF	1	CN
3	RECD_CASHFLOW_PAY	CONDTYPE	TIVCDCONDTYPE	CONDTYPE	KEY	1	CN
4	RECD_CASHFLOW_PAY	FLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE	REF	1	CN
5	RECD_CASHFLOW_PAY	ORIGFLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE	REF	1	CN
6	RECD_CASHFLOW_PAY	REFFLOWREL	TIVCDREFFLOWREL	REFFLOWREL	REF	1	CN
7	RECD_CASHFLOW_PAY	TAXGROUP	TIVRATAXGROUP	TAXGROUP	REF	1	CN
8	RECD_CASHFLOW_PAY	TAXTYPE	TIVRATAXTYPE	TAXTYPE	REF	1	CN

History

Last changed by/on	SAP	20141121
SAP Release Created in	110