SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | VVSCITEM
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Services :: CollectionsDisbursements
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VVSCITEM732Bill Scheduling: Scheduling DocumentCollectionsDisbursements
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, GPART, VTREF, POSNR, SCPOSNR, SCITEM, BLTYP, STATPOST, OPBEL, OPUPK, OPUPW, OPUPZ, SUBITEM_TYPE, GPART_SUCC, AMTDUE, AMTDUE_ORG, AMTDUE_TIME, BETR_DELTA, STUDT, FRPER, TOPER, RBTDUE, AMOUNT, CURR, CINEED, LITEM, XCHARGE, PKEY, XFIRST, XFFIRST, PSNGL, HVORG, TVORG, OPHVORG, OPTVORG, HKONT, CHKONT, XREVE, REVBL, MG1BL, XLOCK, XALOCK, XBLAST, XLAST, CHGID, STAKZ, BUDAT, SKTPZ, ROPBEL, ROPUPW, ROPUPK, ROPUPZ, XVORZB, STORNGFREVBL, STORNZPREVBL, STORNPPREVBL, FDGRP, FDZTG, FDLEV, FDWBT, FDDATE, FAEDS, GRKEY, XMARK, GSFNR, VTRE3, VGPART3, VGPART3_SUCC, LAUFD, LAUFI, AMTCHANG, WWERT, VGPART2_SUCC FROM VVSCITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GPARTBusiness Partner Numbernvarchar100CHAR(N' ')No*GPART_KK Allow NULL? 
3VTREFReference Specifications from Contractnvarchar200CHAR(N' ')NoVTREF_KK Allow NULL? 
4POSNRItem IDnvarchar120CHAR(N' ')NoSCCOUNT_SC Allow NULL? 
5SCPOSNRTime Stamp (Date and Time)nvarchar140CHAR(N' ')NoTIMST_VK Allow NULL? 
6SCITEMNumber of a scheduling documentnvarchar120CHAR(N' ')NoSCITEM_SC Allow NULL? 
7BLTYPPayment Plan Document Categorynvarchar20CHAR(N' ')Yes*BLTP2_SC Allow NULL? 
8STATPOSTPost Payment Plan Item w/o Posting Stat.?char10CHAR(N' ')YesSTATPOST_SC Allow NULL? 
9OPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')Yes*OPBEL_KK Allow NULL? 
10OPUPKItem number in contract account documentnvarchar40NUMC(N'0000')YesOPUPK_KK Allow NULL? 
11OPUPWRepetition Item in Contract Account Documentnvarchar30NUMC(N'000')YesOPUPW_KK Allow NULL? 
12OPUPZSubitem for a Partial Clearing in Documentnvarchar30NUMC(N'000')YesOPUPZ_KK Allow NULL? 
13SUBITEM_TYPEPayment Plan: Payment Plan Subitem Typechar10CHAR(N' ')YesSUBITEM_TYPE_SC Allow NULL? 
14GPART_SUCCSuccessor Business Partnernvarchar100CHAR(N' ')Yes*GPART_SUCC_SC Allow NULL? 
15AMTDUEDue date for net paymentnvarchar80DATS(N'00000000')YesFAEDN_KK Allow NULL? 
16AMTDUE_ORGDue date for net paymentnvarchar80DATS(N'00000000')YesFAEDN_KK Allow NULL? 
17AMTDUE_TIMEPayment Plan Subitem: Event for Due Datenvarchar60TIMS(N'000000')YesAMTDUE_TIME_SC Allow NULL? 
18BETR_DELTAPayment Plan Subitem from Immediately Due Amount Changechar10CHAR(N' ')YesBETR_DELTA_SC Allow NULL? 
19STUDTDeferral tonvarchar80DATS(N'00000000')YesSTUDT_KK Allow NULL? 
20FRPERPeriod Start for Payment Plan Documentnvarchar80DATS(N'00000000')YesFRPER_SC Allow NULL? 
21TOPERTo Date For Payment Plan Docnvarchar80DATS(N'00000000')YesTOPER_SC Allow NULL? 
22RBTDUEDue Date for Cash Discountnvarchar80DATS(N'00000000')YesFAEDS_KK Allow NULL? 
23AMOUNTAmount in Transaction Currency with +/- Signdecimal132CURR((0))YesBETRW_KK
24CURRCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
25CINEEDInfo Identifier when Clearing Itemschar10CHAR(N' ')YesCINEED_SC Allow NULL? 
26LITEMLast prepared payment plan documentchar10CHAR(N' ')YesLITEM_SC Allow NULL? 
27XCHARGECharge Documentchar10CHAR(N' ')YesXCHARGE_SC Allow NULL? 
28PKEYPayment Plan Keynvarchar20CHAR(N' ')Yes*PKEY_VK Allow NULL? 
29XFIRSTFirst itemchar10CHAR(N' ')YesXFIRST_SC Allow NULL? 
30XFFIRSTIndicator for First Item of a Renewed Scheduling Itemchar10CHAR(N' ')YesXFFIRST_SC Allow NULL? 
31PSNGLIndicator: One-Time Paymentchar10CHAR(N' ')YesPSNGL_SC Allow NULL? 
32HVORGMain Transaction for Line Itemnvarchar40CHAR(N' ')Yes*HVORG_KK Allow NULL? 
33TVORGSubtransaction for Document Itemnvarchar40CHAR(N' ')Yes*TVORG_KK Allow NULL? 
34OPHVORGMain Transaction for Line Itemnvarchar40CHAR(N' ')Yes*HVORG_KK Allow NULL? 
35OPTVORGSubtransaction for Document Itemnvarchar40CHAR(N' ')Yes*TVORG_KK Allow NULL? 
36HKONTGeneral ledger accountnvarchar100CHAR(N' ')Yes*HKONT_KK Allow NULL? 
37CHKONTGeneral ledger accountnvarchar100CHAR(N' ')Yes*HKONT_KK Allow NULL? 
38XREVEDocument must be reversedchar10CHAR(N' ')YesXREVE_SC Allow NULL? 
39REVBLReversal Document Numbernvarchar120CHAR(N' ')YesREVBL_SC Allow NULL? 
40MG1BLDoc no. for charge 1nvarchar120CHAR(N' ')Yes*MG1BL_KK Allow NULL? 
41XLOCKIndicator: Item with Document Lockchar10CHAR(N' ')YesXLOCK_SC Allow NULL? 
42XALOCKTransfer after lockchar10CHAR(N' ')YesXALOCK_SC Allow NULL? 
43XBLASTIndicator for Last Item of a Scheduling Itemchar10CHAR(N' ')YesXBLAST_SC Allow NULL? 
44XLASTIndicator for Very Last Item of a Scheduling Itemchar10CHAR(N' ')YesXLAST_SC Allow NULL? 
45CHGIDCharges Schedulenvarchar20CHAR(N' ')Yes*CHGID_KK Allow NULL? 
46STAKZType of statistical itemchar10CHAR(N' ')YesSTAKZ_KK Allow NULL? 
47BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
48SKTPZCash discount ratedecimal53DEC((0))YesSKTPZ_KK
49ROPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')Yes*OPBEL_KK Allow NULL? 
50ROPUPWRepetition Item in Contract Account Documentnvarchar30NUMC(N'000')YesOPUPW_KK Allow NULL? 
51ROPUPKItem number in contract account documentnvarchar40NUMC(N'0000')YesOPUPK_KK Allow NULL? 
52ROPUPZSubitem for a Partial Clearing in Documentnvarchar30NUMC(N'000')YesOPUPZ_KK Allow NULL? 
53XVORZBSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
54STORNGFREVBLReversal Document Numbernvarchar120CHAR(N' ')YesREVBL_SC Allow NULL? 
55STORNZPREVBLReversal Document Numbernvarchar120CHAR(N' ')YesREVBL_SC Allow NULL? 
56STORNPPREVBLReversal Document Numbernvarchar120CHAR(N' ')YesREVBL_SC Allow NULL? 
57FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP_KK Allow NULL? 
58FDZTGAdditional Days for Cash Managementnvarchar20NUMC(N'00')YesFDZTG_KK Allow NULL? 
59FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV_KK Allow NULL? 
60FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
61FDDATEDate Used to Convert for Cash Management and Forecastnvarchar80DATS(N'00000000')YesFDDATE_SC Allow NULL? 
62FAEDSDue Date for Cash Discountnvarchar80DATS(N'00000000')YesFAEDS_KK Allow NULL? 
63GRKEYGrouping Key for Displaying Open Itemsnvarchar30CHAR(N' ')YesGRKEY_KK Allow NULL? 
64XMARKItem selectedchar10CHAR(N' ')YesXMARK_KK Allow NULL? 
65GSFNRBusiness Transaction Numbernvarchar160CHAR(N' ')YesGSFNR_VK Allow NULL? 
66VTRE3Target Insurance Object for Cross-Company Code Postingsnvarchar200CHAR(N' ')YesVTRE3_SC Allow NULL? 
67VGPART3Target Business Partner for Cross-Company Code Postingnvarchar100CHAR(N' ')Yes*VGPART3_SC Allow NULL? 
68VGPART3_SUCCVGPART3 Successornvarchar100CHAR(N' ')Yes*VGPART3_SUCC_SC Allow NULL? 
69LAUFDDate IDnvarchar80DATS(N'00000000')YesLAUFD_KK Allow NULL? 
70LAUFIAdditional Identification Characteristicnvarchar60CHAR(N' ')YesLAUFI_KK Allow NULL? 
71AMTCHANGPayment Plan Subitem Contains Share from Amount Changechar10CHAR(N' ')YesAMTCHANG_KK Allow NULL? 
72WWERTTranslation Datenvarchar80DATS(N'00000000')YesWWERT_D Allow NULL? 
73VGPART2_SUCCVGPART2 Successornvarchar100CHAR(N' ')Yes*VGPART2_SUCC_SC Allow NULL? 
NamePrimaryUniqueTypeColumns
VVSCITEM~0YesYesCLUSTEREDMANDT, GPART, VTREF, POSNR, SCPOSNR, SCITEM
VVSCITEM~001NoNoNONCLUSTEREDOPBEL, OPUPK, OPUPW, OPUPZ

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy