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