SAP ABAP Table VICDCFOBJ (Object-Related Cash Flow)

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	TRANSP	Transparent table
Transparent table	VICDCFOBJ	Table Relationship Diagram
Short Description	Object-Related Cash Flow

Delivery and Maintenance

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

History

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