SAP VVSCPOS Payment Plan Item Table

Overview

VVSCPOS is a standard SAP S/4HANA table that stores Payment Plan Item data. There are total 170 fields in the VVSCPOS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VVSCPOS belongs to Collections/Disbursements (FS-CD) module and is located in the package Payment Plan: Repository (FSCDPP_REP).

In addition, following links provide an overview of foreign key relationships, if any, that link VVSCPOS to other SAP tables and standard CDS views available based on VVSCPOS table in S/4HANA 2020.

Techincal Settings of VVSCPOS

Below are technical details of the table VVSCPOS

Buffering not allowed
No buffering
Storage type is Column Store

List of VVSCPOS Fields

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

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT		CLNT	3
GPART	Business Partner Number	GPART_KK		CHAR	10
VTREF	Reference Specifications from Contract	VTREF_KK		CHAR	20
POSNR	Item ID	SCCOUNT_SC		CHAR	12
SCPOSNR	Time Stamp (Date and Time)	TIMST_VK		CHAR	14
BLTYP	Payment Plan Item Category	BLTP1_SC		CHAR	2
STATPOST	Post Payment Plan Item w/o Posting Stat.?	STATPOST_SC		CHAR	1
ARCHI	Payment item can be written to archive	ARCHI_SC		CHAR	1
XLOCK	Indicator: Item with Document Lock	XLOCK_SC		CHAR	1
PSNGL	Indicator: One-Time Payment	PSNGL_SC		CHAR	1
PMTFR	Valid-From Date for Payment Plan Item	PMFTR_SC		DATS	8
PMTTO	Valid-to date for payment plan items	PMTTO_SC		DATS	8
RISKFR	Valid-From Date for Payment Plan Item Risk	RISKFR_SC		DATS	8
RISKTO	Valid-To Date for Risk for Payment Plan Item	RISKTO_SC		DATS	8
PERFR	Start of Next Payment Period	PERFD_SC		DATS	8
PMEND	End early on	PMEND_SC		DATS	8
PMEND_TIME	Payment Plan Item: Event for Early Ending	PMEND_TIME_SC		TIMS	6
RENEW	Indicator: Renew Item	RENEW_SC		CHAR	1
RNEWX	Number of Automatically Renewed Items	RNEWX_SC		NUMC	3
RNEWD	Number of current renewals	RNEWD_SC		NUMC	3
RENEW_EXEC	Payment Plan: Payment Plan Item Renewed	RENEW_EXEC_SC		CHAR	1
CCODE	Company Code	BUKRS		CHAR	4
OPCCODE	Company Code	BUKRS		CHAR	4
GSBER	Business Area	GSBER	TGSB	CHAR	4
OPGSBER	Business Area	GSBER	TGSB	CHAR	4
PRGRP	Product Group	PRGRP_VK	TKKVPRGRP	CHAR	2
SEGMENT	Segment for Segmental Reporting	SEGMT_KK		CHAR	10
VSARL_VX	Insurance Type	VSARL_VX	TLXXVAL	CHAR	6
INSTAXS	Insurance Tax Schedule	INSTAXS_VK	TKKV007A	CHAR	4
TXPOS	Tax Referemce (Tax Reporting)	TXPOS_KK		NUMC	4
AMOUNT_TOTAL	Amount in Transaction Currency with +/- Sign	BETRW_SC		CURR	13
AMOUNT_INST	Payment Plan Item: Installment for each Due Date	AMOUNT_INST_SC		CURR	13
ATFRD	Valid-From Date for Amount Changes	ATFRD_SC		DATS	8
ATFRD_TIME	Payment Plan Item: Event for Amount Change	ATFRD_TIME_SC		TIMS	6
AMOUNT_DIFF	Amount in Transaction Currency with +/- Sign	BETRW_KK		CURR	13
AMOUNT_TRANS	Current distrib.amount of payment plan item	XBETRW_SC		CURR	13
ENDTYPE	Payment Plans: End Type for a Payment Plan Item	ENDTYPE_SC		CHAR	1
AMOUNT_NEED	Total amount when canceling payment plan early	AMNEED_SC		CURR	13
AMOUNT_END	Difference Amount for Ending Payment Plan Item	AMOUNT_END_SC		CURR	13
CHARGE_NEED	Charges Amount When Ending Payment Plan Item	CHNEED_SC		CURR	13
GLAET_AMT	Amount in Transaction Currency with +/- Sign	BETRW_SC		CURR	13
CURR	Currency Key	WAERS	TCURC	CUKY	5
PAYMENTFR	Lower Limit for Customer-Initiated Payment (in Percent)	PAYMENTFR_SC		NUMC	3
PAYMENTTO	Upper Limit for Customer-Initiated Payment (in Percent)	PAYMENTTO_SC		NUMC	3
CRDATE	Payment Plan Item Creation Date	CRDATE_SC		DATS	8
CRTIME	Scheduling Item Created at	CRTIME_SC		TIMS	6
CRUSER	Name of Person who Added Object	CRUSER_SC		CHAR	12
CHDATE	Date of Last Change of Scheduling Item	CHDATE_SC		DATS	8
CHTIME	Time of Last Change of Payment Plan Item	CHTIME_SC		TIMS	6
CHUSER	Payment Plan Item Last Changed by	CHUSER_SC		CHAR	12
POKEY	Payment Option Key	POKEY_VK		CHAR	2
PKEY	Payment Plan Key	PKEY_VK		CHAR	2
PKEYFD	Valid-From Date for Payment Plan Key	PKEYFD_SC		DATS	8
HVORG	Main Transaction for Line Item	HVORG_KK	TFKHVO	CHAR	4
TVORG	Subtransaction for Document Item	TVORG_KK	TFKTVO	CHAR	4
OPHVORG	Main Transaction for Line Item	HVORG_KK	TFKHVO	CHAR	4
OPTVORG	Subtransaction for Document Item	TVORG_KK	TFKTVO	CHAR	4
S_HKONT	General ledger account	HKONT_KK		CHAR	10
H_HKONT	General ledger account	HKONT_KK		CHAR	10
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR		NUMC	10
VBUND	Company ID of Trading Partner	RASSC		CHAR	6
KONTT	Account Assignment Category	KONTT_KK		CHAR	2
KONTL	Acct assnmnt string for industry-specific account assngments	KONTL_KK		CHAR	50
BLART	Document Type	BLART_KK	TFK003	CHAR	2
VTRE2	Reference Specifications from Contract	VTREF_KK		CHAR	20
VTRE3	Reference Specifications from Contract	VTREF_KK		CHAR	20
XREVE	Document must be reversed	XREVE_SC		CHAR	1
XDIST	Indicator: Manual Distribution of Amount in Item	XDIST_SC		CHAR	1
BUGRD	Posting Reason	BUGRD_VK		NUMC	3
PNTYP	Item Category	PNTYP_VK		CHAR	2
XDERE	Indicator: Debt Recognition	XDEREN_SC		CHAR	1
AMOUNT_DERE	Amount in Transaction Currency with +/- Sign	BETRW_KK		CURR	13
VGPART2	Business Partner Number	GPART_KK		CHAR	10
VGPART3	Business Partner Number	GPART_KK		CHAR	10
GSFNR	Business Transaction Number	GSFNR_VK		CHAR	16
BELNR	Transfer Document Number	BELNR_VK		CHAR	6
PEROFF	Offset for Period Positioning	PEROFF_SC		DEC	3
VALUT	Value date	VALUT		DATS	8
PRCTR	Profit Center	PRCTR		CHAR	10
KOSTL	Cost Center	KOSTL	CSKS	CHAR	10
AUFNR	Order Number	AUFNR		CHAR	12
LDGRP	Ledger Group	LDGRP_KK	FAGL_TLDGRP	CHAR	4
PYGRP	Grouping field for automatic payments	PYGRP_KK		CHAR	10
PDTYP	Category of Payment Specification	PDTYP_KK		CHAR	1
GRKEY	Grouping Key for Displaying Open Items	GRKEY_KK		CHAR	3
XBEENDET	Checkbox: Scheduling Item Finished Deletes Payt Amt-Need	XBEENDET_SC		CHAR	1
CFSET	Indicator: Scheduling Item Processed in Cash Management	CFSET_SC		CHAR	1
CFPPC	Indicator: Payment Plan Change Processed in Cash Management	CFPPC_SC		CHAR	1
CFAC	Indicator: Amount Change Processed in Cash Management	CFAC_SC		CHAR	1
CFPE	Indicator: End Processed in Cash Management	CFPE_SC		CHAR	1
FDDATE	Date Used to Convert for Cash Management and Forecast	FDDATE_SC		DATS	8
FDDATE_FROM	Date from Which Cash Management Was Updated	FDDATE_FROM_SC		DATS	8
FDDATE_TO	Date up to Which Cash Management Was Updated	FDDATE_TO_SC		DATS	8
SCFDGRP	Planning Group	FDGRP_KK		CHAR	10
SCFDZTG	Additional Days for Cash Management	FDZTG_KK		NUMC	2
VOPBEL	Number of a FI-CA Document	OPBEL_KK		CHAR	12
MWSKZ	Tax on sales/purchases code	MWSKZ	T007A	CHAR	2
QSSKZ	Withholding Tax Code	QSSKZ	T059Q	CHAR	2
STRKZ	Tax Code for Other Taxes	STRKZ_KK	TFK007F	CHAR	2
OPKONTT	Account Assignment Category	KONTT_KK		CHAR	2
OPKONTL	Acct assnmnt string for industry-specific account assngments	KONTL_KK		CHAR	50
STRNETTO	Net Tax	STRNETTO_SC		CHAR	1
KTOSL	Transaction key for account determination	KTOSL_KK		CHAR	3
TXT	Item text	OPTXT_KK		CHAR	50
ORIGIN	Source of Data	ORIGIN_DI		CHAR	30
MPPLAN	Manual Payment Plan Linked with This Item	MPPLAN_SC		CHAR	1
XEIBH_KO	Create Separate Document in General Ledger	XEIBH_KK		CHAR	1
XEIPH_OPK	Create Line Item in General Ledger	XEIPH_KK		CHAR	1
HZUON	Assignment Number in G/L Document	HZUON_KK		CHAR	18
SGTXT	Item Text for G/L Document	SGTXT_KK		CHAR	50
XEIPH_OP	Create Line Item in General Ledger	XEIPH_KK		CHAR	1
FINRE	Contract Account of Final Recipient	FINRE_KK		CHAR	12
COINS_CODE	Coinsurance Key	COINS_REPID		CHAR	10
COINS_CAT	Category for Coinsurance-Relevant Document	COINS_DOC_TYPE_PRCL		CHAR	1
AWSYS	Logical system of source document	AWSYS		CHAR	10
AWTYP	Reference procedure	AWTYP		CHAR	5
AWKEY	Object key	AWKEY		CHAR	20
VERSION	Payment Plans: Version Number	VERSION_SC		CHAR	4
EMGPA	Alternative Business Partner for Payments	EMGPA_KK	BUT000	CHAR	10
EMBVT	Bank Details ID of Payee	EMBVT_KK		CHAR	4
EMADR	Address Number	AD_ADDRNUM	*	CHAR	10
EMCCID	Payment Card ID for Payments	CCID_KK		CHAR	6
PYMET	Payment Method	PYMET_KK	*	CHAR	1
PYBUK	Company Code for Automatic Payment Transactions	PYBUK_KK	*	CHAR	4
FDGRP	Planning Group	FDGRP_KK	T035	CHAR	10
FDZTG	Additional Days for Cash Management	FDZTG_KK		NUMC	2
FAEDS	Due Date for Cash Discount	FAEDS_KK		DATS	8
SKTPZ	Cash Discount Percentage Rate	SKTPZ_KK		DEC	5
FAEDN	Due date for net payment	FAEDN_KK		DATS	8
IKEY	Interest Key	IKEY_KK	TFK056A	CHAR	2
BUDAT	Posting Date in the Document	BUDAT		DATS	8
STUDT	Deferral to	STUDT_KK		DATS	8
BLDAT	Document Date in Document	BLDAT		DATS	8
DUN_REASON	Dunning Lock Reason	DUN_LOCKREASON_KK	*	CHAR	1
DUN_REASON_DAYS	Number Of Days An Object Remains Locked	LOCK_DAYS_KK		NUMC	3
PAY_REASON	Lock Reason for Automatic Payment	SPZAH_KK	*	CHAR	1
PAY_REASON_DAYS	Number Of Days An Object Remains Locked	LOCK_DAYS_KK		NUMC	3
CLR_REASON	Clearing Lock Reason	CLRLO_KK	*	CHAR	1
CLR_REASON_DAYS	Number Of Days An Object Remains Locked	LOCK_DAYS_KK		NUMC	3
INT_REASON	Interest Lock Reason	SPERZ_KK	*	CHAR	1
INT_REASON_DAYS	Number Of Days An Object Remains Locked	LOCK_DAYS_KK		NUMC	3
REFCLAIM	Reference to Payment in Claims Management System	REFCLAIM_VK		CHAR	8
WWERT	Translation date	WWERT_D		DATS	8
MNDID	Unique Reference to Mandate for each Payee	SEPA_MNDID		CHAR	35
FMTYP	Update Method for FM - FI-CA Integration	FMTYP_KK		CHAR	2
ORIGFIKRS	Original FM Area for FM Account Assignment	ORIGFIKRS_KK	*	CHAR	4
FIPEX	Commitment item	FM_FIPEX	*	CHAR	24
FISTL	Funds Center	FISTL	*	CHAR	16
FONDS	Fund	BP_GEBER	*	CHAR	10
FKBER	Functional Area	FKBER	*	CHAR	16
MEASURE	Funded Program	FM_MEASURE	*	CHAR	24
GRANT_NBR	Grant	GM_GRANT_NBR		CHAR	20
BUDGETYEAR	Original Year for FM Account Assignment	FM_START_OF_CHAIN		NUMC	4
BUDGET_PD	Budget Period	FM_BUDGET_PERIOD	*	CHAR	10
DUN_REASON_FDATE	Valid-From Date of Dunning Lock	DUN_REASON_FDATE_KK		DATS	8
DUN_REASON_TDATE	Valid-To Date of Dunning Lock	DUN_REASON_TDATE_KK		DATS	8
PAY_REASON_FDATE	Valid-From Date of Payment Lock	PAY_REASON_FDATE_KK		DATS	8
PAY_REASON_TDATE	Valid-To Date of Payment Lock	PAY_REASON_TDATE_KK		DATS	8
CLR_REASON_FDATE	Valid-From Date of Clearing Lock	CLR_REASON_FDATE_KK		DATS	8
CLR_REASON_TDATE	Valid-To Date of Clearing Lock	CLR_REASON_TDATE_KK		DATS	8
INT_REASON_FDATE	Valid-From Date of Interest Lock	INT_REASON_FDATE_KK		DATS	8
INT_REASON_TDATE	Valid-To Date of Interest Lock	INT_REASON_TDATE_KK		DATS	8
KSCHL	Type of Tax Item for Other Tax Codes	KSCHL_STRKZ_KK		CHAR	4
TAXAM	Tax Amount in Transaction Currency with +/- Sign	TAXAM_SC		CURR	13
STPRZ	Tax Percentage	STPRZ_SC		NUMC	6
SBASW	Amount Subject to Tax in Transaction Currency (Tax Base Amt)	SBASW_KK		CURR	13
XETAX	Indicator: Additional Entries Available in VVSCPOSETAX	XETAX_SC		CHAR	1
BETRH	Amount In Local Currency With +/- Signs	BETRH_KK		CURR	13
KURSF	Exchange rate	KURSF_KK		DEC	9
KTOSL_TAX	Transaction key for account determination	KTOSL_KK		CHAR	3

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 VVSCPOS

