SAP VICDCFOBJ Object-Related Cash Flow Table
Overview
VICDCFOBJ is a standard SAP S/4HANA table that stores Object-Related Cash Flow data. There are total 110 fields in the VICDCFOBJ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VICDCFOBJ belongs to Real Estate Contract (RE-FX-CN) module and is located in the package RE: Cash Flow (RE_CD_CF).
In addition, following links provide an overview of foreign key relationships, if any, that link VICDCFOBJ to other SAP tables and standard CDS views available based on VICDCFOBJ table in S/4HANA 2020.
Techincal Settings of VICDCFOBJ
Below are technical details of the table VICDCFOBJ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VICDCFOBJ Fields
The following table gives you an overview of the fields available in VICDCFOBJ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| CFOBJGUID | GUID (RAW16) for Object-Related Cash Flow | RECDCFOBJGUID | RAW | 16 | |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| CONDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | |
| REFGUID | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| BBWHR | Amount which changes position | TFM_BBWHR | CURR | 23 | |
| BNWHR | Nominal amount | TFM_BNWHR | CURR | 23 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | |
| SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | |
| SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SVINCL | Inclusive indicator for value date | VVSVINCL | NUMC | 1 | |
| SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | |
| DFAELL | Due date | DFAELL | DATS | 8 | |
| SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | |
| SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | |
| DDISPO | Payment Date | DDISPO | DATS | 8 | |
| SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | |
| SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | |
| ATAGE | Number of Days | TFMATAGE | INT4 | 10 | |
| ABASTAGE | Amount in floating point format for recursive determination | BITER | FLTP | 16 | |
| APERTAGE | No. of days of a (calculation) period in cash flow | VVAPERTAGE | NUMC | 6 | |
| STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | |
| STGBASIS | Base Days Method | VVSTGBASIS | CHAR | 1 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | |
| SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | |
| SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | |
| DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | |
| SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | |
| SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | |
| SWHRKOND | Currency of Condition Item | TFMWHRKOND | * | CUKY | 5 |
| BKOND | Condition item currency amount | TFM_BKOND | CURR | 17 | |
| SSTAFF | Type of Scaled Calculation | TFMSSTAFF | NUMC | 1 | |
| SBASIS | Calculation Base Reference | TFM_SBASIS | CHAR | 4 | |
| JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | TFMSOFVERR | CHAR | 1 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | |
| SSORTZIT | Sort Flag for Financial Mathematical Calculations | TFM_SORT | NUMC | 2 | |
| SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | |
| SSALBAS | Indicator for debit position/incoming pmnt (internal FiMa) | TFMSSALBAS | CHAR | 1 | |
| SKONDGRP | Condition group in cash flow calculator | SKONDGRP | NUMC | 4 | |
| LCNETAMOUNT | Net Amount of Cash Flow Item in Local Currency | RECDCFLCVALUENET | CURR | 15 | |
| LCGROSSAMOUNT | Gross Amount of Cash Flow Item in Local Currency | RECDCFLCVALUEGROSS | CURR | 15 | |
| LCTAXAMOUNT | Sales/Purch. Tax Amount of Cash Flow Item in Local Currency | RECDCFLCTAXVALUE | CURR | 15 | |
| LOCALCURR | Local Currency of Cash Flow Item | RECDCFLCCURR | * | CUKY | 5 |
| CCNETAMOUNT | Net Amount of Cash Flow Item in Condition Currency | RECDCFVALUENET | CURR | 15 | |
| CCGROSSAMOUNT | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15 | |
| CCTAXAMOUNT | Tax on Sales/Purch. of Cash Flow Item in Condition Currency | RECDCFTAXVALUE | CURR | 15 | |
| CONDCURR | Condition Currency of Cash Flow Item | RECDCFCURR | * | CUKY | 5 |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| TAXCOUNTRY | Alternative Tax Reporting Country | RERATAXCOUNTRY | * | CHAR | 3 |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| WHEREFROM | Flow Origin | RECDWHEREFROM | CHAR | 1 | |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| ORIGFLOWTYPE | Original Flow Type | RECDORIGFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | TIVCDREFFLOWREL | CHAR | 3 |
| CFSTATUS | Indicates Status of Flow | RECDCFSTATUS | CHAR | 1 | |
| FDLEV | Planning Level | FDLEV | * | CHAR | 2 |
| FDUPD | Flag as to whether record enters cash management + forecast | FDUPD | CHAR | 1 | |
| FDELETE | Deletion Indicator for Archiving | RECAARDELETEIND | CHAR | 1 | |
| ORIGDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | |
| TERMNORH | Number of Frequency Term | RECDTERMNORH | CHAR | 4 | |
| TERMNOAJ | Number of Adjustment Term | RECDTERMNOAJ | CHAR | 4 | |
| TERMNOOA | Number of Organizational Assignment Term | RECDTERMNOOA | CHAR | 4 | |
| TERMNOSR | Number of Sales Term | RECDTERMNOSR | CHAR | 4 | |
| TERMNOMR | Number of Peak Sales Term | RECDTERMNOMR | CHAR | 4 | |
| TERMNOWT | Number of Withholding Tax Term | RECDTERMNOWT | CHAR | 4 | |
| ORIGEXDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | |
| SEAPSTATUS | Status of Advance Payment Relevant to SCS | RERASEAPSTATUS | CHAR | 1 | |
| POSTINGDATE | Posting Date | RECDPOSTINGDATE | DATS | 8 | |
| DOCUMENTDATE | Document Date | RECDDOCUMENTDATE | DATS | 8 | |
| VALUATIONDATE | Date for Translation of Contract Currency to Local Currency | RECDVALUATIONDATE | DATS | 8 | |
| 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 | TIVCDFLOWTYPE | CHAR | 4 |
| BOOK_REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | TIVCDREFFLOWREL | CHAR | 3 |
| TAXDATE | Date of Calculation of Sales/Purchase Tax | RECDTAXDATE | DATS | 8 | |
| MODDUEDATE | Modified Due Date | RECDMODDUEDATE | DATS | 8 | |
| CALCDUEDATE | Calculated Due Date | RECDCALCDUEDATE | DATS | 8 | |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15 | |
| CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTRATEORIG | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTPOSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | |
| CTDATEREQ | Planned Translation Date | RECACTDATEREQ | DATS | 8 | |
| CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTDATEACTORIG | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTDATEFROMCFPOS | Use Translation Date from Cash Flow | RECDCTDATEFROMCFPOS | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VICDCFOBJ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VICDCFOBJ | BOOK_FLOWTYPE | 1: CN | TIVCDFLOWTYPE |
| VICDCFOBJ | BOOK_REFFLOWREL | 1: CN | TIVCDREFFLOWREL |
| VICDCFOBJ | CONDTYPE | 1: CN | TIVCDCONDTYPE |
| VICDCFOBJ | FLOWTYPE | 1: CN | TIVCDFLOWTYPE |
| VICDCFOBJ | ORIGFLOWTYPE | 1: CN | TIVCDFLOWTYPE |
| VICDCFOBJ | REFFLOWREL | 1: CN | TIVCDREFFLOWREL |
| VICDCFOBJ | TAXGROUP | 1: CN | TIVRATAXGROUP |
| VICDCFOBJ | TAXTYPE | 1: CN | TIVRATAXTYPE |