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

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
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data

152 columns | Print definition?B1 9.1  | 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-
6OSRDBatches and Serial Numbers13CardCodeBP CodenVarChar150
7OSRLSerial Numbers3CardCodeCustomer CodenVarChar150
TOPBanking
8ABOEBill of Exchange for Payment - History17CardCodeBP CodenVarChar150
9ARCTIncoming Payment - History9CardCodeBP CodenVarChar150
10OBCGBank Charge for Bank Transfers1CardCodeBP CodenVarChar150
11OBNKExternal Bank Statement Received17CardCodeBP CodenVarChar150
12OBOEBill of Exchange for Payment17CardCodeBP CodenVarChar150
13OCHHCheck Register8CardCodeCustomer CodenVarChar150
14OCRHCredit Card Management25CardCodeCustomer CodenVarChar150
15OCRVCredit Payments19CardCodeCustomer CodenVarChar150
16OPDFPayment Draft9CardCodeCustomer/Vendor CodenVarChar150
17OPMNPayment9CardCodeCustomer/Vendor CodenVarChar150
18OPWBPWZ - Bank Account2CardCodeBP CodenVarChar150
19ORCTIncoming Payment9CardCodeCustomer/Vendor CodenVarChar150
20OVPMOutgoing Payments9CardCodeCustomer/Vendor CodenVarChar150
21PWZ1Payment Wizard - Rows 12CardCodeBP CodenVarChar150
22PWZ3Payment Wizard - Rows 33CardCodeVendor CodenVarChar150
23PWZ4Payment Wizard - Rows 43CardCodeVendor's Card codenVarChar150
24PWZ5Payment Wizard - Rows 54CardCodeCard CodenVarChar150
25RTW1Boleto Retorno Wizard: Import Table43CardCodeBoE BP CodenVarChar150
TOPBusiness Partners
26ACPRContact Persons - History2CardCodeBP CodenVarChar150
27ACR1Business Partner Addresses - History2CardCodeBP CodenVarChar150
28ACR2Bussiness Partners - Payment Methods-History1CardCodeBP CodenVarChar150
29ACR3Business Partner Control Accounts - History1CardCodeBP CodenVarChar150
30ACR4Allowed WTax Codes for BP - History1CardCodeBP CodenVarChar150
31ACR5BP Payment Dates1CardCodeBP CodenVarChar150
32ACR7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
33ACRBBusiness Partner Bank Accounts - History2CardCodeBP CodenVarChar150
34ACRDBusiness Partners - History1CardCodeBP CodenVarChar150
35CRD1Business Partners - Addresses2CardCodeBP CodenVarChar150
36CRD2Bussiness Partners - Payment Methods1CardCodeBP CodenVarChar150
37CRD3BP Control Account1CardCodeBP CodenVarChar150
38CRD4Allowed WTax Codes for BP1CardCodeBP CodenVarChar150
39CRD5BP Payment Dates1CardCodeBP CodenVarChar150
40CRD6BP's Payer Name1CardCodeBP CodenVarChar150
41CRD7Fiscal IDs for BP Master Data1CardCodeBP CodenVarChar250
42CRD8BP Branch Assignment1CardCodeBP CodenVarChar150
43CRD9OCRD Extension1CardCodeBP CodenVarChar250
44OCLGActivities2CardCodeBP CodenVarChar150
45OCPRContact Persons2CardCodeBP CodenVarChar150
46OCRBBP - Bank Account2CardCodeBP CodenVarChar150
47OCRDBusiness Partner1CardCodeBP CodenVarChar150
48ODDTWithholding Tax Deduction Hierarchy2CardCodeBP CodenVarChar150
49OSCNCustomer/Vendor Cat. No.2CardCodeBP CodenVarChar150
50OTBPTarget Group Business Partner1CardCodeBP CodenVarChar150
51TGG1Target Group Details2CardCodeBP CodenVarChar150
TOPFinance
52AGARG/L Account Advanced Rules - History81CardCodeCustomer/Vendor CodenVarChar150
53ISW1Reported Business Partners2CardCodeBusiness Partner CodenVarChar150
54ISW3Declaration Rows5CardCodeBusiness Partner CodenVarChar150
55OACMAccumulation2CardCodeCustomer/Vendor CodenVarChar150
56OGARG/L Account Advanced Rules81CardCodeCustomer/Vendor CodenVarChar150
57RTM2Rate Differences - SC Adjustment Rows3CardCodeBP CodenVarChar150
58VRW3VAT Reposting Wizard - Rows 32CardCodeCustomer/Vendor CodenVarChar150
TOPGeneral
59AGRSG/L Account Advanced Rules for Resources - History54CardCodeCustomer/Vendor CodenVarChar150
60ARSCResource Master Data - Log14CardCodePreferred VendornVarChar150
61L856856 Report - Record 607CardCodeBP CodenVarChar140
62OGRSG/L Account Advanced Rules for Resources54CardCodeCustomer/Vendor CodenVarChar150
63ORSCResource Master Data14CardCodePreferred VendornVarChar150
64PSARFrame for Sales Analysis Report1CardCodeBP CodenVarChar150
65RITLSnB Report Trans List9CardCodeBP CodenVarChar150
66TCN2Tracking Note - Brokers3CardCodeBP CodenVarChar150
67TDARTemp Data Archive27CardCodeCustomer/Vendor CodenVarChar150
TOPInventory and Production
68AIBTBatch No. for Item17CardCodeBP CodenVarChar150
69AITMItems - History19CardCodePreferred VendornVarChar150
70AMRVInventory Revaluation - History30CardCodeCustomer/Vendor CodenVarChar150
71AQI1Inventory Initial Qty Rows30CardCodePreferred VendornVarChar150
72AQR1Inventory Stock Posting (Reconcile) Lines29CardCodePreferred VendornVarChar150
73ASP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
74ASP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
75ASPPSpecial Prices2CardCodeBP CodenVarChar150
76AWORProduction Order - History19CardCodeCustomer CodenVarChar150
77IBT1Batch Number Transactions12CardCodeBP CodenVarChar150
78IOD1Inventory Initial Qty Draft Rows30CardCodePreferred VendornVarChar150
79IPD1Inventory Stock Posting Draft (Reconcile) Lines29CardCodePreferred VendornVarChar150
80IPF1Landed Costs - Rows25CardCodeVendor CodenVarChar150
81IQI1Inventory Initial Qty Rows30CardCodePreferred VendornVarChar150
82IQR1Inventory Stock Posting (Reconcile) Lines29CardCodePreferred VendornVarChar150
83ODIBBatch No. for Item Draft17CardCodeBP CodenVarChar150
84ODSRDraft Serial Numbers for Items20CardCodeBP CodenVarChar150
85OENTShipping Types8CardCodeBP CodenVarChar150
86OIBTBatch No. for Item17CardCodeBP CodenVarChar150
87OIGEGoods Issue13CardCodeExpense AccountnVarChar150
88OIGNGoods Receipt13CardCodeRevenue AccountnVarChar150
89OINMWhse Journal8CardCodeCustomer/Vendor CodenVarChar150
90OIPFLanded Costs5CardCodeVendor CodenVarChar150
91OITLInventory Transactions Log17CardCodeBP CodenVarChar150
92OITMItems19CardCodePreferred VendornVarChar150
93OMRVInventory Revaluation30CardCodeCustomer/Vendor CodenVarChar150
94OSPGSpecial Prices for Groups1CardCodeBP CodenVarChar150
95OSPPSpecial Prices2CardCodeBP CodenVarChar150
96OSRISerial Numbers for Items20CardCodeBP CodenVarChar150
97OWKOProduction Instructions9CardCodeSold-to Party CodenVarChar150
98OWORProduction Order19CardCodeCustomer CodenVarChar150
99OWTQInventory Transfer Request13CardCodeCustomer/Vendor CodenVarChar150
100OWTRInventory Transfer13CardCodeCustomer/Vendor CodenVarChar150
101SITMItems19CardCodePreferred VendornVarChar150
102SPP1Special Prices - Data Areas2CardCodeBP CodenVarChar150
103SPP2Special Prices - Quantity Areas2CardCodeBP CodenVarChar150
104SRI1Serial No. Trans. for Item10CardCodeBP CodenVarChar150
105UITMItems19CardCodePreferred VendornVarChar150
106UWKOProduction Instructions9CardCodeSold-To-Party CodenVarChar150
107UWORProduction Order19CardCodeCustomer CodenVarChar150
108WOR2VProduction Order - Base4CardCodeCustomer CodenVarChar150
TOPMarketing Documents
109ADOCInvoice - History13CardCodeBP CodenVarChar150
110ATXITax Invoice - History10CardCodeCustomer CodenVarChar150
111DWZ1Dunning Wizard Array1 - BP Filter2CardCodeBP Card CodenVarChar150
112DWZ2Dunning Wizard Array 2-Invoice Filter2CardCodeBP Card CodenVarChar150
113DWZ3Dunning Wizard Array 3 - Recommended Service Invoice2CardCodeBP Card CodenVarChar150
114DWZ4Dunning Wizard Array 4-Paging Grid5CardCodeBP Card CodenVarChar150
115OCINA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
116OCPIA/P Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
117OCPVA/P Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
118OCSIA/R Correction Invoice13CardCodeCustomer/Vendor CodenVarChar150
119OCSVA/R Correction Invoice Reversal13CardCodeCustomer/Vendor CodenVarChar150
120ODLNDelivery13CardCodeCustomer/Vendor CodenVarChar150
121ODOCMarketing Documents13CardCodeCustomer/Vendor CodenVarChar150
122ODPIA/R Down Payment13CardCodeCustomer/Vendor CodenVarChar150
123ODPOA/P Down Payment13CardCodeCustomer/Vendor CodenVarChar150
124ODRFDrafts13CardCodeBP CodenVarChar150
125OIEIIncoming Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
126OINVA/R Invoice13CardCodeCustomer/Vendor CodenVarChar150
127OOEIOutgoing Excise Invoice13CardCodeCustomer/Vendor CodenVarChar150
128OPCHA/P Invoice13CardCodeCustomer/Vendor CodenVarChar150
129OPDNGoods Receipt PO13CardCodeCustomer/Vendor CodenVarChar150
130OPORPurchase Order13CardCodeCustomer/Vendor CodenVarChar150
131OPQTPurchase Quotation13CardCodeCustomer/Vendor CodenVarChar150
132OPRQPurchase Request13CardCodeCustomer/Vendor CodenVarChar150
133OQUTSales Quotation13CardCodeCustomer/Vendor CodenVarChar150
134ORDNReturns13CardCodeCustomer/Vendor CodenVarChar150
135ORDRSales Order13CardCodeCustomer/Vendor CodenVarChar150
136ORINA/R Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
137ORPCA/P Credit Memo13CardCodeCustomer/Vendor CodenVarChar150
138ORPDGoods Return13CardCodeCustomer/Vendor CodenVarChar150
139OSALOutgoing8CardCodeBP CodenVarChar150
140OTPIPurchase Tax Invoice10CardCodeCustomer CodenVarChar150
141OTRATransition8CardCodeBP CodenVarChar150
142OTSISales Tax Invoice10CardCodeCustomer CodenVarChar150
143OTXDTax Invoice Draft10CardCodeCustomer CodenVarChar150
144OVRTTax Invoice Report4CardCodeReceipt BP CodenVarChar150
TOPMRP
145ORCMRecommendation Data9CardCodePreferred VendornVarChar150
TOPReports
146AMD1Amout Differences Report Lines5CardCodeBP CodenVarChar150
147OAMDAmount Differences Report4CardCodeBP CodenVarChar150
148RDFLDocument Standards4CardCodeBP CodenVarChar150-1
149SRT2Korean Summary Report - Rows24CardCodeBP Code on OCRDnVarChar150
150TRB5Tax Report Wizard Reported Tax Sums3CardCodeVendor CodenVarChar150
TOPSales Opportunities
151AOPRSales Opportunity2CardCodeBP CodenVarChar150
152OOPRSales Opportunity2CardCodeBP CodenVarChar150