VVSCPOS

Payment Plan Item | #masterdata | Component: Collections/Disbursements
Column Name Description
MANDT Client
GPART Business Partner Number
VTREF Reference Specifications from Contract
POSNR Item ID
SCPOSNR Time Stamp (Date and Time)
Column Name Description
💲 Currency Key (CURR):
AMOUNT_TOTAL Amount in Transaction Currency with +/- Sign
AMOUNT_INST Payment Plan Item: Installment for each Due Date
AMOUNT_DIFF Amount in Transaction Currency with +/- Sign
AMOUNT_TRANS Current distrib.amount of payment plan item
AMOUNT_NEED Total amount when canceling payment plan early
AMOUNT_END Difference Amount for Ending Payment Plan Item
CHARGE_NEED Charges Amount When Ending Payment Plan Item
GLAET_AMT Amount in Transaction Currency with +/- Sign
AMOUNT_DERE Amount in Transaction Currency with +/- Sign
TAXAM Tax Amount in Transaction Currency with +/- Sign
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt)
💲 Currency Key (T001.WAERS):
BETRH Amount In Local Currency With +/- Signs
Column Name Description
Column Name Description
PMTFR Valid-From Date for Payment Plan Item
PMTTO Valid-to date for payment plan items
RISKFR Valid-From Date for Payment Plan Item Risk
RISKTO Valid-To Date for Risk for Payment Plan Item
PERFR Start of Next Payment Period
PMEND End early on
PMEND_TIME Payment Plan Item: Event for Early Ending
ATFRD Valid-From Date for Amount Changes
ATFRD_TIME Payment Plan Item: Event for Amount Change
CRDATE Payment Plan Item Creation Date
CRTIME Scheduling Item Created at
CHDATE Date of Last Change of Scheduling Item
CHTIME Time of Last Change of Payment Plan Item
PKEYFD Valid-From Date for Payment Plan Key
VALUT Value date
FDDATE Date Used to Convert for Cash Management and Forecast
FDDATE_FROM Date from Which Cash Management Was Updated
FDDATE_TO Date up to Which Cash Management Was Updated
FAEDS Due Date for Cash Discount
FAEDN Due date for net payment
BUDAT Posting Date in the Document
STUDT Deferral to
BLDAT Document Date in Document
WWERT Translation date
DUN_REASON_FDATE Valid-From Date of Dunning Lock
DUN_REASON_TDATE Valid-To Date of Dunning Lock
PAY_REASON_FDATE Valid-From Date of Payment Lock
PAY_REASON_TDATE Valid-To Date of Payment Lock
CLR_REASON_FDATE Valid-From Date of Clearing Lock
CLR_REASON_TDATE Valid-To Date of Clearing Lock
INT_REASON_FDATE Valid-From Date of Interest Lock
INT_REASON_TDATE Valid-To Date of Interest Lock
Column Name Description
BLTYP Payment Plan Item Category Show values
STATPOST Post Payment Plan Item w/o Posting Stat.? Show values
ARCHI Payment item can be written to archive Show values
XLOCK Indicator: Item with Document Lock Show values
PSNGL Indicator: One-Time Payment Show values
RENEW Indicator: Renew Item Show values
ENDTYPE Payment Plans: End Type for a Payment Plan Item Show values
XREVE Document must be reversed Show values
XDIST Indicator: Manual Distribution of Amount in Item Show values
XDERE Indicator: Debt Recognition Show values
PDTYP Category of Payment Specification Show values
XBEENDET Checkbox: Scheduling Item Finished, Deletes Payt Amt-Need Show values
CFSET Indicator: Scheduling Item Processed in Cash Management Show values
CFPPC Indicator: Payment Plan Change Processed in Cash Management Show values
CFAC Indicator: Amount Change Processed in Cash Management Show values
CFPE Indicator: End Processed in Cash Management Show values
KTOSL Transaction key for account determination Show values
XEIBH_KO Create Separate Document in General Ledger Show values
XEIPH_OPK Create Line Item in General Ledger Show values
XEIPH_OP Create Line Item in General Ledger Show values
COINS_CAT Category for Coinsurance-Relevant Document Show values
FMTYP Update Method for FM - FI-CA Integration Show values
XETAX Indicator: Additional Entries Available in VVSCPOSETAX Show values
KTOSL_TAX Transaction key for account determination Show values
Column Name Description Domain name
RNEWX Number of Automatically Renewed Items NUMC3
RNEWD Number of current renewals NUMC3
RENEW_EXEC Payment Plan: Payment Plan Item Renewed CHAR1
CCODE Company Code BUKRS
OPCCODE Company Code BUKRS
SEGMENT Segment for Segmental Reporting FB_SEGMENT
TXPOS Tax Referemce (Tax Reporting) TXPOS_KK
PAYMENTFR Lower Limit for Customer-Initiated Payment (in Percent) NUM03
PAYMENTTO Upper Limit for Customer-Initiated Payment (in Percent) NUM03
CRUSER Name of Person who Added Object USNAM
CHUSER Payment Plan Item Last Changed by USNAM
POKEY Payment Option Key POKEY_VK
PKEY Payment Plan Key PKEY_VK
S_HKONT General ledger account SAKNR
H_HKONT General ledger account SAKNR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
VBUND Company ID of Trading Partner RCOMP
KONTT Account Assignment Category KONTT_KK
KONTL Acct assnmnt string for industry-specific account assngments CHAR50
VTRE2 Reference Specifications from Contract VTREF_KK
VTRE3 Reference Specifications from Contract VTREF_KK
BUGRD Posting Reason BUGRD_VK
PNTYP Item Category PNTYP_VK
VGPART2 Business Partner Number BU_PARTNER
VGPART3 Business Partner Number BU_PARTNER
GSFNR Business Transaction Number GSFNR_VK
BELNR Transfer Document Number BELNR_VK
PEROFF Offset for Period Positioning PEROFF_SC
PRCTR Profit Center PRCTR
AUFNR Order Number AUFNR
PYGRP Grouping field for automatic payments CHAR10
GRKEY Grouping Key for Displaying Open Items CHAR3
SCFDGRP Planning Group FDGRP
SCFDZTG Additional Days for Cash Management NUM2
VOPBEL Number of a FI-CA Document OPBEL_KK
OPKONTT Account Assignment Category KONTT_KK
OPKONTL Acct assnmnt string for industry-specific account assngments CHAR50
STRNETTO Net Tax STRNETTO_SC
TXT Item text TEXT50
ORIGIN Source of Data CHAR30
MPPLAN Manual Payment Plan Linked with This Item CHAR1
HZUON Assignment Number in G/L Document ZUONR
SGTXT Item Text for G/L Document TEXT50
FINRE Contract Account of Final Recipient VKONT_KK
COINS_CODE Coinsurance Key REPID_VK
AWSYS Logical system of source document LOGSYS
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
VERSION Payment Plans: Version Number VERSION_SC
EMBVT Bank Details ID of Payee CHAR4
EMADR Address Number AD_ADDRNUM
EMCCID Payment Card ID for Payments CHAR6
PYMET Payment Method PYMET_KK
PYBUK Company Code for Automatic Payment Transactions BUKRS
FDZTG Additional Days for Cash Management NUM2
SKTPZ Cash Discount Percentage Rate PRZ23
DUN_REASON Dunning Lock Reason MANSP_KK
DUN_REASON_DAYS Number Of Days An Object Remains Locked LOCK_DAYS_KK
PAY_REASON Lock Reason for Automatic Payment SPZAH_KK
PAY_REASON_DAYS Number Of Days An Object Remains Locked LOCK_DAYS_KK
CLR_REASON Clearing Lock Reason SPPOS_KK
CLR_REASON_DAYS Number Of Days An Object Remains Locked LOCK_DAYS_KK
INT_REASON Interest Lock Reason SPERZ_KK
INT_REASON_DAYS Number Of Days An Object Remains Locked LOCK_DAYS_KK
REFCLAIM Reference to Payment in Claims Management System CHAR8
MNDID Unique Reference to Mandate for each Payee ID035
ORIGFIKRS Original FM Area for FM Account Assignment FIKRS
FIPEX Commitment Item FM_FIPEX
FISTL Funds Center FISTL
FONDS Fund BP_GEBER
FKBER Functional Area FKBER
MEASURE Funded Program FM_MEASURE
GRANT_NBR Grant GM_GRANT_NBR
BUDGETYEAR Original Year for FM Account Assignment GJAHR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
KSCHL Type of Tax Item for Other Tax Codes CHAR4
STPRZ Tax Percentage STPRZ_KK
KURSF Exchange rate KURSF
BENT1 Service Type BENTY_KK
ISSRB ISS Tax Rate for Simples PRZ22
Master Data Relations Join Conditions
Document Type
  • ?
  • Document Type
  • VVSCPOS.MANDT == TFK003.MANDT
  • VVSCPOS.[column in domain "APPLK_KK"] == TFK003.APPLK
  • VVSCPOS.BLART == TFK003.BLART
