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  | BSAK_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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
1ERP EHP76.0BSAK_BAK1811Accounting: Secondary Index for Vendors (Cleared Items)
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, LIFNR, 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, EBELN, EBELP, SAKNR, HKONT, FKONT, FILKD, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, REBZG, REBZJ, REBZZ, SAMNR, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, MANSP, MSCHL, MADAT, MANST, MABER, XNETB, XANET, XCPDD, XESRD, XZAHL, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, QSSKZ, QSSHB, QBSHB, BSTAT, ANFBN, ANFBJ, ANFBU, VBUND, REBZT, STCEG, EGBLD, EGLLD, QSZNR, QSFBT, XINVE, PROJK, FIPOS, NPLNR, AUFPL, APLZL, XEGDR, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, SKNT2, SKNT3, BDIF3, XRAGL, RSTGR, UZAWE, KOSTL, LNRAN, XSTOV, KZBTR, XREF1, XREF2, XARCH, PSWSL, PSWBT, IMKEY, ZEKKN, FISTL, GEBER, DABRZ, XNEGP, EMPFB, PRCTR, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, XPYPR, KIDNO, PYCUR, PYAMT, BUPLA, SECCO, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, VERTT, VERTN, VBEWA, KBLNR, KBLPOS, GRANT_NBR, GMVKZ, SRTYPE, LOTKZ, ZINKZ, FKBER, INTRENO, PPRCT, BUZID, AUGGJ, HKTID, BUDGET_PD, KONTT, KONTL, UEBGDAT, VNAME, EGRUP, BTYPE, PROPMANO FROM BSAK_BAK
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2BUKRSCompany Codenvarchar40 Allow NULL? 
3LIFNRAccount Number of Vendor or Creditornvarchar100 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? 
35EBELNPurchasing Document Numbernvarchar100 Allow NULL? 
36EBELPItem Number of Purchasing Documentnvarchar50 Allow NULL? 
37SAKNRG/L Account Numbernvarchar100 Allow NULL? 
38HKONTGeneral Ledger Accountnvarchar100 Allow NULL? 
39FKONTFinancial Budget Itemnvarchar30 Allow NULL? 
40FILKDAccount Number of the Branchnvarchar100 Allow NULL? 
41ZFBDTBaseline Date for Due Date Calculationnvarchar80 Allow NULL? 
42ZTERMTerms of Payment Keynvarchar40 Allow NULL? 
43ZBD1TCash discount days 1decimal30
44ZBD2TCash discount days 2decimal30
45ZBD3TNet Payment Terms Perioddecimal30
46ZBD1PCash Discount Percentage 1decimal53
47ZBD2PCash Discount Percentage 2decimal53
48SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132
49SKNTOCash discount amount in local currencydecimal132
50WSKTOCash discount amount in document currencydecimal132
51ZLSCHPayment Methodchar10 Allow NULL? 
52ZLSPRPayment Block Keychar10 Allow NULL? 
53ZBFIXFixed Payment Termschar10 Allow NULL? 
54HBKIDShort Key for a House Banknvarchar50 Allow NULL? 
55BVTYPPartner Bank Typenvarchar40 Allow NULL? 
56REBZGNumber of the Invoice the Transaction Belongs tonvarchar100 Allow NULL? 
57REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40 Allow NULL? 
58REBZZLine Item in the Relevant Invoicenvarchar30 Allow NULL? 
59SAMNRInvoice List Numbernvarchar80 Allow NULL? 
60ZOLLTCustoms Tariff Numbernvarchar80 Allow NULL? 
61ZOLLDCustoms Datenvarchar80 Allow NULL? 
62LZBKZState Central Bank Indicatornvarchar30 Allow NULL? 
63LANDLSupplying Countrynvarchar30 Allow NULL? 
64DIEKZService Indicator (Foreign Payment)char10 Allow NULL? 
65MANSPDunning blockchar10 Allow NULL? 
66MSCHLDunning keychar10 Allow NULL? 
67MADATLast dunned onnvarchar80 Allow NULL? 
68MANSTDunning levelchar10 Allow NULL? 
69MABERDunning Areanvarchar20 Allow NULL? 
70XNETBIndicator: Document posted net ?char10 Allow NULL? 
71XANETIndicator: Down payment in net procedure ?char10 Allow NULL? 
72XCPDDIndicator: Address and bank data set individuallychar10 Allow NULL? 
73XESRDIndicator: Is any ISR data set in the document ?char10 Allow NULL? 
74XZAHLIndicator: Is the posting key used in a payment transaction?char10 Allow NULL? 
75MWSK1Tax Code for Distributionnvarchar20 Allow NULL? 
76DMBT1Amount in Local Currency for Tax Distributiondecimal132
77WRBT1Amount in foreign currency for tax breakdowndecimal132
78MWSK2Tax Code for Distributionnvarchar20 Allow NULL? 
79DMBT2Amount in Local Currency for Tax Distributiondecimal132
80WRBT2Amount in foreign currency for tax breakdowndecimal132
81MWSK3Tax Code for Distributionnvarchar20 Allow NULL? 
82DMBT3Amount in Local Currency for Tax Distributiondecimal132
83WRBT3Amount in foreign currency for tax breakdowndecimal132
84QSSKZWithholding Tax Codenvarchar20 Allow NULL? 
85QSSHBWithholding Tax Base Amountdecimal132
86QBSHBWithholding Tax Amount (in Document Currency)decimal132
87BSTATDocument Statuschar10 Allow NULL? 
88ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100 Allow NULL? 
89ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40 Allow NULL? 
90ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40 Allow NULL? 
91VBUNDCompany ID of trading partnernvarchar60 Allow NULL? 
92REBZTFollow-On Document Typechar10 Allow NULL? 
93STCEGVAT Registration Numbernvarchar200 Allow NULL? 
94EGBLDCountry of Destination for Delivery of Goodsnvarchar30 Allow NULL? 
95EGLLDSupplying Country for Delivery of Goodsnvarchar30 Allow NULL? 
96QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100 Allow NULL? 
97QSFBTWithholding Tax-Exempt Amount (in Document Currency)decimal132
98XINVEIndicator: Capital Goods Affected?char10 Allow NULL? 
99PROJKWork Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
100FIPOSCommitment Itemnvarchar140 Allow NULL? 
101NPLNRNetwork Number for Account Assignmentnvarchar120 Allow NULL? 
102AUFPLRouting number of operations in the ordernvarchar100 Allow NULL? 
103APLZLInternal counternvarchar80 Allow NULL? 
104XEGDRIndicator: Triangular deal within the EU ?char10 Allow NULL? 
105DMBE2Amount in Second Local Currencydecimal132
106DMBE3Amount in Third Local Currencydecimal132
107DMB21Amount in Second Local Currency for Tax Breakdowndecimal132
108DMB22Amount in Second Local Currency for Tax Breakdowndecimal132
109DMB23Amount in Second Local Currency for Tax Breakdowndecimal132
110DMB31Amount in Third Local Currency for Tax Breakdowndecimal132
111DMB32Amount in Third Local Currency for Tax Breakdowndecimal132
112DMB33Amount in Third Local Currency for Tax Breakdowndecimal132
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
117BDIF3Valuation Difference for the Third Local Currencydecimal132
118XRAGLIndicator: Clearing was Reversedchar10 Allow NULL? 
119RSTGRReason Code for Paymentsnvarchar30 Allow NULL? 
120UZAWEPayment Method Supplementnvarchar20 Allow NULL? 
121KOSTLCost Centernvarchar100 Allow NULL? 
122LNRANSequence number of asset line items in fiscal yearnvarchar50 Allow NULL? 
123XSTOVIndicator: Document is flagged for reversalchar10 Allow NULL? 
124KZBTROriginal Reduction Amount in Local Currencydecimal132
125XREF1Business partner reference keynvarchar120 Allow NULL? 
126XREF2Business partner reference keynvarchar120 Allow NULL? 
127XARCHIndicator: Document already archived ?char10 Allow NULL? 
128PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50 Allow NULL? 
129PSWBTAmount for Updating in General Ledgerdecimal132
130IMKEYInternal Key for Real Estate Objectnvarchar80 Allow NULL? 
131ZEKKNSequential Number of Account Assignmentnvarchar20 Allow NULL? 
132FISTLFunds Centernvarchar160 Allow NULL? 
133GEBERFundnvarchar100 Allow NULL? 
134DABRZReference Date for Settlementnvarchar80 Allow NULL? 
135XNEGPIndicator: Negative postingchar10 Allow NULL? 
136EMPFBPayee/Payernvarchar100 Allow NULL? 
137PRCTRProfit Centernvarchar100 Allow NULL? 
138XREF3Reference key for line itemnvarchar200 Allow NULL? 
139DTWS1Instruction key 1nvarchar20 Allow NULL? 
140DTWS2Instruction key 2nvarchar20 Allow NULL? 
141DTWS3Instruction key 3nvarchar20 Allow NULL? 
142DTWS4Instruction key 4nvarchar20 Allow NULL? 
143XPYPRIndicator: Items from Payment Program Blockedchar10 Allow NULL? 
144KIDNOPayment Referencenvarchar300 Allow NULL? 
145PYCURCurrency for Automatic Paymentnvarchar50 Allow NULL? 
146PYAMTAmount in Payment Currencydecimal132
147BUPLABusiness Placenvarchar40 Allow NULL? 
148SECCOSection Codenvarchar40 Allow NULL? 
149PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)decimal132
150PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)decimal132
151PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)decimal132
152PENLC1Penalty charge amount in first local currencydecimal132
153PENLC2Penalty charge amount in second local currencydecimal132
154PENLC3Penalty Charge Amount in Third Local Currencydecimal132
155PENFCPenalty charge amount in document currencydecimal132
156PENDAYSNumber of days for penalty charge calculationint100 Allow NULL? 
157PENRCReason for late paymentnvarchar20 Allow NULL? 
158VERTTContract Typechar10 Allow NULL? 
159VERTNContract Numbernvarchar130 Allow NULL? 
160VBEWAFlow Typenvarchar40 Allow NULL? 
161KBLNRDocument Number for Earmarked Fundsnvarchar100 Allow NULL? 
162KBLPOSEarmarked Funds: Document Itemnvarchar30 Allow NULL? 
163GRANT_NBRGrantnvarchar200 Allow NULL? 
164GMVKZItem is in Executionchar10 Allow NULL? 
165SRTYPEType of Additional Receivablenvarchar20 Allow NULL? 
166LOTKZLot Number for Requestsnvarchar100 Allow NULL? 
167ZINKZExempted from interest calculationnvarchar20 Allow NULL? 
168FKBERFunctional Areanvarchar160 Allow NULL? 
169INTRENOInternal Real Estate Master Data Codenvarchar130 Allow NULL? 
170PPRCTPartner Profit Centernvarchar100 Allow NULL? 
171BUZIDIdentification of the Line Itemchar10 Allow NULL? 
172AUGGJFiscal Year of Clearing Documentnvarchar40 Allow NULL? 
173HKTIDID for account detailsnvarchar50 Allow NULL? 
174BUDGET_PDFM: Budget Periodnvarchar100 Allow NULL? 
175KONTTAccount Assignment Category for Industry Solutionnvarchar20 Allow NULL? 
176KONTLAcct assignment string for industry-specific acct assignmntsnvarchar500 Allow NULL? 
177UEBGDATTransfer date of an item to legal dunning proceedingnvarchar80 Allow NULL? 
178VNAMEJoint Venturenvarchar60 Allow NULL? 
179EGRUPEquity groupnvarchar30 Allow NULL? 
180BTYPEPayroll Typenvarchar20 Allow NULL? 
181PROPMANOMandate, Mandate-Opening Contractnvarchar130 Allow NULL? 
NamePrimaryUniqueTypeColumns
BSAK_BAK~0YesYesCLUSTEREDBUZEI, BELNR, GJAHR, ZUONR, AUGBL, AUGDT, UMSKZ, UMSKS, LIFNR, 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