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.0RFITEMAP_NO_ITEM1471Item wise detail for the Vendor TransactionsLocalization
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, KONTO, GJAHR, SEQNO, UNAME, ACTIV, ANLN1, ANLN2, AUFNR, AUGBL, AUGDT, BELNR, BLART, BLDAT, BSCHL, BSTAT, BUDAT, BUZEI, BWWRT, BWWRC, BWWR2, BWWR3, DMSHB, HWAER, DMBE2, HWAE2, DMBE3, HWAE3, EBELN, EBELP, ETEN2, FAEDT, FILKD, GSBER, JAMON, KOART, KOSTL, MABER, MADAT, MANSP, MANST, MONAT, MSCHL, MWSKZ, POSN2, PRCTR, QBSHB, QSFBT, QSSHB, REBZG, SAMNR, SGTXT, SHKZG, SKFBT, WSKTO, SKNTO, STAKZ, UMSKS, UMSKZ, UZAWE, VALUT, VBEL2, VBELN, VBEWA, VBUND, VERTN, VERTT, VERZ1, VERZN, WERKS, WRSHB, WRSHC, WAERS, 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, COLOR, CESSION_KZ, BUZID, AUGGJ, AGZEI, SYM_AUGP, ICO_AUGP, ICO_DUE, ICO_DUE1, SORT, U_STBLG, U_BWSHB1, U_PSTLZ, U_FWBAS, U_REBZG, U_CHECF, STCEG, ACNAM FROM RFITEMAP_NO_ITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3KONTOAccount Numbernvarchar100CHAR(N' ')NoKTONR_AV Allow NULL? 
4GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
5SEQNONumeric Character Field, Length 10nvarchar100NUMC(N'0000000000')NoNUMC10 Allow NULL? 
6UNAMEUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
7ACTIVList Level in which the Line Item is Activenvarchar20NUMC(N'00')YesACTIV Allow NULL? 
8ANLN1Main Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
9ANLN2New asset subnumber, 4 charactersnvarchar40CHAR(N' ')YesANLN2_4 Allow NULL? 
10AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR 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? 
19BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
20BWWRTValuated Amount in Local Currencydecimal152CURR((0))YesBWWRT_X8
21BWWRCValuated Amount in Local Currencydecimal152CURR((0))YesBWWRT_X8
22BWWR2Amount Valuated in Local Currency 2decimal152CURR((0))YesBWWR2_X8
23BWWR3Amount Valuated in Local Currency 3decimal152CURR((0))YesBWWR3_X8
24DMSHBAmount in Local Currency with +/- Signsdecimal152CURR((0))YesDMSHB_X8
25HWAERLocal Currencynvarchar50CUKY(N' ')Yes*HWAER Allow NULL? 
26DMBE2Amount in Second Local Currencydecimal152CURR((0))YesDMBE2_X8
27HWAE2Currency Key of Second Local Currencynvarchar50CUKY(N' ')Yes*HWAE2 Allow NULL? 
28DMBE3Amount in Third Local Currencydecimal152CURR((0))YesDMBE3_X8
29HWAE3Currency Key of Third Local Currencynvarchar50CUKY(N' ')Yes*HWAE3 Allow NULL? 
30EBELNPurchasing Document Numbernvarchar100CHAR(N' ')YesEKKOEBELN Allow NULL? 
31EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
32ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')YesVBEPETENR Allow NULL? 
33FAEDTNet Due Datenvarchar80DATS(N'00000000')YesFAEDT_FPOS Allow NULL? 
34FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
35GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
36JAMONFiscal Year/Posting Period from Posting Datenvarchar70CHAR(N' ')YesJAMON_XPO Allow NULL? 
37KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
38KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
39MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
40MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
41MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
42MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
43MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
44MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
45MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
46POSN2Sales Document Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VA Allow NULL? 
47PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
48QBSHBWithholding Tax Amount in Document Currencydecimal152CURR((0))YesQBSHB_X8
49QSFBTWithholding Tax Exempt Amount in Document Currencydecimal152CURR((0))YesQSFBT_X8
50QSSHBWithholding Tax Base Amount in Document Currencydecimal152CURR((0))YesQSSHB_X8
51REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
52SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
53SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
54SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
55SKFBTAmount Eligible for Cash Discount in Document Currencydecimal152CURR((0))YesSKFBT_X8
56WSKTOCash Discount Amount in Document Currencydecimal152CURR((0))YesWSKTO_X8
57SKNTOCash Discount Amount in Local Currencydecimal152CURR((0))YesSKNTO_X8
58STAKZIndicator: Statistical document ?char10CHAR(N' ')YesXSTKZ Allow NULL? 
59UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
60UMSKZSpecial G/L Indicatorchar10CHAR(N' ')YesT074UUMSKZ Allow NULL? 
61UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
62VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
63VBEL2Sales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
64VBELNBilling Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VF Allow NULL? 
65VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
66VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
67VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
68VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
69VERZ1Days in Arrears for Cash Discount Terms 1decimal50DEC((0))YesVERZ1
70VERZNDays in Arrears by Net Due Datedecimal50DEC((0))YesVERZN
71WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
72WRSHBAmount in Document Currency (Foreign Currency)decimal152CURR((0))YesWRSHB_X8
73WRSHCAmount in Document Currency (Foreign Currency)decimal152CURR((0))YesWRSHB_X8
74WAERSDocument Currency (Key)nvarchar50CUKY(N' ')Yes*WAER_DOC Allow NULL? 
75WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
76XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
77XSTRPIndicator: Disputed item?char10CHAR(N' ')YesXSTRP Allow NULL? 
78XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
79ZALDTProbable Payment Date (Cash Discount 1 Due)nvarchar80DATS(N'00000000')YesDZALDT Allow NULL? 
80ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
81ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
82ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
83ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
84ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
85ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
86ZINSZInterest Calculation Numerator (Days in Arrears * Amount)decimal152CURR((0))YesDZINSZ
87ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZDZLSCH Allow NULL? 
88ZLSPRPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
89ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
90ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
91XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
92XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
93XARCHIndicator: Document already archived ?char10CHAR(N' ')YesXARCH Allow NULL? 
94RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')YesT053RRSTGR Allow NULL? 
95ASKTOCurrent Cash Discount Amount in Document Currencydecimal152CURR((0))YesASKTO_X8
96KURSEEffective Exchange Rate in the Line Itemdecimal95DEC((0))YesKURSE
97REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
98PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')YesTCURCPSWSL Allow NULL? 
99PSWBTAmount for General Ledger Update (Absolute)decimal152CURR((0))YesPSWBT_X8
100HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKA1HKONT Allow NULL? 
101XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
102ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
103RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
104CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
105KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
106XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
107DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
108DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
109DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
110DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
111ABSBTCredit Management: Hedged Amount (Absolute)decimal152CURR((0))YesABSBT_X8
112KKBWRCurrency of Credit Control Areanvarchar50CUKY(N' ')Yes*KKBWR Allow NULL? 
113PROJKIndividual Structural Element (WBS Element) in Ext. Formatnvarchar240CHAR(N' ')YesPROJK_EXT Allow NULL? 
114XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
115KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
116XAUGPIndicator: Item has been cleared?char10CHAR(N' ')YesXAUGP Allow NULL? 
117BUPLABusiness Placenvarchar40CHAR(N' ')YesJ_1BBRANCHBUPLA Allow NULL? 
118SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
119GKARTOffsetting Account Typechar10CHAR(N' ')YesGKART Allow NULL? 
120GKONTOffsetting Account Numbernvarchar100CHAR(N' ')YesGKONT Allow NULL? 
121PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')YesTCURCPYCUR Allow NULL? 
122PYAMTAmount in Automatic Payment Currency (Absolute)decimal152CURR((0))YesPYAMT_X8
123PYORDPayment Ordernvarchar100CHAR(N' ')YesPYORD Allow NULL? 
124XTEXTIndicator: Texts exist ?char10CHAR(N' ')YesXTEXT_F02L Allow NULL? 
125TDIDText IDnvarchar40CHAR(N' ')Yes*TDID Allow NULL? 
126XDUENIndicator: Item is due net?char10CHAR(N' ')YesXDUEN Allow NULL? 
127XDUE1Indicator: Cash discount term 1 is due on item?char10CHAR(N' ')YesXDUE1 Allow NULL? 
128XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
129XSELPItem selected (selected, chosen, ...)char10CHAR(N' ')YesXSELP Allow NULL? 
130COLORColor of Line Item in the Listnvarchar30CHAR(N' ')YesCOL_ITEM Allow NULL? 
131CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')YesTCESSIONCESSION_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
135SYM_AUGPItem Status Symbolnvarchar20CHAR(N' ')YesSYM_AUGP Allow NULL? 
136ICO_AUGPCleared/Open Items Symbolnvarchar340CHAR(N' ')YesICO_AUGP Allow NULL? 
137ICO_DUENet Due Date Symbolnvarchar340CHAR(N' ')YesICO_DUE Allow NULL? 
138ICO_DUE1Discount 1 Due Date Symbolnvarchar340CHAR(N' ')YesICO_DUE1 Allow NULL? 
139SORTSort Key for Line Item Reportint100INT4((0))YesITEMSORT Allow NULL? 
140U_STBLGReverse Document Numbernvarchar100CHAR(N' ')YesSTBLG Allow NULL? 
141U_BWSHB1Valuation Difference for Line Item Displaydecimal152CURR((0))YesBWSHB_V
142U_PSTLZPostal Codenvarchar100CHAR(N' ')YesPSTLZ Allow NULL? 
143U_FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
144U_REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
145U_CHECFCheck Number Fromnvarchar130CHAR(N' ')YesCHECF Allow NULL? 
146STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
147ACNAMG/L Account Long Textnvarchar500CHAR(N' ')YesTXT50_SKAT Allow NULL? 
NamePrimaryUniqueTypeColumns
RFITEMAP_NO_ITEM~0YesYesCLUSTEREDSEQNO, GJAHR, KONTO, BUKRS, MANDT