Currency Key
  • VVSCPOS.MANDT == TCURC.MANDT
  • VVSCPOS.CURR == TCURC.WAERS
Alternative Business Partner for Payments
  • Alternative Business Partner for Payments
  • Client
  • VVSCPOS.EMGPA == BUT000.PARTNER
  • VVSCPOS.MANDT == BUT000.CLIENT
Planning Group
  • VVSCPOS.MANDT == T035.MANDT
  • VVSCPOS.FDGRP == T035.GRUPP
Business Area
  • VVSCPOS.MANDT == TGSB.MANDT
  • VVSCPOS.GSBER == TGSB.GSBER
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • VVSCPOS.MANDT == TFKHVO.MANDT
  • VVSCPOS.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • VVSCPOS.HVORG == TFKHVO.HVORG
Interest Key
Insurance Tax Schedule
  • Insurance Tax Schedule
  • ?
  • VVSCPOS.MANDT == TKKV007A.MANDT
  • VVSCPOS.INSTAXS == TKKV007A.INSTAXS
  • VVSCPOS.[column in domain "LAND"] == TKKV007A.COUNTRY
Cost Center
  • ?
  • Cost Center
  • ?
  • VVSCPOS.MANDT == CSKS.MANDT
  • VVSCPOS.[column in domain "DATBI"] == CSKS.DATBI
  • VVSCPOS.KOSTL == CSKS.KOSTL
  • VVSCPOS.[column in domain "KOKRS"] == CSKS.KOKRS
Ledger Group
  • Ledger Group
  • Client
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • VVSCPOS.MANDT == T007A.MANDT
  • VVSCPOS.[column in domain "KALSM_D"] == T007A.KALSM
  • VVSCPOS.MWSKZ == T007A.MWSKZ
Business Area
  • VVSCPOS.MANDT == TGSB.MANDT
  • VVSCPOS.OPGSBER == TGSB.GSBER
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • VVSCPOS.MANDT == TFKHVO.MANDT
  • VVSCPOS.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • VVSCPOS.OPHVORG == TFKHVO.HVORG
Subtransaction for Document Item
  • Main Transaction for Line Item
  • ?
  • Subtransaction for Document Item
  • VVSCPOS.MANDT == TFKTVO.MANDT
  • VVSCPOS.OPHVORG == TFKTVO.HVORG
  • VVSCPOS.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • VVSCPOS.OPTVORG == TFKTVO.TVORG
Product Group
  • Company Code
  • Client
  • Product Group
Withholding Tax Code
  • ?
  • Client
  • Withholding Tax Code
  • VVSCPOS.[column in domain "LAND1"] == T059Q.LAND1
  • VVSCPOS.MANDT == T059Q.MANDT
  • VVSCPOS.QSSKZ == T059Q.QSSKZ
Tax Code for Other Taxes
  • ?
  • Tax Code for Other Taxes
  • VVSCPOS.MANDT == TFK007F.MANDT
  • VVSCPOS.[column in domain "LAND"] == TFK007F.LAND
  • VVSCPOS.STRKZ == TFK007F.STRKZ
Subtransaction for Document Item
  • Main Transaction for Line Item
  • ?
  • Subtransaction for Document Item
  • VVSCPOS.MANDT == TFKTVO.MANDT
  • VVSCPOS.HVORG == TFKTVO.HVORG
  • VVSCPOS.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • VVSCPOS.TVORG == TFKTVO.TVORG
Insurance Type
  • Company Code
  • Insurance Type