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
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0BBSID1563Accounting: Secondary index for customersCross-Application Components
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, KUNNR, UMSKS, UMSKZ, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI, BUDAT, BLDAT, CPUDT, WAERS, XBLNR, BLART, MONAT, BSCHL, ZUMSK, SHKZG, GSBER, MWSKZ, DMBTR, WRBTR, MWSTS, WMWST, BDIFF, BDIF2, SGTXT, PROJN, AUFNR, ANLN1, ANLN2, SAKNR, HKONT, FKONT, FILKD, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, REBZG, REBZJ, REBZZ, SAMNR, ANFBN, ANFBJ, ANFBU, ANFAE, MANSP, MSCHL, MADAT, MANST, MABER, XNETB, XANET, XCPDD, XINVE, XZAHL, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, BSTAT, VBUND, VBELN, REBZT, INFAE, STCEG, EGBLD, EGLLD, RSTGR, XNOZA, VERTT, VERTN, VBEWA, WVERW, PROJK, FIPOS, NPLNR, AUFPL, APLZL, XEGDR, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, BDIF3, XRAGL, UZAWE, XSTOV, MWST2, MWST3, SKNT2, SKNT3, XREF1, XREF2, XARCH, PSWSL, PSWBT, LZBKZ, LANDL, IMKEY, VBEL2, VPOS2, POSN2, ETEN2, FISTL, GEBER, DABRZ, XNEGP, KOSTL, RFZEI, KKBER, EMPFB, PRCTR, XREF3, QSSKZ, ZINKZ, DTWS1, DTWS2, DTWS3, DTWS4, XPYPR, KIDNO, ABSBT, CCBTC, PYCUR, PYAMT, BUPLA, SECCO, CESSION_KZ, PPDIFF, PPDIF2, PPDIF3 FROM BBSID
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoKNB1BUKRS Allow NULL? 
3KUNNRCustomer Numbernvarchar100CHAR(N' ')NoKNA1KUNNR Allow NULL? 
4UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')NoUMSKS Allow NULL? 
5UMSKZSpecial G/L Indicatorchar10CHAR(N' ')No*UMSKZ Allow NULL? 
6AUGDTClearing Datenvarchar80DATS(N'00000000')NoAUGDT Allow NULL? 
7AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')NoAUGBL Allow NULL? 
8ZUONRAssignment Numbernvarchar180CHAR(N' ')NoDZUONR Allow NULL? 
9GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
10BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
11BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
12BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
13BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
14CPUDTDay On Which Accounting Document Was Enterednvarchar80DATS(N'00000000')YesCPUDT Allow NULL? 
15WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
16XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR Allow NULL? 
17BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
18MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
19BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
20ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')Yes*DZUMSK Allow NULL? 
21SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
22GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
23MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
24DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
25WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
26MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
27WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
28BDIFFValuation Differencedecimal132CURR((0))YesBDIFF
29BDIF2Valuation Difference for the Second Local Currencydecimal132CURR((0))YesBDIF2
30SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
31PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
32AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
33ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
34ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
35SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
36HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
37FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
38FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
39ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
40ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
41ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
42ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
43ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
44ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
45ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
46SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
47SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
48WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
49ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
50ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
51ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
52HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
53BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
54REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
55REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
56REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
57SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
58ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100CHAR(N' ')YesANFBN Allow NULL? 
59ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40NUMC(N'0000')YesANFBJ Allow NULL? 
60ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40CHAR(N' ')Yes*ANFBU Allow NULL? 
61ANFAEBill of Exchange Payment Request Due Datenvarchar80DATS(N'00000000')YesANFAE Allow NULL? 
62MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
63MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
64MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
65MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
66MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
67XNETBIndicator: Document posted net ?char10CHAR(N' ')YesXNETB Allow NULL? 
68XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
69XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
70XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
71XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
72MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
73DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
74WRBT1Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
75MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
76DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
77WRBT2Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
78MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
79DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
80WRBT3Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
81BSTATDocument Statuschar10CHAR(N' ')YesBSTAT_D Allow NULL? 
82VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
83VBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
84REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
85INFAEInverted Date for Net Due Datenvarchar80CHAR(N' ')YesINFAE Allow NULL? 
86STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
87EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGBLD Allow NULL? 
88EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGLLD Allow NULL? 
89RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
90XNOZAIndicator: Account is not countedchar10CHAR(N' ')YesXNOZA Allow NULL? 
91VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
92VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
93VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
94WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
96FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
97NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
98AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
99APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
100XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
101DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
102DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
103DMB21Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
104DMB22Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
105DMB23Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
106DMB31Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
107DMB32Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
108DMB33Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
109BDIF3Valuation Difference for the Third Local Currencydecimal132CURR((0))YesBDIF3
110XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
111UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
112XSTOVIndicator: Document is flagged for reversalchar10CHAR(N' ')YesXSTOV Allow NULL? 
113MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
114MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
115SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
116SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
117XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
118XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
119XARCHIndicator: Document already archived ?char10CHAR(N' ')YesXARCH Allow NULL? 
120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')YesTCURCPSWSL Allow NULL? 
121PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
122LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
123LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
124IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
125VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
126VPOS2Numeric field: Length 6nvarchar60NUMC(N'000000')YesNUM06 Allow NULL? 
127POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
128ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
129FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
130GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
131DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
132XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
133KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
134RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
135KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
136EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
137PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
138XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
139QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
140ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
141DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
142DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
143DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
144DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
145XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
146KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
147ABSBTCredit management: Hedged amountdecimal132CURR((0))YesABSBT
148CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
149PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')Yes*PYCUR Allow NULL? 
150PYAMTAmount in Payment Currencydecimal132CURR((0))YesPYAMT
151BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
152SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
153CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')YesTCESSIONCESSION_KZ Allow NULL? 
154PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIFF
155PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)decimal132CURR((0))YesPPDIF2
156PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIF3
NamePrimaryUniqueTypeColumns
BBSID~0YesYesCLUSTEREDBUZEI, BELNR, GJAHR, ZUONR, AUGBL, AUGDT, UMSKZ, UMSKS, KUNNR, BUKRS, MANDT
BBSID~1NoYesNONCLUSTEREDBUZEI, BELNR, GJAHR, BUKRS, KUNNR, MANDT
BBSID~2NoNoNONCLUSTEREDKIDNO, MANDT