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

86 columns | Print definition?ERP 6.0  | OWN_INT_TYPE_CD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUY3_TX_OWNOVRRoyalty 2.0 - TX GLO/TAMU Owner Level Reporting Override7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
2OIUY6_WY_RPDTCRoyalty 2.0 - WY - Lease/Unit Report Detail - CA11OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
TOPBalancing
3OIUBL01_ADJBalancing Adjustments8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
4OIUBL01_ADJHBalancing Adjustments History8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
5OIUBL01_PBADOIPBA DOI11OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
6OIUBL_IMBMPMeasurement Point Imbalance7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
7OIUBL_IMBWCWell Completion Imbalance8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
8OIU_SB_SPEMP_TSpecial owner entitlements at MP level7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
9OIU_SB_SPEWC_TSpecial owner entitlements at WC level8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
TOPCheck Input
10OIUCI_DOC_CIREJContains VL/RD rejects to be reported to Check Input8OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
11OIUCI_JEIncoming Check Journalized. Temporary hold37OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
12OIUCI_SPC_DISTPurchaser DOI Cross Reference10OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
TOPCheck Write
13OIUCW_BA_WH_EXMPBusiness Associates exempt from State Withholding7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
14OIUCW_EXTDExtended Details from Payment Run7OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
15OIUCW_PAYMENTPayment Details from Payment Run27OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
TOPContractual Allocation
16OIUCA_OSPTermination Point Component Options for Selective Process.7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
TOPOwnership
17GHO_OWN_INTTYOwnership Interest Type2OWN_INT_TYPE_CDOwner Interest Typenvarchar20
18GHO_OWN_INTTY_TXOwnership Interest Type Text Table3OWN_INT_TYPE_CDOwner Interest Typenvarchar20
19OIUOW_DORHDO Owner Request History9OWN_INT_TYPE_CDTransferor participant interest typenvarchar20
20OIUOW_POWOwners on Pending Requests3OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
TOPProduction and Revenue Accounting
21OIUP_SB_ACTMPActual Owner Level CA results at MP's (PDM Shadow)9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
22OIUP_SB_ACTWCActual Owner Level CA results at WC's (PDM Shadow)10OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
23OIUP_SB_ENTMPMP level owner entitlements (PDM Shadow)13OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
24OIUP_SB_ENTWCWC level owner entitlements (PDM Shadow)14OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
25OIUP_SB_RNAWCResidue and NGL actual at a WC level (PDM Shadow)10OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
26OIUP_SB_RNEWCResidue and NGL entitlements at a WC level (PDM Shadow)10OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
27OIU_CM_PINTTYParticipant Interest Type (TBLRV006 & TBLRV035)1OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
28OIU_CM_PINTTY_TXParticipant Interest Type Description (TBLR006 & TBLR035)2OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
29OIU_DO_BRBearer Table4OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
30OIU_DO_BR_WKBearer Table4OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
31OIU_DO_DODivision of Interest Ownership7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
32OIU_DO_DOGRIDivision Order Gross Revenue Interest7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
33OIU_DO_DO_WKDivision of Interest Ownership Worktable7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
34OIU_DO_TRGRITract Gross Revenue Interest7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
35OIU_SB_ACTMPActual Owner Level Contractual Allocations results at MP's8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
36OIU_SB_ACTMP_TActual Owner Level Contractual Allocations results at MP's8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
37OIU_SB_ACTWCActual Owner Level Contractual Allocations results at WC's9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
38OIU_SB_ACTWC_TActual Owner Level Contractual Allocations results at WC's9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
39OIU_SB_AVDAvailability Detail5OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
40OIU_SB_ENTMPMP level owner entitlements12OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
41OIU_SB_ENTMP_TMP level owner entitlements12OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
42OIU_SB_ENTWCWC level owner entitlements13OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
43OIU_SB_ENTWC_TWC level owner entitlements13OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
44OIU_SB_MGDDMarketing Group Determination Detail4OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
45OIU_SB_MGOPMPMarketing Group Owner Percent MP11OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
46OIU_SB_MGOPMP_TMarketing Group Owner Percent MP11OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
47OIU_SB_MGOPWCMarketing Group Owner Percent WC12OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
48OIU_SB_MGOPWC_TMarketing Group Owner Percent WC12OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
49OIU_SB_OADOwner Availability Detail5OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
50OIU_SB_RNAMPResidue and NGL actual at a MP level8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
51OIU_SB_RNAMP_TTemporary Residue and NGL actual at a MP level8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
52OIU_SB_RNAWCResidue and NGL actual at a WC level9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
53OIU_SB_RNAWC_TTemporary Residue and NGL actual at a WC level9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
54OIU_SB_RNEMPResidue and NGL entitlements at a MP level8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
55OIU_SB_RNEMP_TTemporary Residue and NGL entitlements at a MP level8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
56OIU_SB_RNEWCResidue and NGL entitlements at a WC level9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
57OIU_SB_RNEWC_TTemporary Residue and NGL entitlements at a WC level9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
58OIU_SB_SPEMPSpecial owner entitlements at MP level7OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
59OIU_SB_SPEWCSpecial owner entitlements at WC level8OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
TOPRevenue
60OIUE2_JEINTFProc 2.0 - JE Interface Table38OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
61OIUH_CDEX_INTYPMapping Owner Interest type with CDEX Interest type1OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
62OIUH_RV_ARINTFPRA Journal Entries to A/R interface table36OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
63OIUH_RV_EXSLJournal Entry Expense Subledger Table13OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
64OIUH_RV_EXSL_HOil and Gas appl table13OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
65OIUH_RV_INSLJournal Entry Income Subledger Table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
66OIUH_RV_INSL_HOil and Gas appl table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
67OIUH_RV_JEJournal Entry42OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
68OIUH_RV_JEINTFPRA Journal Entries37OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
69OIUH_RV_LSSLJournal Entry Legal Suspense Subledger Table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
70OIUH_RV_LSSL_HOil and Gas appl table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
71OIUH_RV_MSSLJournal Entry Miscellaneous Subledger Table19OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
72OIUH_RV_MSSL_HOil and Gas appl table19OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
73OIUH_RV_OPSLJournal Entry Owner Payable Subledger Table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
74OIUH_RV_OPSL_HOil and Gas OPSL History Table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
75OIUH_RV_STSLJournal Entry Statistical Subledger Table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
76OIUH_RV_STSL_HOil and Gas appl table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
TOPRoyalty Reporting
77OIUH_TEMP_OPSLJournal Entry Owner Payable Subledger Table16OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
78OIUREP_XTRCT_ROYExtract Royaty Data for the current reporting period36OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20
TOPTax Reporting
79OIUX3_JEINTFTax Reporting - JE Interface Table46OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20
80OIUX6_WY_CAPRDTTax 2.0 - Wyoming Conservation CA PRA Detail Transactions11OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
81OIUX6_WY_CASTGTax 2.0 - Wyoming Conservation CA Transactions Staging10OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
82OIUX6_WY_CATXNTax 2.0 - Wyoming Conservation CA Transactions10OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
83OIUX7_WY_GSALESTax 2.0 - WYGP Sales10OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
84OIUX7_WY_GSALHSTTax 2.0 - WYGP Sales History9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
85OIUX7_WY_GSALTXNTax 2.0 - WYGP Sales9OWN_INT_TYPE_CDParticipant Interest Typenvarchar20
TOPValuation
86OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table39OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20