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

136 tablesERP 6.0 

Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Reporting :: Royalty Reporting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUH_TEMP_GL421Journal Entry General Ledger TableRoyalty Reporting
2ERP EHP76.0OIUH_TEMP_OPSL521Journal Entry Owner Payable Subledger TableRoyalty Reporting
3ERP EHP76.0OIUREPP_LEASE191MMS-2014 - Lease PPARoyalty Reporting
4ERP EHP76.0OIUREPP_OWNER131MMS-2014 - Owner PPARoyalty Reporting
5ERP EHP76.0OIUREPP_PRPAYXRF141MMS-2014 - Property / Payor XRef PPARoyalty Reporting
6ERP EHP76.0OIUREPP_SALETYPE201MMS-2014 - Sales Type PPARoyalty Reporting
7ERP EHP76.0OIUREPP_WCPAYXRF131MMS-2014 - Well Completion / Payor XRef PPARoyalty Reporting
8ERP EHP76.0OIUREP_2014_CONF31MMS-2014: Configurable ItemsRoyalty Reporting
9ERP EHP76.0OIUREP_2014_INFO301MMS-2014 - Report Executions Start informationRoyalty Reporting
10ERP EHP76.0OIUREP_2014_REP531MMS-2014 - Supplemental Reports From Report ExecutionsRoyalty Reporting
11ERP EHP76.0OIUREP_2014_RUNS242MMS-2014 - Report ExecutionsRoyalty Reporting
12ERP EHP76.0OIUREP_ACTIVATE71Reg./Tax and Royalty Reporting - report activationRoyalty Reporting
13ERP EHP76.0OIUREP_ADD_DATA91Regulatory Reporting Config for Additional Master DataRoyalty Reporting
14ERP EHP76.0OIUREP_ADJCD_XRF31MMS-2014 - Reversal Rsn to Adjustment Reason Code XREFRoyalty Reporting
15ERP EHP76.0OIUREP_ADJ_DTLA221MMS OGOR A Adjustment Detail RecordRoyalty Reporting
16ERP EHP76.0OIUREP_ADJ_DTLB211MMS OGOR B Adjustment Detail RecordRoyalty Reporting
17ERP EHP76.0OIUREP_ADJ_DTLC231MMS OGOR C Adjustment Detail RecordRoyalty Reporting
18ERP EHP76.0OIUREP_ADJ_HDR201Adjustment Header for MMS OGORRoyalty Reporting
19ERP EHP76.0OIUREP_ADJ_PASR191MMS PASR Adjustment Detail RecordRoyalty Reporting
20ERP EHP76.0OIUREP_ADJ_PASRH221MMS PASR Adjustment Header RecordRoyalty Reporting
21ERP EHP76.0OIUREP_AGENCIES31Regulatory Reporting AgenciesRoyalty Reporting
22ERP EHP76.0OIUREP_AGENCYTX31Regulatory Reporting AgenciesRoyalty Reporting
23ERP EHP76.0OIUREP_AGY_LSE291Agency assigned LeasesRoyalty Reporting
24ERP EHP76.0OIUREP_AGY_LSETX51Text Table for Agency assigned LeasesRoyalty Reporting
25ERP EHP76.0OIUREP_AGY_PCDTX41Agency defined Product Code TextRoyalty Reporting
26ERP EHP76.0OIUREP_AGY_PDCD91Agency defined Product CodeRoyalty Reporting
27ERP EHP76.0OIUREP_AGY_VLTP41Agency defined Volume TypesRoyalty Reporting
28ERP EHP76.0OIUREP_AGY_VTPTX41Text table for Agency defined Volume TypeRoyalty Reporting
29ERP EHP76.0OIUREP_AMND_STAT91Report Execution statistics for amended monthsRoyalty Reporting
30ERP EHP76.0OIUREP_BA_MASTER91Regulatory reporting: BA table to drive Partner reportingRoyalty Reporting
31ERP EHP76.0OIUREP_CM_JIL31Activate JIL control tableRoyalty Reporting
32ERP EHP76.0OIUREP_CODE_CMLB71Regulatory Reporting Common Table List Box SetupRoyalty Reporting
33ERP EHP76.0OIUREP_CODE_COMA101Common table to convert SAP codes to Ag. codes Apl.TableRoyalty Reporting
34ERP EHP76.0OIUREP_CODE_COMN101Common table for converting SAP codes to Agency codesRoyalty Reporting
35ERP EHP76.0OIUREP_CODE_FLDS41Fields available for customizingRoyalty Reporting
36ERP EHP76.0OIUREP_CODE_FLDT61Descriptions for Code FieldsRoyalty Reporting
37ERP EHP76.0OIUREP_CODE_RDNG111Reg Reporting Rounding ConfigurationRoyalty Reporting
38ERP EHP76.0OIUREP_CODE_RPTC41Report Columns available for customizingRoyalty Reporting
39ERP EHP76.0OIUREP_CODE_RULE101Reg Reporting Rules for Column DataRoyalty Reporting
40ERP EHP76.0OIUREP_CODE_VALS51Code Values available for customizing Reg ReportingRoyalty Reporting
41ERP EHP76.0OIUREP_CODE_VLTX71Code Value TextsRoyalty Reporting
42ERP EHP76.0OIUREP_CODE_XREF191Reg Reporting Product/Volume Type to Report Code Cross RefRoyalty Reporting
43ERP EHP76.0OIUREP_COMN_KEYS61Reg.Reporting - Field description for COMN table keysRoyalty Reporting
44ERP EHP76.0OIUREP_DD_STRUCT61Master DD file structuresRoyalty Reporting
45ERP EHP76.0OIUREP_DN_XREF61Regulatory Reporting X-ref for Delivery NetworksRoyalty Reporting
46ERP EHP76.0OIUREP_EXEC_COMB171Possible Combinations of Royalty ExecutionsRoyalty Reporting
47ERP EHP76.0OIUREP_EXEC_STAT252Report Execution StatisticsRoyalty Reporting
48ERP EHP76.0OIUREP_EXT_COMP31External Company by State AgencyRoyalty Reporting
49ERP EHP76.0OIUREP_EXT_COMTX51Text Table for External Company CodeRoyalty Reporting
50ERP EHP76.0OIUREP_FEDINDIAN31MMS-2014 - Federal or Indian LeasesRoyalty Reporting
51ERP EHP76.0OIUREP_FIELDS151Regulatory Report Master Data set upRoyalty Reporting
52ERP EHP76.0OIUREP_FIELDSTX71Regulatory Report Master Data set upRoyalty Reporting
53ERP EHP76.0OIUREP_FIN_LEVEL81Regulatory Reporting Operator and Contact XrefRoyalty Reporting
54ERP EHP76.0OIUREP_GEN_DATA161Reg. Reporting - Generic Transactional dataRoyalty Reporting
55ERP EHP76.0OIUREP_HISTCNTRL71Regulatory Reporting History Control tableRoyalty Reporting
56ERP EHP76.0OIUREP_INDIAN_TR31MMS-2014 - Indian TribesRoyalty Reporting
57ERP EHP76.0OIUREP_KEY_XREFD71Regulatory Reporting SAP Key Cross Reference DetailRoyalty Reporting
58ERP EHP76.0OIUREP_KEY_XREFH71Regulatory Reporting SAP Key Cross Reference HeaderRoyalty Reporting
59ERP EHP76.0OIUREP_LEASE192MMS-2014 - LeaseRoyalty Reporting
60ERP EHP76.0OIUREP_LGL_RPTS261Legal Reports for Tax and Royalty ReportingRoyalty Reporting
61ERP EHP76.0OIUREP_LGL_RPTTX31Text Table for Legal Reports (Tax and Royalty)Royalty Reporting
62ERP EHP76.0OIUREP_MASTER811Regulatory Reporting Master DataRoyalty Reporting
63ERP EHP76.0OIUREP_MASTER_MP271Re.Reporting - MP related Reg IDRoyalty Reporting
64ERP EHP76.0OIUREP_MASTER_OV41RegID Split table (e.g. MMS Override Group split)Royalty Reporting
65ERP EHP76.0OIUREP_MASTER_PC41RegID Split table (e.g. LA Parish split)Royalty Reporting
66ERP EHP76.0OIUREP_MMS_ACTN41MMS Well Status Reason Code/Action Code Combos (OGOR-A)Royalty Reporting
67ERP EHP76.0OIUREP_MMS_DTEDT41MMS-2014 Edit Effective Date TableRoyalty Reporting
68ERP EHP76.0OIUREP_MMS_REAS41MMS Well Status / Reason Code Combinations (OGOR-A)Royalty Reporting
69ERP EHP76.0OIUREP_MMS_REJS951MMS-2014 - Extraction RejectsRoyalty Reporting
70ERP EHP76.0OIUREP_MP_XREF81Regulatory Reporting X-ref - MP to State Assigned IDRoyalty Reporting
71ERP EHP76.0OIUREP_MRT_CRED101MMS-2014: Credits Against Monthly ReportRoyalty Reporting
72ERP EHP76.0OIUREP_MRT_HIST393MMS-2014 MMS Royalty Transaction Processed HistoryRoyalty Reporting
73ERP EHP76.0OIUREP_MRT_PEND392MMS-2014 MMS Royalty Transaction Processed - PendingRoyalty Reporting
74ERP EHP76.0OIUREP_OWNER131MMS-2014 - OwnerRoyalty Reporting
75ERP EHP76.0OIUREP_PAYOR41MMS-2014 - Payor / Company Code XRefRoyalty Reporting
76ERP EHP76.0OIUREP_PDCD_XREF61Cross Reference Between State Agency and PRA MaterialRoyalty Reporting
77ERP EHP76.0OIUREP_PRDCDXREF31MMS: Possible Material No/MMS Prod Cd CombinationsRoyalty Reporting
78ERP EHP76.0OIUREP_PROWNERS51MMS-2014 - Property w/ Multiple Owners?Royalty Reporting
79ERP EHP76.0OIUREP_PRPAYXREF142MMS-2014 - Property / Payor XRefRoyalty Reporting
80ERP EHP76.0OIUREP_RECOUP101MMS-2014 - Recoupable BalanceRoyalty Reporting
81ERP EHP76.0OIUREP_REG_HIST131Reporting history (System table INDX)Royalty Reporting
82ERP EHP76.0OIUREP_REG_OPER121Regulatory Reporting Operator and Contact Xref EFF DatedRoyalty Reporting
83ERP EHP76.0OIUREP_REG_OPERA101Regulatory Reporting Operator and Contact XrefRoyalty Reporting
84ERP EHP76.0OIUREP_REG_OUT91Regulatory Reporting Output ControlRoyalty Reporting
85ERP EHP76.0OIUREP_REPORTS171Supported Regulatory reportsRoyalty Reporting
86ERP EHP76.0OIUREP_REPORTSTX41Supported Regulatory reportsRoyalty Reporting
87ERP EHP76.0OIUREP_ROYHIST332Reported Royalty and Volume Data by Reporting EntitiesRoyalty Reporting
88ERP EHP76.0OIUREP_ROY_AGY271Reporting Agencies for Tax and RoyaltyRoyalty Reporting
89ERP EHP76.0OIUREP_ROY_AGYTX31Regulatory Reporting AgenciesRoyalty Reporting
90ERP EHP76.0OIUREP_ROY_DATA374Reported Royalty and Volume Data by Reporting EntitiesRoyalty Reporting
91ERP EHP76.0OIUREP_ROY_FLDTX41Text Table for Report FieldsRoyalty Reporting
92ERP EHP76.0OIUREP_ROY_LOG131Changes to master data for reportingRoyalty Reporting
93ERP EHP76.0OIUREP_ROY_PRFL161Royalty Reporting ProfilesRoyalty Reporting
94ERP EHP76.0OIUREP_ROY_PRFLD101Field Values in the Royalty Reporting ProfilesRoyalty Reporting
95ERP EHP76.0OIUREP_RPT_ENTTY192Entities for Royalty ReportingRoyalty Reporting
96ERP EHP76.0OIUREP_RPT_OWNER81Owners for royalty reportingRoyalty Reporting
97ERP EHP76.0OIUREP_RPT_PRFL91Report ProfileRoyalty Reporting
98ERP EHP76.0OIUREP_RRST271Regulatory Reporting Status TableRoyalty Reporting
99ERP EHP76.0OIUREP_RRST_DET81Regulatory Reporting Status TableRoyalty Reporting
100ERP EHP76.0OIUREP_RRST_NEW281NEW Regulatory Reporting Status Table (with Version Number)Royalty Reporting
101ERP EHP76.0OIUREP_RTPEND941MMS-2014 - Royalty Transaction PendingRoyalty Reporting
102ERP EHP76.0OIUREP_RT_HIST942MMS-2014 - Royalty Transaction (Pending) HistoryRoyalty Reporting
103ERP EHP76.0OIUREP_RUNGRPKEY21Reg.Reporting - Report Submission groupsRoyalty Reporting
104ERP EHP76.0OIUREP_RUN_GROUP41Reg.Reporting - Report Submission groupingRoyalty Reporting
105ERP EHP76.0OIUREP_RUN_REPNM21Reg.Reporting - Report run/submission namesRoyalty Reporting
106ERP EHP76.0OIUREP_RWC141WCs that have been changed since previous report runRoyalty Reporting
107ERP EHP76.0OIUREP_SALESTY21MMS-2014: Sales Type Control TableRoyalty Reporting
108ERP EHP76.0OIUREP_SALESTYPE201MMS-2014 - Sales TypeRoyalty Reporting
109ERP EHP76.0OIUREP_SALESTY_T41MMS-2014: Sales Type Control Table DescriptionRoyalty Reporting
110ERP EHP76.0OIUREP_STAT_SPLT111Regulatory Reporting: Well Status Split tableRoyalty Reporting
111ERP EHP76.0OIUREP_STRUC91Regulatory Reporting StructuresRoyalty Reporting
112ERP EHP76.0OIUREP_STRUCTX61Regulatory Reporting StructuresRoyalty Reporting
113ERP EHP76.0OIUREP_SUPL_REP51MMS-2014 - Supplemental ReportsRoyalty Reporting
114ERP EHP76.0OIUREP_SUPL_REPT51MMS-2014 - Supplemental Reports DescriptionRoyalty Reporting
115ERP EHP76.0OIUREP_TAB_IND51Agency related fields for master data maintainenceRoyalty Reporting
116ERP EHP76.0OIUREP_TEXT_STDD61Regulatory Reporting Standard Texts DetailRoyalty Reporting
117ERP EHP76.0OIUREP_TEXT_STDH41Regulatory Reporting Valid Standard Texts HeaderRoyalty Reporting
118ERP EHP76.0OIUREP_TEXT_XREF101Regulatory Reporting Texts for Diff Reporting LevelsRoyalty Reporting
119ERP EHP76.0OIUREP_TRAN_ERR21Transaction code to error code xref for edits/valsRoyalty Reporting
120ERP EHP76.0OIUREP_TRAN_FLDS31MMS-2014 - Transaction Code Field Requirement XREFRoyalty Reporting
121ERP EHP76.0OIUREP_UOM71Regulatory Report Unit of MeasuresRoyalty Reporting
122ERP EHP76.0OIUREP_VALTABC51Reporting general value table - CustomizingRoyalty Reporting
123ERP EHP76.0OIUREP_VALTABCTX71Reporting general value table - CustomizingRoyalty Reporting
124ERP EHP76.0OIUREP_VALTABM61Reporting general value table - CustomizingRoyalty Reporting
125ERP EHP76.0OIUREP_VLTP_XREF41Cross reference between Agency defined & PRA volume typesRoyalty Reporting
126ERP EHP76.0OIUREP_VL_VOL211Gross Volume and Value after VL/RDRoyalty Reporting
127ERP EHP76.0OIUREP_VOLHIST192Reported Volume Data by Reporting EntitiesRoyalty Reporting
128ERP EHP76.0OIUREP_VOL_DATA234Reported Volume Data by Reporting EntitiesRoyalty Reporting
129ERP EHP76.0OIUREP_WCOWNERS41MMS-2014 - Well Completion w/ Multiple OwnersRoyalty Reporting
130ERP EHP76.0OIUREP_WCPAYXREF132MMS-2014 - Well Completion / Payor XRefRoyalty Reporting
131ERP EHP76.0OIUREP_XTRCT_ROY1461Extract Royaty Data for the current reporting periodRoyalty Reporting
132ERP EHP76.0OIUY1_CAT_CD21Generic Category Code in New RoyaltyRoyalty Reporting
133ERP EHP76.0OIUY1_CAT_CDTX41Descriptions for the categoriesRoyalty Reporting
134ERP EHP76.0OIUY1_CAT_CD_VAL51Descriptions for the codesRoyalty Reporting
135ERP EHP76.0OIUY1_GEN_CD_VAL81Maintain Code with Effective DatedRoyalty Reporting
136ERP EHP76.0OIUY1_REP_HIST81Reported data historyRoyalty Reporting