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
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
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
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OBOT10Bill Of Exchang Transaction
9OOCR9Loading Factors
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool

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