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
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
3OIVL77Whse Journal
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6ORCT154Incoming Payment
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

137 columns | Print definition?B1 9.2  | 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
24ACPRContact Persons - History2CardCodeBP CodenVarChar150
25ACR1Business Partner Addresses - History2CardCodeBP CodenVarChar150
26ACR2Bussiness Partners - Payment Methods-History1CardCodeBP CodenVarChar150
27ACR3Business Partner Control Accounts - History1CardCodeBP CodenVarChar150
28ACR4Allowed WTax Codes for BP - History1CardCodeBP CodenVarChar150
29ACR5BP Payment Dates1CardCodeBP CodenVarChar150
30ACR7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
31ACRBBusiness Partner Bank Accounts - History2CardCodeBP CodenVarChar150
32ACRDBusiness Partners - History1CardCodeBP CodenVarChar150
33CRD1Business Partners - Addresses2CardCodeBP CodenVarChar150
34CRD2Bussiness Partners - Payment Methods1CardCodeBP CodenVarChar150
35CRD3BP Control Account1CardCodeBP CodenVarChar150
36CRD4Allowed WTax Codes for BP1CardCodeBP CodenVarChar150
37CRD5BP Payment Dates1CardCodeBP CodenVarChar150
38CRD6BP's Payer Name1CardCodeBP CodenVarChar150
39CRD7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
40CRD8BP Branch Assignment1CardCodeBP CodenVarChar150
41CRD9OCRD Extension1CardCodeBP CodenVarChar250
42OCLGActivities2CardCodeBP CodenVarChar150
43OCPRContact Persons2CardCodeBP CodenVarChar150
44OCRBBP - Bank Account2CardCodeBP CodenVarChar150
45OCRDBusiness Partner1CardCodeBP CodenVarChar150
46ODDTWithholding Tax Deduction Hierarchy2CardCodeBP CodenVarChar150
47OSCNCustomer/Vendor Cat. No.2CardCodeBP CodenVarChar150
48OTBPTarget Group Business Partner1CardCodeBP CodenVarChar150
49TGG1Target Group Details2CardCodeBP CodenVarChar150
TOPFinance
50AGARG/L Account Advanced Rules - History81CardCodeCustomer/Vendor CodenVarChar150
51ISW1Reported Business Partners2CardCodeBusiness Partner CodenVarChar150
52ISW3Declaration Rows5CardCodeBusiness Partner CodenVarChar150
53OACMAccumulation2CardCodeCustomer/Vendor CodenVarChar150
54OGARG/L Account Advanced Rules81CardCodeCustomer/Vendor CodenVarChar150
55RTM2Rate Differences - SC Adjustment Rows3CardCodeBP CodenVarChar150
56VRW3VAT Reposting Wizard - Rows 32CardCodeCustomer/Vendor CodenVarChar150
TOPGeneral
57AGRSG/L Account Advanced Rules for Resources - History54CardCodeCustomer/Vendor CodenVarChar150
58ARSCResource Master Data - Log14CardCodePreferred VendornVarChar150
59CRDCBP - Commnunication Mean1CardCodeBP CodenVarChar150
60OGRSG/L Account Advanced Rules for Resources54CardCodeCustomer/Vendor CodenVarChar150
61ORSCResources14CardCodePreferred VendornVarChar150
62OSWASpecific Withholding Amounts2CardCodeBP CodenVarChar150
63TCN2Tracking Note - Brokers3CardCodeBP CodenVarChar150
TOPInventory and Production
64AITMItems - History19CardCodePreferred VendornVarChar150
65AMRVInventory Revaluation - History30CardCodeCustomer/Vendor CodenVarChar150
66AQI1Inventory Opening Balance - Rows30CardCodePreferred VendornVarChar150
67AQR1Inventory Posting - Rows29CardCodePreferred VendornVarChar150
68ASP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
69ASP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
70ASPPSpecial Prices2CardCodeBP CodenVarChar150
71AWORProduction Order - History19CardCodeCustomer CodenVarChar150
72IOD1Inventory Opening Balance Draft - Rows30CardCodePreferred VendornVarChar150
73IPD1Inventory Posting Draft - Rows29CardCodePreferred VendornVarChar150
74IPF1Landed Costs - Rows25CardCodeVendor CodenVarChar150
75IQI1Inventory Opening Balance - Rows30CardCodePreferred VendornVarChar150
76IQR1Inventory Posting - Rows29CardCodePreferred VendornVarChar150
77OENTShipping Types8CardCodeBP CodenVarChar150
78OIGEGoods Issue13CardCodeExpense AccountnVarChar150
79OIGNGoods Receipt13CardCodeRevenue AccountnVarChar150
80OIPFLanded Costs5CardCodeVendor CodenVarChar150
81OITLInventory Transactions Log17CardCodeBP CodenVarChar150
82OITMItems19CardCodePreferred VendornVarChar150
83OMRVInventory Revaluation30CardCodeCustomer/Vendor CodenVarChar150
84OSPGSpecial Prices for Groups1CardCodeBP CodenVarChar150
85OSPPSpecial Prices2CardCodeBP CodenVarChar150
86OWKOProduction Instructions9CardCodeSold-to Party CodenVarChar150
87OWORProduction Order19CardCodeCustomer CodenVarChar150
88OWTQInventory Transfer Request13CardCodeCustomer/Vendor CodenVarChar150
89OWTRInventory Transfer13CardCodeCustomer/Vendor CodenVarChar150
90SITMItems19CardCodePreferred VendornVarChar150
91SPP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
92SPP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
93UITMItems19CardCodePreferred VendornVarChar150
94UWKOProduction Instructions9CardCodeSold-To-Party CodenVarChar150
95UWORProduction Order19CardCodeCustomer CodenVarChar150
96WOR2VProduction Order - Base4CardCodeCustomer CodenVarChar150
TOPMarketing Documents
97ADOCInvoice - History13CardCodeBP CodenVarChar150
98ATXITax Invoice - History10CardCodeCustomer CodenVarChar150
99DWZ1Dunning Wizard Array1 - BP Filter2CardCodeBP Card CodenVarChar150
100DWZ2Dunning Wizard Array 2-Invoice Filter2CardCodeBP Card CodenVarChar150
101DWZ3Dunning Wizard Array 3 - Recommended Service Invoice2CardCodeBP Card CodenVarChar150
102DWZ4Dunning Wizard Array 4-Paging Grid5CardCodeBP Card CodenVarChar150
103OCINA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
104OCPIA/P Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
105OCPVA/P Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
106OCSIA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
107OCSVA/R Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
108ODLNDelivery13CardCodeCustomer/Vendor CodenVarChar150
109ODPIA/R Down Payment13CardCodeCustomer/Vendor CodenVarChar150
110ODPOA/P Down Payment13CardCodeCustomer/Vendor CodenVarChar150
111ODRFDrafts13CardCodeBP CodenVarChar150
112OIEIIncoming Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
113OINVA/R Invoice13CardCodeCustomer/Vendor CodenVarChar150
114OOEIOutgoing Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
115OPCHA/P Invoice13CardCodeCustomer/Vendor CodenVarChar150
116OPDNGoods Receipt PO13CardCodeCustomer/Vendor CodenVarChar150
117OPORPurchase Order13CardCodeCustomer/Vendor CodenVarChar150
118OPQTPurchase Quotation13CardCodeCustomer/Vendor CodenVarChar150
119OPRQPurchase Request13CardCodeCustomer/Vendor CodenVarChar150
120OQUTSales Quotation13CardCodeCustomer/Vendor CodenVarChar150
121ORDNReturns13CardCodeCustomer/Vendor CodenVarChar150
122ORDRSales Order13CardCodeCustomer/Vendor CodenVarChar150
123ORINA/R Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
124ORPCA/P Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
125ORPDGoods Return13CardCodeCustomer/Vendor CodenVarChar150
126OSALOutgoing8CardCodeBP CodenVarChar150
127OTPIPurchase Tax Invoice10CardCodeCustomer CodenVarChar150
128OTRATransition8CardCodeBP CodenVarChar150
129OTSISales Tax Invoice10CardCodeCustomer CodenVarChar150
130OTXDTax Invoice Draft10CardCodeCustomer CodenVarChar150
131OVRTTax Invoice Report4CardCodeReceipt BP CodenVarChar150
TOPMRP
132ORCMRecommendation Data9CardCodePreferred VendornVarChar150
TOPReports
133AMD1Amout Differences Report Lines5CardCodeBP CodenVarChar150
134OAMDAmount Differences Report4CardCodeBP CodenVarChar150
135RDFLDocument Standards4CardCodeBP CodenVarChar150-1
136SRT2Korean Summary Report - Rows24CardCodeBP Code on OCRDnVarChar150
137TRB5Tax Report Wizard Reported Tax Sums3CardCodeVendor CodenVarChar150