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
Financial Accounting :: Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_3RFTAX_EXTRD1381Tax Extract Detail LinesLocalization
SQL:  selectupdate insert create

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

SELECT MANDT, EXTRT, BUKRS1, BELNR1, GJAHR1, BUZEI1, ACTIV, ANLN1, ANLN2, AUFNR, AUGBL, AUGDT, BELNR, BLART, BLDAT, BSCHL, BSTAT, BUDAT, BUKRS, BUZEI, BWWRT, BWWR2, BWWR3, DMSHB, HWAER, DMBE2, HWAE2, DMBE3, HWAE3, EBELN, EBELP, ETEN2, FAEDT, FILKD, GJAHR, GSBER, JAMON, KOART, KONTO, KOSTL, MABER, MADAT, MANSP, MANST, MONAT, MSCHL, MWSKZ, POSN2, PRCTR, QBSHB, QSFBT, QSSHB, REBZG, SAMNR, SGTXT, SHKZG, SKFBT, SKNTO, STAKZ, UMSKS, UMSKZ, UZAWE, VALUT, VBEL2, VBELN, VBEWA, VBUND, VERTN, VERTT, VERZ1, VERZN, WERKS, WRSHB, WAERS, WSKTO, WVERW, XBLNR, XSTRP, XZAHL, ZALDT, ZBD1P, ZBD1T, ZBD2P, ZBD2T, ZBD3T, ZFBDT, ZINSZ, ZLSCH, ZLSPR, ZTERM, ZUONR, XREF1, XREF2, XARCH, RSTGR, ASKTO, KURSE, REBZT, PSWSL, PSWBT, HKONT, XNEGP, ZBFIX, RFZEI, CCBTC, KKBER, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, ABSBT, KKBWR, PROJK, XPYPR, KIDNO, XAUGP, BUPLA, SECCO, GKART, GKONT, PYCUR, PYAMT, PYORD, XTEXT, TDID, XDUEN, XDUE1, XRAGL, XSELP, CESSION_KZ, BUZID, AUGGJ, AGZEI, VNAME, EGRUP, BTYPE, VORGN FROM J_3RFTAX_EXTRD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EXTRTExtract namenvarchar120CHAR(N' ')NoJ_3RFTAX_EXTRHJ_3RF_TAX_EXTRACT Allow NULL? 
3BUKRS1Company Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
4BELNR1Accounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
5GJAHR1Fiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
6BUZEI1Number of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
7ACTIVList Level in which the Line Item is Activenvarchar20NUMC(N'00')YesACTIV Allow NULL? 
8ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
9ANLN2New asset subnumber, 4 charactersnvarchar40CHAR(N' ')YesANLN2_4 Allow NULL? 
10AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
11AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
12AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
13BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
14BLARTDocument Typenvarchar20CHAR(N' ')YesT003BLART Allow NULL? 
15BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
16BSCHLPosting Keynvarchar20CHAR(N' ')YesTBSLBSCHL Allow NULL? 
17BSTATDocument Statuschar10CHAR(N' ')YesBSTAT_D Allow NULL? 
18BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
19BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
20BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
21BWWRTAmount Valuated in Local Currencydecimal132CURR((0))YesBWWRT
22BWWR2Amount Valuated in Local Currency 2decimal132CURR((0))YesBWWR2
23BWWR3Amount Valuated in Local Currency 3decimal132CURR((0))YesBWWR3
24DMSHBAmount in Local Currency with +/- Signsdecimal132CURR((0))YesDMSHB
25HWAERLocal Currencynvarchar50CUKY(N' ')YesTCURCHWAER Allow NULL? 
26DMBE2Amount in Second Local Currency with +/- Signdecimal132CURR((0))YesDMBE2_VZ
27HWAE2Currency Key of Second Local Currencynvarchar50CUKY(N' ')Yes*HWAE2 Allow NULL? 
28DMBE3Amount in Third Local Currency with +/- Signdecimal132CURR((0))YesDMBE3_VZ
29HWAE3Currency Key of Third Local Currencynvarchar50CUKY(N' ')Yes*HWAE3 Allow NULL? 
30EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
31EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
32ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
33FAEDTNet Due Datenvarchar80DATS(N'00000000')YesFAEDT_FPOS Allow NULL? 
34FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
35GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
36GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
37JAMONFiscal Year/Posting Period from Posting Datenvarchar70CHAR(N' ')YesJAMON_XPO Allow NULL? 
38KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
39KONTOAccount Numbernvarchar100CHAR(N' ')YesKTONR_AV Allow NULL? 
40KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
41MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
42MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
43MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
44MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
45MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
46MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
47MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
48POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
49PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
50QBSHBWithholding Tax Amount (in Doc. Currency) with +/- Signdecimal132CURR((0))YesQBSHB_VZ
51QSFBTAmount Free of Withhld.Tax (in Doc.Curr.) with +/- Signdecimal132CURR((0))YesQSFBT_VZ
52QSSHBWithholding Tax Base Amount with +/- Signdecimal132CURR((0))YesQSSHB_VZ
53REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
54SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
55SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
56SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
57SKFBTAmount Subject to Discount in Document Curr. with +/- Signdecimal132CURR((0))YesSKFBT_VZ
58SKNTOCash Discount Amount (+/-) in Local Currencydecimal132CURR((0))YesSKNTO_VZ
59STAKZIndicator: Statistical document ?char10CHAR(N' ')YesXSTKZ Allow NULL? 
60UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
61UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
62UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
63VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
64VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
65VBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
66VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
67VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
68VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
69VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
70VERZ1Days in Arrears for Cash Discount Terms 1decimal50DEC((0))YesVERZ1
71VERZNDays in Arrears by Net Due Datedecimal50DEC((0))YesVERZN
72WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
73WRSHBForeign Currency Amount with Signs (+/-)decimal132CURR((0))YesWRSHB
74WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
75WSKTOCash discount amount in document currency with +/- signdecimal132CURR((0))YesWSKTO_VZ
76WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
77XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
78XSTRPIndicator: Disputed item?char10CHAR(N' ')YesXSTRP Allow NULL? 
79XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
80ZALDTProbable Payment Date (Cash Discount 1 Due)nvarchar80DATS(N'00000000')YesDZALDT Allow NULL? 
81ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
82ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
83ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
84ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
85ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
86ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
87ZINSZInterest Calculation Numerator (Days in Arrears * Amount)decimal152CURR((0))YesDZINSZ
88ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZDZLSCH Allow NULL? 
89ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
90ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
91ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
92XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
93XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
94XARCHIndicator: Document already archived ?char10CHAR(N' ')YesXARCH Allow NULL? 
95RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
96ASKTOCurrent Cash Disc. Amount in Document Currency with +/- Signdecimal132CURR((0))YesASKTO_VZ
97KURSEEffective Exchange Rate in the Line Itemdecimal95DEC((0))YesKURSE
98REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
99PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')YesTCURCPSWSL Allow NULL? 
100PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
101HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
102XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
103ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
104RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
105CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
106KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
107XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
108DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
109DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
110DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
111DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
112ABSBTCredit management: Hedged amountdecimal132CURR((0))YesABSBT
113KKBWRCurrency of Credit Control Areanvarchar50CUKY(N' ')Yes*KKBWR Allow NULL? 
114PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240CHAR(N' ')YesPROJK_EXT Allow NULL? 
115XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
116KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
117XAUGPIndicator: Item has been cleared?char10CHAR(N' ')YesXAUGP Allow NULL? 
118BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
119SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
120GKARTOffsetting Account Typechar10CHAR(N' ')YesGKART Allow NULL? 
121GKONTOffsetting Account Numbernvarchar100CHAR(N' ')YesGKONT Allow NULL? 
122PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')Yes*PYCUR Allow NULL? 
123PYAMTAmount in Payment Currencydecimal132CURR((0))YesPYAMT
124PYORDPayment Ordernvarchar100CHAR(N' ')YesPYORD Allow NULL? 
125XTEXTIndicator: Texts exist ?char10CHAR(N' ')YesXTEXT_F02L Allow NULL? 
126TDIDText IDnvarchar40CHAR(N' ')Yes*TDID Allow NULL? 
127XDUENIndicator: Item is due net?char10CHAR(N' ')YesXDUEN Allow NULL? 
128XDUE1Indicator: Cash discount term 1 is due on item?char10CHAR(N' ')YesXDUE1 Allow NULL? 
129XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
130XSELPItem selected (selected, chosen, ...)char10CHAR(N' ')YesXSELP Allow NULL? 
131CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')Yes*CESSION_KZ Allow NULL? 
132BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
133AUGGJFiscal Year of Clearing Documentnvarchar40NUMC(N'0000')YesAUGGJ Allow NULL? 
134AGZEIClearing Itemdecimal50DEC((0))YesAGZEI
135VNAMEJoint Venturenvarchar60CHAR(N' ')YesT8JVJV_NAME Allow NULL? 
136EGRUPEquity groupnvarchar30CHAR(N' ')YesT8JFJV_EGROUP Allow NULL? 
137BTYPEPayroll Typenvarchar20CHAR(N' ')YesT8JAJV_BILIND Allow NULL? 
138VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
NamePrimaryUniqueTypeColumns
J_3RFTAX_EXTRD~0YesYesCLUSTEREDBUZEI1, GJAHR1, BELNR1, BUKRS1, EXTRT, MANDT