OIUY3_TX_RPODT SAP (Royalty 2.0 - TX GLO/TAMU - Oil Report) Table details
Description: Royalty 2.0 - TX GLO/TAMU - Oil Report
Related tables to OIUY3_TX_RPODT
Access table OIUY3_TX_RPODT
Table field list including key, data, relationships and ABAP select examples
OIUY3_TX_RPODT is a standard SAP Table which is used to store Royalty 2.0 - TX GLO/TAMU - Oil Report data and is available within R/3 SAP systems depending on the version and release level.
The OIUY3_TX_RPODT table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - TX GLO/TAMU - Oil Report data available in SAP. These include RUN_ID (Run ID of Tax Report), PROD_YEAR_MO (Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM), GLO_LEASE (Royalty 2.0 - TX GLO/TAMU Lease), RRC_DISTRICT_NO (Royalty 2.0 - TX GLO/TAMU - District Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIUY3_TX_RPODT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RUN_ID | Run ID of Tax Report | OIUX3_RUN_ID | NUMC | 10 | NUMC10 | ||||
PROD_YEAR_MO | Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM | OIUY3_TX_PROD_YEAR_MO | ACCP | 6 | PERI | OIU_PROD_MONTH | |||
GLO_LEASE | Royalty 2.0 - TX GLO/TAMU Lease | OIUY3_TX_GLO_LEASE | NUMC | 6 | OIUY3_TX_LEASE | OIUY3_TX_GLO_LEASE | |||
RRC_DISTRICT_NO | Royalty 2.0 - TX GLO/TAMU - District Number | OIUY3_TX_GLO_DISTRICT_NO | CHAR | 2 | |||||
RRC_OIL_LEASE_NO | Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number | OIUY3_TX_GLO_RRC_OIL_LEASE_NO | CHAR | 5 | |||||
RRC_GAS_WELL_ID | Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID | OIUY3_TX_GLO_RRC_GAS_WELL_ID | CHAR | 6 | |||||
RRC_DRILL_PERMIT | Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit | OIUY3_TX_GLO_RRC_DRILLING_PERM | CHAR | 6 | |||||
PURCHASER_ID | Royalty 2.0 - Texas GLO/TAMU - Purchaser ID | OIUY3_TX_PURCHASER_ID | NUMC | 11 | |||||
REV_BOOK_ADJ_IND | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | OIUY3_REV_BOOK_REVADJ_ADJ_IND | CHAR | 1 | OIUY3_REV_BOOK_REVADJ_ADJ_IND | ||||
RRC_FIELD_NAME | Royalty 2.0 - TX GLO/TAMU - RRC Field Name | OIUY3_TX_GLO_RRC_FIELD_NAME | CHAR | 32 | |||||
RRC_LEASE_NAME | Royalty 2.0 - TX GLO/TAMU - RRC Lease Name | OIUY3_TX_GLO_RRC_LEASE_NAME | CHAR | 32 | |||||
PROP_ALIAS_NAME | Royalty 2.0 - TX GLO/TAMU - Property Alias Name | OIUY3_TX_GLO_PROP_ALIAS_NAME | CHAR | 32 | |||||
REPORT_TYPE | Royalty 2.0 - Texas GLO/TAMU - Report Type | OIUY3_TX_REPORT_TYPE | CHAR | 1 | OIUY3_TX_REPORT_TYPE | ||||
GLO_UNIT_NO | Royalty 2.0 - Texas GLO/TAMU - Unit Number | OIUY3_TX_GLO_UNIT_NO | CHAR | 4 | |||||
TRACT_PART_FACT | Royalty 2.0 - Texas GLO - Tract Participation Factor | OIUY3_TX_TRACT_PART_FACTOR | DEC | 9(8) | OIU_PERCENT98 | ||||
OVERRIDE_CODE | Royalty 2.0 - TX GLO/TAMU - Override Code | OIUY3_TX_OVERRIDE_CODE | CHAR | 5 | |||||
OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | OIUY3_TX_OPERATOR_ID | CHAR | 10 | OIUY3_TX_ID | ||||
PROD_DISP_RPT | Royalty 2.0 - TX GLO/TAMU - Production Disp Report Indicator | OIUY3_TX_PROD_DISP_RPT_IND | CHAR | 1 | YESNO | ||||
AFFILIATED_SALE | Royalty 2.0 - TX GLO - Affiliated Sale Indicator | OIUY3_TX_AFFILIATED_SALE_IND | CHAR | 1 | YESNO | ||||
GLO_TIK | Royalty 2.0 - Texas GLO/TAMU - GLO TIK | OIUY3_TX_GLO_TIK | CHAR | 1 | YESNO | ||||
BEGINNING_STOCK | Royalty 2.0 - TX GLO/TAMU - Beginning Stock | OIUY3_TX_BEGINNING_STOCK | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
GROSS_PRODUCTION | Royalty 2.0 - TX GLO/TAMU - Gross Production | OIUY3_TX_GROSS_PRODUCTION | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
PIPELINE | Royalty 2.0 - TX GLO/TAMU - Pipeline | OIUY3_TX_PIPELINE | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
TRUCK | Royalty 2.0 - TX GLO/TAMU - Truck | OIUY3_TX_TRUCK | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
TANK_CAR_BARGE | Royalty 2.0 - TX GLO/TAMU - Tank Car Barge | OIUY3_TX_TANK_CAR_BARGE | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
TANK_CLEANING | Royalty 2.0 - TX GLO/TAMU - Tank Cleaning | OIUY3_TX_TANK_CLEANING | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
CIRC_OIL_COND | Royalty 2.0 - TX GLO/TAMU - Circulating Oil/Condensate | OIUY3_TX_CIRCULATING_OIL_COND | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
LOST_STOLEN | Royalty 2.0 - TX GLO/TAMU - Lost/Stolen | OIUY3_TX_LOST_STOLEN | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
BSW | Royalty 2.0 - TX GLO/TAMU - Basic Sediment / Water | OIUY3_TX_BASIC_SEDIMENT_WATER | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
OTHER_ROY_DUE | Royalty 2.0 - TX GLO/TAMU - Other Royalty Due | OIUY3_TX_OTHER_ROYALTY_DUE | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
OTHER_NO_ROY_DUE | Royalty 2.0 - TX GLO/TAMU - Other No Royalty Due | OIUY3_TX_OTHER_NO_ROYALTY_DUE | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
SKIM_LIQ_HYDRO | Royalty 2.0 - TX GLO/TAMU - Skim Liquid Hydrocarbon | OIUY3_TX_SKIM_LIQUID_HYDRO | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
SCRUBBER_OIL | Royalty 2.0 - TX GLO/TAMU - Scrubber Oil | OIUY3_TX_SCRUBBER_OIL | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
ENDING_STOCK | Royalty 2.0 - TX GLO/TAMU - Ending Stock | OIUY3_TX_ENDING_STOCK | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
DRIP_OIL | Royalty 2.0 - TX GLO/TAMU - Drip Oil | OIUY3_TX_DRIP_OIL | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
ENTIRE_ROY_OB | Royalty 2.0 - TX GLO/TAMU - Entire Royalty Obligation | OIUY3_TX_ENTIRE_ROYALTY_OB | CHAR | 1 | OIUY3_TX_ENTIRE_ROYALTY_OB | ||||
ROY_DUE_NET_BBLS | Royalty 2.0 - TX GLO/TAMU - Royalty Due Net Barrels | OIUY3_TX_ROY_DUE_NET_BARRELS | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 | ||||
API_GRAVITY | Royalty 2.0 - Texas GLO/TAMU - API Gravity | OIUY3_TX_API_GRAVITY | DEC | 9(6) | |||||
UNIT_VALUE | Royalty 2.0 - Texas GLO/TAMU - Unit Value | OIUY3_TX_UNIT_VALUE | DEC | 9(6) | |||||
GROSS_VALUE | Gross Value | OIUX3_GROSS_VALUE | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
ROYALTY_DECIMAL | Royalty 2.0 - Texas GLO - Royalty Decimal | OIUY3_TX_ROYALTY_DECIMAL | DEC | 9(8) | OIU_PERCENT98 | ||||
ROYALTY_DUE | Royalty 2.0 - Texas GLO/TAMU - Royalty Due | OIUY3_TX_ROYALTY_DUE | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
COMMENT_FL | Royalty 2.0 - Texas GLO/TAMU - Comment Flag | OIUY3_TX_COMMENT_FL | CHAR | 1 | YESNO | ||||
ORIGINAL_REPORT | Royalty 2.0 - TX GLOTAMU - Original Report | OIUY3_TX_ORIGINAL_REPORT | CHAR | 1 | OIUY3_TX_ORIGINAL_REPORT | ||||
ZERO_VOL | Royalty 2.0 - Texas GLO/TAMU - Zero Volume Flag | OIUY3_TX_ZERO_VOL | CHAR | 1 | YESNO | ||||
PAY_REPORT_FLAG | Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag | OIUY3_TX_PAY_REPORT_FLAG | CHAR | 1 | OIUY3_TX_PAY_REPORT_FLAG | ||||
EXPECTED_RPT_EXC | Royalty 2.0 - Texas GLO/TAMU No of Expected Reports Exceeded | OIUY3_TX_EXPECTED_RPT_EXCEEDED | CHAR | 1 | FLAG | ||||
MULTI_PURCHASER | Royalty 2.0 - Texas GLO/TAMU - Multiple Purchasers Flag | OIUY3_TX_MULTIPLE_PURCHASERS | CHAR | 1 | YESNO | ||||
REPORT_NUM | Roy 2.0 TX - Report Number | OIUY3_TX_REPORT_NUM | NUMC | 4 | |||||
OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table OIUY3_TX_RPODT using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUY3_TX_RPODT to SELECT all data from the tableDATA: WA_OIUY3_TX_RPODT TYPE OIUY3_TX_RPODT.
SELECT SINGLE *
FROM OIUY3_TX_RPODT
INTO CORRESPONDING FIELDS OF WA_OIUY3_TX_RPODT
WHERE...
How to access SAP table OIUY3_TX_RPODT
Within an ECC or HANA version of SAP you can also view further information about OIUY3_TX_RPODT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects