VICECFRULE - Valuation Cash Flow

Valuation Cash Flow information is stored in SAP table VICECFRULE.
It is part of development package RE_CE_CF in software component RE-FX. This development package consists of objects that can be grouped under "RE: Cash Flow CE (Evaluation and Cash Flow)".

Fields for table VICECFRULE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE	KEY	X		VICECFRULE_KEY	0
INTRENO	Internal Key of Real Estate Object	X	RECAINTRENO	CHAR	26	VICNCN
RULEGUID	GUID (RAW16) for Valuation Rule	X	RECERULEGUID	RAW	16	VICERULE
PROCESSGUID	GUID (RAW16) for Valuation Process	X	RECEPROCESSGUID	RAW	16	VICEPROCESS
CFGUID	GUID (RAW16) for Valuation Cash Flow	X	RECECFGUID	RAW	16
.INCLUDE	TAB			VICECFRULE_TAB	0
TERMNO	Term Number		RETMTERMNO	CHAR	8
CERULE	Valuation Rule		RECECERULE	CHAR	20
CFTYPE	Cash Flow Type		RECECFTYPE	CHAR	2
CFWHEREFROM	Cash Flow Origin		RECECFWHEREFROM	CHAR	2
OBJNR	Object Number		RECAOBJNR	CHAR	44	*
ASSETOBJNR	Object Number - Asset		RECEASOBJNR	CHAR	44	*
CONDGUID	GUID (RAW16) for Conditions		RECDCONDGUID	RAW	16	VICDCOND
CONDVALIDFROM	Date from when condition is valid		RECDVALIDFROM	DATS	16
DBERVON	Start of Calculation Period		DBERVON	DATS	16
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
ATAGE	Number of Days		TFMATAGE	INT4	4
DUEDATE	Due Date		RECEDUEDATE	DATS	16
DFAELL	Due date		DFAELL	DATS	16
DVALUT	Calculation Date		DVALUT	DATS	16
BBWHR	Amount which changes position		TFM_BBWHR	CURR	12
SWHRKOND	Currency of Condition Item		TFMWHRKOND	CUKY	10	*
INTERESTRATE	Percentage Rate for Condition Items		PKOND2	DEC	8
ISINITIALCOSTS	Initial?		RECEISINITIALCOSTS	CHAR	2
ISREPAYMENTDIF	Liability Difference?		RECEISREPAYMENTDIF	CHAR	2
ISDEFERRALSADJUSTMENT	Accrual/Deferral Adjustment?		RECEISDEFERRALSADJUSTMENT	CHAR	2
ISRECONOBLIGATION	Asset Retirement Obligation?		RECEISRECONOBLIGATION	CHAR	2
ISCOMPLETERETIREMENT	Complete Retirement?		RECEISCOMPLETERETIREMENT	CHAR	2
ISRETROACTIVECHANGE	Retroactive change?		RECEISRETROACTIVECHANGE	CHAR	2
ISREDUCTION	Reduction?		RECEISREDUCTION	CHAR	2
REFGUID	GUID (RAW16) for Document References in Cash Flow		RECDREFGUID	RAW	16
REFGUID2	GUID (RAW16) for Document References in Cash Flow		RECDREFGUID	RAW	16
REFGUID3	GUID (RAW16) for Document References in Cash Flow		RECDREFGUID	RAW	16
REFGUID4	GUID (RAW16) for Document References in Cash Flow		RECDREFGUID	RAW	16
.INCLUDE	RUSER			RUSER	0
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
ISREVERSED	Reversed?		RECEISREVERSED	CHAR	2
SPLITFORGUID	GUID (RAW16) of Cash Flow Record That Was Split		RECDCFSPLITFORGUID	RAW	16
SPLITBASIS	Cash Flow Record Was Basis for Split		RECDCFSPLITBASIS	CHAR	2
EVALUATIONPOINT	Time of Valuation		RECEEVALUATIONPOINT	CHAR	2
ASSETREDUCTION	Asset Retirement: Percentage Rate		RECEASSETREDUCTION	DEC	3
CORRECTIONGUID	GUID (RAW16) for Valuation Correction		RECECORRECTIONGUID	RAW	16
VALUATIONENGINE	Evaluation Core		RECEVALUATIONENGINE	CHAR	2
.INCLUDE	ADDITIONAL			VICECFRULE_ADD	0
.INCLUDE				RECD_CF_VALUE_CONTEXT	0
LCNETAMOUNT	Net Amount of Cash Flow Item in Local Currency		RECDCFLCVALUENET	CURR	8
LCGROSSAMOUNT	Gross Amount of Cash Flow Item in Local Currency		RECDCFLCVALUEGROSS	CURR	8
LCTAXAMOUNT	Sales/Purch. Tax Amount of Cash Flow Item in Local Currency		RECDCFLCTAXVALUE	CURR	8
LOCALCURR	Local Currency of Cash Flow Item		RECDCFLCCURR	CUKY	10	*
CCNETAMOUNT	Net Amount of Cash Flow Item in Condition Currency		RECDCFVALUENET	CURR	8
CCGROSSAMOUNT	Gross Amount of Cash Flow Item in Condition Currency		RECDCFVALUEGROSS	CURR	8
CCTAXAMOUNT	Tax on Sales/Purch. of Cash Flow Item in Condition Currency		RECDCFTAXVALUE	CURR	8
CONDCURR	Condition Currency of Cash Flow Item		RECDCFCURR	CUKY	10	*
TAXTYPE	Tax Type		RERATAXTYPE	CHAR	8	TIVRATAXTYPE
TAXGROUP	Tax Group		RERATAXGROUP	CHAR	40	TIVRATAXGROUP
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	*
ISGROSS	Condition Amount Is Gross Amount		RECDISGROSS	CHAR	2
TAXCOUNTRY	Alternative Tax Reporting Country/Region		RERATAXCOUNTRY	CHAR	6	*
FLOWTYPE	Flow Type		RECDFLOWTYPE	CHAR	8	*
ORIGFLOWTYPE	Original Flow Type		RECDORIGFLOWTYPE	CHAR	8	*
REFFLOWREL	Type of Relationship Between Flow Type and Refer.Flow Type		RECDREFFLOWREL	CHAR	6	*
CFSTATUS	Indicates Status of Flow		RECDCFSTATUS	CHAR	2
FDELETE	Deletion Indicator for Archiving		RECAARDELETEIND	CHAR	2
ORIGDUEDATE	Original Due Date		RECDORIGDUEDATE	DATS	16
CONDTYPE	Condition Type		RECDCONDTYPE	CHAR	8	*
POSTINGDATE	Posting Date		RECDPOSTINGDATE	DATS	16
DOCUMENTDATE	Document Date		RECDDOCUMENTDATE	DATS	16
VALUATIONDATE	Date for Translation of Contract Currency to Local Currency		RECDVALUATIONDATE	DATS	16
REVERSAL_FOR	GUID (RAW16) for 'Reversal for' References		RECDREVERSALFORGUID	RAW	16
REVERSAL_BY	GUID (RAW16) for 'Reversed by' References		RECDREVERSALBYGUID	RAW	16
FOLLOWUP_FOR	GUID (RAW16) for 'Follow-Up Posting for' References		RECDFOLLOWUPFORGUID	RAW	16
BOOK_FLOWTYPE	Flow Type		RECDFLOWTYPE	CHAR	8	*
BOOK_REFFLOWREL	Type of Relationship Between Flow Type and Refer.Flow Type		RECDREFFLOWREL	CHAR	6	*
TAXDATE	Date of Calculation of Sales/Purchase Tax		RECDTAXDATE	DATS	16
MODDUEDATE	Modified Due Date		RECDMODDUEDATE	DATS	16
CALCDUEDATE	Calculated Due Date		RECDCALCDUEDATE	DATS	16
CTRULE	Currency Translation Rule		RECACTRULE	CHAR	40	*
CTLCNETAMOUNT	Net Amount in Local Currency		RECACTLCNETAMOUNT	CURR	8
CTLCGROSSAMOUNT	Gross Amount in Local Currency		RECACTLCGROSSAMOUNT	CURR	8
CTLCTAXAMOUNT	Tax Amount in Local Currency		RECACTLCTAXAMOUNT	CURR	8
CTRATE	Exchange Rate		RECACTRATE	DEC	5
CTRATEORIG	Exchange Rate		RECACTRATE	DEC	5
CTPOSTCDCURR	Post in Condition Currency		RECACTPOSTCDCURR	CHAR	2
CTDATEREQ	Planned Translation Date		RECACTDATEREQ	DATS	16
CTDATEACT	Actual Translation Date		RECACTDATEACT	DATS	16
CTDATEACTORIG	Actual Translation Date		RECACTDATEACT	DATS	16
CTDATEFROMCFPOS	Use Translation Date from Cash Flow		RECDCTDATEFROMCFPOS	CHAR	2