VICDCFPAY SAP (Payment-Related Cash Flow) Table details

Dictionary Type: Table
Description: Payment-Related Cash Flow




ABAP Code to SELECT data from VICDCFPAY
Related tables to VICDCFPAY
Access table VICDCFPAY




Table field list including key, data, relationships and ABAP select examples

VICDCFPAY is a standard SAP Table which is used to store Payment-Related Cash Flow data and is available within R/3 SAP systems depending on the version and release level.

The VICDCFPAY table consists of various fields, each holding specific information or linking keys about Payment-Related Cash Flow data available in SAP. These include CFPAYGUID (GUID (RAW16) for Payment-Related Cash Flow), CONDGUID (GUID (RAW16) for Conditions), CONDVALIDFROM (Date from when condition is valid), REFGUID (GUID (RAW16) for Document References in Cash Flow).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VICDCFPAY table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
CFPAYGUIDGUID (RAW16) for Payment-Related Cash Flow RECDCFPAYGUIDRAW16RECAGUID
CONDGUIDGUID (RAW16) for Conditions RECDCONDGUIDRAW16RECAGUID
CONDVALIDFROMDate from when condition is valid RECDVALIDFROMDATS8RECADATE
REFGUIDGUID (RAW16) for Document References in Cash Flow RECDREFGUIDRAW16RECAGUID
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
BBWHRAmount which changes position TFM_BBWHRCURR23(2) TFM_WRTV12
BNWHRNominal amount TFM_BNWHRCURR23(2) TFM_WRTV12
DBERVONStart of Calculation Period DBERVONDATS8DATUM
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
DVALUTCalculation Date DVALUTDATS8DATUM
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SVINCLInclusive indicator for value date VVSVINCLNUMC1VVSINCL
SVULTMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
DFAELLDue date DFAELLDATS8DATUM
SFINCLInclusive Indicator for Due Date VVSFINCLNUMC1VVSINCL
SFULTMonth-End Indicator for Due Date SFULTCHAR1VVSULT
DDISPOPayment Date DDISPODATS8DATUM
SINCLVERRInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERRMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
ATAGENumber of Days TFMATAGEINT410INT4
ABASTAGEAmount in floating point format for recursive determination BITERFLTP16(16) BFLTP
APERTAGENo. of days of a (calculation) period in cash flow VVAPERTAGENUMC6INT6
STGMETHDaily Method VVSTGMETHNUMC1VVSTGMETH
STGBASISBase Days Method VVSTGBASISNUMC1VVSTGBASIS
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
DBPERIODPeriod start VVDBPERIODDATS8DATUM
SPAEXCLExclusive Indicator for Start Date of a Period TFMSPAEXCLNUMC1TFMSPAEXCL
SPAULTMonth-End Indicator for Start Date of a Period TFMSPAULTCHAR1VVSULT
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
SWHRKONDCurrency of Condition Item TFMWHRKONDCUKY5Assigned to domainTFM_WAERS
BKONDCondition item currency amount TFM_BKONDCURR17(2) TFM_WRTV9
SSTAFFType of Scaled Calculation TFMSSTAFFNUMC1TFMSSTAFF
SBASISCalculation Base Reference TFM_SBASISCHAR4TFM_SBASIS
JSOFVERRIndicator for Immediate Settlement (Financial Mathematics) TFMSOFVERRCHAR1TFMSOFVERR
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
ATTRHYFrequency in Days ATTRHYNUMC3NUMC03
SSORTZITSort indicator for financial mathematic calculations TFM_SORTNUMC2NUMC2
SZEITANTIndicator for Pro Rata Temporis Calculations VVSZEITANTNUMC1VVSZEITANT
SSALBASIndicator for debit position/incoming pmnt (internal FiMa) TFMSSALBASCHAR1TFMSSALBAS
SKONDGRPCondition group in cash flow calculator SKONDGRPNUMC4SKONDGRP
LCNETAMOUNTNet Amount of Cash Flow Item in Local Currency RECDCFLCVALUENETCURR15(2) RECACURR
LCGROSSAMOUNTGross Amount of Cash Flow Item in Local Currency RECDCFLCVALUEGROSSCURR15(2) RECACURR
LCTAXAMOUNTSales/Purch. Tax Amount of Cash Flow Item in Local Currency RECDCFLCTAXVALUECURR15(2) RECACURR
LOCALCURRLocal Currency of Cash Flow Item RECDCFLCCURRCUKY5Assigned to domainWAERS
CCNETAMOUNTNet Amount of Cash Flow Item in Condition Currency RECDCFVALUENETCURR15(2) RECACURR
CCGROSSAMOUNTGross Amount of Cash Flow Item in Condition Currency RECDCFVALUEGROSSCURR15(2) RECACURR
CCTAXAMOUNTTax on Sales/Purch. of Cash Flow Item in Condition Currency RECDCFTAXVALUECURR15(2) RECACURR
CONDCURRCondition Currency of Cash Flow Item RECDCFCURRCUKY5Assigned to domainWAERS
TAXTYPETax Type RERATAXTYPECHAR4TIVRATAXTYPERERATAXTYPE
TAXGROUPTax Group RERATAXGROUPCHAR20TIVRATAXGROUPRERATAXGROUP
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
ISGROSSCondition Amount Is Gross Amount RECDISGROSSCHAR1RECABOOL
WHEREFROMFlow Origin RECDWHEREFROMCHAR1RECDWHEREFROM
FLOWTYPEFlow Type RECDFLOWTYPECHAR4TIVCDFLOWTYPEALPHARECDFLOWTYPE
ORIGFLOWTYPEOriginal Flow Type RECDORIGFLOWTYPECHAR4TIVCDFLOWTYPEALPHARECDFLOWTYPE
REFFLOWRELType of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWRELCHAR3TIVCDREFFLOWRELALPHARECDREFFLOWREL
CFSTATUSIndicates Status of Flow RECDCFSTATUSCHAR1RECDCFSTATUS
FDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
FDUPDFlag as to whether record enters cash management + forecast FDUPDCHAR1KENZX
FDELETEDeletion Indicator for Archiving RECAARDELETEINDCHAR1RECABOOL
ORIGDUEDATEOriginal Due Date RECDORIGDUEDATEDATS8DATUM
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNEROBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
CONDTYPECondition Type RECDCONDTYPECHAR4TIVCDCONDTYPEALPHARECDCONDTYPE
TERMNOPYNumber of Posting Term RECDTERMNOPYCHAR4ALPHARETMTERMNO
TERMNORHNumber of Frequency Term RECDTERMNORHCHAR4ALPHARETMTERMNO
TERMNOAJNumber of Adjustment Term RECDTERMNOAJCHAR4ALPHARETMTERMNO
TERMNOOANumber of Organizational Assignment Term RECDTERMNOOACHAR4ALPHARETMTERMNO
TERMNOSRNumber of Sales Term RECDTERMNOSRCHAR4ALPHARETMTERMNO
TERMNOMRNumber of Peak Sales Term RECDTERMNOMRCHAR4ALPHARETMTERMNO
TERMNOWTNumber of Withholding Tax Term RECDTERMNOWTCHAR4ALPHARETMTERMNO
ORIGEXDUEDATEOriginal Due Date RECDORIGDUEDATEDATS8DATUM
SEAPSTATUSStatus of Advance Payment Relevant to SCS RERASEAPSTATUSCHAR1RERASEAPSTATUS
POSTINGDATEPosting Date RECDPOSTINGDATEDATS8RECADATE
DOCUMENTDATEDocument Date RECDDOCUMENTDATEDATS8RECADATE
VALUATIONDATEDate for Translation of Contract Currency to Local Currency RECDVALUATIONDATEDATS8RECADATE
REVERSAL_FORGUID (RAW16) for 'Reversal for' References RECDREVERSALFORGUIDRAW16RECAGUID
REVERSAL_BYGUID (RAW16) for 'Reversed by' References RECDREVERSALBYGUIDRAW16RECAGUID
FOLLOWUP_FORGUID (RAW16) for 'Follow-Up Posting for' References RECDFOLLOWUPFORGUIDRAW16RECAGUID
BOOK_FLOWTYPEFlow Type RECDFLOWTYPECHAR4TIVCDFLOWTYPEALPHARECDFLOWTYPE
BOOK_REFFLOWRELType of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWRELCHAR3TIVCDREFFLOWRELALPHARECDREFFLOWREL
TAXDATEDate of Calculation of Sales/Purchase Tax RECDTAXDATEDATS8RECADATE
MODDUEDATEModified Due Date RECDMODDUEDATEDATS8DATUM
CALCDUEDATECalculated Due Date RECDCALCDUEDATEDATS8DATUM
CFSPLITFORGUIDGUID (RAW16) of Cash Flow Record That Was Split RECDCFSPLITFORGUIDRAW16RECAGUID
CFSPLITBASISCash Flow Record Was Basis for Split RECDCFSPLITBASISCHAR1RECABOOL
CDSPLITNONumber of Condition Split RETMCDSPLITNONUMC4NUMC4
COMPANYCODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CMCFGROUPPlanning Group FDGRPCHAR10Assigned to domainALPHAFDGRPFFG
CTRULECurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
CTLCNETAMOUNTNet Amount in Local Currency RECACTLCNETAMOUNTCURR15(2) RECACURR
CTLCGROSSAMOUNTGross Amount in Local Currency RECACTLCGROSSAMOUNTCURR15(2) RECACURR
CTLCTAXAMOUNTTax Amount in Local Currency RECACTLCTAXAMOUNTCURR15(2) RECACURR
CTRATEExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
CTRATEORIGExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
CTPOSTCDCURRPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
CTDATEREQPlanned Translation Date RECACTDATEREQDATS8DATS
CTDATEACTActual Translation Date RECACTDATEACTDATS8DATS
CTDATEACTORIGActual Translation Date RECACTDATEACTDATS8DATS
CTDATEFROMCFPOSUse Translation Date from Cash Flow RECDCTDATEFROMCFPOSCHAR1RECABOOL

Key field Non-key field



How do I retrieve data from SAP table VICDCFPAY using ABAP code

The following ABAP code Example will allow you to do a basic selection on VICDCFPAY to SELECT all data from the table
DATA: WA_VICDCFPAY TYPE VICDCFPAY.

SELECT SINGLE *
FROM VICDCFPAY
INTO CORRESPONDING FIELDS OF WA_VICDCFPAY
WHERE...

How to access SAP table VICDCFPAY

Within an ECC or HANA version of SAP you can also view further information about VICDCFPAY and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!