VICECFRULE

Valuation Cash Flow | #transactional | Component: Flexible Real Estate Management
Column Name Description
MANDT Client
INTRENO FK Internal Key of Real Estate Object
RULEGUID FK GUID (RAW16) for Valuation Rule
PROCESSGUID FK GUID (RAW16) for Valuation Process
CFGUID GUID (RAW16) for Valuation Cash Flow
Column Name Description
💲 Currency of Condition Item (SWHRKOND):
BBWHR Amount which changes position
💲 Local Currency of Cash Flow Item (LOCALCURR):
LCNETAMOUNT Net Amount of Cash Flow Item in Local Currency
LCGROSSAMOUNT Gross Amount of Cash Flow Item in Local Currency
LCTAXAMOUNT Sales/Purch. Tax Amount of Cash Flow Item in Local Currency
CTLCNETAMOUNT Net Amount in Local Currency
CTLCGROSSAMOUNT Gross Amount in Local Currency
CTLCTAXAMOUNT Tax Amount in Local Currency
💲 Condition Currency of Cash Flow Item (CONDCURR):
CCNETAMOUNT Net Amount of Cash Flow Item in Condition Currency
CCGROSSAMOUNT Gross Amount of Cash Flow Item in Condition Currency
CCTAXAMOUNT Tax on Sales/Purch. of Cash Flow Item in Condition Currency
Column Name Description
Column Name Description
CONDVALIDFROM Date from when condition is valid
DBERVON Start of Calculation Period
DBERBIS End of Calculation Period
DUEDATE Due Date
DFAELL Due date
DVALUT Calculation Date
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
ORIGDUEDATE Original Due Date
POSTINGDATE Posting Date
DOCUMENTDATE Document Date
VALUATIONDATE Date for Translation of Contract Currency to Local Currency
TAXDATE Date of Calculation of Sales/Purchase Tax
MODDUEDATE Modified Due Date
CALCDUEDATE Calculated Due Date
CTDATEREQ Planned Translation Date
CTDATEACT Actual Translation Date
CTDATEACTORIG Actual Translation Date
Column Name Description
CFTYPE Cash Flow Type Show values
CFWHEREFROM Cash Flow Origin Show values
ISINITIALCOSTS Initial? Show values
ISREPAYMENTDIF Liability Difference? Show values
ISDEFERRALSADJUSTMENT Accrual/Deferral Adjustment? Show values
ISRECONOBLIGATION Asset Retirement Obligation? Show values
ISCOMPLETERETIREMENT Complete Retirement? Show values
ISRETROACTIVECHANGE Retroactive change? Show values
ISREDUCTION Reduction? Show values
ISREVERSED Reversed? Show values
SPLITBASIS Cash Flow Record Was Basis for Split Show values
EVALUATIONPOINT Time of Valuation Show values
VALUATIONENGINE Evaluation Core Show values
ISGROSS Condition Amount Is Gross Amount Show values
CFSTATUS Indicates Status of Flow Show values
FDELETE Deletion Indicator for Archiving Show values
CTPOSTCDCURR Post in Condition Currency Show values
CTDATEFROMCFPOS Use Translation Date from Cash Flow Show values
Column Name Description Domain name
TERMNO Term Number RETMTERMNO
CERULE Valuation Rule RECECERULE
OBJNR Object Number J_OBJNR
ASSETOBJNR Object Number - Asset J_OBJNR
ATAGE Number of Days INT4
INTERESTRATE Percentage Rate for Condition Items DECV5_10
REFGUID GUID (RAW16) for Document References in Cash Flow RECAGUID
REFGUID2 GUID (RAW16) for Document References in Cash Flow RECAGUID
REFGUID3 GUID (RAW16) for Document References in Cash Flow RECAGUID
REFGUID4 GUID (RAW16) for Document References in Cash Flow RECAGUID
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SPLITFORGUID GUID (RAW16) of Cash Flow Record That Was Split RECAGUID
ASSETREDUCTION Asset Retirement: Percentage Rate PRZ32
CORRECTIONGUID GUID (RAW16) for Valuation Correction RECAGUID
TXJCD Tax Jurisdiction TXJCD
TAXCOUNTRY Alternative Tax Reporting Country/Region LAND1
FLOWTYPE Flow Type RECDFLOWTYPE
ORIGFLOWTYPE Original Flow Type RECDFLOWTYPE
REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL
CONDTYPE Condition Type RECDCONDTYPE
REVERSAL_FOR GUID (RAW16) for 'Reversal for' References RECAGUID
REVERSAL_BY GUID (RAW16) for 'Reversed by' References RECAGUID
FOLLOWUP_FOR GUID (RAW16) for 'Follow-Up Posting for' References RECAGUID
BOOK_FLOWTYPE Flow Type RECDFLOWTYPE
BOOK_REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL
CTRULE Currency Translation Rule RECACTRULE
CTRATE Exchange Rate KURSF
CTRATEORIG Exchange Rate KURSF
Master Data Relations Join Conditions
GUID (RAW16) for Conditions VICECFRULE.MANDT == VICDCOND.MANDT
Internal Key of Real Estate Object
  • VICECFRULE.MANDT == VICNCN.MANDT
  • VICECFRULE.INTRENO == VICNCN.INTRENO
GUID (RAW16) for Valuation Rule
  • GUID (RAW16) for Valuation Rule
  • Client
Tax Group
Tax Type
  • ?
  • Client
  • Tax Type