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

46 columns | Print definition?ERP 6.0  | RPT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX8Y_NM_MASTERTax 2.0 - NM - Master Data PPN2RPT_IDReport IDnvarchar100
2OIUX8_NM_ASUE_HDTax 2.0 NM - Auto Suspend Exception Header4RPT_IDReport IDnvarchar100
3OIUX8_NM_ASU_HDTax 2.0 - NM - Auto Suspend Header4RPT_IDReport IDnvarchar100
4OIUX8_NM_MASTERTax 2.0 - NM - Master Data2RPT_IDReport IDnvarchar100
5OIUX8_NM_SOLEHDTax 2.0 - NM - Statute of Limitation Exception Header4RPT_IDReport IDnvarchar100
6OIUY3Y_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data PPN2RPT_IDReport IDnvarchar100
7OIUY3Y_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master PPN2RPT_IDReport IDnvarchar100
8OIUY3_TX_ASU_HDRoyalty 2.0 - TX GLO/TAMU - Auto Suspend Header4RPT_IDReport IDnvarchar100
9OIUY3_TX_CTRLRoyalty 2.0 - TX GLO/TAMU Reporting Control Record Master2RPT_IDReport IDnvarchar100
10OIUY3_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data2RPT_IDReport IDnvarchar100
11OIUY3_TX_PDCXRFRoyalty 2.0 - TX GLO/TAMU - Production Disposition XRef2RPT_IDReport IDnvarchar100
12OIUY3_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master2RPT_IDReport IDnvarchar100
13OIUY3_TX_SOLRoyalty 2.0 - Texas GLO Statute of Limitation4RPT_IDReport IDnvarchar100
14OIUY3_TX_SOLEHDRoyalty 2.0 - TX GLO/TAMU SOL Exception Header4RPT_IDReport IDnvarchar100
15OIUY6Y_WY_MASTERRoyalty 2.0 - WY - Master Data PPN2RPT_IDReport IDnvarchar100
16OIUY6_WY_ASU_HDRoyalty 2.0 - WY - Auto Suspend Header4RPT_IDReport IDnvarchar100
17OIUY6_WY_MASTERRoyalty 2.0 - WY - Master Data2RPT_IDReport IDnvarchar100
18OIUY6_WY_PRICERoyalty 2.0 - WY - Report Pricing2RPT_IDReport IDnvarchar100
19OIUY6_WY_RPDTMRoyalty 2.0 - WY - Lease/Unit Report Detail - Masters6RPT_IDReport IDnvarchar100
20OIUY6_WY_SOLRoyalty 2.0 - Wyoming Statute of Limitation4RPT_IDReport IDnvarchar100
21OIUY6_WY_SOLEHDRoyalty 2.0 - WY Statute of Limitation Exception Header4RPT_IDReport IDnvarchar100
22OIUY6_WY_ZVOLRoyalty 2.0 - WY - Zero Volume Master2RPT_IDReport IDnvarchar100
23OIUYC_BA_RPTIDRoyalty 2.0 - Report ID Owner Cross Reference2RPT_IDReport IDnvarchar100
24OIUYC_OVR_MASTEROverride master - Pass Exception data to Royalty loaders2RPT_IDReport IDnvarchar100
TOPTax Reporting
25OIUX3Y_TX_MASTERTax Reporting - Texas Master Data PPN2RPT_IDReport IDnvarchar100
26OIUX3Y_TX_MSTOVRTax Reporting - Texas Master Data Overrides2RPT_IDReport IDnvarchar100
27OIUX3_MIG_GRPRXTax Reporting - Migration Group Report XRef3RPT_IDReport IDnvarchar100
28OIUX3_RPTTax Reporting - Reports2RPT_IDReport IDnvarchar100
29OIUX3_RPT_COMPTax Reporting - Reporting Company3RPT_IDReport IDnvarchar100
30OIUX3_RPT_COMPTTax Reporting - Reporting Company Text4RPT_IDReport IDnvarchar100
31OIUX3_RPT_COMPXTax Reporting - Reporting Company XRef3RPT_IDReport IDnvarchar100
32OIUX3_RPT_CONFTax Reporting - Report Specific Configuration2RPT_IDReport IDnvarchar100
33OIUX3_RPT_CONFDTax Reporting - Report Specific Configuration (Dated)2RPT_IDReport IDnvarchar100
34OIUX3_RPT_PROFTax Reporting - Reporting Profile3RPT_IDReport IDnvarchar100
35OIUX3_RPT_STEPXTax Reporting - Reporting/Step XRef2RPT_IDReport IDnvarchar100
36OIUX3_RPT_TXTax Reporting - Reports3RPT_IDReport IDnvarchar100
37OIUX3_RUN_HDRTax Reporting - Run Header3RPT_IDReport IDnvarchar100
38OIUX3_STEPX_STTax Reporting - Step Prerequisite Status2RPT_IDReport IDnvarchar100
39OIUX3_TX_ASU_HDTax Reporting - Auto Suspend Header4RPT_IDReport IDnvarchar100
40OIUX3_TX_MASTERTax Reporting - Texas Master Data2RPT_IDReport IDnvarchar100
41OIUX3_TX_MSTOVRTax Reporting - Texas Master Data Overrides2RPT_IDReport IDnvarchar100
42OIUX3_TX_SOLTax Reporting - Statute of Limitation4RPT_IDReport IDnvarchar100
43OIUX3_TX_SOLEHDTax Reporting - Statute of Limitation Exception Header4RPT_IDReport IDnvarchar100
44OIUX6_WY_SOLTax 2.0 - Wyoming Statute of Limitation4RPT_IDReport IDnvarchar100
45OIUX6_WY_SOLEHDTax 2.0 - Wyoming Statute of Limitation Exception Header4RPT_IDReport IDnvarchar100
46OIUXC_RPT_PPTax 2.0 - Report Specific Parallel Processing Config2RPT_IDReport IDnvarchar100