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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

95 columns | Print definition?ERP 6.0  | OWN_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUY3_TX_OWNOVRRoyalty 2.0 - TX GLO/TAMU Owner Level Reporting Override5OWN_NOBusiness Associatenvarchar60
2OIUY6_WY_RPDTCRoyalty 2.0 - WY - Lease/Unit Report Detail - CA10OWN_NOPRA ownernvarchar100
TOPBalancing
3OIUBL01_ADJBalancing Adjustments7OWN_NOPRA ownernvarchar100
4OIUBL01_ADJHBalancing Adjustments History7OWN_NOPRA ownernvarchar100
5OIUBL01_PBADOIPBA DOI10OWN_NOPRA ownernvarchar100
6OIUBL01_RPTPABalancing Permanent Report Adjustments3OWN_NOPRA ownernvarchar100
7OIUBL01_RPTPDBalancing Permanent Report Detail3OWN_NOPRA ownernvarchar100
8OIUBL_IMBMPMeasurement Point Imbalance6OWN_NOPRA ownernvarchar100
9OIUBL_IMBWCWell Completion Imbalance7OWN_NOPRA ownernvarchar100
10OIU_SB_SPEMP_TSpecial owner entitlements at MP level6OWN_NOPRA ownernvarchar100
11OIU_SB_SPEWC_TSpecial owner entitlements at WC level7OWN_NOPRA ownernvarchar100
TOPCheck Input
12OIUCI_CDEXDCDEX Detail3OWN_NOOwner Numbernvarchar120
13OIUCI_CDEXHCDEX Header3OWN_NOOwner Numbernvarchar120
14OIUCI_CDEX_REMXCDEX Remitter Xref3OWN_NOOwner Numbernvarchar120
15OIUCI_DOC_CIREJContains VL/RD rejects to be reported to Check Input6OWN_NOOwner Numbernvarchar60
16OIUCI_JEIncoming Check Journalized. Temporary hold30OWN_NOOwner Numbernvarchar60
17OIUCI_SPC_DISTPurchaser DOI Cross Reference8OWN_NOOwner Numbernvarchar60
TOPCheck Write
18OIUCW_EXTDExtended Details from Payment Run4OWN_NOOwner (Business Associate)nvarchar60
19OIUCW_OWNER_SEQOwner/Sequence List for Payment Runs4OWN_NOOwner (Business Associate)nvarchar60
20OIUCW_PAYMENTPayment Details from Payment Run4OWN_NOOwner (Business Associate)nvarchar60
21OIUCW_REJECTSPayments Not Made in the Run4OWN_NOOwner (Business Associate)nvarchar60
22OIU_CW_SUM_PAYSummarized Payable Table for Check Write3OWN_NOOwner (Business Associate)nvarchar60
TOPContractual Allocation
23OIUCA_OSPTermination Point Component Options for Selective Process.6OWN_NOPRA ownernvarchar100
TOPOwnership
24OIUOW_DORHDO Owner Request History8OWN_NOTransferor - ownernvarchar100
25OIUOW_POWOwners on Pending Requests2OWN_NOPRA ownernvarchar100
26OIUOW_PPOwnership Production Payment2OWN_NOPRA ownernvarchar100
TOPProduction and Revenue Accounting
27OIUP_SB_ACTMPActual Owner Level CA results at MP's (PDM Shadow)8OWN_NOPRA ownernvarchar100
28OIUP_SB_ACTWCActual Owner Level CA results at WC's (PDM Shadow)9OWN_NOPRA ownernvarchar100
29OIUP_SB_ENTMPMP level owner entitlements (PDM Shadow)12OWN_NOPRA ownernvarchar100
30OIUP_SB_ENTWCWC level owner entitlements (PDM Shadow)13OWN_NOPRA ownernvarchar100
31OIUP_SB_RNAWCResidue and NGL actual at a WC level (PDM Shadow)9OWN_NOPRA ownernvarchar100
32OIUP_SB_RNEWCResidue and NGL entitlements at a WC level (PDM Shadow)9OWN_NOPRA ownernvarchar100
33OIUREP_TIKBACKUPBackup tik table for old tax reporting SOL31OWN_NOPRA ownernvarchar100
34OIU_DO_BRBearer Table3OWN_NOPRA ownernvarchar100
35OIU_DO_BR_WKBearer Table3OWN_NOPRA ownernvarchar100
36OIU_DO_DODivision of Interest Ownership6OWN_NOPRA ownernvarchar100
37OIU_DO_DOGRIDivision Order Gross Revenue Interest6OWN_NOPRA ownernvarchar100
38OIU_DO_DO_WKDivision of Interest Ownership Worktable6OWN_NOPRA ownernvarchar100
39OIU_DO_TRGRITract Gross Revenue Interest6OWN_NOPRA ownernvarchar100
40OIU_SB_ACTMPActual Owner Level Contractual Allocations results at MP's7OWN_NOPRA ownernvarchar100
41OIU_SB_ACTMP_TActual Owner Level Contractual Allocations results at MP's7OWN_NOPRA ownernvarchar100
42OIU_SB_ACTWCActual Owner Level Contractual Allocations results at WC's8OWN_NOPRA ownernvarchar100
43OIU_SB_ACTWC_TActual Owner Level Contractual Allocations results at WC's8OWN_NOPRA ownernvarchar100
44OIU_SB_AVDAvailability Detail4OWN_NOPRA ownernvarchar100
45OIU_SB_ENTMPMP level owner entitlements11OWN_NOPRA ownernvarchar100
46OIU_SB_ENTMP_TMP level owner entitlements11OWN_NOPRA ownernvarchar100
47OIU_SB_ENTWCWC level owner entitlements12OWN_NOPRA ownernvarchar100
48OIU_SB_ENTWC_TWC level owner entitlements12OWN_NOPRA ownernvarchar100
49OIU_SB_MGDDMarketing Group Determination Detail3OWN_NOPRA ownernvarchar100
50OIU_SB_MGOPMPMarketing Group Owner Percent MP10OWN_NOPRA ownernvarchar100
51OIU_SB_MGOPMP_TMarketing Group Owner Percent MP10OWN_NOPRA ownernvarchar100
52OIU_SB_MGOPWCMarketing Group Owner Percent WC11OWN_NOPRA ownernvarchar100
53OIU_SB_MGOPWC_TMarketing Group Owner Percent WC11OWN_NOPRA ownernvarchar100
54OIU_SB_OADOwner Availability Detail4OWN_NOPRA ownernvarchar100
55OIU_SB_RNAMPResidue and NGL actual at a MP level7OWN_NOPRA ownernvarchar100
56OIU_SB_RNAMP_TTemporary Residue and NGL actual at a MP level7OWN_NOPRA ownernvarchar100
57OIU_SB_RNAWCResidue and NGL actual at a WC level8OWN_NOPRA ownernvarchar100
58OIU_SB_RNAWC_TTemporary Residue and NGL actual at a WC level8OWN_NOPRA ownernvarchar100
59OIU_SB_RNEMPResidue and NGL entitlements at a MP level7OWN_NOPRA ownernvarchar100
60OIU_SB_RNEMP_TTemporary Residue and NGL entitlements at a MP level7OWN_NOPRA ownernvarchar100
61OIU_SB_RNEWCResidue and NGL entitlements at a WC level8OWN_NOPRA ownernvarchar100
62OIU_SB_RNEWC_TTemporary Residue and NGL entitlements at a WC level8OWN_NOPRA ownernvarchar100
63OIU_SB_SPEMPSpecial owner entitlements at MP level6OWN_NOPRA ownernvarchar100
64OIU_SB_SPEWCSpecial owner entitlements at WC level7OWN_NOPRA ownernvarchar100
TOPRevenue
65OIUE1_LSSL_SUMLegal Suspense Summary2OWN_NOOwner Numbernvarchar60
66OIUE2_CW_REJECTSProc 2.0 - Check Write Rejects5OWN_NOOwner (Business Associate)nvarchar60
67OIUE2_ESCH_BAProc 2.0 - Escheat - BA2OWN_NOBusiness Associatenvarchar60
68OIUE2_ESCH_DTLProc 2.0 - Escheat - Owner Details3OWN_NOOwner Numbernvarchar60
69OIUE2_ESCH_DTLHProc 2.0 - Escheat - Owner Detail History3OWN_NOOwner Numbernvarchar60
70OIUE2_ESCH_RPDTPProc 2.0 - Escheat - Report Detail - Property4OWN_NOOwner Numbernvarchar60
71OIUE2_ESCH_SUMProc 2.0 - Escheat - Owner Summary3OWN_NOOwner Numbernvarchar60
72OIUE2_ESCH_SUMHProc 2.0 - Escheat - Owner Summary History3OWN_NOOwner Numbernvarchar60
73OIUE2_ESCROW_DTLProc 2.0 - WY Escrow - Owner Details3OWN_NOOwner Numbernvarchar60
74OIUE2_JEINTFProc 2.0 - JE Interface Table31OWN_NOOwner Numbernvarchar60
75OIUH_RV_ARINTFPRA Journal Entries to A/R interface table29OWN_NOOwner Numbernvarchar60
76OIUH_RV_JEINTFPRA Journal Entries30OWN_NOOwner Numbernvarchar60
TOPRoyalty Reporting
77OIUREPP_OWNERMMS-2014 - Owner PPA3OWN_NOPRA ownernvarchar100
78OIUREP_MMS_REJSMMS-2014 - Extraction Rejects27OWN_NOPRA ownernvarchar100
79OIUREP_OWNERMMS-2014 - Owner3OWN_NOPRA ownernvarchar100
80OIUREP_RECOUPMMS-2014 - Recoupable Balance4OWN_NOPRA ownernvarchar100
81OIUREP_RTPENDMMS-2014 - Royalty Transaction Pending26OWN_NOPRA ownernvarchar100
82OIUREP_RT_HISTMMS-2014 - Royalty Transaction (Pending) History26OWN_NOPRA ownernvarchar100
TOPTax Reporting
83OIUX3_JEINTFTax Reporting - JE Interface Table43OWN_NOOwner Numbernvarchar60
84OIUX6_WY_CAPRDTTax 2.0 - Wyoming Conservation CA PRA Detail Transactions10OWN_NOPRA ownernvarchar100
85OIUX6_WY_CASTGTax 2.0 - Wyoming Conservation CA Transactions Staging9OWN_NOPRA ownernvarchar100
86OIUX6_WY_CATXNTax 2.0 - Wyoming Conservation CA Transactions9OWN_NOPRA ownernvarchar100
87OIUX7_WY_GSALESTax 2.0 - WYGP Sales9OWN_NOPRA ownernvarchar100
88OIUX7_WY_GSALHSTTax 2.0 - WYGP Sales History8OWN_NOPRA ownernvarchar100
89OIUX7_WY_GSALTXNTax 2.0 - WYGP Sales8OWN_NOPRA ownernvarchar100
TOPValuation
90OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table32OWN_NOOwner Numbernvarchar60
91OIUVL_GSPGas Statement Profile8OWN_NOownernvarchar100
92OIUVL_MTAHMarketing Cost Tax Exemption - Header5OWN_NOPRA ownernvarchar100
93OIUVL_OSPOil Statement Profile8OWN_NOownernvarchar100
94OIUVL_RPADRoyalty Processing Allowance Detail4OWN_NOPRA ownernvarchar100
95OIUVL_TPAHTax Processing Allowance6OWN_NOPRA ownernvarchar100