Table Name	Field	Cardinality	Check Table
VVSCPOS	BLART	1: CN	TFK003
VVSCPOS	CURR	:	TCURC
VVSCPOS	EMGPA	:	BUT000
VVSCPOS	FDGRP	:	T035
VVSCPOS	GSBER	C: CN	TGSB
VVSCPOS	HVORG	1: CN	TFKHVO
VVSCPOS	IKEY	:	TFK056A
VVSCPOS	INSTAXS	1: CN	TKKV007A
VVSCPOS	KOSTL	:	CSKS
VVSCPOS	LDGRP	:	FAGL_TLDGRP
VVSCPOS	MWSKZ	1: CN	T007A
VVSCPOS	OPGSBER	C: CN	TGSB
VVSCPOS	OPHVORG	1: CN	TFKHVO
VVSCPOS	OPTVORG	1: CN	TFKTVO
VVSCPOS	PRGRP	1: CN	TKKVPRGRP
VVSCPOS	QSSKZ	:	T059Q
VVSCPOS	STRKZ	:	TFK007F
VVSCPOS	TVORG	1: CN	TFKTVO
VVSCPOS	VSARL_VX	C: CN	TLXXVAL

SAP VVSCPOS Payment Plan Item Table

Overview

Techincal Settings of VVSCPOS

List of VVSCPOS Fields

Foreign Key Relationships

Other References