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

88 columns | Print definition?B1 9.2  | FINNCPRIOD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBanking
1ARCTIncoming Payment - History74FinncPriodPosting PeriodInt110
2ODPSDeposit38FinncPriodPosting PeriodInt110
3ODPTPostdated Deposit23FinncPriodPosting PeriodInt110
4OPDFPayment Draft74FinncPriodPosting PeriodInt110
5ORCTIncoming Payment74FinncPriodPosting PeriodInt110
6OVPMOutgoing Payments74FinncPriodPosting PeriodInt110
TOPFinance
7AFADAsset Document - History5FinncPriodPosting PeriodInt110
8AJD1Journal Entry - History - Rows36FinncPriodPosting PeriodInt110
9AJDTJournal Entry - History23FinncPriodPosting PeriodInt110
10BTF1Journal Voucher - Rows36FinncPriodPosting PeriodInt110
11JDT1Journal Entry - Rows36FinncPriodPosting PeriodInt110
12OACDCredit Memo5FinncPriodPosting PeriodInt110
13OACQCapitalization5FinncPriodPosting PeriodInt110
14OBTFJournal Voucher Entry23FinncPriodPosting PeriodInt110
15OFTRTransfer5FinncPriodPosting PeriodInt110
16OJDTJournal Entry23FinncPriodPosting PeriodInt110
17OMDPManual Depreciation5FinncPriodPosting PeriodInt110
18ORTIRetirement5FinncPriodPosting PeriodInt110
TOPInventory and Production
19AINCInventory Counting32FinncPriodPosting PeriodInt110
20AIQIInventory Opening Balance34FinncPriodPosting PeriodInt110
21AIQRInventory Posting37FinncPriodPosting PeriodInt110
22IGE1Goods Issue - Rows78FinncPriodPosting PeriodInt110
23IGN1Goods Receipt - Rows78FinncPriodPosting PeriodInt110
24OICDInventory Counting Draft32FinncPriodPosting PeriodInt110
25OIGEGoods Issue76FinncPriodPosting PeriodInt110
26OIGNGoods Receipt76FinncPriodPosting PeriodInt110
27OINCInventory Counting32FinncPriodPosting PeriodInt110
28OIODInventory Opening Balance Draft34FinncPriodPosting PeriodInt110
29OIPDInventory Posting Draft37FinncPriodPosting PeriodInt110
30OIQIInventory Opening Balance34FinncPriodPosting PeriodInt110
31OIQRInventory Posting37FinncPriodPosting PeriodInt110
32OMRLAdvanced Inventory Revaluation23FinncPriodPosting PeriodInt110
33OWKOProduction Instructions30FinncPriodPosting PeriodInt110
34OWTQInventory Transfer Request76FinncPriodPosting PeriodInt110
35OWTRInventory Transfer76FinncPriodPosting PeriodInt110
36UWKOProduction Instructions30FinncPriodPosting PeriodInt110
37UWKO1Production Instructions - Rows9FinncPriodPosting PeriodInt110
38WKO1Production Instructions - Rows9FinncPriodPosting PeriodInt110
39WTQ1Inventory Transfer Request - Rows78FinncPriodPosting PeriodInt110
40WTR1Inventory Transfer - Rows78FinncPriodPosting PeriodInt110
TOPMarketing Documents
41ADO1A/R Invoice (Rows) - History78FinncPriodPosting PeriodInt110
42ADOCInvoice - History76FinncPriodPosting PeriodInt110
43CIN1Correction Invoice - Rows78FinncPriodPosting PeriodInt110
44CPI1A/P Correction Invoice - Rows78FinncPriodPosting PeriodInt110
45CPV1A/P Correction Invoice Reversal - Rows78FinncPriodPosting PeriodInt110
46CSI1A/R Correction Invoice - Rows78FinncPriodPosting PeriodInt110
47CSV1A/R Correction Invoice Reversal - Rows78FinncPriodPosting PeriodInt110
48DLN1Delivery - Rows78FinncPriodPosting PeriodInt110
49DPI1A/R Down Payment - Rows78FinncPriodPosting PeriodInt110
50DPO1A/P Down Payment - Rows78FinncPriodPosting PeriodInt110
51DRF1Draft - Rows78FinncPriodPosting PeriodInt110
52IEI1Incoming Excise Invoice - Rows78FinncPriodPosting PeriodInt110
53INV1A/R Invoice - Rows78FinncPriodPosting PeriodInt110
54OCINA/R Correction Invoice76FinncPriodPosting PeriodInt110
55OCPIA/P Correction Invoice76FinncPriodPosting PeriodInt110
56OCPVA/P Correction Invoice Reversal76FinncPriodPosting PeriodInt110
57OCSIA/R Correction Invoice76FinncPriodPosting PeriodInt110
58OCSVA/R Correction Invoice Reversal76FinncPriodPosting PeriodInt110
59ODLNDelivery76FinncPriodPosting PeriodInt110
60ODPIA/R Down Payment76FinncPriodPosting PeriodInt110
61ODPOA/P Down Payment76FinncPriodPosting PeriodInt110
62ODRFDrafts76FinncPriodPosting PeriodInt110
63OEI1Outgoing Excise Invoice - Rows78FinncPriodPosting PeriodInt110
64OIEIIncoming Excise Invoice76FinncPriodPosting PeriodInt110
65OINVA/R Invoice76FinncPriodPosting PeriodInt110
66OOEIOutgoing Excise Invoice76FinncPriodPosting PeriodInt110
67OPCHA/P Invoice76FinncPriodPosting PeriodInt110
68OPDNGoods Receipt PO76FinncPriodPosting PeriodInt110
69OPORPurchase Order76FinncPriodPosting PeriodInt110
70OPQTPurchase Quotation76FinncPriodPosting PeriodInt110
71OPRQPurchase Request76FinncPriodPosting PeriodInt110
72OQUTSales Quotation76FinncPriodPosting PeriodInt110
73ORDNReturns76FinncPriodPosting PeriodInt110
74ORDRSales Order76FinncPriodPosting PeriodInt110
75ORINA/R Credit Memo76FinncPriodPosting PeriodInt110
76ORPCA/P Credit Memo76FinncPriodPosting PeriodInt110
77ORPDGoods Return76FinncPriodPosting PeriodInt110
78PCH1A/P Invoice - Rows78FinncPriodPosting PeriodInt110
79PDN1Goods Receipt PO - Rows78FinncPriodPosting PeriodInt110
80POR1Purchase Order - Rows78FinncPriodPosting PeriodInt110
81PQT1Purchase Quotation - Rows78FinncPriodPosting PeriodInt110
82PRQ1Purchase Request - Rows78FinncPriodPosting PeriodInt110
83QUT1Sales Quotation - Rows78FinncPriodPosting PeriodInt110
84RDN1Returns - Rows78FinncPriodPosting PeriodInt110
85RDR1Sales Order - Rows78FinncPriodPosting PeriodInt110
86RIN1A/R Credit Memo - Rows78FinncPriodPosting PeriodInt110
87RPC1A/P Credit Memo - Rows78FinncPriodPosting PeriodInt110
88RPD1Goods Return - Rows78FinncPriodPosting PeriodInt110