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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

67 columns | Print definition?B1 9.3  | MODEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1NFN1Not a Fiscal Sequence19ModelNota Fiscal ModelnVarChar600
2NFN4Manual Nota Fiscal Number8ModelNota Fiscal ModelnVarChar60
3OPOSPOS Master Data2ModelModelnVarChar200
TOPInventory and Production
4IGE21Goods Issue - Document Reference Information14ModelFiscal Document ModelnVarChar60
5IGN21Goods Receipt - Document Reference Information14ModelFiscal Document ModelnVarChar60
6OIGEGoods Issue236ModelNota Fiscal ModelnVarChar600
7OIGNGoods Receipt236ModelNota Fiscal ModelnVarChar600
8OWTQInventory Transfer Request236ModelNota Fiscal ModelnVarChar600
9OWTRInventory Transfer236ModelNota Fiscal ModelnVarChar600
10WTQ21Inventory Transfer Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
11WTR21Inventory Transfer - Document Reference Information14ModelFiscal Document ModelnVarChar60
TOPMarketing Documents
12ADO21A/R Invoice - Document Reference Information - History14ModelFiscal Document ModelnVarChar60
13ADOCInvoice - History236ModelNota Fiscal ModelnVarChar600
14CIN21Correction Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
15CPI21A/P Correction Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
16CPV21A/P Correction Invoice Reversal - Document Reference Information14ModelFiscal Document ModelnVarChar60
17CSI21A/R Correction Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
18CSV21A/R Correction Invoice Reversal - Document Reference Information14ModelFiscal Document ModelnVarChar60
19DLN21Delivery - Document Reference Information14ModelFiscal Document ModelnVarChar60
20DPI21A/R Down Payment - Document Reference Information14ModelFiscal Document ModelnVarChar60
21DPO21A/P Down Payment - Document Reference Information14ModelFiscal Document ModelnVarChar60
22DRF21Draft - Document Reference Information14ModelFiscal Document ModelnVarChar60
23IEI21Incoming Excise Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
24INV21A/R Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
25OCINA/R Correction Invoice236ModelNota Fiscal ModelnVarChar600
26OCPIA/P Correction Invoice236ModelNota Fiscal ModelnVarChar600
27OCPVA/P Correction Invoice Reversal236ModelNota Fiscal ModelnVarChar600
28OCSIA/R Correction Invoice236ModelNota Fiscal ModelnVarChar600
29OCSVA/R Correction Invoice Reversal236ModelNota Fiscal ModelnVarChar600
30ODLNDelivery236ModelNota Fiscal ModelnVarChar600
31ODPIA/R Down Payment236ModelNota Fiscal ModelnVarChar600
32ODPOA/P Down Payment236ModelNota Fiscal ModelnVarChar600
33ODRFDrafts236ModelNota Fiscal ModelnVarChar600
34OEI21Outgoing Excise Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
35OIEIIncoming Excise Invoice236ModelNota Fiscal ModelnVarChar600
36OINVA/R Invoice236ModelNota Fiscal ModelnVarChar600
37OOEIOutgoing Excise Invoice236ModelNota Fiscal ModelnVarChar600
38OPCHA/P Invoice236ModelNota Fiscal ModelnVarChar600
39OPDNGoods Receipt PO236ModelNota Fiscal ModelnVarChar600
40OPORPurchase Order236ModelNota Fiscal ModelnVarChar600
41OPQTPurchase Quotation236ModelNota Fiscal ModelnVarChar600
42OPRQPurchase Request236ModelNota Fiscal ModelnVarChar600
43OPRRGoods Return Request236ModelNota Fiscal ModelnVarChar600
44OQUTSales Quotation236ModelNota Fiscal ModelnVarChar600
45ORDNReturns236ModelNota Fiscal ModelnVarChar600
46ORDRSales Order236ModelNota Fiscal ModelnVarChar600
47ORINA/R Credit Memo236ModelNota Fiscal ModelnVarChar600
48ORPCA/P Credit Memo236ModelNota Fiscal ModelnVarChar600
49ORPDGoods Return236ModelNota Fiscal ModelnVarChar600
50ORRRReturn Request236ModelNota Fiscal ModelnVarChar600
51OSFCSelf Credit Memo236ModelNota Fiscal ModelnVarChar600
52OSFISelf Invoice236ModelNota Fiscal ModelnVarChar600
53PCH21A/P Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60
54PDN21Goods Receipt PO - Document Reference Information14ModelFiscal Document ModelnVarChar60
55POR21Purchase Order - Document Reference Information14ModelFiscal Document ModelnVarChar60
56PQT21Purchase Quotation - Document Reference Information14ModelFiscal Document ModelnVarChar60
57PRQ21Purchase Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
58PRR21A/P Return Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
59QUT21Sales Quotation - Document Reference Information14ModelFiscal Document ModelnVarChar60
60RDN21Returns - Document Reference Information14ModelFiscal Document ModelnVarChar60
61RDR21Sales Order - Document Reference Information14ModelFiscal Document ModelnVarChar60
62RIN21A/R Credit Memo - Document Reference Information14ModelFiscal Document ModelnVarChar60
63RPC21A/P Credit Memo - Document Reference Information14ModelFiscal Document ModelnVarChar60
64RPD21Goods Return - Document Reference Information14ModelFiscal Document ModelnVarChar60
65RRR21A/R Return Request - Document Reference Information14ModelFiscal Document ModelnVarChar60
66SFC21Self Credit Memo - Document Reference Information14ModelFiscal Document ModelnVarChar60
67SFI21Self Invoice - Document Reference Information14ModelFiscal Document ModelnVarChar60