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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
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

160 columns | Print definition?B1 9.3  | CARDCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log25CardCodeCard CodenVarChar150
2DAR2Data Archive - Transaction Log7CardCodeCustomer/Vendor CodenVarChar150
3DGP1Customer List2CardCodeCustomer CodenVarChar150
4GPC1Authority Assignment4CardCodeVendor CodenVarChar150
5NFN4Manual Nota Fiscal Number9CardCodeCustomer/Vendor CodenVarChar150-
6OSRLSerial Numbers3CardCodeCustomer CodenVarChar150
TOPBanking
7ABOEBill of Exchange for Payment - History17CardCodeBP CodenVarChar150
8ARCTIncoming Payment - History9CardCodeBP CodenVarChar150
9OBCGBank Charge for Bank Transfers1CardCodeBP CodenVarChar150
10OBNKExternal Bank Statement Received17CardCodeBP CodenVarChar150
11OBOEBill of Exchange for Payment17CardCodeBP CodenVarChar150
12OCHHCheck Register8CardCodeBP/Account CodenVarChar150
13OCRHCredit Card Management25CardCodeBP/Account CodenVarChar150
14OCRVCredit Payments19CardCodeBP/Account CodenVarChar150
15OPDFPayment Draft9CardCodeCustomer/Vendor CodenVarChar150
16OPWBPWZ - Bank Account2CardCodeBP CodenVarChar150
17ORCTIncoming Payment9CardCodeCustomer/Vendor CodenVarChar150
18OVPMOutgoing Payments9CardCodeCustomer/Vendor CodenVarChar150
19PWZ1Payment Wizard - Rows 12CardCodeBP CodenVarChar150
20PWZ3Payment Wizard - Rows 33CardCodeVendor CodenVarChar150
21PWZ4Payment Wizard - Rows 43CardCodeVendor's Card codenVarChar150
22PWZ5Payment Wizard - Rows 54CardCodeCard CodenVarChar150
23RTW1Boleto Retorno Wizard: Import Table43CardCodeBoE BP CodenVarChar150
TOPBusiness Partners
24ACLGActivities - History2CardCodeBP CodenVarChar150
25ACPRContact Persons - History2CardCodeBP CodenVarChar150
26ACR1Business Partner Addresses - History2CardCodeBP CodenVarChar150
27ACR11BP Tributary Info.1CardCodeBP CodenVarChar250
28ACR12BP eDoc Settings1CardCodeBP CodenVarChar150
29ACR2Bussiness Partners - Payment Methods-History1CardCodeBP CodenVarChar150
30ACR3Business Partner Control Accounts - History1CardCodeBP CodenVarChar150
31ACR4Allowed WTax Codes for BP - History1CardCodeBP CodenVarChar150
32ACR5BP Payment Dates1CardCodeBP CodenVarChar150
33ACR7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
34ACRBBusiness Partner Bank Accounts - History2CardCodeBP CodenVarChar150
35ACRDBusiness Partners - History1CardCodeBP CodenVarChar150
36CRD1Business Partners - Addresses2CardCodeBP CodenVarChar150
37CRD11BP Tributary Info.1CardCodeBP CodenVarChar250
38CRD12BP eDoc Settings1CardCodeBP CodenVarChar150
39CRD2Bussiness Partners - Payment Methods1CardCodeBP CodenVarChar150
40CRD3BP Control Account1CardCodeBP CodenVarChar150
41CRD4Allowed WTax Codes for BP1CardCodeBP CodenVarChar150
42CRD5BP Payment Dates1CardCodeBP CodenVarChar150
43CRD6BP's Payer Name1CardCodeBP CodenVarChar150
44CRD7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
45CRD8BP Branch Assignment1CardCodeBP CodenVarChar150
46CRD9OCRD Extension1CardCodeBP CodenVarChar250
47OCLGActivities2CardCodeBP CodenVarChar150
48OCPRContact Persons2CardCodeBP CodenVarChar150
49OCRBBP - Bank Account2CardCodeBP CodenVarChar150
50OCRDBusiness Partner1CardCodeBP CodenVarChar150
51OCRWBP for IIS Annual2CardCodeBP CodenVarChar150
52ODDTWithholding Tax Deduction Hierarchy2CardCodeBP CodenVarChar150
53OSCNCustomer/Vendor Cat. No.2CardCodeBP CodenVarChar150
54OTBPTarget Group Business Partner1CardCodeBP CodenVarChar150
55TGG1Target Group Details2CardCodeBP CodenVarChar150
TOPFinance
56AGARG/L Account Advanced Rules - History81CardCodeCustomer/Vendor CodenVarChar150
57ISW1Reported Business Partners2CardCodeBusiness Partner CodenVarChar150
58ISW3Declaration Rows5CardCodeBusiness Partner CodenVarChar150
59OACMAccumulation2CardCodeCustomer/Vendor CodenVarChar150
60OGARG/L Account Advanced Rules81CardCodeCustomer/Vendor CodenVarChar150
61OWTAWithholding Tax Accumulation2CardCodeBP CodenVarChar150
62RTM2Rate Differences - SC Adjustment Rows3CardCodeBP CodenVarChar150
63VRW3VAT Reposting Wizard - Rows 32CardCodeCustomer/Vendor CodenVarChar150
TOPGeneral
64AGRSG/L Account Advanced Rules for Resources - History54CardCodeCustomer/Vendor CodenVarChar150
65APMGProject Management Document - History9CARDCODEBP CodenVarChar150
66ARSCResource Master Data - Log14CardCodePreferred VendornVarChar150
67CRDCBP - Communication Means1CardCodeBP CodenVarChar150
68OGRSG/L Account Advanced Rules for Resources54CardCodeCustomer/Vendor CodenVarChar150
69OPMGProject Management Document9CARDCODEBP CodenVarChar150
70ORSCResources14CardCodePreferred VendornVarChar150
71OSWASpecific Withholding Amounts2CardCodeBP CodenVarChar150
72OTCNTracking Note7CardCodeBP CodenVarChar150
73TCN2Tracking Note - Brokers3CardCodeBP CodenVarChar150
TOPInventory and Production
74AITMItems - History19CardCodePreferred VendornVarChar150
75AMRVInventory Revaluation - History30CardCodeCustomer/Vendor CodenVarChar150
76AQI1Inventory Opening Balance - Rows30CardCodePreferred VendornVarChar150
77AQR1Inventory Posting - Rows29CardCodePreferred VendornVarChar150
78ASP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
79ASP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
80ASPPSpecial Prices2CardCodeBP CodenVarChar150
81AWORProduction Order - History19CardCodeCustomer CodenVarChar150
82IOD1Inventory Opening Balance Draft - Rows30CardCodePreferred VendornVarChar150
83IPD1Inventory Posting Draft - Rows29CardCodePreferred VendornVarChar150
84IPF1Landed Costs - Rows25CardCodeVendor CodenVarChar150
85IQI1Inventory Opening Balance - Rows30CardCodePreferred VendornVarChar150
86IQR1Inventory Posting - Rows29CardCodePreferred VendornVarChar150
87OENTShipping Types8CardCodeBP CodenVarChar150
88OIGEGoods Issue13CardCodeExpense AccountnVarChar150
89OIGNGoods Receipt13CardCodeRevenue AccountnVarChar150
90OIPFLanded Costs5CardCodeVendor CodenVarChar150
91OITLInventory Transactions Log17CardCodeBP CodenVarChar150
92OITMItems19CardCodePreferred VendornVarChar150
93OMRVInventory Revaluation30CardCodeCustomer/Vendor CodenVarChar150
94OSPGSpecial Prices for Groups1CardCodeBP CodenVarChar150
95OSPPSpecial Prices2CardCodeBP CodenVarChar150
96OWKOProduction Instructions9CardCodeSold-to Party CodenVarChar150
97OWORProduction Order19CardCodeCustomer CodenVarChar150
98OWTQInventory Transfer Request13CardCodeCustomer/Vendor CodenVarChar150
99OWTRInventory Transfer13CardCodeCustomer/Vendor CodenVarChar150
100SITMItems19CardCodePreferred VendornVarChar150
101SPP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
102SPP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
103UITMItems19CardCodePreferred VendornVarChar150
104UWKOProduction Instructions9CardCodeSold-To-Party CodenVarChar150
105UWORProduction Order19CardCodeCustomer CodenVarChar150
106WOR2VProduction Order - Base4CardCodeCustomer CodenVarChar150
TOPMarketing Documents
107ADOCInvoice - History13CardCodeBP CodenVarChar150
108ATX3Tax Invoice Archive - Document Reference Information11CardCodeBusiness PartnernVarChar150
109ATXITax Invoice - History10CardCodeCustomer CodenVarChar150
110DWZ1Dunning Wizard Array1 - BP Filter2CardCodeBP Card CodenVarChar150
111DWZ2Dunning Wizard Array 2-Invoice Filter2CardCodeBP Card CodenVarChar150
112DWZ3Dunning Wizard Array 3 - Recommended Service Invoice2CardCodeBP Card CodenVarChar150
113DWZ4Dunning Wizard Array 4-Paging Grid5CardCodeBP Card CodenVarChar150
114OCINA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
115OCPIA/P Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
116OCPVA/P Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
117OCSIA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
118OCSVA/R Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
119ODLNDelivery13CardCodeCustomer/Vendor CodenVarChar150
120ODPIA/R Down Payment13CardCodeCustomer/Vendor CodenVarChar150
121ODPOA/P Down Payment13CardCodeCustomer/Vendor CodenVarChar150
122ODRFDrafts13CardCodeBP CodenVarChar150
123OIEIIncoming Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
124OINVA/R Invoice13CardCodeCustomer/Vendor CodenVarChar150
125OOEIOutgoing Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
126OPCHA/P Invoice13CardCodeCustomer/Vendor CodenVarChar150
127OPDNGoods Receipt PO13CardCodeCustomer/Vendor CodenVarChar150
128OPORPurchase Order13CardCodeCustomer/Vendor CodenVarChar150
129OPQTPurchase Quotation13CardCodeCustomer/Vendor CodenVarChar150
130OPRQPurchase Request13CardCodeCustomer/Vendor CodenVarChar150
131OPRRGoods Return Request13CardCodeCustomer/Vendor CodenVarChar150
132OQUTSales Quotation13CardCodeCustomer/Vendor CodenVarChar150
133ORDNReturns13CardCodeCustomer/Vendor CodenVarChar150
134ORDRSales Order13CardCodeCustomer/Vendor CodenVarChar150
135ORINA/R Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
136ORPCA/P Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
137ORPDGoods Return13CardCodeCustomer/Vendor CodenVarChar150
138ORRRReturn Request13CardCodeCustomer/Vendor CodenVarChar150
139OSALOutgoing8CardCodeBP CodenVarChar150
140OSFCSelf Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
141OSFISelf Invoice13CardCodeCustomer/Vendor CodenVarChar150
142OTPIPurchase Tax Invoice10CardCodeCustomer CodenVarChar150
143OTRATransition8CardCodeBP CodenVarChar150
144OTSISales Tax Invoice10CardCodeCustomer CodenVarChar150
145OTXDTax Invoice Draft10CardCodeCustomer CodenVarChar150
146OVRTTax Invoice Report4CardCodeReceipt BP CodenVarChar150
147TPI3Purchase Tax Invoice - Document Reference Information11CardCodeBusiness PartnernVarChar150
148TSI3Sales Tax Invoice - Document Reference Information11CardCodeBusiness PartnernVarChar150
149TXD3Tax Invoice Draft - Document Reference Information11CardCodeBusiness PartnernVarChar150
TOPMRP
150ORCMRecommendation Data9CardCodePreferred VendornVarChar150
TOPReports
151AMD1Amout Differences Report Lines5CardCodeBP CodenVarChar150
152OAMDAmount Differences Report4CardCodeBP CodenVarChar150
153OEMLE-mail Log2CardCodeBP CodenVarChar150
154RDFLDocument Standards4CardCodeBP CodenVarChar150-1
155SOI1Statement of Import - Business Partners2CardCodeBP Card CodenVarChar150
156SOI3Statement of Import - Invoices5CardCodeCustomer/Vendor CodenVarChar150
157SRT2Korean Summary Report - Rows24CardCodeBP Code on OCRDnVarChar150
158TRB5Tax Report Wizard Reported Tax Sums3CardCodeVendor CodenVarChar150
TOPSales Opportunities
159AOPROpportunity2CardCodeBP CodenVarChar150
160OOPROpportunity2CardCodeBP CodenVarChar150