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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

70 columns | Print definition?B1 9.2  | LICTRADNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBusiness Partners
1ACP1Campaign - BPs38LicTradNumFederal Tax IDnVarChar320
2ACR1Business Partner Addresses - History13LicTradNumFederal Tax IDnVarChar320
3ACRDBusiness Partners - History24LicTradNumFederal Tax IDnVarChar320
4CPN1Campaign - BPs38LicTradNumFederal Tax IDnVarChar320
5CRD1Business Partners - Addresses13LicTradNumFederal Tax IDnVarChar320
6OCRDBusiness Partner24LicTradNumFederal Tax IDnVarChar320
7TGG1Target Group Details27LicTradNumFederal Tax IDnVarChar320
TOPFinance
8AGARG/L Account Advanced Rules - History22LicTradNumFederal Tax IDnVarChar320!^|!^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID
9AJD1Journal Entry - History - Rows111LicTradNumFederal Tax IDnVarChar320
10BTF1Journal Voucher - Rows111LicTradNumFederal Tax IDnVarChar320
11JDT1Journal Entry - Rows111LicTradNumFederal Tax IDnVarChar320
12OGARG/L Account Advanced Rules22LicTradNumFederal Tax IDnVarChar320!^|!^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID
TOPGeneral
13AGRSG/L Account Advanced Rules for Resources - History22LicTradNumFederal Tax IDnVarChar320!^|!^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID
14OGRSG/L Account Advanced Rules for Resources22LicTradNumFederal Tax IDnVarChar320!^|!^|=All, !^|E=Empty, !^|F=Filled, Enter Tax ID=Enter Tax ID
TOPInventory and Production
15IGE1Goods Issue - Rows261LicTradNumFederal Tax IDnVarChar320
16IGN1Goods Receipt - Rows261LicTradNumFederal Tax IDnVarChar320
17OIGEGoods Issue103LicTradNumLicensed Dealer No.nVarChar320
18OIGNGoods Receipt103LicTradNumLicensed Dealer No.nVarChar320
19OWTQInventory Transfer Request103LicTradNumLicensed Dealer No.nVarChar320
20OWTRInventory Transfer103LicTradNumLicensed Dealer No.nVarChar320
21WTQ1Inventory Transfer Request - Rows261LicTradNumFederal Tax IDnVarChar320
22WTR1Inventory Transfer - Rows261LicTradNumFederal Tax IDnVarChar320
TOPMarketing Documents
23ADO1A/R Invoice (Rows) - History261LicTradNumFederal Tax IDnVarChar320
24ADOCInvoice - History103LicTradNumL.T. No.nVarChar320
25CIN1Correction Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
26CPI1A/P Correction Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
27CPV1A/P Correction Invoice Reversal - Rows261LicTradNumFederal Tax IDnVarChar320
28CSI1A/R Correction Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
29CSV1A/R Correction Invoice Reversal - Rows261LicTradNumFederal Tax IDnVarChar320
30DLN1Delivery - Rows261LicTradNumFederal Tax IDnVarChar320
31DPI1A/R Down Payment - Rows261LicTradNumFederal Tax IDnVarChar320
32DPO1A/P Down Payment - Rows261LicTradNumFederal Tax IDnVarChar320
33DRF1Draft - Rows261LicTradNumFederal Tax IDnVarChar320
34IEI1Incoming Excise Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
35INV1A/R Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
36OCINA/R Correction Invoice103LicTradNumLicensed Dealer No.nVarChar320
37OCPIA/P Correction Invoice103LicTradNumLicensed Dealer No.nVarChar320
38OCPVA/P Correction Invoice Reversal103LicTradNumLicensed Dealer No.nVarChar320
39OCSIA/R Correction Invoice103LicTradNumLicensed Dealer No.nVarChar320
40OCSVA/R Correction Invoice Reversal103LicTradNumLicensed Dealer No.nVarChar320
41ODLNDelivery103LicTradNumLicensed Dealer No.nVarChar320
42ODPIA/R Down Payment103LicTradNumLicensed Dealer No.nVarChar320
43ODPOA/P Down Payment103LicTradNumLicensed Dealer No.nVarChar320
44ODRFDrafts103LicTradNumLicensed Dealer No.nVarChar320
45OEI1Outgoing Excise Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
46OIEIIncoming Excise Invoice103LicTradNumLicensed Dealer No.nVarChar320
47OINVA/R Invoice103LicTradNumLicensed Dealer No.nVarChar320
48OOEIOutgoing Excise Invoice103LicTradNumLicensed Dealer No.nVarChar320
49OPCHA/P Invoice103LicTradNumLicensed Dealer No.nVarChar320
50OPDNGoods Receipt PO103LicTradNumLicensed Dealer No.nVarChar320
51OPORPurchase Order103LicTradNumLicensed Dealer No.nVarChar320
52OPQTPurchase Quotation103LicTradNumLicensed Dealer No.nVarChar320
53OPRQPurchase Request103LicTradNumLicensed Dealer No.nVarChar320
54OQUTSales Quotation103LicTradNumLicensed Dealer No.nVarChar320
55ORDNReturns103LicTradNumLicensed Dealer No.nVarChar320
56ORDRSales Order103LicTradNumLicensed Dealer No.nVarChar320
57ORINA/R Credit Memo103LicTradNumLicensed Dealer No.nVarChar320
58ORPCA/P Credit Memo103LicTradNumLicensed Dealer No.nVarChar320
59ORPDGoods Return103LicTradNumLicensed Dealer No.nVarChar320
60PCH1A/P Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
61PDN1Goods Receipt PO - Rows261LicTradNumFederal Tax IDnVarChar320
62POR1Purchase Order - Rows261LicTradNumFederal Tax IDnVarChar320
63PQT1Purchase Quotation - Rows261LicTradNumFederal Tax IDnVarChar320
64PRQ1Purchase Request - Rows261LicTradNumFederal Tax IDnVarChar320
65QUT1Sales Quotation - Rows261LicTradNumFederal Tax IDnVarChar320
66RDN1Returns - Rows261LicTradNumFederal Tax IDnVarChar320
67RDR1Sales Order - Rows261LicTradNumFederal Tax IDnVarChar320
68RIN1A/R Credit Memo - Rows261LicTradNumFederal Tax IDnVarChar320
69RPC1A/P Credit Memo - Rows261LicTradNumFederal Tax IDnVarChar320
70RPD1Goods Return - Rows261LicTradNumFederal Tax IDnVarChar320