SAP table VVSCPOS (Payment Plan Item)

SAP table VVSCPOS has 5 primary key fields being MANDT,GPART,VTREF,POSNR,SCPOSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

VVSCPOS foreign key relationships

Table Field Check Table Check Field
0 VVSCPOS CURR TCURC Currency Codes MANDT
0 VVSCPOS CURR TCURC Currency Codes WAERS
1 VVSCPOS EMGPA BUT000 BP: General data I PARTNER
0 VVSCPOS FDGRP T035 Planning groups GRUPP
1 VVSCPOS GSBER TGSB Business Areas MANDT
1 VVSCPOS GSBER TGSB Business Areas GSBER
0 VVSCPOS HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
0 VVSCPOS HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
1 VVSCPOS IKEY TFK056A Interest Key Table for FI-CA IKEY
0 VVSCPOS INSTAXS TKKV007A Insurance Tax Schedule MANDT
0 VVSCPOS INSTAXS TKKV007A Insurance Tax Schedule COUNTRY
1 VVSCPOS KOSTL CSKS Cost Center Master Record MANDT
1 VVSCPOS KOSTL CSKS Cost Center Master Record KOKRS
1 VVSCPOS KOSTL CSKS Cost Center Master Record KOSTL
1 VVSCPOS KOSTL CSKS Cost Center Master Record DATBI
0 VVSCPOS LDGRP FAGL_TLDGRP Ledger Group LDGRP
1 VVSCPOS MWSKZ T007A Tax Keys KALSM
1 VVSCPOS MWSKZ T007A Tax Keys MWSKZ
0 VVSCPOS OPGSBER TGSB Business Areas MANDT
0 VVSCPOS OPGSBER TGSB Business Areas GSBER
1 VVSCPOS OPHVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 VVSCPOS OPHVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 VVSCPOS OPTVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 VVSCPOS OPTVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 VVSCPOS PRGRP TKKVPRGRP Product Groups BUKRS
0 VVSCPOS QSSKZ T059Q Withholding Tax MANDT
0 VVSCPOS QSSKZ T059Q Withholding Tax LAND1
0 VVSCPOS QSSKZ T059Q Withholding Tax QSSKZ
1 VVSCPOS STRKZ TFK007F Other Tax Codes LAND
0 VVSCPOS TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 VVSCPOS TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 VVSCPOS VSARL_VX TLXXVAL Insurance Type MANDT
1 VVSCPOS VSARL_VX TLXXVAL Insurance Type BUKRS