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

78 columns | Print definition?B1 9.3  | 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
54OPRRGoods Return Request103LicTradNumLicensed Dealer No.nVarChar320
55OQUTSales Quotation103LicTradNumLicensed Dealer No.nVarChar320
56ORDNReturns103LicTradNumLicensed Dealer No.nVarChar320
57ORDRSales Order103LicTradNumLicensed Dealer No.nVarChar320
58ORINA/R Credit Memo103LicTradNumLicensed Dealer No.nVarChar320
59ORPCA/P Credit Memo103LicTradNumLicensed Dealer No.nVarChar320
60ORPDGoods Return103LicTradNumLicensed Dealer No.nVarChar320
61ORRRReturn Request103LicTradNumLicensed Dealer No.nVarChar320
62OSFCSelf Credit Memo103LicTradNumLicensed Dealer No.nVarChar320
63OSFISelf Invoice103LicTradNumLicensed Dealer No.nVarChar320
64PCH1A/P Invoice - Rows261LicTradNumFederal Tax IDnVarChar320
65PDN1Goods Receipt PO - Rows261LicTradNumFederal Tax IDnVarChar320
66POR1Purchase Order - Rows261LicTradNumFederal Tax IDnVarChar320
67PQT1Purchase Quotation - Rows261LicTradNumFederal Tax IDnVarChar320
68PRQ1Purchase Request - Rows261LicTradNumFederal Tax IDnVarChar320
69PRR1A/P Return Request - Rows261LicTradNumFederal Tax IDnVarChar320
70QUT1Sales Quotation - Rows261LicTradNumFederal Tax IDnVarChar320
71RDN1Returns - Rows261LicTradNumFederal Tax IDnVarChar320
72RDR1Sales Order - Rows261LicTradNumFederal Tax IDnVarChar320
73RIN1A/R Credit Memo - Rows261LicTradNumFederal Tax IDnVarChar320
74RPC1A/P Credit Memo - Rows261LicTradNumFederal Tax IDnVarChar320
75RPD1Goods Return - Rows261LicTradNumFederal Tax IDnVarChar320
76RRR1A/R Return Request - Rows261LicTradNumFederal Tax IDnVarChar320
77SFC1Self Credit Memo - Rows261LicTradNumFederal Tax IDnVarChar320
78SFI1Self Invoice - Rows261LicTradNumFederal Tax IDnVarChar320