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
8BSEG345Accounting Document Segment
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
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Financial Accounting :: General Ledger Accounting :: Information System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DKKOP661Balance Audit TrailInformation System
SQL:  selectupdate insert create

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

SELECT MANDT, KOART, BUKRS, KONTO, GJAHR, GSBER, SAART, UMSKS, UMSAT, BUPER, BUDAT, BELNR, BUZEI, HKONT, ALTKZ, ALTKT, BLART, BLDAT, UMSKZ, WAERS, XBLNR, CPUDT, USNAM, STAKZ, DBBLG, BKTXT, XUMSW, XOPVW, BSCHL, SHKZG, BUZID, MWSKZ, FIPLS, DMBTR, GSBE1, WRBTR, WSKTO, WMWST, MWSHB, ZUONR, AUGBL, AUGDT, AUGCP, MSCHL, ZLSCH, NETDT, ZFBDT, SKFBT, MWSTS, MDSHB, SKNTO, HWBAS, ZINKZ, VALUT, FWBAS, PERNR, ABPER, KOSTL, SGTXT, GKART, GKONT, VBUND, EGMLD, STCEG, BVORG, XNEGP FROM DKKOP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2KOARTAccount Typechar10CHAR(N' ')NoKOART Allow NULL? 
3BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
4KONTOCustomer Numbernvarchar100CHAR(N' ')No*KUNNR Allow NULL? 
5GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
6GSBERBusiness Areanvarchar40CHAR(N' ')No*GSBER Allow NULL? 
7SAARTRecord Type for Accumulated Balance Audit Trailchar10CHAR(N' ')NoSAART Allow NULL? 
8UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')NoUMSKS Allow NULL? 
9UMSATSpecial G/L Indicatorchar10CHAR(N' ')No*UMSKZ Allow NULL? 
10BUPERPosting period in the form YYYYMMnvarchar60ACCP(N' ')NoBUPER Allow NULL? 
11BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')NoBUDAT Allow NULL? 
12BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
13BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
14HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
15ALTKZFull audit trail:ID:Altern.acct no. filled with credit acctchar10CHAR(N' ')YesALTKZ Allow NULL? 
16ALTKTAccount Number in Groupnvarchar100CHAR(N' ')YesALTKT Allow NULL? 
17BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
18BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
19UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
20WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
21XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
22CPUDTDay On Which Accounting Document Was Enterednvarchar80DATS(N'00000000')YesCPUDT Allow NULL? 
23USNAMUser namenvarchar120CHAR(N' ')Yes*USNAM Allow NULL? 
24STAKZIndicator. object is statisticalchar10CHAR(N' ')YesSTAKZ Allow NULL? 
25DBBLGRecurring Entry Document Numbernvarchar100CHAR(N' ')YesDBBLG Allow NULL? 
26BKTXTDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
27XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
28XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
29BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
30SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
31BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
32MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
33FIPLSFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
34DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
35GSBE1Business Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
36WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
37WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
38WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
39MWSHBTax on Sales/Purchases Amount in Foreign Curr. with +/- Signdecimal132CURR((0))YesMWSHB
40ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
41AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
42AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
43AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
44MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
45ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
46NETDTDue Date for Net Paymentnvarchar80DATS(N'00000000')YesNETDT Allow NULL? 
47ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
48SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
49MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
50MDSHBTax on Sales/Purchases amount in Local Curr. with +/- Signdecimal132CURR((0))YesMDSHB
51SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
52HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
53ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
54VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
55FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
56PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
57ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
58KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
59SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
60GKARTOffsetting Account Typechar10CHAR(N' ')YesGKART Allow NULL? 
61GKONTOffsetting Account Numbernvarchar100CHAR(N' ')YesGKONT Allow NULL? 
62VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
63EGMLDReporting Country for Delivery of Goods within the EUnvarchar30CHAR(N' ')Yes*EGMLD_BSEZ Allow NULL? 
64STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
65BVORGNumber of Cross-Company Code Posting Transactionnvarchar160CHAR(N' ')YesBVORG Allow NULL? 
66XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
NamePrimaryUniqueTypeColumns
DKKOP~0YesYesCLUSTEREDBUZEI, BELNR, BUDAT, BUPER, UMSAT, UMSKS, SAART, GSBER, GJAHR, KONTO, BUKRS, KOART, MANDT