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

54 columns | Print definition?ERP 6.0  | DUMMY_SEQ_FIELD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPProduction and Revenue Accounting
1OIUPH_RV_RJEJournal Entry (PDM Shadow)3DUMMY_SEQ_FIELDSystem numbernvarchar200
TOPRevenue
2OIUE2_RV_CRProc 2.0 - Check Register3DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
3OIUH_CM_ECOil and Gas appl table2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
4OIUH_CM_EMOil and Gas appl table1DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
5OIUH_CM_INSTLRevenue Installation Parameters2DUMMY_SEQ_FIELDSystem Numbernvarchar100
6OIUH_PR_WCAPOil and Gas appl table2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
7OIUH_RV_ACAccount Control2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
8OIUH_RV_BRBearer2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
9OIUH_RV_CCHObsolete (4.72)-keep for 1 minor release- Cdex Check History2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
10OIUH_RV_CHDDCheck Deduction Detail2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
11OIUH_RV_CNLCdex New Lease2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
12OIUH_RV_CRCheck Register2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
13OIUH_RV_DOACCDOI Owner Override Acct Codes2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
14OIUH_RV_DOHDOI Owner History2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
15OIUH_RV_DOIWCDOI / WC Cross Reference2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
16OIUH_RV_DPACCDOI Override Acct Codes2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
17OIUH_RV_DPPCDOI Product Processed Control2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
18OIUH_RV_DPPNDivision Order Prior Period Notification2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
19OIUH_RV_DPUCDOI Product Use Control2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
20OIUH_RV_DTWKDeduction/Tax Work Table2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
21OIUH_RV_ESCBAEscheated Business Associates2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
22OIUH_RV_EXTDRDI - Check Detail Subset2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
23OIUH_RV_FOTForeign Owner Tax Rates2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
24OIUH_RV_GRPGroup Number And Description2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
25OIUH_RV_IVSInvoice Selection2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
26OIUH_RV_MDOIMP/DOI Cross Reference2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
27OIUH_RV_MTADProducers Mkting Tax Exemption Allowance Detail2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
28OIUH_RV_MVTManual Void Check Transactions2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
29OIUH_RV_OICOwner Interest Calculations2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
30OIUH_RV_ONABOwners Negative Account Balance2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
31OIUH_RV_OSTAOwners State Tax Adjustments2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
32OIUH_RV_PACProperty Affiliated Company2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
33OIUH_RV_PRXPurchaser Remitter Cross Reference2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
34OIUH_RV_RDTLRoyalty Details2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
35OIUH_RV_RJEJournal Entry2DUMMY_SEQ_FIELDSystem numbernvarchar200
36OIUH_RV_ROYHNew Mexico Royalty History2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
37OIUH_RV_RPGHRoyalty Production Gas History2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
38OIUH_RV_RPOHRoyalty Production Oil History2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
39OIUH_RV_RTDRD DOI Transferee Detail2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
40OIUH_RV_RVHRpoyalty Reporting Value History2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
41OIUH_RV_SCDObsolete (4.72)-keep for 1 minor release - Suspended Check2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
42OIUH_RV_SSContract Spot Sale2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
43OIUH_RV_STRSeverence Tax Rates2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
44OIUH_RV_STSSeverence Tax Subsidiary2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
45OIUH_RV_STXRState Tax Rates2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
46OIUH_RV_TAXHANew Mexico Tax History For Affiliated Txns2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
47OIUH_RV_TAXHNNew Mexico Tax History For Non-Affiliated Txns2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
48OIUH_RV_TCDTax Calc Data2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
49OIUH_RV_TDTax Detail2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
50OIUH_RV_TEPTax Extract Profile2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
51OIUH_RV_THDRTax Header2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
52OIUH_RV_TPPNTr PPN2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
53OIUH_RV_TRTract Information2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100
54OIUH_RV_TRPTax And Royalty Profile2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100