SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7BSEG345Accounting Document Segment
8/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Cross-Application Components :: General Application Functions :: Data Retention Tool
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TXW_S_BSEG1241Retrieve BSEG from archiveData Retention Tool
SQL:  selectupdate insert create

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

SELECT TXW_MANDT, TXW_BUKRS, TXW_BELNR, TXW_GJAHR, TXW_BUZEI, TXW_XNEGP, MANDT, BUKRS, BELNR, GJAHR, MONAT, BUZEI, BSCHL, KOART, UMSKZ, HKONT, GSBER, VBUND, SHKZG, WRBTR, DMBTR, DMBE2, DMBE3, WSKTO, SKNTO, SKNT2, SKNT3, ZUONR, LIFNR, KUNNR, TXJCD, MEINS, MENGE, KOKRS, PROJK, WBS_POSID, AUFNR, KOSTL, PRCTR, WERKS, MATNR, VBELN, VBEL2, POSN2, EBELN, EBELP, ABPER, ANBWA, ANLN1, ANLN2, AUGBL, AUGDT, BEWAR, FILKD, FKBER, MWSKZ, FWBAS, HWBAS, WMWST, GBETR, LANDL, REBZT, REBZJ, REBZG, REBZZ, NEBTR, NPLNR, PSWSL, PSWBT, PARGB, PROJN, QSSKZ, QSFBT, QSSHB, QBSHB, SAKNR, SGTXT, VALUT, TXGRP, HBKID, MWSTS, MWST2, MWST3, RSTGR, UZAWE, ZBD3T, ZFBDT, ZTERM, TXBFW, TXBHW, TXBH2, TXBH3, KKBER, STCEG, EGBLD, EGLLD, XEGDR, FKBER_LONG, VERTT, VERTN, VBEWA, IMKEY, INTRENO, DABRZ, BSTAT, LEDGER, MWART, XBILK, GVTYP, NAVHW, KSTRG, ALTKT, LOKKT, ZLSCH, BUZID, AUGCP, ACC_NUM, NAME1, NAME2, GACC_NUM, TXT20, TXT50, GJAHR_CALC, MONAT_CALC FROM TXW_S_BSEG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1TXW_MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TXW_BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
3TXW_BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
4TXW_GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
5TXW_BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
6TXW_XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
7MANDTClientnvarchar30CLNT(N'000')Yes*MANDT Allow NULL? 
8BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
9BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
10GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
11MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
12BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
13BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
14KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
15UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
16HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
17GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
18VBUNDTrading Partnernvarchar60CHAR(N' ')Yes*TXW_VBUND Allow NULL? 
19SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
20WRBTRAmount in document currency (TC)nvarchar160CHAR(N' ')YesTXW_WRBTR Allow NULL? 
21DMBTRAmount in Local Currencynvarchar160CHAR(N' ')YesTXW_DMBTR Allow NULL? 
22DMBE2Amount in second local currency (LC2)nvarchar160CHAR(N' ')YesTXW_DMBE2 Allow NULL? 
23DMBE3Amount in third local currency (LC3)nvarchar160CHAR(N' ')YesTXW_DMBE3 Allow NULL? 
24WSKTOCash discount amount in document currencynvarchar160CHAR(N' ')YesTXW_WSKTO Allow NULL? 
25SKNTOCash discount amount in local currencynvarchar160CHAR(N' ')YesTXW_SKNTO Allow NULL? 
26SKNT2Cash discount amount in second local currency (LC2)nvarchar160CHAR(N' ')YesTXW_SKNT2 Allow NULL? 
27SKNT3Cash discount amount in third local currency (LC3)nvarchar160CHAR(N' ')YesTXW_SKNT3 Allow NULL? 
28ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
29LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
30KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
31TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
32MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
33MENGETotal quantitynvarchar160CHAR(N' ')YesTXW_QUANT Allow NULL? 
34KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
35PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
36WBS_POSIDWork Breakdown Structure Element (WBS Element)nvarchar240CHAR(N' ')YesPS_POSID Allow NULL? 
37AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
38KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
39PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
40WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
41MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
42VBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
43VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
44POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
45EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
46EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
47ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
48ANBWAAsset Transaction Typenvarchar30CHAR(N' ')Yes*ANBWA Allow NULL? 
49ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
50ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
51AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
52AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
53BEWARConsolidation Transaction Typenvarchar30CHAR(N' ')Yes*BEWAR Allow NULL? 
54FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
55FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
56MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
57FWBASTax base amount in document currency (TC)nvarchar160CHAR(N' ')YesTXW_FWBAS Allow NULL? 
58HWBASTax base amount in local currencynvarchar160CHAR(N' ')YesTXW_HWBAS Allow NULL? 
59WMWSTTax amount in document currency (TC)nvarchar160CHAR(N' ')YesTXW_WMWST Allow NULL? 
60GBETRHedged amount in foreign currencynvarchar160CHAR(N' ')YesTXW_GBETR Allow NULL? 
61LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
62REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
63REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
64REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
65REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
66NEBTRNet payment amountnvarchar160CHAR(N' ')YesTXW_NEBTR Allow NULL? 
67NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
68PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')Yes*PSWSL Allow NULL? 
69PSWBTAmount for updating in general ledger (position currency PC)nvarchar160CHAR(N' ')YesTXW_PSWBT Allow NULL? 
70PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
71PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
72QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
73QSFBTWithholding tax-exempt amount (in document currency)nvarchar160CHAR(N' ')YesTXW_QSFBT Allow NULL? 
74QSSHBWithholding tax base amountnvarchar160CHAR(N' ')YesTXW_QSSHB Allow NULL? 
75QBSHBWithholding tax amount (in document currency)nvarchar160CHAR(N' ')YesTXW_QBSHB Allow NULL? 
76SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
77SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
78VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
79TXGRPGroup Indicator for Tax Line Itemsnvarchar30NUMC(N'000')YesTXGRP Allow NULL? 
80HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
81MWSTSTax amount in local currencynvarchar160CHAR(N' ')YesTXW_MWSTS Allow NULL? 
82MWST2Tax amount in second local currencynvarchar160CHAR(N' ')YesTXW_MWST2 Allow NULL? 
83MWST3Tax amount in third local currencynvarchar160CHAR(N' ')YesTXW_MWST3 Allow NULL? 
84RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
85UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
86ZBD3TNet payment terms periodnvarchar30CHAR(N' ')YesTXW_DZBD3T Allow NULL? 
87ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
88ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
89TXBFWOriginal tax base amount in document currencynvarchar160CHAR(N' ')YesTXW_TXBFW Allow NULL? 
90TXBHWOriginal tax base amount in local currencynvarchar160CHAR(N' ')YesTXW_TXBHW Allow NULL? 
91TXBH2Tax base/original tax base in second local currencynvarchar160CHAR(N' ')YesTXW_TXBH2 Allow NULL? 
92TXBH3Tax base/original tax base in third local currencynvarchar160CHAR(N' ')YesTXW_TXBH3 Allow NULL? 
93KKBERCredit control areanvarchar40CHAR(N' ')Yes*KKBER Allow NULL? 
94STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
95EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGBLD Allow NULL? 
96EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGLLD Allow NULL? 
97XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
98FKBER_LONGFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
99VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
100VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
101VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
102IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
103INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
104DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
105BSTATDocument Statuschar10CHAR(N' ')YesBSTAT_D Allow NULL? 
106LEDGERLedger in General Ledger Accountingnvarchar20CHAR(N' ')Yes*FAGL_RLDNR Allow NULL? 
107MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
108XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
109GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
110NAVHWNon-Deductible Input Tax (in Local Currency)nvarchar160CHAR(N' ')YesTXW_NAVHW Allow NULL? 
111KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
112ALTKTGroup account numbernvarchar100CHAR(N' ')Yes*BILKT_SKA1 Allow NULL? 
113LOKKTAlternative account number in company codenvarchar100CHAR(N' ')Yes*ALTKT_SKB1 Allow NULL? 
114ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
115BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
116AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
117ACC_NUMAccount number of Customer or Vendornvarchar100CHAR(N' ')YesTXW_ACC_NUM Allow NULL? 
118NAME1Name 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
119NAME2Name 2nvarchar350CHAR(N' ')YesNAME2_GP Allow NULL? 
120GACC_NUMGroup ledger or group account numbernvarchar100CHAR(N' ')YesTXW_GACC_NUM Allow NULL? 
121TXT20Account short textnvarchar200CHAR(N' ')YesTXW_TXT20 Allow NULL? 
122TXT50Textnvarchar500CHAR(N' ')YesTXW_TXT50 Allow NULL? 
123GJAHR_CALCFiscal Year (calculated, GL view)nvarchar40NUMC(N'0000')YesTXW_GJAHR_CALC Allow NULL? 
124MONAT_CALCFiscal Period (calculated, GL view)nvarchar20NUMC(N'00')YesTXW_MONAT_CALC Allow NULL? 
NamePrimaryUniqueTypeColumns
TXW_S_BSEG~0YesYesCLUSTEREDTXW_MANDT, TXW_BUKRS, TXW_BELNR, TXW_GJAHR, TXW_BUZEI