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

59 columns | Print definition?ERP 6.0  | OWN_ISQ_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUY3_TX_OWNOVRRoyalty 2.0 - TX GLO/TAMU Owner Level Reporting Override8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
2OIUY6_WY_RPDTCRoyalty 2.0 - WY - Lease/Unit Report Detail - CA12OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
TOPBalancing
3OIUBL01_ADJBalancing Adjustments9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
4OIUBL01_ADJHBalancing Adjustments History9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
5OIUBL01_PBADOIPBA DOI12OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
6OIUBL01_RPTPABalancing Permanent Report Adjustments4OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
7OIUBL01_RPTPDBalancing Permanent Report Detail4OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
8OIUBL_IMBMPMeasurement Point Imbalance8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
9OIUBL_IMBWCWell Completion Imbalance9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
10OIU_SB_SPEMP_TSpecial owner entitlements at MP level8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
11OIU_SB_SPEWC_TSpecial owner entitlements at WC level9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
TOPContractual Allocation
12OIUCA_OSPTermination Point Component Options for Selective Process.8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
TOPOwnership
13OIUOW_DORHDO Owner Request History10OWN_ISQ_NOTransferor owner interest sequence numbernvarchar20
14OIUOW_POWOwners on Pending Requests4OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
TOPProduction and Revenue Accounting
15OIUP_SB_ACTMPActual Owner Level CA results at MP's (PDM Shadow)10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
16OIUP_SB_ACTWCActual Owner Level CA results at WC's (PDM Shadow)11OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
17OIUP_SB_ENTMPMP level owner entitlements (PDM Shadow)14OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
18OIUP_SB_ENTWCWC level owner entitlements (PDM Shadow)15OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
19OIUP_SB_RNAWCResidue and NGL actual at a WC level (PDM Shadow)11OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
20OIUP_SB_RNEWCResidue and NGL entitlements at a WC level (PDM Shadow)11OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
21OIU_DO_BRBearer Table5OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
22OIU_DO_BR_WKBearer Table5OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
23OIU_DO_DODivision of Interest Ownership8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
24OIU_DO_DOGRIDivision Order Gross Revenue Interest8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
25OIU_DO_DO_WKDivision of Interest Ownership Worktable8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
26OIU_SB_ACTMPActual Owner Level Contractual Allocations results at MP's9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
27OIU_SB_ACTMP_TActual Owner Level Contractual Allocations results at MP's9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
28OIU_SB_ACTWCActual Owner Level Contractual Allocations results at WC's10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
29OIU_SB_ACTWC_TActual Owner Level Contractual Allocations results at WC's10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
30OIU_SB_AVDAvailability Detail6OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
31OIU_SB_ENTMPMP level owner entitlements13OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
32OIU_SB_ENTMP_TMP level owner entitlements13OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
33OIU_SB_ENTWCWC level owner entitlements14OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
34OIU_SB_ENTWC_TWC level owner entitlements14OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
35OIU_SB_MGDDMarketing Group Determination Detail5OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
36OIU_SB_MGOPMPMarketing Group Owner Percent MP12OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
37OIU_SB_MGOPMP_TMarketing Group Owner Percent MP12OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
38OIU_SB_MGOPWCMarketing Group Owner Percent WC13OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
39OIU_SB_MGOPWC_TMarketing Group Owner Percent WC13OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
40OIU_SB_OADOwner Availability Detail6OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
41OIU_SB_RNAMPResidue and NGL actual at a MP level9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
42OIU_SB_RNAMP_TTemporary Residue and NGL actual at a MP level9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
43OIU_SB_RNAWCResidue and NGL actual at a WC level10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
44OIU_SB_RNAWC_TTemporary Residue and NGL actual at a WC level10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
45OIU_SB_RNEMPResidue and NGL entitlements at a MP level9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
46OIU_SB_RNEMP_TTemporary Residue and NGL entitlements at a MP level9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
47OIU_SB_RNEWCResidue and NGL entitlements at a WC level10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
48OIU_SB_RNEWC_TTemporary Residue and NGL entitlements at a WC level10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
49OIU_SB_SPEMPSpecial owner entitlements at MP level8OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
50OIU_SB_SPEWCSpecial owner entitlements at WC level9OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
TOPRoyalty Reporting
51OIUREP_MMS_REJSMMS-2014 - Extraction Rejects28OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
52OIUREP_RTPENDMMS-2014 - Royalty Transaction Pending27OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
53OIUREP_RT_HISTMMS-2014 - Royalty Transaction (Pending) History27OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
TOPTax Reporting
54OIUX6_WY_CAPRDTTax 2.0 - Wyoming Conservation CA PRA Detail Transactions12OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
55OIUX6_WY_CASTGTax 2.0 - Wyoming Conservation CA Transactions Staging11OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
56OIUX6_WY_CATXNTax 2.0 - Wyoming Conservation CA Transactions11OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
57OIUX7_WY_GSALESTax 2.0 - WYGP Sales11OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
58OIUX7_WY_GSALHSTTax 2.0 - WYGP Sales History10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20
59OIUX7_WY_GSALTXNTax 2.0 - WYGP Sales10OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20