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

30 columns | Print definition?ERP 6.0  | PUN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX8Y_NM_MASTERTax 2.0 - NM - Master Data PPN12PUNTax 2.0 - NM - PUNnvarchar70
2OIUX8_NM_ASUE_DTTax 2.0 NM - Auto Suspend Exception Detail9PUNTax 2.0 - NM - PUNnvarchar70
3OIUX8_NM_ASU_DTTax 2.0 - NM - Auto Suspend Detail9PUNTax 2.0 - NM - PUNnvarchar70
4OIUX8_NM_JC_MSTTax 2.0 - NM - Jicarilla Credit Master2PUNTax 2.0 - NM - PUNnvarchar70
5OIUX8_NM_MASTERTax 2.0 - NM - Master Data11PUNTax 2.0 - NM - PUNnvarchar70
6OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History56PUNTax 2.0 - NM - PUNnvarchar70
7OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions56PUNTax 2.0 - NM - PUNnvarchar70
8OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions58PUNTax 2.0 - NM - PUNnvarchar70
9OIUX8_NM_RPDTTax 2.0 - NM - Report Detail6PUNTax 2.0 - NM - PUNnvarchar70
10OIUX8_NM_RPDT_HTax 2.0 - NM Tax Report Detail - State History6PUNTax 2.0 - NM - PUNnvarchar70
11OIUX8_NM_SOLEDTTax 2.0 - NM - Statute of Limitation Exception Detail3PUNTax 2.0 - NM - PUNnvarchar70
12OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History56PUNTax 2.0 - NM - PUNnvarchar70
13OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)56PUNTax 2.0 - NM - PUNnvarchar70
14OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions56PUNTax 2.0 - NM - PUNnvarchar70
TOPTax Reporting
15OIUX5Y_OK_MASTERTax 2.0 - Oklahoma Master Data PPN11PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
16OIUX5_OK_ASU_DTTax 2.0 - Oklahoma Auto Suspend Detail9PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
17OIUX5_OK_CONFLTax 2.0 - Oklahoma Exempt Decimal Conflict8PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
18OIUX5_OK_MASTERTax 2.0 - Oklahoma Master Data10PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
19OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History54PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
20OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions54PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
21OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions56PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
22OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count58PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
23OIUX5_OK_RPDTTax 2.0 - Oklahoma Gross Prod Report Detail8PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
24OIUX5_OK_SOLEDTTax 2.0 - Statute of Limitation Exception Detail3PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
25OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History54PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
26OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties56PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
27OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging54PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
28OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions54PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
29OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties56PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110
30OIUX5_OK_ZVOLTax 2.0 - Oklahoma Zero Volume Reporting Master3PUNTax 2.0 - Oklahoma Production Unit Numbernvarchar110