1. Home
  2. Resources
  3. SAP Tables
  4. VVSCPOS - Payment Plan Item

SAP Table VVSCPOS

Payment Plan Item

VVSCPOS (Payment Plan Item) 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 VVSCPOS to other SAP tables.

VVSCPOS table fields

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

VVSCPOS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VVSCPOS BLART VVSCPOS MANDT TFK003 Document types MANDT
VVSCPOS BLART 'V' TFK003 Document types APPLK
VVSCPOS BLART VVSCPOS BLART TFK003 Document types BLART
VVSCPOS CURR VVSCPOS MANDT TCURC Currency Codes MANDT
VVSCPOS CURR VVSCPOS CURR TCURC Currency Codes WAERS
VVSCPOS EMGPA SY MANDT BUT000 BP: General data I CLIENT
VVSCPOS EMGPA VVSCPOS EMGPA BUT000 BP: General data I PARTNER
VVSCPOS FDGRP SYST MANDT T035 Planning groups MANDT
VVSCPOS FDGRP VVSCPOS FDGRP T035 Planning groups GRUPP
VVSCPOS GSBER VVSCPOS MANDT TGSB Business Areas MANDT
VVSCPOS GSBER VVSCPOS GSBER TGSB Business Areas GSBER
VVSCPOS HVORG 'V' TFKHVO Main transactions in contract accts receivable and payable APPLK
VVSCPOS HVORG VVSCPOS HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
VVSCPOS HVORG VVSCPOS MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
VVSCPOS IKEY SYST MANDT TFK056A Interest Key Table for FI-CA MANDT
VVSCPOS IKEY VVSCPOS IKEY TFK056A Interest Key Table for FI-CA IKEY
VVSCPOS INSTAXS VVSCPOS MANDT TKKV007A Insurance Tax Schedule MANDT
VVSCPOS INSTAXS VVSCPOS INSTAXS TKKV007A Insurance Tax Schedule INSTAXS
VVSCPOS INSTAXS * TKKV007A Insurance Tax Schedule COUNTRY
VVSCPOS KOSTL VVSCPOS MANDT CSKS Cost Center Master Data MANDT
VVSCPOS KOSTL * CSKS Cost Center Master Data KOKRS
VVSCPOS KOSTL VVSCPOS KOSTL CSKS Cost Center Master Data KOSTL
VVSCPOS KOSTL * CSKS Cost Center Master Data DATBI
VVSCPOS LDGRP VVSCPOS MANDT FAGL_TLDGRP Ledger Group MANDT
VVSCPOS LDGRP VVSCPOS LDGRP FAGL_TLDGRP Ledger Group LDGRP
VVSCPOS MWSKZ VVSCPOS MANDT T007A Tax Keys MANDT
VVSCPOS MWSKZ * T007A Tax Keys KALSM
VVSCPOS MWSKZ VVSCPOS MWSKZ T007A Tax Keys MWSKZ
VVSCPOS OPGSBER VVSCPOS OPGSBER TGSB Business Areas GSBER
VVSCPOS OPGSBER VVSCPOS MANDT TGSB Business Areas MANDT
VVSCPOS OPHVORG VVSCPOS MANDT TFKHVO Main transactions in contract accts receivable and payable MANDT
VVSCPOS OPHVORG 'V' TFKHVO Main transactions in contract accts receivable and payable APPLK
VVSCPOS OPHVORG VVSCPOS OPHVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
VVSCPOS OPTVORG VVSCPOS MANDT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
VVSCPOS OPTVORG 'V' TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
VVSCPOS OPTVORG VVSCPOS OPHVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
VVSCPOS OPTVORG VVSCPOS OPTVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
VVSCPOS PRGRP VVSCPOS CCODE TKKVPRGRP Product Groups BUKRS
VVSCPOS PRGRP VVSCPOS PRGRP TKKVPRGRP Product Groups PRGRP
VVSCPOS PRGRP VVSCPOS MANDT TKKVPRGRP Product Groups MANDT
VVSCPOS QSSKZ VVSCPOS MANDT T059Q Withholding Tax MANDT
VVSCPOS QSSKZ * T059Q Withholding Tax LAND1
VVSCPOS QSSKZ VVSCPOS QSSKZ T059Q Withholding Tax QSSKZ
VVSCPOS STRKZ SIMAFLDS LAND1_CCODE TFK007F Other Tax Codes LAND
VVSCPOS STRKZ VVSCPOS STRKZ TFK007F Other Tax Codes STRKZ
VVSCPOS STRKZ VVSCPOS MANDT TFK007F Other Tax Codes MANDT
VVSCPOS TVORG VVSCPOS HVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
VVSCPOS TVORG VVSCPOS TVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
VVSCPOS TVORG VVSCPOS MANDT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
VVSCPOS TVORG 'V' TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
VVSCPOS VSARL_VX VVSCPOS MANDT TLXXVAL Insurance Type MANDT
VVSCPOS VSARL_VX VVSCPOS CCODE TLXXVAL Insurance Type BUKRS
VVSCPOS VSARL_VX VVSCPOS VSARL_VX TLXXVAL Insurance Type VSARL_VX