VVSCITEM SAP table for – Bill Scheduling: Scheduling Document

Here we would like to draw your attention to VVSCITEM 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). VVSCITEM is a SAP standard transp table used for storing Bill Scheduling: Scheduling Document related data in SAP. It comes under the package VVSC.

SAP VVSCITEM table

Table VVSCITEM technical data

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

SAP VVSCITEM 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 VVSCITEM 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
  • SCITEM : Number of a scheduling document
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • BLTYP : Payment Plan Document 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
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • OPUPK : Item number in contract account document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPUPW : Repetition Item in Contract Account Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • OPUPZ : Subitem for a Partial Clearing in Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SUBITEM_TYPE : Payment Plan: Payment Plan Subitem Type
    Its data type is CHAR (Character String) with field length 1
  • GPART_SUCC : Successor Business Partner
    Its data type is CHAR (Character String) with field length 10
  • AMTDUE : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AMTDUE_ORG : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AMTDUE_TIME : Payment Plan Subitem: Event for Due Date
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • BETR_DELTA : Payment Plan Subitem from Immediately Due Amount Change
    Its data type is CHAR (Character String) with field length 1
  • STUDT : Deferral to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FRPER : Period Start for Payment Plan Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TOPER : To Date For Payment Plan Doc
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RBTDUE : Due Date for Cash Discount
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AMOUNT : 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
  • CINEED : Info Identifier when Clearing Items
    Its data type is CHAR (Character String) with field length 1
  • LITEM : Last prepared payment plan document
    Its data type is CHAR (Character String) with field length 1
  • XCHARGE : Charge Document
    Its data type is CHAR (Character String) with field length 1
  • PKEY : Payment Plan Key
    Its data type is CHAR (Character String) with field length 2
  • XFIRST : First item
    Its data type is CHAR (Character String) with field length 1
  • XFFIRST : Indicator for First Item of a Renewed Scheduling Item
    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
  • 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
  • HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • CHKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • XREVE : Document must be reversed
    Its data type is CHAR (Character String) with field length 1
  • REVBL : Reversal Document Number
    Its data type is CHAR (Character String) with field length 12
  • MG1BL : Doc no. for charge 1
    Its data type is CHAR (Character String) with field length 12
  • XLOCK : Indicator: Item with Document Lock
    Its data type is CHAR (Character String) with field length 1
  • XALOCK : Transfer after lock
    Its data type is CHAR (Character String) with field length 1
  • XBLAST : Indicator for Last Item of a Scheduling Item
    Its data type is CHAR (Character String) with field length 1
  • XLAST : Indicator for Very Last Item of a Scheduling Item
    Its data type is CHAR (Character String) with field length 1
  • CHGID : Charges Schedule
    Its data type is CHAR (Character String) with field length 2
  • STAKZ : Type of statistical item
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    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
  • ROPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • ROPUPW : Repetition Item in Contract Account Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • ROPUPK : Item number in contract account document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ROPUPZ : Subitem for a Partial Clearing in Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • XVORZB : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • STORNGFREVBL : Reversal Document Number
    Its data type is CHAR (Character String) with field length 12
  • STORNZPREVBL : Reversal Document Number
    Its data type is CHAR (Character String) with field length 12
  • STORNPPREVBL : Reversal Document Number
    Its data type is CHAR (Character String) with field length 12
  • 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
  • FDLEV : Planning level
    Its data type is CHAR (Character String) with field length 2
  • FDWBT : Planned Amount in Document or G/L Account Currency
    Its data type is CURR (Currency Field) with field length 13
  • FDDATE : Date Used to Convert for Cash Management and Forecast
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDS : Due Date for Cash Discount
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GRKEY : Grouping Key for Displaying Open Items
    Its data type is CHAR (Character String) with field length 3
  • XMARK : Item selected
    Its data type is CHAR (Character String) with field length 1
  • GSFNR : Business Transaction Number
    Its data type is CHAR (Character String) with field length 16
  • VTRE3 : Target Insurance Object for Cross-Company Code Postings
    Its data type is CHAR (Character String) with field length 20
  • VGPART3 : Target Business Partner for Cross-Company Code Posting
    Its data type is CHAR (Character String) with field length 10
  • VGPART3_SUCC : VGPART3 Successor
    Its data type is CHAR (Character String) with field length 10
  • LAUFD : Date ID
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI : Additional Identification Characteristic
    Its data type is CHAR (Character String) with field length 6
  • AMTCHANG : Payment Plan Subitem Contains Share from Amount Change
    Its data type is CHAR (Character String) with field length 1
  • WWERT : Translation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VGPART2_SUCC : VGPART2 Successor
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes