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

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