SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | BSID_BAK
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
1ERP EHP76.0BSID_BAK1791Accounting: Secondary Index for Customers
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, KBLNR, KBLPOS, GRANT_NBR, GMVKZ, SRTYPE, LOTKZ, FKBER, INTRENO, PPRCT, BUZID, AUGGJ, HKTID, BUDGET_PD, PAYS_PROV, PAYS_TRAN, MNDID, KONTT, KONTL, UEBGDAT, VNAME, EGRUP, BTYPE, PROPMANO FROM BSID_BAK
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2BUKRSCompany Codenvarchar40 Allow NULL? 
3KUNNRCustomer Numbernvarchar100 Allow NULL? 
4UMSKSSpecial G/L Transaction Typechar10 Allow NULL? 
5UMSKZSpecial G/L Indicatorchar10 Allow NULL? 
6AUGDTClearing Datenvarchar80 Allow NULL? 
7AUGBLDocument Number of the Clearing Documentnvarchar100 Allow NULL? 
8ZUONRAssignment Numbernvarchar180 Allow NULL? 
9GJAHRFiscal Yearnvarchar40 Allow NULL? 
10BELNRAccounting Document Numbernvarchar100 Allow NULL? 
11BUZEINumber of Line Item Within Accounting Documentnvarchar30 Allow NULL? 
12BUDATPosting Date in the Documentnvarchar80 Allow NULL? 
13BLDATDocument Date in Documentnvarchar80 Allow NULL? 
14CPUDTDay On Which Accounting Document Was Enterednvarchar80 Allow NULL? 
15WAERSCurrency Keynvarchar50 Allow NULL? 
16XBLNRReference Document Numbernvarchar160 Allow NULL? 
17BLARTDocument Typenvarchar20 Allow NULL? 
18MONATFiscal Periodnvarchar20 Allow NULL? 
19BSCHLPosting Keynvarchar20 Allow NULL? 
20ZUMSKTarget Special G/L Indicatorchar10 Allow NULL? 
21SHKZGDebit/Credit Indicatorchar10 Allow NULL? 
22GSBERBusiness Areanvarchar40 Allow NULL? 
23MWSKZTax on sales/purchases codenvarchar20 Allow NULL? 
24DMBTRAmount in Local Currencydecimal132
25WRBTRAmount in document currencydecimal132
26MWSTSTax Amount in Local Currencydecimal132
27WMWSTTax amount in document currencydecimal132
28BDIFFValuation Differencedecimal132
29BDIF2Valuation Difference for the Second Local Currencydecimal132
30SGTXTItem Textnvarchar500 Allow NULL? 
31PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160 Allow NULL? 
32AUFNROrder Numbernvarchar120 Allow NULL? 
33ANLN1Main Asset Numbernvarchar120 Allow NULL? 
34ANLN2Asset Subnumbernvarchar40 Allow NULL? 
35SAKNRG/L Account Numbernvarchar100 Allow NULL? 
36HKONTGeneral Ledger Accountnvarchar100 Allow NULL? 
37FKONTFinancial Budget Itemnvarchar30 Allow NULL? 
38FILKDAccount Number of the Branchnvarchar100 Allow NULL? 
39ZFBDTBaseline Date for Due Date Calculationnvarchar80 Allow NULL? 
40ZTERMTerms of Payment Keynvarchar40 Allow NULL? 
41ZBD1TCash discount days 1decimal30
42ZBD2TCash discount days 2decimal30
43ZBD3TNet Payment Terms Perioddecimal30
44ZBD1PCash Discount Percentage 1decimal53
45ZBD2PCash Discount Percentage 2decimal53
46SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132
47SKNTOCash discount amount in local currencydecimal132
48WSKTOCash discount amount in document currencydecimal132
49ZLSCHPayment Methodchar10 Allow NULL? 
50ZLSPRPayment Block Keychar10 Allow NULL? 
51ZBFIXFixed Payment Termschar10 Allow NULL? 
52HBKIDShort Key for a House Banknvarchar50 Allow NULL? 
53BVTYPPartner Bank Typenvarchar40 Allow NULL? 
54REBZGNumber of the Invoice the Transaction Belongs tonvarchar100 Allow NULL? 
55REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40 Allow NULL? 
56REBZZLine Item in the Relevant Invoicenvarchar30 Allow NULL? 
57SAMNRInvoice List Numbernvarchar80 Allow NULL? 
58ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100 Allow NULL? 
59ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40 Allow NULL? 
60ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40 Allow NULL? 
61ANFAEBill of Exchange Payment Request Due Datenvarchar80 Allow NULL? 
62MANSPDunning blockchar10 Allow NULL? 
63MSCHLDunning keychar10 Allow NULL? 
64MADATLast dunned onnvarchar80 Allow NULL? 
65MANSTDunning levelchar10 Allow NULL? 
66MABERDunning Areanvarchar20 Allow NULL? 
67XNETBIndicator: Document posted net ?char10 Allow NULL? 
68XANETIndicator: Down payment in net procedure ?char10 Allow NULL? 
69XCPDDIndicator: Address and bank data set individuallychar10 Allow NULL? 
70XINVEIndicator: Capital Goods Affected?char10 Allow NULL? 
71XZAHLIndicator: Is the posting key used in a payment transaction?char10 Allow NULL? 
72MWSK1Tax Code for Distributionnvarchar20 Allow NULL? 
73DMBT1Amount in Local Currency for Tax Distributiondecimal132
74WRBT1Amount in foreign currency for tax breakdowndecimal132
75MWSK2Tax Code for Distributionnvarchar20 Allow NULL? 
76DMBT2Amount in Local Currency for Tax Distributiondecimal132
77WRBT2Amount in foreign currency for tax breakdowndecimal132
78MWSK3Tax Code for Distributionnvarchar20 Allow NULL? 
79DMBT3Amount in Local Currency for Tax Distributiondecimal132
80WRBT3Amount in foreign currency for tax breakdowndecimal132
81BSTATDocument Statuschar10 Allow NULL? 
82VBUNDCompany ID of trading partnernvarchar60 Allow NULL? 
83VBELNBilling Documentnvarchar100 Allow NULL? 
84REBZTFollow-On Document Typechar10 Allow NULL? 
85INFAEInverted Date for Net Due Datenvarchar80 Allow NULL? 
86STCEGVAT Registration Numbernvarchar200 Allow NULL? 
87EGBLDCountry of Destination for Delivery of Goodsnvarchar30 Allow NULL? 
88EGLLDSupplying Country for Delivery of Goodsnvarchar30 Allow NULL? 
89RSTGRReason Code for Paymentsnvarchar30 Allow NULL? 
90XNOZAIndicator: Account is not countedchar10 Allow NULL? 
91VERTTContract Typechar10 Allow NULL? 
92VERTNContract Numbernvarchar130 Allow NULL? 
93VBEWAFlow Typenvarchar40 Allow NULL? 
94WVERWBill of exchange usage typechar10 Allow NULL? 
95PROJKWork Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
96FIPOSCommitment Itemnvarchar140 Allow NULL? 
97NPLNRNetwork Number for Account Assignmentnvarchar120 Allow NULL? 
98AUFPLRouting number of operations in the ordernvarchar100 Allow NULL? 
99APLZLInternal counternvarchar80 Allow NULL? 
100XEGDRIndicator: Triangular deal within the EU ?char10 Allow NULL? 
101DMBE2Amount in Second Local Currencydecimal132
102DMBE3Amount in Third Local Currencydecimal132
103DMB21Amount in Second Local Currency for Tax Breakdowndecimal132
104DMB22Amount in Second Local Currency for Tax Breakdowndecimal132
105DMB23Amount in Second Local Currency for Tax Breakdowndecimal132
106DMB31Amount in Third Local Currency for Tax Breakdowndecimal132
107DMB32Amount in Third Local Currency for Tax Breakdowndecimal132
108DMB33Amount in Third Local Currency for Tax Breakdowndecimal132
109BDIF3Valuation Difference for the Third Local Currencydecimal132
110XRAGLIndicator: Clearing was Reversedchar10 Allow NULL? 
111UZAWEPayment Method Supplementnvarchar20 Allow NULL? 
112XSTOVIndicator: Document is flagged for reversalchar10 Allow NULL? 
113MWST2Tax Amount in Second Local Currencydecimal132
114MWST3Tax Amount in Third Local Currencydecimal132
115SKNT2Cash Discount Amount in Second Local Currencydecimal132
116SKNT3Cash Discount Amount in Third Local Currencydecimal132
117XREF1Business partner reference keynvarchar120 Allow NULL? 
118XREF2Business partner reference keynvarchar120 Allow NULL? 
119XARCHIndicator: Document already archived ?char10 Allow NULL? 
120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50 Allow NULL? 
121PSWBTAmount for Updating in General Ledgerdecimal132
122LZBKZState Central Bank Indicatornvarchar30 Allow NULL? 
123LANDLSupplying Countrynvarchar30 Allow NULL? 
124IMKEYInternal Key for Real Estate Objectnvarchar80 Allow NULL? 
125VBEL2Sales Documentnvarchar100 Allow NULL? 
126VPOS2Numeric field: Length 6nvarchar60 Allow NULL? 
127POSN2Sales Document Itemnvarchar60 Allow NULL? 
128ETEN2Delivery Schedule Line Numbernvarchar40 Allow NULL? 
129FISTLFunds Centernvarchar160 Allow NULL? 
130GEBERFundnvarchar100 Allow NULL? 
131DABRZReference Date for Settlementnvarchar80 Allow NULL? 
132XNEGPIndicator: Negative postingchar10 Allow NULL? 
133KOSTLCost Centernvarchar100 Allow NULL? 
134RFZEIPayment Card Itemnvarchar30 Allow NULL? 
135KKBERCredit control areanvarchar40 Allow NULL? 
136EMPFBPayee/Payernvarchar100 Allow NULL? 
137PRCTRProfit Centernvarchar100 Allow NULL? 
138XREF3Reference key for line itemnvarchar200 Allow NULL? 
139QSSKZWithholding Tax Codenvarchar20 Allow NULL? 
140ZINKZExempted from interest calculationnvarchar20 Allow NULL? 
141DTWS1Instruction key 1nvarchar20 Allow NULL? 
142DTWS2Instruction key 2nvarchar20 Allow NULL? 
143DTWS3Instruction key 3nvarchar20 Allow NULL? 
144DTWS4Instruction key 4nvarchar20 Allow NULL? 
145XPYPRIndicator: Items from Payment Program Blockedchar10 Allow NULL? 
146KIDNOPayment Referencenvarchar300 Allow NULL? 
147ABSBTCredit management: Hedged amountdecimal132
148CCBTCPayment cards: Settlement runnvarchar100 Allow NULL? 
149PYCURCurrency for Automatic Paymentnvarchar50 Allow NULL? 
150PYAMTAmount in Payment Currencydecimal132
151BUPLABusiness Placenvarchar40 Allow NULL? 
152SECCOSection Codenvarchar40 Allow NULL? 
153CESSION_KZAccounts Receivable Pledging Indicatornvarchar20 Allow NULL? 
154PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)decimal132
155PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)decimal132
156PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)decimal132
157KBLNRDocument Number for Earmarked Fundsnvarchar100 Allow NULL? 
158KBLPOSEarmarked Funds: Document Itemnvarchar30 Allow NULL? 
159GRANT_NBRGrantnvarchar200 Allow NULL? 
160GMVKZItem is in Executionchar10 Allow NULL? 
161SRTYPEType of Additional Receivablenvarchar20 Allow NULL? 
162LOTKZLot Number for Requestsnvarchar100 Allow NULL? 
163FKBERFunctional Areanvarchar160 Allow NULL? 
164INTRENOInternal Real Estate Master Data Codenvarchar130 Allow NULL? 
165PPRCTPartner Profit Centernvarchar100 Allow NULL? 
166BUZIDIdentification of the Line Itemchar10 Allow NULL? 
167AUGGJFiscal Year of Clearing Documentnvarchar40 Allow NULL? 
168HKTIDID for account detailsnvarchar50 Allow NULL? 
169BUDGET_PDFM: Budget Periodnvarchar100 Allow NULL? 
170PAYS_PROVPayment Service Providernvarchar40 Allow NULL? 
171PAYS_TRANPayment Reference of Payment Service Providernvarchar350 Allow NULL? 
172MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350 Allow NULL? 
173KONTTAccount Assignment Category for Industry Solutionnvarchar20 Allow NULL? 
174KONTLAcct assignment string for industry-specific acct assignmntsnvarchar500 Allow NULL? 
175UEBGDATTransfer date of an item to legal dunning proceedingnvarchar80 Allow NULL? 
176VNAMEJoint Venturenvarchar60 Allow NULL? 
177EGRUPEquity groupnvarchar30 Allow NULL? 
178BTYPEPayroll Typenvarchar20 Allow NULL? 
179PROPMANOMandate, Mandate-Opening Contractnvarchar130 Allow NULL? 
NamePrimaryUniqueTypeColumns
BSID_BAK~0YesYesCLUSTEREDBUZEI, BELNR, GJAHR, ZUONR, AUGBL, AUGDT, UMSKZ, UMSKS, KUNNR, BUKRS, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy