SAP VVSCITEM Bill Scheduling: Scheduling Document Table

Overview

VVSCITEM is a standard SAP S/4HANA table that stores Bill Scheduling: Scheduling Document data. There are total 75 fields in the VVSCITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VVSCITEM belongs to Collections/Disbursements (FS-CD) module and is located in the package Payment Plan: Repository (FSCDPP_REP).

In addition, following links provide an overview of foreign key relationships, if any, that link VVSCITEM to other SAP tables and standard CDS views available based on VVSCITEM table in S/4HANA 2020.

Techincal Settings of VVSCITEM

Below are technical details of the table VVSCITEM

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VVSCITEM Fields

The following table gives you an overview of the fields available in VVSCITEM

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
GPARTBusiness Partner NumberGPART_KKCHAR10
VTREFReference Specifications from ContractVTREF_KKCHAR20
POSNRItem IDSCCOUNT_SCCHAR12
SCPOSNRTime Stamp (Date and Time)TIMST_VKCHAR14
SCITEMNumber of a scheduling documentSCITEM_SCCHAR12
BLTYPPayment Plan Document CategoryBLTP2_SCCHAR2
STATPOSTPost Payment Plan Item w/o Posting Stat.?STATPOST_SCCHAR1
OPBELNumber of a FI-CA DocumentOPBEL_KKCHAR12
OPUPKItem Number in FI-CA DocumentOPUPK_KKNUMC4
OPUPWRepetition Item in FI-CA DocumentOPUPW_KKNUMC3
OPUPZSubitem for a Partial Clearing in DocumentOPUPZ_KKNUMC3
SUBITEM_TYPEPayment Plan: Payment Plan Subitem TypeSUBITEM_TYPE_SCCHAR1
GPART_SUCCSuccessor Business PartnerGPART_SUCC_SCCHAR10
AMTDUEDue date for net paymentFAEDN_KKDATS8
AMTDUE_ORGDue date for net paymentFAEDN_KKDATS8
AMTDUE_TIMEPayment Plan Subitem: Event for Due DateAMTDUE_TIME_SCTIMS6
BETR_DELTAPayment Plan Subitem from Immediately Due Amount ChangeBETR_DELTA_SCCHAR1
STUDTDeferral toSTUDT_KKDATS8
FRPERPeriod Start for Payment Plan DocumentFRPER_SCDATS8
TOPERTo Date For Payment Plan DocTOPER_SCDATS8
RBTDUEDue Date for Cash DiscountFAEDS_KKDATS8
AMOUNTAmount in Transaction Currency with +/- SignBETRW_KKCURR13
CURRCurrency KeyWAERSCUKY5
CINEEDInfo Identifier when Clearing ItemsCINEED_SCCHAR1
LITEMLast prepared payment plan documentLITEM_SCCHAR1
XCHARGECharge DocumentXCHARGE_SCCHAR1
PKEYPayment Plan KeyPKEY_VKCHAR2
XFIRSTFirst itemXFIRST_SCCHAR1
XFFIRSTIndicator for First Item of a Renewed Scheduling ItemXFFIRST_SCCHAR1
PSNGLIndicator: One-Time PaymentPSNGL_SCCHAR1
HVORGMain Transaction for Line ItemHVORG_KKCHAR4
TVORGSubtransaction for Document ItemTVORG_KKCHAR4
OPHVORGMain Transaction for Line ItemHVORG_KKCHAR4
OPTVORGSubtransaction for Document ItemTVORG_KKCHAR4
HKONTGeneral ledger accountHKONT_KKCHAR10
CHKONTGeneral ledger accountHKONT_KKCHAR10
XREVEDocument must be reversedXREVE_SCCHAR1
REVBLReversal Document NumberREVBL_SCCHAR12
MG1BLDoc no. for charge 1MG1BL_KKCHAR12
XLOCKIndicator: Item with Document LockXLOCK_SCCHAR1
XALOCKTransfer after lockXALOCK_SCCHAR1
XBLASTIndicator for Last Item of a Scheduling ItemXBLAST_SCCHAR1
XLASTIndicator for Very Last Item of a Scheduling ItemXLAST_SCCHAR1
CHGIDCharges ScheduleCHGID_KKCHAR2
STAKZType of statistical itemSTAKZ_KKCHAR1
BUDATPosting Date in the DocumentBUDATDATS8
SKTPZCash Discount Percentage RateSKTPZ_KKDEC5
ROPBELNumber of a FI-CA DocumentOPBEL_KKCHAR12
ROPUPWRepetition Item in FI-CA DocumentOPUPW_KKNUMC3
ROPUPKItem Number in FI-CA DocumentOPUPK_KKNUMC4
ROPUPZSubitem for a Partial Clearing in DocumentOPUPZ_KKNUMC3
XVORZBSingle-Character FlagCHAR1CHAR1
STORNGFREVBLReversal Document NumberREVBL_SCCHAR12
STORNZPREVBLReversal Document NumberREVBL_SCCHAR12
STORNPPREVBLReversal Document NumberREVBL_SCCHAR12
FDGRPPlanning GroupFDGRP_KKCHAR10
FDZTGAdditional Days for Cash ManagementFDZTG_KKNUMC2
FDLEVPlanning levelFDLEV_KKCHAR2
FDWBTPlanned Amount in Document or G/L Account CurrencyFDWBT_KKCURR13
FDDATEDate Used to Convert for Cash Management and ForecastFDDATE_SCDATS8
FAEDSDue Date for Cash DiscountFAEDS_KKDATS8
GRKEYGrouping Key for Displaying Open ItemsGRKEY_KKCHAR3
XMARKItem selectedXMARK_KKCHAR1
GSFNRBusiness Transaction NumberGSFNR_VKCHAR16
VTRE3Target Insurance Object for Cross-Company Code PostingsVTRE3_SCCHAR20
VGPART3Target Business Partner for Cross-Company Code PostingVGPART3_SCCHAR10
VGPART3_SUCCVGPART3 SuccessorVGPART3_SUCC_SCCHAR10
LAUFDDate IDLAUFD_KKDATS8
LAUFIRun IDLAUFI_KKCHAR6
AMTCHANGPayment Plan Subitem Contains Share from Amount ChangeAMTCHANG_KKCHAR1
WWERTTranslation dateWWERT_DDATS8
VGPART2_SUCCVGPART2 SuccessorVGPART2_SUCC_SCCHAR10
BETRHAmount In Local Currency With +/- SignsBETRH_KKCURR13
KURSFExchange rateKURSF_KKDEC9

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VVSCITEM

Other References