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

61 columns | Print definition?ERP 6.0  | MASTER_LEVEL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History58MASTER_LEVELTexas Master Data Levelnvarchar10
2OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions58MASTER_LEVELTexas Master Data Levelnvarchar10
3OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions60MASTER_LEVELTexas Master Data Levelnvarchar10
4OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History58MASTER_LEVELTexas Master Data Levelnvarchar10
5OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)58MASTER_LEVELTexas Master Data Levelnvarchar10
6OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions58MASTER_LEVELTexas Master Data Levelnvarchar10
7OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging45MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
8OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface45MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
9OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist42MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
10OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions42MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
11OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details44MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
12OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)45MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
13OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History42MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
14OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)43MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
15OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)42MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
16OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions42MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
17OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)43MASTER_LEVELRoyalty 2.0 - TX GLO - Master Levelnvarchar10
18OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)59MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
19OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface59MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
20OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist56MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
21OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions56MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
22OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details58MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
23OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)59MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
24OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History56MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
25OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)57MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
26OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)56MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
27OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions56MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
28OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)57MASTER_LEVELRoyalty 2.0 - WY - Master Levelnvarchar10
TOPTax Reporting
29OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History40MASTER_LEVELTexas Master Data Levelnvarchar10
30OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions40MASTER_LEVELTexas Master Data Levelnvarchar10
31OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below41MASTER_LEVELTexas Master Data Levelnvarchar10
32OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental41MASTER_LEVELTexas Master Data Levelnvarchar10
33OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax41MASTER_LEVELTexas Master Data Levelnvarchar10
34OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions40MASTER_LEVELTexas Master Data Levelnvarchar10
35OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging40MASTER_LEVELTexas Master Data Levelnvarchar10
36OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions40MASTER_LEVELTexas Master Data Levelnvarchar10
37OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History60MASTER_LEVELTax 2.0 - Master Levelnvarchar10
38OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions60MASTER_LEVELTax 2.0 - Master Levelnvarchar10
39OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions62MASTER_LEVELTax 2.0 - Master Levelnvarchar10
40OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count64MASTER_LEVELTax 2.0 - Master Levelnvarchar10
41OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History60MASTER_LEVELTax 2.0 - Master Levelnvarchar10
42OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties62MASTER_LEVELTax 2.0 - Master Levelnvarchar10
43OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging60MASTER_LEVELTax 2.0 - Master Levelnvarchar10
44OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions60MASTER_LEVELTax 2.0 - Master Levelnvarchar10
45OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties62MASTER_LEVELTax 2.0 - Master Levelnvarchar10
46OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist39MASTER_LEVELTexas Master Data Levelnvarchar10
47OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions39MASTER_LEVELTexas Master Data Levelnvarchar10
48OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions41MASTER_LEVELTexas Master Data Levelnvarchar10
49OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History39MASTER_LEVELTexas Master Data Levelnvarchar10
50OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging39MASTER_LEVELTexas Master Data Levelnvarchar10
51OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions39MASTER_LEVELTexas Master Data Levelnvarchar10
52OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging59MASTER_LEVELTexas Master Data Levelnvarchar10
53OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions59MASTER_LEVELTexas Master Data Levelnvarchar10
54OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History59MASTER_LEVELTexas Master Data Levelnvarchar10
55OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions59MASTER_LEVELTexas Master Data Levelnvarchar10
56OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions61MASTER_LEVELTexas Master Data Levelnvarchar10
57OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History59MASTER_LEVELTexas Master Data Levelnvarchar10
58OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging59MASTER_LEVELTexas Master Data Levelnvarchar10
59OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions59MASTER_LEVELTexas Master Data Levelnvarchar10
60OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions59MASTER_LEVELTexas Master Data Levelnvarchar10
61OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History58MASTER_LEVELTexas Master Data Levelnvarchar10