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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

96 columns | Print definition?B1 9.3  | 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
72OPRRGoods Return Request76FinncPriodPosting PeriodInt110
73OQUTSales Quotation76FinncPriodPosting PeriodInt110
74ORDNReturns76FinncPriodPosting PeriodInt110
75ORDRSales Order76FinncPriodPosting PeriodInt110
76ORINA/R Credit Memo76FinncPriodPosting PeriodInt110
77ORPCA/P Credit Memo76FinncPriodPosting PeriodInt110
78ORPDGoods Return76FinncPriodPosting PeriodInt110
79ORRRReturn Request76FinncPriodPosting PeriodInt110
80OSFCSelf Credit Memo76FinncPriodPosting PeriodInt110
81OSFISelf Invoice76FinncPriodPosting PeriodInt110
82PCH1A/P Invoice - Rows78FinncPriodPosting PeriodInt110
83PDN1Goods Receipt PO - Rows78FinncPriodPosting PeriodInt110
84POR1Purchase Order - Rows78FinncPriodPosting PeriodInt110
85PQT1Purchase Quotation - Rows78FinncPriodPosting PeriodInt110
86PRQ1Purchase Request - Rows78FinncPriodPosting PeriodInt110
87PRR1A/P Return Request - Rows78FinncPriodPosting PeriodInt110
88QUT1Sales Quotation - Rows78FinncPriodPosting PeriodInt110
89RDN1Returns - Rows78FinncPriodPosting PeriodInt110
90RDR1Sales Order - Rows78FinncPriodPosting PeriodInt110
91RIN1A/R Credit Memo - Rows78FinncPriodPosting PeriodInt110
92RPC1A/P Credit Memo - Rows78FinncPriodPosting PeriodInt110
93RPD1Goods Return - Rows78FinncPriodPosting PeriodInt110
94RRR1A/R Return Request - Rows78FinncPriodPosting PeriodInt110
95SFC1Self Credit Memo - Rows78FinncPriodPosting PeriodInt110
96SFI1Self Invoice - Rows78FinncPriodPosting PeriodInt110