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
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OSRN20Serial Numbers Master Data
5OIVL77Whse Journal
6OBOT10Bill Of Exchang Transaction
7ORCT154Incoming Payment
8OVPM154Outgoing Payments
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

110 columns | Print definition?B1 8.82  | CARDCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR2Data Archive - Transaction Log7CardCodeCustomer/Vendor CodenVarChar150
2DGP1Customer List2CardCodeCustomer CodenVarChar150
3NFN4Manual Nota Fiscal Number9CardCodeCustomer/Vendor CodenVarChar150-
4OSRLSerial Numbers3CardCodeCustomer CodenVarChar150
TOPBanking
5ABOEBill of Exchange for Payment - History17CardCodeBP CodenVarChar150
6ARCTIncoming Payment - History9CardCodeBP CodenVarChar150
7OBCGBank Charge for Bank Transfers1CardCodeBP CodenVarChar150
8OBNKExternal Bank Statement Received17CardCodeBP CodenVarChar150
9OBOEBill of Exchange for Payment17CardCodeBP CodenVarChar150
10OCHHCheck Register8CardCodeCustomer CodenVarChar150
11OCRHCredit Card Management25CardCodeCustomer CodenVarChar150
12OCRVCredit Payments19CardCodeCustomer CodenVarChar150
13OPDFPayment Draft9CardCodeCustomer/Vendor CodenVarChar150
14OPWBPWZ - Bank Account2CardCodeBP CodenVarChar150
15ORCTIncoming Payment9CardCodeCustomer/Vendor CodenVarChar150
16OVPMOutgoing Payments9CardCodeCustomer/Vendor CodenVarChar150
17PWZ1Payment Wizard - Rows 12CardCodeBP CodenVarChar150
18PWZ3Payment Wizard - Rows 33CardCodeVendor CodenVarChar150
19PWZ4Payment Wizard - Rows 43CardCodeVendor's Card codenVarChar150
20PWZ5Payment Wizard - Rows 54CardCodeCard CodenVarChar150
TOPBusiness Partners
21ACPRContact Persons - History2CardCodeBP CodenVarChar150
22ACR1Business Partner Addresses - History2CardCodeBP CodenVarChar150
23ACR2Bussiness Partners - Payment Methods-History1CardCodeBP CodenVarChar150
24ACR3Business Partner Control Accounts - History1CardCodeBP CodenVarChar150
25ACR4Allowed WTax Codes for BP - History1CardCodeBP CodenVarChar150
26ACR5BP Payment Dates1CardCodeBP CodenVarChar150
27ACR7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
28ACRBBusiness Partner Bank Accounts - History2CardCodeBP CodenVarChar150
29ACRDBusiness Partners - History1CardCodeBP CodenVarChar150
30CRD1Business Partners - Addresses2CardCodeBP CodenVarChar150
31CRD2Bussiness Partners - Payment Methods1CardCodeBP CodenVarChar150
32CRD3BP Control Account1CardCodeBP CodenVarChar150
33CRD4Allowed WTax Codes for BP1CardCodeBP CodenVarChar150
34CRD5BP Payment Dates1CardCodeBP CodenVarChar150
35CRD6BP's Payer Name1CardCodeBP CodenVarChar150
36CRD7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
37CRD8BP Branch Assignment1CardCodeBP CodenVarChar250
38OCLGActivities2CardCodeBP CodenVarChar150
39OCPRContact Persons2CardCodeBP CodenVarChar150
40OCRBBP - Bank Account2CardCodeBP CodenVarChar150
41OCRDBusiness Partner1CardCodeBP CodenVarChar150
42ODDTWithholding Tax Deduction Hierarchy2CardCodeBP CodenVarChar150
43OSCNCustomer/Vendor Cat. No.2CardCodeBP CodenVarChar150
TOPFinance
44OACMAccumulation2CardCodeCustomer/Vendor CodenVarChar150
TOPInventory and Production
45AITMItems - History19CardCodePreferred VendornVarChar150
46AWORProduction Order - History19CardCodeCustomer CodenVarChar150
47IPF1Landed Costs - Rows25CardCodeVendor CodenVarChar150
48OENTShipping Types8CardCodeBP CodenVarChar150
49OIBTBatch No. for Item17CardCodeBP CodenVarChar150
50OIGEGoods Issue13CardCodeExpense AccountnVarChar150
51OIGNGoods Receipt13CardCodeRevenue AccountnVarChar150
52OINMWhse Journal8CardCodeCustomer/Vendor CodenVarChar150
53OIPFLanded Costs5CardCodeVendor CodenVarChar150
54OITLInventory Transactions Log17CardCodeBP CodenVarChar150
55OITMItems19CardCodePreferred VendornVarChar150
56OSPGSpecial Prices for Groups1CardCodeBP CodenVarChar150
57OSPPSpecial Prices2CardCodeBP CodenVarChar150
58OSRISerial Numbers for Items20CardCodeBP CodenVarChar150
59OWKOProduction Instructions9CardCodeSold-to Party CodenVarChar150
60OWORProduction Order19CardCodeCustomer CodenVarChar150
61OWTQInventory Transfer Request13CardCodeCustomer/Vendor CodenVarChar150
62OWTRInventory Transfer13CardCodeCustomer/Vendor CodenVarChar150
63SITMItems19CardCodePreferred VendornVarChar150
64SPP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
65SPP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
66UITMItems19CardCodePreferred VendornVarChar150
67UWKOProduction Instructions9CardCodeSold-To-Party CodenVarChar150
68UWORProduction Order19CardCodeCustomer CodenVarChar150
69WOR2VProduction Order - Base4CardCodeCustomer CodenVarChar150
TOPMarketing Documents
70ADOCInvoice - History13CardCodeBP CodenVarChar150
71ATXITax Invoice - History10CardCodeCustomer CodenVarChar150
72DWZ1Dunning Wizard Array1 - BP Filter2CardCodeBP Card CodenVarChar150
73DWZ2Dunning Wizard Array 2-Invoice Filter2CardCodeBP Card CodenVarChar150
74DWZ3Dunning Wizard Array 3 - Recommended Service Invoice2CardCodeBP Card CodenVarChar150
75OCINA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
76OCPIA/P Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
77OCPVA/P Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
78OCSIA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
79OCSVA/R Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
80ODLNDelivery13CardCodeCustomer/Vendor CodenVarChar150
81ODPIA/R Down Payment13CardCodeCustomer/Vendor CodenVarChar150
82ODPOA/P Down Payment13CardCodeCustomer/Vendor CodenVarChar150
83ODRFDrafts13CardCodeBP CodenVarChar150
84OIEIIncoming Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
85OINVA/R Invoice13CardCodeCustomer/Vendor CodenVarChar150
86OOEIOutgoing Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
87OPCHA/P Invoice13CardCodeCustomer/Vendor CodenVarChar150
88OPDNGoods Receipt PO13CardCodeCustomer/Vendor CodenVarChar150
89OPORPurchase Order13CardCodeCustomer/Vendor CodenVarChar150
90OPQTPurchase Quotation13CardCodeCustomer/Vendor CodenVarChar150
91OQUTSales Quotation13CardCodeCustomer/Vendor CodenVarChar150
92ORDNReturns13CardCodeCustomer/Vendor CodenVarChar150
93ORDRSales Order13CardCodeCustomer/Vendor CodenVarChar150
94ORINA/R Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
95ORPCA/P Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
96ORPDGoods Return13CardCodeCustomer/Vendor CodenVarChar150
97OSALOutgoing8CardCodeBP CodenVarChar150
98OTPIPurchase Tax Invoice10CardCodeCustomer CodenVarChar150
99OTRATransition8CardCodeBP CodenVarChar150
100OTSISales Tax Invoice10CardCodeCustomer CodenVarChar150
101OTXDTax Invoice Draft10CardCodeCustomer CodenVarChar150
102OVRTTax Invoice Report4CardCodeReceipt BP CodenVarChar150
TOPMRP
103ORCMRecommendation Data9CardCodePreferred VendornVarChar150
TOPReports
104AMD1Amout Differences Report Lines5CardCodeBP CodenVarChar150
105OAMDAmount Differences Report4CardCodeBP CodenVarChar150
106RDFLDocument Standards4CardCodeBP CodenVarChar150-1
107SRT2Korean Summary Report - Rows24CardCodeBP Code on OCRDnVarChar150
TOPSales Opportunities
108OOPRSales Opportunity2CardCodeBP CodenVarChar150
TOPService
109OTBPTarget Group Business Partner1CardCodeBP CodenVarChar150
110TGG1Target Group Details2CardCodeBP CodenVarChar150