1. Home
  2. Resources
  3. SAP Tables
  4. AVICDCFOBJ - Change Doc. Structure Object-Related Cash-Flow (VICDCFOBJ)

SAP Table AVICDCFOBJ

Change Doc. Structure Object-Related Cash-Flow (VICDCFOBJ)

AVICDCFOBJ (Change Doc. Structure Object-Related Cash-Flow (VICDCFOBJ)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AVICDCFOBJ to other SAP tables.

AVICDCFOBJ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CFOBJGUID GUID (RAW16) for Object-Related Cash Flow RECDCFOBJGUID RAW 16 0
CONDGUID GUID (RAW16) for Conditions RECDCONDGUID RAW 16 0
CONDVALIDFROM Date from when condition is valid RECDVALIDFROM DATS 8 0
REFGUID GUID (RAW16) for Document References in Cash Flow RECDREFGUID RAW 16 0
INTRENO Internal Key of Real Estate Object RECAINTRENO CHAR 13 0
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
BBWHR Amount which changes position TFM_BBWHR CURR 23 2
BNWHR Nominal amount TFM_BNWHR CURR 23 2
DBERVON Start of Calculation Period DBERVON DATS 8 0
SEXCLVON Exclusive Indicator for the Start of a Calculation Period VVSEXCLVON NUMC 1 0
0 Inclusive
1 Exclusive
SULTVON Month-End Indicator for Start of a Calculation Period VVSULTVON CHAR 1 0
NULL
X Month-end date
DBERBIS End of Calculation Period DBERBIS DATS 8 0
SINCLBIS Inclusive Indicator for the End of a Calculation Period VVSINCLBIS NUMC 1 0
0 Exclusive
1 Inclusive
SULTBIS Month-End Indicator for the End of a Calculation Period VVSULTBIS CHAR 1 0
NULL
X Month-end date
DVALUT Calculation Date DVALUT DATS 8 0
SINCL Inclusive indicator for beginning and end of a period VVSINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SVINCL Inclusive indicator for value date VVSVINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SVULT Month-End Indicator for Value Date VVSVULT CHAR 1 0
NULL
X Month-end date
DFAELL Due date DFAELL DATS 8 0
SFINCL Inclusive Indicator for Due Date VVSFINCL NUMC 1 0
0 Start date inclusive/end date exclusive
1 Start date exclusive/end date inclusive
SFULT Month-End Indicator for Due Date SFULT CHAR 1 0
NULL
X Month-end date
DDISPO Payment Date DDISPO DATS 8 0
SINCLVERR Inclusive Indicator for Clearing Date VVSINCLVER NUMC 1 0
0 Exclusive
1 Inclusive
SULTVERR Month-End Indicator for Clearing Date VVSULTVERR CHAR 1 0
NULL
X Month-end date
ATAGE Number of Days TFMATAGE INT4 10 0
ABASTAGE Amount in floating point format for recursive determination BITER FLTP 16 16
APERTAGE No. of days of a (calculation) period in cash flow VVAPERTAGE NUMC 6 0
STGMETH Daily Method VVSTGMETH NUMC 1 0
1 360E
2 Act
3 365
4 360
5 ActW
6 360 ISDA
7 m+act
8 m+30
9 360 German
STGBASIS Base Days Method VVSTGBASIS NUMC 1 0
1 0
2 360
3 365
4 366
5 ActP
6 ActY
7 252
8 364
9 ActE
SZBMETH Interest Calculation Method SZBMETH CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
DBPERIOD Period start VVDBPERIOD DATS 8 0
SPAEXCL Exclusive Indicator for Start Date of a Period TFMSPAEXCL NUMC 1 0
0 inclusive
1 exclusive
SPAULT Month-End Indicator for Start Date of a Period TFMSPAULT CHAR 1 0
NULL
X Month-end date
DEPERIOD Period End VVDEPERIOD DATS 8 0
SPEINCL Inclusive Indicator for End Date of a Period TFMSPEINCL NUMC 1 0
0 exclusive
1 inclusive
SPEULT Month-End Indicator for End of a Period TFMSPEULT CHAR 1 0
NULL
X Month-end date
SWHRKOND Currency of Condition Item TFMWHRKOND CUKY 5 0
BKOND Condition item currency amount TFM_BKOND CURR 17 2
SSTAFF Type of Scaled Calculation TFMSSTAFF NUMC 1 0
0 No incremental/interval calculation
1 Incremental calculation
2 Interval calculation
SBASIS Calculation Base Reference TFM_SBASIS CHAR 4 0
JSOFVERR Indicator for Immediate Settlement (Financial Mathematics) TFMSOFVERR CHAR 1 0
NULL Settlement According to Condition
X Immediate Settlement
Y Settlement on Due Date
Z Settlement on Calculation Date
P Settlement at End of Period
E Clearing on Calculation Date (Interest Calc. Capital Only)
AMMRHY Frequency in months AMMRHY NUMC 3 0
ATTRHY Frequency in Days ATTRHY NUMC 3 0
SSORTZIT Sort indicator for financial mathematic calculations TFM_SORT NUMC 2 0
SZEITANT Indicator for Pro Rata Temporis Calculations VVSZEITANT NUMC 1 0
0 Pro rate calculation in shortened/extended periods
1 No consideration taken in shortened/extended periods
2 Full consideration taken in shortened/extended periods
3 Start period: pro rate; End period: no consideration taken
4 Start period: pro rate; End period: full consideration taken
5 Start period: No consideration; End period: Pro rata
6 Start period: Full consideration; End period: Pro rata
7 Start period: No consideration; End period: full considerat.
8 Start period: Full consideration; End period: no considerat.
SSALBAS Indicator for debit position/incoming pmnt (internal FiMa) TFMSSALBAS CHAR 1 0
NULL Planned flow
1 (Posted) debit position
2 (Posted) incoming payment
SKONDGRP Condition group in cash flow calculator SKONDGRP NUMC 4 0
LCNETAMOUNT Net Amount of Cash Flow Item in Local Currency RECDCFLCVALUENET CURR 15 2
LCGROSSAMOUNT Gross Amount of Cash Flow Item in Local Currency RECDCFLCVALUEGROSS CURR 15 2
LCTAXAMOUNT Sales/Purch. Tax Amount of Cash Flow Item in Local Currency RECDCFLCTAXVALUE CURR 15 2
LOCALCURR Local Currency of Cash Flow Item RECDCFLCCURR CUKY 5 0
CCNETAMOUNT Net Amount of Cash Flow Item in Condition Currency RECDCFVALUENET CURR 15 2
CCGROSSAMOUNT Gross Amount of Cash Flow Item in Condition Currency RECDCFVALUEGROSS CURR 15 2
CCTAXAMOUNT Tax on Sales/Purch. of Cash Flow Item in Condition Currency RECDCFTAXVALUE CURR 15 2
CONDCURR Condition Currency of Cash Flow Item RECDCFCURR CUKY 5 0
TAXTYPE Tax Type RERATAXTYPE TIVRATAXTYPE CHAR 4 0
TAXGROUP Tax Group RERATAXGROUP TIVRATAXGROUP CHAR 20 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
ISGROSS Condition Amount Is Gross Amount RECDISGROSS CHAR 1 0
X Yes
NULL No
OBJNR Object Number RECAOBJNR CHAR 22 0
WHEREFROM Flow Origin RECDWHEREFROM CHAR 1 0
G Entered by TR - Generating Program (Financial Mathematics)
F Entered by RE - Generating Program (Follow-Up Postings)
O Entered by TR - Generating Program (One-Time Conditions)
P Entered by Process - One-Time Postings
A Entered by Process - Accruals/Deferrals
R Entered by RE - Generator (Differences)
S Entered by RE - Generator (Split)
E Entered by Process - Reservation/Continuous Occupancy
U Entered by Process - Sales-Based Settlement
FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
ORIGFLOWTYPE Original Flow Type RECDORIGFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL TIVCDREFFLOWREL CHAR 3 0
CFSTATUS Indicates Status of Flow RECDCFSTATUS CHAR 1 0
P Planned Record
I Actual Record
V Partially Canceled
FDLEV Planning level FDLEV CHAR 2 0
FDUPD Flag as to whether record enters cash management + forecast FDUPD CHAR 1 0
X Selection character
NULL Blank
FDELETE Deletion Indicator for Archiving RECAARDELETEIND CHAR 1 0
X Yes
NULL No
ORIGDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
CONDTYPE Condition Type RECDCONDTYPE TIVCDCONDTYPE CHAR 4 0
TERMNOPY Number of Posting Term RECDTERMNOPY CHAR 4 0
TERMNORH Number of Frequency Term RECDTERMNORH CHAR 4 0
TERMNOAJ Number of Adjustment Term RECDTERMNOAJ CHAR 4 0
TERMNOOA Number of Organizational Assignment Term RECDTERMNOOA CHAR 4 0
TERMNOSR Number of Sales Term RECDTERMNOSR CHAR 4 0
TERMNOMR Number of Peak Sales Term RECDTERMNOMR CHAR 4 0
TERMNOWT Number of Withholding Tax Term RECDTERMNOWT CHAR 4 0
ORIGEXDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
SEAPSTATUS Status of Advance Payment Relevant to SCS RERASEAPSTATUS CHAR 1 0
NULL Not Yet Considered
+ Simulation Mode
X Was Updated
POSTINGDATE Posting Date RECDPOSTINGDATE DATS 8 0
DOCUMENTDATE Document Date RECDDOCUMENTDATE DATS 8 0
VALUATIONDATE Date for Translation of Contract Currency to Local Currency RECDVALUATIONDATE DATS 8 0
REVERSAL_FOR GUID (RAW16) for 'Reversal for' References RECDREVERSALFORGUID RAW 16 0
REVERSAL_BY GUID (RAW16) for 'Reversed by' References RECDREVERSALBYGUID RAW 16 0
FOLLOWUP_FOR GUID (RAW16) for 'Follow-Up Posting for' References RECDFOLLOWUPFORGUID RAW 16 0
BOOK_FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
BOOK_REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWREL TIVCDREFFLOWREL CHAR 3 0
TAXDATE Date of Calculation of Sales/Purchase Tax RECDTAXDATE DATS 8 0
MODDUEDATE Modified Due Date RECDMODDUEDATE DATS 8 0
CALCDUEDATE Calculated Due Date RECDCALCDUEDATE DATS 8 0
CTRULE Currency Translation Rule RECACTRULE CHAR 20 0
CTLCNETAMOUNT Net Amount in Local Currency RECACTLCNETAMOUNT CURR 15 2
CTLCGROSSAMOUNT Gross Amount in Local Currency RECACTLCGROSSAMOUNT CURR 15 2
CTLCTAXAMOUNT Tax Amount in Local Currency RECACTLCTAXAMOUNT CURR 15 2
CTRATE Exchange Rate RECACTRATE DEC 9 5
CTRATEORIG Exchange Rate RECACTRATE DEC 9 5
CTPOSTCDCURR Post in Condition Currency RECACTPOSTCDCURR CHAR 1 0
X Yes
NULL No
CTDATEREQ Planned Translation Date RECACTDATEREQ DATS 8 0
CTDATEACT Actual Translation Date RECACTDATEACT DATS 8 0
CTDATEACTORIG Actual Translation Date RECACTDATEACT DATS 8 0
CTDATEFROMCFPOS Use Translation Date from Cash Flow RECDCTDATEFROMCFPOS CHAR 1 0
X Yes
NULL No
KZ Change Type (U, I, S, D) CDCHNGIND CHAR 1 0
U Update
I Insert
E Delete (Single Field Documentation)
D Delete
J Insert (Single Field Documentation)

AVICDCFOBJ foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AVICDCFOBJ BOOK_FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
AVICDCFOBJ BOOK_FLOWTYPE AVICDCFOBJ BOOK_FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
AVICDCFOBJ BOOK_REFFLOWREL AVICDCFOBJ BOOK_REFFLOWREL TIVCDREFFLOWREL Type of Relationships Between Flow Types REFFLOWREL
AVICDCFOBJ CONDTYPE SYST MANDT TIVCDCONDTYPE Condition Type MANDT
AVICDCFOBJ CONDTYPE AVICDCFOBJ CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
AVICDCFOBJ FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
AVICDCFOBJ FLOWTYPE AVICDCFOBJ FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
AVICDCFOBJ ORIGFLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
AVICDCFOBJ ORIGFLOWTYPE AVICDCFOBJ ORIGFLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
AVICDCFOBJ REFFLOWREL AVICDCFOBJ REFFLOWREL TIVCDREFFLOWREL Type of Relationships Between Flow Types REFFLOWREL
AVICDCFOBJ TAXGROUP AVICDCFOBJ TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
AVICDCFOBJ TAXGROUP SYST MANDT TIVRATAXGROUP Tax Group MANDT
AVICDCFOBJ TAXTYPE SYST MANDT TIVRATAXTYPE Tax Types MANDT
AVICDCFOBJ TAXTYPE * TIVRATAXTYPE Tax Types COUNTRY
AVICDCFOBJ TAXTYPE AVICDCFOBJ TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE