VVSCPOS SAP table for – Bill Scheduling: Scheduling Item

Here we would like to draw your attention to VVSCPOS table in SAP. As we know it is being mainly used with the SAP FS-CD (Collections/Disbursements in FS) component which is coming under FS module (Financial Services). VVSCPOS is a SAP standard transp table used for storing Bill Scheduling: Scheduling Item related data in SAP. It comes under the package VVSC.

SAP VVSCPOS table

Table VVSCPOS technical data

TableVVSCPOS
Data storingBill Scheduling: Scheduling Item
ModuleFS
Sub ModuleFS-CD
SAP PackageVVSC
Delivery ClassA – Application table (master and transaction data)
ComponentINSURANCE
Table CategoryTRANSP

SAP VVSCPOS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VVSCPOS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GPART : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VTREF : Reference Specifications from Contract
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • POSNR : Item ID
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • SCPOSNR : Time Stamp (Date and Time)
    Its a key field. Its data type is CHAR (Character String) with field length 14
  • BLTYP : Payment Plan Item Category
    Its data type is CHAR (Character String) with field length 2
  • STATPOST : Post Payment Plan Item w/o Posting Stat.?
    Its data type is CHAR (Character String) with field length 1
  • ARCHI : Payment item can be written to archive
    Its data type is CHAR (Character String) with field length 1
  • XLOCK : Indicator: Item with Document Lock
    Its data type is CHAR (Character String) with field length 1
  • PSNGL : Indicator: One-Time Payment
    Its data type is CHAR (Character String) with field length 1
  • PMTFR : Valid-From Date for Payment Plan Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PMTTO : Valid-to date for payment plan items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RISKFR : Valid-From Date for Payment Plan Item Risk
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RISKTO : Valid-To Date for Risk for Payment Plan Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PERFR : Start of Next Payment Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PMEND : End early on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PMEND_TIME : Payment Plan Item: Event for Early Ending
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RENEW : Indicator: Renew Item
    Its data type is CHAR (Character String) with field length 1
  • RNEWX : Number of Automatically Renewed Items
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RNEWD : Number of current renewals
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RENEW_EXEC : Payment Plan: Payment Plan Item Renewed
    Its data type is CHAR (Character String) with field length 1
  • CCODE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • OPCCODE : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • OPGSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PRGRP : Product Group
    Its data type is CHAR (Character String) with field length 2
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • VSARL_VX : Insurance Type
    Its data type is CHAR (Character String) with field length 6
  • INSTAXS : Insurance Tax Schedule
    Its data type is CHAR (Character String) with field length 4
  • TXPOS : Tax Referemce (Tax Reporting)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • AMOUNT_TOTAL : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • AMOUNT_INST : Payment Plan Item: Installment for each Due Date
    Its data type is CURR (Currency Field) with field length 13
  • ATFRD : Valid-From Date for Amount Changes
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ATFRD_TIME : Payment Plan Item: Event for Amount Change
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AMOUNT_DIFF : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • AMOUNT_TRANS : Current distrib.amount of payment plan item
    Its data type is CURR (Currency Field) with field length 13
  • ENDTYPE : Payment Plans: End Type for a Payment Plan Item
    Its data type is CHAR (Character String) with field length 1
  • AMOUNT_NEED : Total amount when canceling payment plan early
    Its data type is CURR (Currency Field) with field length 13
  • AMOUNT_END : Difference Amount for Ending Payment Plan Item
    Its data type is CURR (Currency Field) with field length 13
  • CHARGE_NEED : Charges Amount When Ending Payment Plan Item
    Its data type is CURR (Currency Field) with field length 13
  • GLAET_AMT : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PAYMENTFR : Lower Limit for Customer-Initiated Payment (in Percent)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PAYMENTTO : Upper Limit for Customer-Initiated Payment (in Percent)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CRDATE : Payment Plan Item Creation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRTIME : Scheduling Item Created at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CRUSER : Name of Person who Added Object
    Its data type is CHAR (Character String) with field length 12
  • CHDATE : Date of Last Change of Scheduling Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHTIME : Time of Last Change of Payment Plan Item
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CHUSER : Payment Plan Item Last Changed by
    Its data type is CHAR (Character String) with field length 12
  • POKEY : Payment Option Key
    Its data type is CHAR (Character String) with field length 2
  • PKEY : Payment Plan Key
    Its data type is CHAR (Character String) with field length 2
  • PKEYFD : Valid-From Date for Payment Plan Key
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HVORG : Main Transaction for Line Item
    Its data type is CHAR (Character String) with field length 4
  • TVORG : Subtransaction for Document Item
    Its data type is CHAR (Character String) with field length 4
  • OPHVORG : Main Transaction for Line Item
    Its data type is CHAR (Character String) with field length 4
  • OPTVORG : Subtransaction for Document Item
    Its data type is CHAR (Character String) with field length 4
  • S_HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • H_HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • KONTT : Account Assignment Category
    Its data type is CHAR (Character String) with field length 2
  • KONTL : Acct assnmnt string for industry-specific account assngments
    Its data type is CHAR (Character String) with field length 50
  • BLART : Document Type
    Its data type is CHAR (Character String) with field length 2
  • VTRE2 : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • VTRE3 : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • XREVE : Document must be reversed
    Its data type is CHAR (Character String) with field length 1
  • XDIST : Indicator: Manual Distribution of Amount in Item
    Its data type is CHAR (Character String) with field length 1
  • BUGRD : Posting Reason
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PNTYP : Item Category
    Its data type is CHAR (Character String) with field length 2
  • XDERE : Indicator: Debt Recognition
    Its data type is CHAR (Character String) with field length 1
  • AMOUNT_DERE : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • VGPART2 : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VGPART3 : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • GSFNR : Business Transaction Number
    Its data type is CHAR (Character String) with field length 16
  • BELNR : Transfer Document Number
    Its data type is CHAR (Character String) with field length 6
  • PEROFF : Offset for Period Positioning
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • PYGRP : Grouping field for automatic payments
    Its data type is CHAR (Character String) with field length 10
  • PDTYP : Category of Payment Specification
    Its data type is CHAR (Character String) with field length 1
  • GRKEY : Grouping Key for Displaying Open Items
    Its data type is CHAR (Character String) with field length 3
  • XBEENDET : Indicator: Scheduling Item Finished, Deletes Pmend Amt-Need
    Its data type is CHAR (Character String) with field length 1
  • CFSET : Indicator: Scheduling Item Processed in Cash Management
    Its data type is CHAR (Character String) with field length 1
  • CFPPC : Indicator: Payment Plan Change Processed in Cash Management
    Its data type is CHAR (Character String) with field length 1
  • CFAC : Indicator: Amount Change Processed in Cash Management
    Its data type is CHAR (Character String) with field length 1
  • CFPE : Indicator: End Processed in Cash Management
    Its data type is CHAR (Character String) with field length 1
  • FDDATE : Date Used to Convert for Cash Management and Forecast
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FDDATE_FROM : Date from Which Cash Management Was Updated
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FDDATE_TO : Date up to Which Cash Management Was Updated
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SCFDGRP : Planning Group
    Its data type is CHAR (Character String) with field length 10
  • SCFDZTG : Additional Days for Cash Management
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • VOPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • STRKZ : Tax Code for Other Taxes
    Its data type is CHAR (Character String) with field length 2
  • OPKONTT : Account Assignment Category
    Its data type is CHAR (Character String) with field length 2
  • OPKONTL : Acct assnmnt string for industry-specific account assngments
    Its data type is CHAR (Character String) with field length 50
  • STRNETTO : Net Tax
    Its data type is CHAR (Character String) with field length 1
  • KTOSL : Transaction key for account determination
    Its data type is CHAR (Character String) with field length 3
  • TXT : Item text
    Its data type is CHAR (Character String) with field length 50
  • ORIGIN : Source of Data
    Its data type is CHAR (Character String) with field length 30
  • MPPLAN : Manual Payment Plan Linked with This Item
    Its data type is CHAR (Character String) with field length 1
  • XEIBH_KO : Create Separate Document in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • XEIPH_OPK : Create Line Item in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • HZUON : Assignment Number in G/L Document
    Its data type is CHAR (Character String) with field length 18
  • SGTXT : Item Text for G/L Document
    Its data type is CHAR (Character String) with field length 50
  • XEIPH_OP : Create Line Item in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • FINRE : Contract Account of Final Recipient
    Its data type is CHAR (Character String) with field length 12
  • COINS_CODE : Coinsurance Key
    Its data type is CHAR (Character String) with field length 10
  • COINS_CAT : Category for Coinsurance-Relevant Document
    Its data type is CHAR (Character String) with field length 1
  • VERSION : Payment Plans: Version Number
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Scheduling Structure for Posting of Single Documents
  • EMGPA : Alternative business partner for payments
    Its data type is CHAR (Character String) with field length 10
  • EMBVT : Bank Details ID of Payee
    Its data type is CHAR (Character String) with field length 4
  • EMADR : Address number
    Its data type is CHAR (Character String) with field length 10
  • EMCCID : Payment Card ID for Payments
    Its data type is CHAR (Character String) with field length 6
  • PYMET : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • PYBUK : Company Code for Automatic Payment Transactions
    Its data type is CHAR (Character String) with field length 4
  • FDGRP : Planning Group
    Its data type is CHAR (Character String) with field length 10
  • FDZTG : Additional Days for Cash Management
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FAEDS : Due Date for Cash Discount
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKTPZ : Cash discount rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IKEY : Interest Key
    Its data type is CHAR (Character String) with field length 2
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STUDT : Deferral to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUN_REASON : Dunning Lock Reason
    Its data type is CHAR (Character String) with field length 1
  • DUN_REASON_DAYS : Number Of Days An Object Remains Locked
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PAY_REASON : Lock Reason for Automatic Payment
    Its data type is CHAR (Character String) with field length 1
  • PAY_REASON_DAYS : Number Of Days An Object Remains Locked
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CLR_REASON : Clearing Lock Reason
    Its data type is CHAR (Character String) with field length 1
  • CLR_REASON_DAYS : Number Of Days An Object Remains Locked
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • INT_REASON : Interest Lock Reason
    Its data type is CHAR (Character String) with field length 1
  • INT_REASON_DAYS : Number Of Days An Object Remains Locked
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REFCLAIM : Reference to Payment in Claims Management System
    Its data type is CHAR (Character String) with field length 8
  • WWERT : Translation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MNDID : Unique Referene to Mandate per Payment Recipient
    Its data type is CHAR (Character String) with field length 35
  • .INCLUDE : Include for FM Integration (OI)
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes