SAP ABAP Table VICDCFPAY_TAB (Payment-Related Cash Flow - Non-Key Fields)

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	VICDCFPAY_TAB	Table Relationship Diagram
Short Description	Payment-Related Cash Flow - Non-Key Fields

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	CONDGUID	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
2	CONDVALIDFROM	☐	RECDVALIDFROM	RECADATE	DATS	8	0	Date from when condition is valid
3	REFGUID	☐	RECDREFGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Document References in Cash Flow
4	INTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
5	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
6	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
7	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
8	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
9	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
10	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
11	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
12	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
13	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
14	.INCLUDE	☐				0	0	FIMA Flow Records: Database Part
15	BBWHR	☐	TFM_BBWHR	TFM_WRTV12	CURR	23	2	Amount which changes position
16	BNWHR	☐	TFM_BNWHR	TFM_WRTV12	CURR	23	2	Nominal amount
17	DBERVON	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
18	SEXCLVON	☐	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
19	SULTVON	☐	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
20	DBERBIS	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
21	SINCLBIS	☐	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
22	SULTBIS	☐	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
23	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
24	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
25	SVINCL	☐	VVSVINCL	VVSINCL	NUMC	1	0	Inclusive indicator for value date
26	SVULT	☐	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
27	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
28	SFINCL	☐	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
29	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
30	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
31	SINCLVERR	☐	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
32	SULTVERR	☐	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
33	ATAGE	☐	TFMATAGE	INT4	INT4	10	0	Number of Days
34	ABASTAGE	☐	BITER	BFLTP	FLTP	16	16	Amount in floating point format for recursive determination
35	APERTAGE	☐	VVAPERTAGE	INT6	NUMC	6	0	No. of days of a (calculation) period in cash flow
36	STGMETH	☐	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
37	STGBASIS	☐	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
38	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
39	DBPERIOD	☐	VVDBPERIOD	DATUM	DATS	8	0	Period start
40	SPAEXCL	☐	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
41	SPAULT	☐	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
42	DEPERIOD	☐	VVDEPERIOD	DATUM	DATS	8	0	Period End
43	SPEINCL	☐	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
44	SPEULT	☐	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
45	SWHRKOND	☐	TFMWHRKOND	TFM_WAERS	CUKY	5	0	Currency of Condition Item	*
46	BKOND	☐	TFM_BKOND	TFM_WRTV9	CURR	17	2	Condition item currency amount
47	SSTAFF	☐	TFMSSTAFF	TFMSSTAFF	NUMC	1	0	Type of Scaled Calculation
48	SBASIS	☐	TFM_SBASIS	TFM_SBASIS	CHAR	4	0	Calculation Base Reference
49	JSOFVERR	☐	TFMSOFVERR	TFMSOFVERR	CHAR	1	0	Indicator for Immediate Settlement (Financial Mathematics)
50	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
51	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
52	SSORTZIT	☐	TFM_SORT	NUMC2	NUMC	2	0	Sort indicator for financial mathematic calculations
53	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
54	SSALBAS	☐	TFMSSALBAS	TFMSSALBAS	CHAR	1	0	Indicator for debit position/incoming pmnt (internal FiMa)
55	SKONDGRP	☐	SKONDGRP	SKONDGRP	NUMC	4	0	Condition group in cash flow calculator
56	.INCLUDE	☐				0	0	Amounts and Amount Context of Cash Flow
57	LCNETAMOUNT	☐	RECDCFLCVALUENET	RECACURR	CURR	15	2	Net Amount of Cash Flow Item in Local Currency
58	LCGROSSAMOUNT	☐	RECDCFLCVALUEGROSS	RECACURR	CURR	15	2	Gross Amount of Cash Flow Item in Local Currency
59	LCTAXAMOUNT	☐	RECDCFLCTAXVALUE	RECACURR	CURR	15	2	Sales/Purch. Tax Amount of Cash Flow Item in Local Currency
60	LOCALCURR	☐	RECDCFLCCURR	WAERS	CUKY	5	0	Local Currency of Cash Flow Item	*
61	CCNETAMOUNT	☐	RECDCFVALUENET	RECACURR	CURR	15	2	Net Amount of Cash Flow Item in Condition Currency
62	CCGROSSAMOUNT	☐	RECDCFVALUEGROSS	RECACURR	CURR	15	2	Gross Amount of Cash Flow Item in Condition Currency
63	CCTAXAMOUNT	☐	RECDCFTAXVALUE	RECACURR	CURR	15	2	Tax on Sales/Purch. of Cash Flow Item in Condition Currency
64	CONDCURR	☐	RECDCFCURR	WAERS	CUKY	5	0	Condition Currency of Cash Flow Item	*
65	TAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
66	TAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
67	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
68	ISGROSS	☐	RECDISGROSS	RECABOOL	CHAR	1	0	Condition Amount Is Gross Amount
69	WHEREFROM	☐	RECDWHEREFROM	RECDWHEREFROM	CHAR	1	0	Flow Origin
70	FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
71	ORIGFLOWTYPE	☐	RECDORIGFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Original Flow Type	TIVCDFLOWTYPE
72	REFFLOWREL	☐	RECDREFFLOWREL	RECDREFFLOWREL	CHAR	3	0	Type of Relationship Between Flow Type and Refer.Flow Type	TIVCDREFFLOWREL
73	CFSTATUS	☐	RECDCFSTATUS	RECDCFSTATUS	CHAR	1	0	Indicates Status of Flow
74	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
75	FDUPD	☐	FDUPD	KENZX	CHAR	1	0	Flag as to whether record enters cash management + forecast
76	FDELETE	☐	RECAARDELETEIND	RECABOOL	CHAR	1	0	Deletion Indicator for Archiving
77	ORIGDUEDATE	☐	RECDORIGDUEDATE	DATUM	DATS	8	0	Original Due Date
78	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
79	PARTNEROBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
80	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
81	TERMNOPY	☐	RECDTERMNOPY	RETMTERMNO	CHAR	4	0	Number of Posting Term
82	TERMNORH	☐	RECDTERMNORH	RETMTERMNO	CHAR	4	0	Number of Frequency Term
83	TERMNOAJ	☐	RECDTERMNOAJ	RETMTERMNO	CHAR	4	0	Number of Adjustment Term
84	TERMNOOA	☐	RECDTERMNOOA	RETMTERMNO	CHAR	4	0	Number of Organizational Assignment Term
85	TERMNOSR	☐	RECDTERMNOSR	RETMTERMNO	CHAR	4	0	Number of Sales Term
86	TERMNOMR	☐	RECDTERMNOMR	RETMTERMNO	CHAR	4	0	Number of Peak Sales Term
87	TERMNOWT	☐	RECDTERMNOWT	RETMTERMNO	CHAR	4	0	Number of Withholding Tax Term
88	ORIGEXDUEDATE	☐	RECDORIGDUEDATE	DATUM	DATS	8	0	Original Due Date
89	SEAPSTATUS	☐	RERASEAPSTATUS	RERASEAPSTATUS	CHAR	1	0	Status of Advance Payment Relevant to SCS
90	POSTINGDATE	☐	RECDPOSTINGDATE	RECADATE	DATS	8	0	Posting Date
91	DOCUMENTDATE	☐	RECDDOCUMENTDATE	RECADATE	DATS	8	0	Document Date
92	VALUATIONDATE	☐	RECDVALUATIONDATE	RECADATE	DATS	8	0	Date for Translation of Contract Currency to Local Currency
93	REVERSAL_FOR	☐	RECDREVERSALFORGUID	RECAGUID	RAW	16	0	GUID (RAW16) for 'Reversal for' References
94	REVERSAL_BY	☐	RECDREVERSALBYGUID	RECAGUID	RAW	16	0	GUID (RAW16) for 'Reversed by' References
95	FOLLOWUP_FOR	☐	RECDFOLLOWUPFORGUID	RECAGUID	RAW	16	0	GUID (RAW16) for 'Follow-Up Posting for' References
96	BOOK_FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
97	BOOK_REFFLOWREL	☐	RECDREFFLOWREL	RECDREFFLOWREL	CHAR	3	0	Type of Relationship Between Flow Type and Refer.Flow Type	TIVCDREFFLOWREL
98	TAXDATE	☐	RECDTAXDATE	RECADATE	DATS	8	0	Date of Calculation of Sales/Purchase Tax
99	MODDUEDATE	☐	RECDMODDUEDATE	DATUM	DATS	8	0	Modified Due Date
100	CALCDUEDATE	☐	RECDCALCDUEDATE	DATUM	DATS	8	0	Calculated Due Date
101	CFSPLITFORGUID	☐	RECDCFSPLITFORGUID	RECAGUID	RAW	16	0	GUID (RAW16) of Cash Flow Record That Was Split
102	CFSPLITBASIS	☐	RECDCFSPLITBASIS	RECABOOL	CHAR	1	0	Cash Flow Record Was Basis for Split
103	CDSPLITNO	☐	RETMCDSPLITNO	NUMC4	NUMC	4	0	Number of Condition Split
104	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
105	CMCFGROUP	☐	FDGRP	FDGRP	CHAR	10	0	Planning Group	*
106	CTRULE	☐	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
107	CTLCNETAMOUNT	☐	RECACTLCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Local Currency
108	CTLCGROSSAMOUNT	☐	RECACTLCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Local Currency
109	CTLCTAXAMOUNT	☐	RECACTLCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
110	CTRATE	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
111	CTRATEORIG	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
112	CTPOSTCDCURR	☐	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
113	CTDATEREQ	☐	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
114	CTDATEACT	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
115	CTDATEACTORIG	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
116	CTDATEFROMCFPOS	☐	RECDCTDATEFROMCFPOS	RECABOOL	CHAR	1	0	Use Translation Date from Cash Flow

Foreign Keys

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

History

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