SAP VICDCFPAY Payment-Related Cash Flow Table

Overview

VICDCFPAY is a standard SAP S/4HANA table that stores Payment-Related Cash Flow data. There are total 117 fields in the VICDCFPAY table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VICDCFPAY 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 VICDCFPAY to other SAP tables and standard CDS views available based on VICDCFPAY table in S/4HANA 2020.

Techincal Settings of VICDCFPAY

Below are technical details of the table VICDCFPAY

Buffering not allowed
No buffering
Storage type is Column Store

List of VICDCFPAY Fields

The following table gives you an overview of the fields available in VICDCFPAY

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
CFPAYGUID	GUID (RAW16) for Payment-Related Cash Flow	RECDCFPAYGUID		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
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
PARTNER	Business Partner Number	BU_PARTNER		CHAR	10
PARTNEROBJNR	Object Number	RECAOBJNR	*	CHAR	22
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
CFSPLITFORGUID	GUID (RAW16) of Cash Flow Record That Was Split	RECDCFSPLITFORGUID		RAW	16
CFSPLITBASIS	Cash Flow Record Was Basis for Split	RECDCFSPLITBASIS		CHAR	1
CDSPLITNO	Number of Condition Split	RETMCDSPLITNO		NUMC	4
COMPANYCODE	Company Code	BUKRS		CHAR	4
CMCFGROUP	Planning Group	FDGRP	*	CHAR	10
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
OBJNRCOND	Object Number	RECAOBJNR	*	CHAR	22

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 VICDCFPAY

Table Name	Field	Cardinality	Check Table
VICDCFPAY	BOOK_FLOWTYPE	1: CN	TIVCDFLOWTYPE
VICDCFPAY	BOOK_REFFLOWREL	1: CN	TIVCDREFFLOWREL
VICDCFPAY	CONDTYPE	1: CN	TIVCDCONDTYPE
VICDCFPAY	FLOWTYPE	1: CN	TIVCDFLOWTYPE
VICDCFPAY	ORIGFLOWTYPE	1: CN	TIVCDFLOWTYPE
VICDCFPAY	REFFLOWREL	1: CN	TIVCDREFFLOWREL
VICDCFPAY	TAXGROUP	1: CN	TIVRATAXGROUP
VICDCFPAY	TAXTYPE	1: CN	TIVRATAXTYPE

SAP VICDCFPAY Payment-Related Cash Flow Table

Overview

Techincal Settings of VICDCFPAY

List of VICDCFPAY Fields

Foreign Key Relationships

Other References