VICDCFOBJ SAP table for – Object-Related Cash Flow

Here we would like to draw your attention to VICDCFOBJ table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VICDCFOBJ is a SAP standard transp table used for storing Object-Related Cash Flow related data in SAP. It comes under the package RE_CD_CF.

SAP VICDCFOBJ table

Table VICDCFOBJ technical data

TableVICDCFOBJ
Data storingObject-Related Cash Flow
ModuleRE
Sub ModuleRE-FX-CN
SAP PackageRE_CD_CF
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VICDCFOBJ Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VICDCFOBJ table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Object-Related Cash Flow – Key Fields
    Its a key field.
  • CFOBJGUID : GUID (RAW16) for Object-Related Cash Flow
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Object-Related Cash Flow – Non-Key Fields
  • CONDGUID : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • CONDVALIDFROM : Date from when condition is valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFGUID : GUID (RAW16) for Document References in Cash Flow
    Its data type is RAW (Byte string) with field length 16
  • INTRENO : Internal Key of Real Estate Object
    Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : FIMA Flow Records: Database Part
  • BBWHR : Amount which changes position
    Its data type is CURR (Currency Field) with field length 23
  • BNWHR : Nominal amount
    Its data type is CURR (Currency Field) with field length 23
  • DBERVON : Start of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEXCLVON : Exclusive Indicator for the Start of a Calculation Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SULTVON : Month-End Indicator for Start of a Calculation Period
    Its data type is CHAR (Character String) with field length 1
  • DBERBIS : End of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCLBIS : Inclusive Indicator for the End of a Calculation Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SULTBIS : Month-End Indicator for the End of a Calculation Period
    Its data type is CHAR (Character String) with field length 1
  • DVALUT : Calculation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCL : Inclusive indicator for beginning and end of a period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SVINCL : Inclusive indicator for value date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SVULT : Month-End Indicator for Value Date
    Its data type is CHAR (Character String) with field length 1
  • DFAELL : Due date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SFINCL : Inclusive Indicator for Due Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SFULT : Month-End Indicator for Due Date
    Its data type is CHAR (Character String) with field length 1
  • DDISPO : Payment Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINCLVERR : Inclusive Indicator for Clearing Date
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SULTVERR : Month-End Indicator for Clearing Date
    Its data type is CHAR (Character String) with field length 1
  • ATAGE : Number of Days
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ABASTAGE : Amount in floating point format for recursive determination
    Its data type is FLTP (Floating point number) with field length 16
  • APERTAGE : No. of days of a (calculation) period in cash flow
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • STGMETH : Daily Method
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • STGBASIS : Base Days Method
    Its data type is CHAR (Character String) with field length 1
  • SZBMETH : Interest Calculation Method
    Its data type is CHAR (Character String) with field length 1
  • DBPERIOD : Period start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPAEXCL : Exclusive Indicator for Start Date of a Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SPAULT : Month-End Indicator for Start Date of a Period
    Its data type is CHAR (Character String) with field length 1
  • DEPERIOD : Period End
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SPEINCL : Inclusive Indicator for End Date of a Period
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SPEULT : Month-End Indicator for End of a Period
    Its data type is CHAR (Character String) with field length 1
  • SWHRKOND : Currency of Condition Item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BKOND : Condition item currency amount
    Its data type is CURR (Currency Field) with field length 17
  • SSTAFF : Type of Scaled Calculation
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SBASIS : Calculation Base Reference
    Its data type is CHAR (Character String) with field length 4
  • JSOFVERR : Indicator for Immediate Settlement (Financial Mathematics)
    Its data type is CHAR (Character String) with field length 1
  • AMMRHY : Frequency in months
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ATTRHY : Frequency in Days
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SSORTZIT : Sort indicator for financial mathematic calculations
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SZEITANT : Indicator for Pro Rata Temporis Calculations
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SSALBAS : Indicator for debit position/incoming pmnt (internal FiMa)
    Its data type is CHAR (Character String) with field length 1
  • SKONDGRP : Condition group in cash flow calculator
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Amounts and Amount Context of Cash Flow
  • LCNETAMOUNT : Net Amount of Cash Flow Item in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • LCGROSSAMOUNT : Gross Amount of Cash Flow Item in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • LCTAXAMOUNT : Sales/Purch. Tax Amount of Cash Flow Item in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • LOCALCURR : Local Currency of Cash Flow Item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CCNETAMOUNT : Net Amount of Cash Flow Item in Condition Currency
    Its data type is CURR (Currency Field) with field length 15
  • CCGROSSAMOUNT : Gross Amount of Cash Flow Item in Condition Currency
    Its data type is CURR (Currency Field) with field length 15
  • CCTAXAMOUNT : Tax on Sales/Purch. of Cash Flow Item in Condition Currency
    Its data type is CURR (Currency Field) with field length 15
  • CONDCURR : Condition Currency of Cash Flow Item
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • ISGROSS : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • WHEREFROM : Flow Origin
    Its data type is CHAR (Character String) with field length 1
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • ORIGFLOWTYPE : Original Flow Type
    Its data type is CHAR (Character String) with field length 4
  • REFFLOWREL : Type of Relationship Between Flow Type and Refer.Flow Type
    Its data type is CHAR (Character String) with field length 3
  • CFSTATUS : Indicates Status of Flow
    Its data type is CHAR (Character String) with field length 1
  • FDLEV : Planning Level
    Its data type is CHAR (Character String) with field length 2
  • FDUPD : Flag as to whether record enters cash management + forecast
    Its data type is CHAR (Character String) with field length 1
  • FDELETE : Deletion Indicator for Archiving
    Its data type is CHAR (Character String) with field length 1
  • ORIGDUEDATE : Original Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONDTYPE : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • TERMNOPY : Number of Posting Term
    Its data type is CHAR (Character String) with field length 4
  • TERMNORH : Number of Frequency Term
    Its data type is CHAR (Character String) with field length 4
  • TERMNOAJ : Number of Adjustment Term
    Its data type is CHAR (Character String) with field length 4
  • TERMNOOA : Number of Organizational Assignment Term
    Its data type is CHAR (Character String) with field length 4
  • TERMNOSR : Number of Sales Term
    Its data type is CHAR (Character String) with field length 4
  • TERMNOMR : Number of Peak Sales Term
    Its data type is CHAR (Character String) with field length 4
  • TERMNOWT : Number of Withholding Tax Term
    Its data type is CHAR (Character String) with field length 4
  • ORIGEXDUEDATE : Original Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEAPSTATUS : Status of Advance Payment Relevant to SCS
    Its data type is CHAR (Character String) with field length 1
  • POSTINGDATE : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCUMENTDATE : Document Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALUATIONDATE : Date for Translation of Contract Currency to Local Currency
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REVERSAL_FOR : GUID (RAW16) for ‘Reversal for’ References
    Its data type is RAW (Byte string) with field length 16
  • REVERSAL_BY : GUID (RAW16) for ‘Reversed by’ References
    Its data type is RAW (Byte string) with field length 16
  • FOLLOWUP_FOR : GUID (RAW16) for ‘Follow-Up Posting for’ References
    Its data type is RAW (Byte string) with field length 16
  • BOOK_FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • BOOK_REFFLOWREL : Type of Relationship Between Flow Type and Refer.Flow Type
    Its data type is CHAR (Character String) with field length 3
  • TAXDATE : Date of Calculation of Sales/Purchase Tax
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MODDUEDATE : Modified Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALCDUEDATE : Calculated Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • CTLCNETAMOUNT : Net Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCGROSSAMOUNT : Gross Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCTAXAMOUNT : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTRATE : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CTRATEORIG : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CTPOSTCDCURR : Post in Condition Currency
    Its data type is CHAR (Character String) with field length 1
  • CTDATEREQ : Planned Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTDATEACT : Actual Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTDATEACTORIG : Actual Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTDATEFROMCFPOS : Use Translation Date from Cash Flow
    Its data type is CHAR (Character String) with field length 1