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
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Materials Management :: Invoice Verification
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0RBCO851Document Item, Incoming Invoice, Account AssignmentInvoice Verification
SQL:  selectupdate insert create

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

SELECT MANDT, BELNR, GJAHR, BUZEI, COBL_NR, WRBTR, ANLN1, ANLN2, APLZL, AUFNR, DABRZ, FIPOS, FISTL, FKBER, GEBER, GRANT_NBR, GSBER, IMKEY, KOKRS, KOSTL, KSTRG, PAOBJNR, PRCTR, PS_PSP_PNR, RECID, SAKNR, SGTXT, TXJCD, VBELN, VBELP, VPTNR, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, MENGE, MWSKZ, ZEKKN, BPMNG, XUNPL, LSTAR, PRZNR, AUFPL, BUKRS, SHKZG, BZDAT, BNKAN_FW, XNEGP, ERLKZ, FIKRS, KBLNR, KBLPOS, PARGB, PERNR, XSKRL, NPLNR, VORNR, ZUONR, MEINS, MWART, FWBAS, HWBAS, ABPER, LEDAT, MENGE_F, BPMNG_F, WERKS, BUDGET_PD, MEASURE, FMFGUS_KEY, KOART, SPGRS, AA_FINAL_IND, AA_FINAL_QTY, AA_FINAL_QTY_F, PARKED_QTY, PARKED_QTY_F FROM RBCO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
3GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
4BUZEIDocument Item in Invoice Documentnvarchar60NUMC(N'000000')NoRBLGP Allow NULL? 
5COBL_NRFour Character Sequential Number for Coding Blocknvarchar40NUMC(N'0000')NoCOBL_NR Allow NULL? 
6WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
7ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
8ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
9APLZLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
10AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
11DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
12FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
13FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
14FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
15GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
16GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
17GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
18IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
19KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
20KOSTLCost Centernvarchar100CHAR(N' ')YesCSKSKOSTL Allow NULL? 
21KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
22PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
23PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
24PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
25RECIDRules for Issuing an Invoicenvarchar40CHAR(N' ')YesRECID Allow NULL? 
26SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
27SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
28TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
29VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
30VBELPSales document itemnvarchar60NUMC(N'000000')Yes*VBELP Allow NULL? 
31VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
32ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
33ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
34ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
35ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
36ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
37ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
38ZZNFALnvarchar100(N' ')Yes Allow NULL? 
39ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
40ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
41ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
42ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
43ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
44MENGEQuantitydecimal133QUAN((0))YesMENGE_D
45MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
46ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
47BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG
48XUNPLUnplanned Account Assignment from Invoice Verificationchar10CHAR(N' ')YesXUNPL Allow NULL? 
49LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
50PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
51AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
52BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
53SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
54BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
55BNKAN_FWDelivery costs' share of item valuedecimal132CURR((0))YesBNK_ANTEIL
56XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
57ERLKZUsed earmarked funds set to "Complete"char10CHAR(N' ')YesREFSETERLK Allow NULL? 
58FIKRSFinancial Management Areanvarchar40CHAR(N' ')Yes*FIKRS Allow NULL? 
59KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR_FI Allow NULL? 
60KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
61PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
62PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
63XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
64NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
65VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
66ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
67MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
68MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
69FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
70HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
71ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
72LEDATDelivery Creation Datenvarchar80DATS(N'00000000')YesLEDAT Allow NULL? 
73MENGE_FQuantity (Floating Point Number - Internal Field)float1516FLTP((0))YesMENGE_F
74BPMNG_FQuantity in PO Price Unit (as Floating Point No. - Int. Fld)float1516FLTP((0))YesBPMNG_F
75WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
76BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
77MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
78FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
79KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
80SPGRSBlocking Reason: Item Amountchar10CHAR(N' ')YesSPGRS Allow NULL? 
81AA_FINAL_INDFinal Account Assignment Indicatorchar10CHAR(N' ')YesAA_FINAL_IND Allow NULL? 
82AA_FINAL_QTYFinal Account Assignment Quantitydecimal133QUAN((0))YesAA_FINAL_QTY
83AA_FINAL_QTY_FFinal Account Assignment Quantity (Floating Point Number)float1516FLTP((0))YesAA_FINAL_QTY_F
84PARKED_QTYParked Invoice Quantitydecimal133QUAN((0))YesPARKED_QTY
85PARKED_QTY_FParked Invoice Quantity (Floating Point Number)float1516FLTP((0))YesPARKED_QTY_F
NamePrimaryUniqueTypeColumns
RBCO~0YesYesCLUSTEREDCOBL_NR, BUZEI, GJAHR, BELNR, MANDT