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  | VBSEGS
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VBSEGS1543Document Segment for Document Parking - G/L Account DatabaseFinancial Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, AUSBK, BELNR, GJAHR, BZKEY, BUKRS, BUZEI, BSCHL, SHKZG, GSBER, PARGB, MWSKZ, DMBTR, DMBE2, DMBE3, WRBTR, HWMET, HWBAS, FWBAS, MWART, KURSR, GBETR, ZFBDT, VALUT, ZUONR, SGTXT, ANBWA, ZINKZ, RMVCT, FDLEV, FDGRP, FDWBT, FDTAG, KOKRS, KOSTL, AUFNR, KDAUF, KDPOS, PPRCTR, IMKEY, PERNR, XUMSW, XSKRL, SAKNR, HZUON, LZBKZ, LANDL, MATNR, WERKS, MENGE, MEINS, BPMNG, EBELN, EBELP, REWRT, REWWR, ZEKKN, LFBNR, LFPOS, LFGJA, BWKEY, BWTAR, TBTKZ, STCEG, PRCTR, VNAME, RECID, EGRUP, VPTNR, VERTT, VERTN, VBEWA, TXJCD, DABRZ, KSTRG, NPLNR, AUFPL, PS_PSP_PNR, PAOBJNR, PASUBNR, BTYPE, ETYPE, XEGDR, HRKFT, FIPOS, KOART, VPRSV, PEINH, KDEIN, ANLN1, ANLN2, SMWSK, SWAER, STUNR, ZAEHK, XFDIS, KBLNR, KBLPOS, STTAX, GEBER, FISTL, VORNR, ABPER, EREKZ, FKBER, VBUND, XREF1, XREF2, XREF3, CCBTC, RSTGR, GRICD, GRIRG, GITYP, IDXSP, BUZID, ERLKZ, BUPLA, LSTAR, PSTYP, PRZNR, KONTT, KONTL, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, GRANT_NBR, BZDAT, XNEGP, SEGMENT, PSEGMENT, UZAWE, PGEBER, PGRANT_NBR, MEASURE, BUDGET_PD, PBUDGET_PD, FIPEX, PEROP_BEG, PEROP_END, FASTPAY, PPA_EX_IND, FMFGUS_KEY, PRODPER, CHWRB FROM VBSEGS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AUSBKSource Company Codenvarchar40CHAR(N' ')NoT001AUSBK Allow NULL? 
3BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
4GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoVBKPFGJAHR Allow NULL? 
5BZKEYNumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
6BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
7BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
8BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
9SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
10GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
11PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
12MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
13DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
14DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
15DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
16WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
17HWMETMethod with Which the Local Currency Amount Was Determinedchar10CHAR(N' ')YesHWMET Allow NULL? 
18HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
19FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
20MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
21KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
22GBETRHedged Amount in Foreign Currencydecimal132CURR((0))YesGBETR
23ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
24VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
25ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
26SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
27ANBWAAsset Transaction Typenvarchar30CHAR(N' ')Yes*ANBWA Allow NULL? 
28ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
29RMVCTTransaction Typenvarchar30CHAR(N' ')Yes*RMVCT Allow NULL? 
30FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
31FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP Allow NULL? 
32FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
33FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
34KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
35KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
36AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
37KDAUFSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
38KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
39PPRCTRPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
40IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
41PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
42XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
43XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
44SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
45HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
46LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
47LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
48MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
49WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
50MENGEQuantitydecimal133QUAN((0))YesMENGE_D
51MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
52BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG
53EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
54EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
55REWRTInvoice Value Entered (in Local Currency)decimal132CURR((0))YesREEWR
56REWWRInvoice value in foreign currencydecimal132CURR((0))YesREFWR
57ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
58LFBNRNumber of goods receipt documentnvarchar100CHAR(N' ')YesWEBLN Allow NULL? 
59LFPOSItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
60LFGJAMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
61BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
62BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
63TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
64STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
65PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
66VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
67RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
68EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
69VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
70VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
71VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
72VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
73TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
74DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
75KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
76NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
77AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
78PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
79PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
80PASUBNRProfitability segment changes (CO-PA)nvarchar40NUMC(N'0000')YesRKESUBNR Allow NULL? 
81BTYPEPayroll Typenvarchar20CHAR(N' ')Yes*JV_BILIND Allow NULL? 
82ETYPEEquity typenvarchar30CHAR(N' ')Yes*JV_ETYPE Allow NULL? 
83XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
84HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
85FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
86KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
87VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
88PEINHPrice Unitdecimal50DEC((0))YesPEINH
89KDEINDelivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
90ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
91ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
92SMWSKTax Category in Account Master Recordnvarchar20CHAR(N' ')YesSMWSK Allow NULL? 
93SWAERCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
94STUNRStep numbernvarchar30NUMC(N'000')Yes*STUNR Allow NULL? 
95ZAEHKCondition counternvarchar20NUMC(N'00')YesDZAEHK Allow NULL? 
96XFDISIndicator: Cash Management activated?char10CHAR(N' ')YesXFDIS Allow NULL? 
97KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')YesKBLKKBLNR_FI Allow NULL? 
98KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')YesKBLPKBLPOS Allow NULL? 
99STTAXTax amount as statistical information in document currencydecimal132CURR((0))YesSTTAX
100GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
101FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
102VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
103ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
104EREKZFinal Invoice Indicatorchar10CHAR(N' ')YesEREKZ Allow NULL? 
105FKBERFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
106VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
107XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
108XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
109XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
110CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
111RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')YesT053RRSTGR Allow NULL? 
112GRICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')YesJ_1AGICDJ_1AGICD_D Allow NULL? 
113GRIRGRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
114GITYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')YesJ_1ADTYPJ_1ADTYP_D Allow NULL? 
115IDXSPInflation Indexnvarchar50CHAR(N' ')YesJ_1AINFT20J_1AINDXSP Allow NULL? 
116BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
117ERLKZCompletion indicator for line itemchar10CHAR(N' ')YesKBLERLKZ Allow NULL? 
118BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
119LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
120PSTYPItem Category in Purchasing Documentchar10CHAR(N' ')Yes*PSTYP Allow NULL? 
121PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
122KONTTAccount Assignment Category for Industry Solutionnvarchar20CHAR(N' ')YesKONTT_FI Allow NULL? 
123KONTLAcct assignment string for industry-specific acct assignmntsnvarchar500CHAR(N' ')YesKONTL_FI Allow NULL? 
124ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
125ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
126ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
127ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
128ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
129ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
130ZZNFALnvarchar100(N' ')Yes Allow NULL? 
131ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
132ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
133ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
134ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
135ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
136GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
137BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
138XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
139SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
140PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_PSEGMENT Allow NULL? 
141UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
142PGEBERPartner Fundnvarchar100CHAR(N' ')Yes*FM_PFUND Allow NULL? 
143PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
144MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
145BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
146PBUDGET_PDFM: Partner Budget Periodnvarchar100CHAR(N' ')Yes*FM_PBUDGET_PERIOD Allow NULL? 
147FIPEXCommitment item - Do not use field - see note 447805nvarchar240CHAR(N' ')Yes*FM_FIPEX_DONT_USE Allow NULL? 
148PEROP_BEGBilling Period of Performance Start Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_LOW Allow NULL? 
149PEROP_ENDBilling Period of Performance End Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_HIGH Allow NULL? 
150FASTPAYPPA Fast Pay Indicatorchar10CHAR(N' ')YesFMFG_FASTPAY_FLG Allow NULL? 
151PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
152FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
153PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
154CHWRBDocument Parking: Amount not Modifiablechar10CHAR(N' ')YesCHWRB Allow NULL? 
NamePrimaryUniqueTypeColumns
VBSEGS~0YesYesCLUSTEREDMANDT, AUSBK, BELNR, GJAHR, BZKEY
VBSEGS~001NoNoNONCLUSTEREDMANDT, SAKNR, AUSBK
VBSEGS~002NoNoNONCLUSTEREDMANDT, SAKNR, BUKRS

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