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

98 columns | Print definition?B1 8.8  | DOCNUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdministration
1DAR1Data Archive - Transaction Log4DocNumDocument NumberInt110
2DAR2Data Archive - Transaction Log5DocNumDocument NumberInt110
3DAR3Data Archive - Handwritten Documents5DocNumDocument NumberInt110
4OCCDCargo Customs Declaration Numbers4DocNumImp./Exp. Document NumbernVarChar200
5OSRLSerial Numbers4DocNumInvoice NumberInt110
TOPBanking
6ARC1Incoming Payment - Checks - History1DocNumDocument NumberInt110
7ARC2Incoming Payment - Invoices - History1DocNumDocument NumberInt110
8ARC3Credit Vouchers History1DocNumDocument No.Int110
9ARC4Incoming Payment - Account List - History1DocNumDocument NumberInt110
10ARC5Reciept log 1DocNumDocument No. - HistoryInt110
11ARC6Incoming Payments - WTax Rows - History1DocNumDocument NumberInt110
12ARC7Incoming Payments - Tax Amount per Document - History1DocNumDocument NumberInt110
13ARC8Incoming Payment - TDS Entries - History1DocNumDocument NumberInt110
14ARCTIncoming Payment - History2DocNumDocument NumberInt110
15BNK2Bank Statement - Recommendation List19DocNumDocument NumberInt110
16OBNKExternal Bank Statement Received20DocNumInvoice DocumentnVarChar270
17OPDFPayment Draft2DocNumDocument NumberInt110
18ORCTIncoming Payment2DocNumDocument NumberInt110
19OVPMOutgoing Payments2DocNumDocument NumberInt110
20PDF1Payment Draft - Checks1DocNumDocument NumberInt110
21PDF2Payment Draft - Invoices1DocNumDocument NumberInt110
22PDF3Payment Draft - Credit Vouchers1DocNumDocument No.Int110
23PDF4Payment Draft - Account List1DocNumDocument NumberInt110
24PDF5PaymentDraft - 1DocNumDocument NumberInt110
25PDF6Payment Drafts - Withholding Tax - Rows1DocNumDocument NumberInt110
26PDF7Payment Draft - Tax Amount per Document1DocNumDocument NumberInt110
27PDF8Payment Draft - TDS Entries1DocNumDocument NumberInt110
28PEX1Payment Results Table - Rows26DocNumDocument NumberInt110
29PMN5Payment - VAT Adjustment1DocNumDocument NumberInt110
30PMV8Incoming Payment - TDS Entries1DocNumDocument NumberInt110
31PWZ3Payment Wizard - Rows 312DocNumDocument NumberInt110
32RCC4Incoming Payment - Credit Vouchers1DocNumDocument NumberInt110
33RCT1Incoming Payment - Checks1DocNumDocument NumberInt110
34RCT2Incoming Payments - Invoices1DocNumDocument NumberInt110
35RCT3Incoming Pmt - Credit Vouchers1DocNumDocument No.Int110
36RCT4Incoming Payment - Account List1DocNumDocument NumberInt110
37RCT5Reciept vat adjustment1DocNumDocument NumberInt110
38RCT6Incoming Payments - WTax Rows1DocNumDocument NumberInt110
39RCT7Incoming Pmt - Tax Amount per Document1DocNumDocument NumberInt110
40RCT8Incoming Payment - TDS Entries1DocNumDocument NumberInt110
41TMP8Incoming Payment - TDS Entries1DocNumDocument NumberInt110
42VPM1Outgoing Payments - Check Rows1DocNumDocument NumberInt110
43VPM2Outgoing Payments - Invoices1DocNumDocument NumberInt110
44VPM3Outgoing Payments - Credit Vouchers1DocNumDocument No.Int110
45VPM4Outgoing Payments - Accounts1DocNumDocument NumberInt110
46VPM5Outgoing Payments - Vat Adjustment1DocNumDocument NumberInt110
47VPM6Outgoing Payments - WTax 1DocNumDocument NumberInt110
48VPM7Outgoing Payments - Tax Amount per Document1DocNumDocument NumberInt110
49VPM8Outgoing Payment - TDS Entries1DocNumDocument NumberInt110
TOPBusiness Partners
50OCLGActivities15DocNumLinked Document NumbernVarChar200
TOPFinance
51GBI7GBI Row 7 - Accounting Vouchers29DocNumDocument NumbernVarChar200
TOPInventory and Production
52AMRVInventory Revaluation - History2DocNumDocument NumberInt110
53AWORProduction Order - History2DocNumDocument NumberInt110
54OENTShipping Types2DocNumDocument NumberInt110
55OIGEGoods Issue2DocNumDocument NumberInt110
56OIGNGoods Receipt2DocNumDocument NumberInt110
57OIPFLanded Costs2DocNumDocument NumberInt110
58OITLInventory Transactions Log9DocNumDoc. NumberInt110
59OMRLAdvanced Inventory Revaluation2DocNumDocument NumberInt110
60OMRVInventory Revaluation2DocNumDocument NumberInt110
61OWORProduction Order2DocNumDocument NumberInt110
62OWTRInventory Transfer2DocNumDocument NumberInt110
63UWORProduction Order2DocNumDocument NumberInt110
TOPMarketing Documents
64ADOCInvoice - History2DocNumDocument NumberInt110
65ATXITax Invoice - History2DocNumDocument NumberInt110
66DWZ2Dunning Wizard Array 2-Invoice Filter10DocNumDoc. No.Int110
67MIN1Monthly Invoice Report Document Information3DocNumDocument NumberInt110
68MIN2Item Imformation of MI2DocNumDocument NumberInt110
69MIV1A/P Monthly Invoice - Document3DocNumDocument NumberInt110
70MIV2A/P Monthly Invoice - Item2DocNumDocument NumberInt110
71OCINA/R Correction Invoice2DocNumDocument NumberInt110
72OCPIA/P Correction Invoice2DocNumDocument NumberInt110
73OCPVA/P Correction Invoice Reversal2DocNumDocument NumberInt110
74OCSIA/R Correction Invoice2DocNumDocument NumberInt110
75OCSVA/R Correction Invoice Reversal2DocNumDocument NumberInt110
76ODLNDelivery2DocNumDocument NumberInt110
77ODPIA/R Down Payment2DocNumDocument NumberInt110
78ODPOA/P Down Payment2DocNumDocument NumberInt110
79ODRFDrafts2DocNumDocument NumberInt110
80OIEIIncoming Excise Invoice2DocNumDocument NumberInt110
81OINVA/R Invoice2DocNumDocument NumberInt110
82OOEIOutgoing Excise Invoice2DocNumDocument NumberInt110
83OPCHA/P Invoice2DocNumDocument NumberInt110
84OPDNGoods Receipt PO2DocNumDocument NumberInt110
85OPORPurchase Order2DocNumDocument NumberInt110
86OQUTSales Quotation2DocNumDocument NumberInt110
87ORDNReturns2DocNumDocument NumberInt110
88ORDRSales Order2DocNumDocument NumberInt110
89ORINA/R Credit Memo2DocNumDocument NumberInt110
90ORPCA/P Credit Memo2DocNumDocument NumberInt110
91ORPDGoods Return2DocNumDocument NumberInt110
92OSALOutgoing2DocNumDocument NumberInt110
93OTPIPurchase Tax Invoice2DocNumDocument NumberInt110
94OTRATransition2DocNumDocument NumberInt110
95OTSISales Tax Invoice2DocNumDocument NumberInt110
96OTXDTax Invoice Draft2DocNumDocument NumberInt110
TOPSales Opportunities
97OOPRSales Opportunity47DocNumLinked Document NumberInt110
TOPService
98OCTRService Contracts19DocNumSource DocumentInt110