SAP Table VICDCFPAY - Payment-Related Cash Flow

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
CFPAYGUID X RECDCFPAYGUID RAW 3 16 0 VICAPROCESSID GUID (RAW16) for Payment-Related Cash Flow
CONDGUID RECDCONDGUID RAW 24 16 0 VICAPROCESSID GUID (RAW16) for Conditions
CONDVALIDFROM RECDVALIDFROM DATS 40 8 0 Date from when condition is valid
REFGUID RECDREFGUID RAW 48 16 0 VICAPROCESSID GUID (RAW16) for Document References in Cash Flow
INTRENO RECAINTRENO CHAR 64 13 0 Internal Key of Real Estate Object
RERF RERF CHAR 77 12 0 Entered by
DERF DERF DATS 89 8 0 First Entered on
TERF TERF TIMS 97 6 0 Time of Initial Entry
REHER REHER CHAR 103 10 0 Source of initial entry
RBEAR RBEAR CHAR 113 12 0 Employee ID
DBEAR DBEAR DATS 125 8 0 Last Edited on
TBEAR TBEAR TIMS 133 6 0 Last Edited at
RBHER RBHER CHAR 139 10 0 Editing Source
BBWHR TFM_BBWHR CURR 152 23 2 Amount which changes position
BNWHR TFM_BNWHR CURR 164 23 2 Nominal amount
DBERVON DBERVON DATS 176 8 0 Start of Calculation Period
SEXCLVON VVSEXCLVON NUMC 184 1 0 Exclusive Indicator for the Start of a Calculation Period
SULTVON VVSULTVON CHAR 185 1 0 Month-End Indicator for Start of a Calculation Period
DBERBIS DBERBIS DATS 186 8 0 End of Calculation Period
SINCLBIS VVSINCLBIS NUMC 194 1 0 Inclusive Indicator for the End of a Calculation Period
SULTBIS VVSULTBIS CHAR 195 1 0 Month-End Indicator for the End of a Calculation Period
DVALUT DVALUT DATS 196 8 0 Calculation Date
SINCL VVSINCL NUMC 204 1 0 Inclusive indicator for beginning and end of a period
SVINCL VVSVINCL NUMC 205 1 0 Inclusive indicator for value date
SVULT VVSVULT CHAR 206 1 0 Month-End Indicator for Value Date
DFAELL DFAELL DATS 207 8 0 Due date
SFINCL VVSFINCL NUMC 215 1 0 Inclusive Indicator for Due Date
SFULT SFULT CHAR 216 1 0 Month-End Indicator for Due Date
DDISPO DDISPO DATS 217 8 0 Payment Date
SINCLVERR VVSINCLVER NUMC 225 1 0 Inclusive Indicator for Clearing Date
SULTVERR VVSULTVERR CHAR 226 1 0 Month-End Indicator for Clearing Date
ATAGE TFMATAGE INT4 228 10 0 Number of Days
ABASTAGE BITER FLTP 232 16 16 Amount in floating point format for recursive determination
APERTAGE VVAPERTAGE NUMC 240 6 0 No. of days of a (calculation) period in cash flow
STGMETH VVSTGMETH NUMC 246 1 0 Daily Method
STGBASIS VVSTGBASIS NUMC 247 1 0 Base Days Method
SZBMETH SZBMETH CHAR 248 1 0 Interest Calculation Method
DBPERIOD VVDBPERIOD DATS 249 8 0 Period start
SPAEXCL TFMSPAEXCL NUMC 257 1 0 Exclusive Indicator for Start Date of a Period
SPAULT TFMSPAULT CHAR 258 1 0 Month-End Indicator for Start Date of a Period
DEPERIOD VVDEPERIOD DATS 259 8 0 Period End
SPEINCL TFMSPEINCL NUMC 267 1 0 Inclusive Indicator for End Date of a Period
SPEULT TFMSPEULT CHAR 268 1 0 Month-End Indicator for End of a Period
SWHRKOND TFMWHRKOND CUKY 269 5 0 Currency of Condition Item
BKOND TFM_BKOND CURR 274 17 2 Condition item currency amount
SSTAFF TFMSSTAFF NUMC 283 1 0 Type of Scaled Calculation
SBASIS TFM_SBASIS CHAR 284 4 0 Calculation Base Reference
JSOFVERR TFMSOFVERR CHAR 288 1 0 Indicator for Immediate Settlement (Financial Mathematics)
AMMRHY AMMRHY NUMC 289 3 0 Frequency in months
ATTRHY ATTRHY NUMC 292 3 0 Frequency in Days
SSORTZIT TFM_SORT NUMC 295 2 0 Sort indicator for financial mathematic calculations
SZEITANT VVSZEITANT NUMC 297 1 0 Indicator for Pro Rata Temporis Calculations
SSALBAS TFMSSALBAS CHAR 298 1 0 Indicator for debit position/incoming pmnt (internal FiMa)
SKONDGRP SKONDGRP NUMC 299 4 0 Condition group in cash flow calculator
LCNETAMOUNT RECDCFLCVALUENET CURR 304 15 2 Net Amount of Cash Flow Item in Local Currency
LCGROSSAMOUNT RECDCFLCVALUEGROSS CURR 312 15 2 Gross Amount of Cash Flow Item in Local Currency
LCTAXAMOUNT RECDCFLCTAXVALUE CURR 320 15 2 Sales/Purch. Tax Amount of Cash Flow Item in Local Currency
LOCALCURR RECDCFLCCURR CUKY 328 5 0 TCURC Local Currency of Cash Flow Item
CCNETAMOUNT RECDCFVALUENET CURR 333 15 2 Net Amount of Cash Flow Item in Condition Currency
CCGROSSAMOUNT RECDCFVALUEGROSS CURR 341 15 2 Gross Amount of Cash Flow Item in Condition Currency
CCTAXAMOUNT RECDCFTAXVALUE CURR 349 15 2 Tax on Sales/Purch. of Cash Flow Item in Condition Currency
CONDCURR RECDCFCURR CUKY 357 5 0 TCURC Condition Currency of Cash Flow Item
TAXTYPE RERATAXTYPE CHAR 362 4 0 TIVRATAXTYPE Tax Type
TAXGROUP RERATAXGROUP CHAR 366 20 0 TIVRATAXGROUP Tax Group
TXJCD TXJCD CHAR 386 15 0 TTXJ Tax Jurisdiction
ISGROSS RECDISGROSS CHAR 401 1 0 Condition Amount Is Gross Amount
WHEREFROM RECDWHEREFROM CHAR 402 1 0 Flow Origin
FLOWTYPE RECDFLOWTYPE CHAR 403 4 0 TIVCDFLOWTYPE Flow Type
ORIGFLOWTYPE RECDORIGFLOWTYPE CHAR 407 4 0 TIVCDFLOWTYPE Original Flow Type
REFFLOWREL RECDREFFLOWREL CHAR 411 3 0 TIVCDREFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type
CFSTATUS RECDCFSTATUS CHAR 414 1 0 Indicates Status of Flow
FDLEV FDLEV CHAR 415 2 0 T036 Planning Level
FDUPD FDUPD CHAR 417 1 0 Flag as to whether record enters cash management + forecast
FDELETE RECAARDELETEIND CHAR 418 1 0 Deletion Indicator for Archiving
ORIGDUEDATE RECDORIGDUEDATE DATS 419 8 0 Original Due Date
PARTNER BU_PARTNER CHAR 427 10 0 Business Partner Number
PARTNEROBJNR RECAOBJNR CHAR 437 22 0 ONR00 Object Number
CONDTYPE RECDCONDTYPE CHAR 459 4 0 Condition Type
TERMNOPY RECDTERMNOPY CHAR 463 4 0 Number of Posting Term
TERMNORH RECDTERMNORH CHAR 467 4 0 Number of Frequency Term
TERMNOAJ RECDTERMNOAJ CHAR 471 4 0 Number of Adjustment Term
TERMNOOA RECDTERMNOOA CHAR 475 4 0 Number of Organizational Assignment Term
TERMNOSR RECDTERMNOSR CHAR 479 4 0 Number of Sales Term
TERMNOMR RECDTERMNOMR CHAR 483 4 0 Number of Peak Sales Term
TERMNOWT RECDTERMNOWT CHAR 487 4 0 Number of Withholding Tax Term
ORIGEXDUEDATE RECDORIGDUEDATE DATS 491 8 0 Original Due Date
SEAPSTATUS RERASEAPSTATUS CHAR 499 1 0 Status of Advance Payment Relevant to SCS
POSTINGDATE RECDPOSTINGDATE DATS 500 8 0 Posting Date
DOCUMENTDATE RECDDOCUMENTDATE DATS 508 8 0 Document Date
VALUATIONDATE RECDVALUATIONDATE DATS 516 8 0 Date for Translation of Contract Currency to Local Currency
REVERSAL_FOR RECDREVERSALFORGUID RAW 524 16 0 VICAPROCESSID GUID (RAW16) for 'Reversal for' References
REVERSAL_BY RECDREVERSALBYGUID RAW 540 16 0 VICAPROCESSID GUID (RAW16) for 'Reversed by' References
FOLLOWUP_FOR RECDFOLLOWUPFORGUID RAW 556 16 0 VICAPROCESSID GUID (RAW16) for 'Follow-Up Posting for' References
BOOK_FLOWTYPE RECDFLOWTYPE CHAR 572 4 0 TIVCDFLOWTYPE Flow Type
BOOK_REFFLOWREL RECDREFFLOWREL CHAR 576 3 0 TIVCDREFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type
TAXDATE RECDTAXDATE DATS 579 8 0 Date of Calculation of Sales/Purchase Tax
MODDUEDATE RECDMODDUEDATE DATS 587 8 0 Modified Due Date
CALCDUEDATE RECDCALCDUEDATE DATS 595 8 0 Calculated Due Date
CFSPLITFORGUID RECDCFSPLITFORGUID RAW 603 16 0 VICAPROCESSID GUID (RAW16) of Cash Flow Record That Was Split
CFSPLITBASIS RECDCFSPLITBASIS CHAR 619 1 0 Cash Flow Record Was Basis for Split
CDSPLITNO RETMCDSPLITNO NUMC 620 4 0 Number of Condition Split
COMPANYCODE BUKRS CHAR 624 4 0 T001 Company Code
CMCFGROUP FDGRP CHAR 628 10 0 T035 Planning Group
CTRULE RECACTRULE CHAR 638 20 0 TIVCACTRULE Currency Translation Rule
CTLCNETAMOUNT RECACTLCNETAMOUNT CURR 658 15 2 Net Amount in Local Currency
CTLCGROSSAMOUNT RECACTLCGROSSAMOUNT CURR 666 15 2 Gross Amount in Local Currency
CTLCTAXAMOUNT RECACTLCTAXAMOUNT CURR 674 15 2 Tax Amount in Local Currency
CTRATE RECACTRATE DEC 682 9 5 Exchange Rate
CTRATEORIG RECACTRATE DEC 687 9 5 Exchange Rate
CTPOSTCDCURR RECACTPOSTCDCURR CHAR 692 1 0 Post in Condition Currency
CTDATEREQ RECACTDATEREQ DATS 693 8 0 Planned Translation Date
CTDATEACT RECACTDATEACT DATS 701 8 0 Actual Translation Date
CTDATEACTORIG RECACTDATEACT DATS 709 8 0 Actual Translation Date
CTDATEFROMCFPOS RECDCTDATEFROMCFPOS CHAR 717 1 0 Use Translation Date from Cash Flow