ROIUY3_TX_RPODT_TC SAP (Royalty 2.0 - TX GLO/TAMU - Oil Report Detail Structure) Structure details
Description: Royalty 2.0 - TX GLO/TAMU - Oil Report Detail Structure
Related tables to ROIUY3_TX_RPODT_TC
Access table ROIUY3_TX_RPODT_TC
Structure field list including key, data, relationships and ABAP select examples
ROIUY3_TX_RPODT_TC is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Royalty 2.0 - TX GLO/TAMU - Oil Report Detail Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_ROIUY3_TX_RPODT_TC TYPE ROIUY3_TX_RPODT_TC.
The ROIUY3_TX_RPODT_TC table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - TX GLO/TAMU - Oil Report Detail Structure data available in SAP. These include MANDT (Client), 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).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ROIUY3_TX_RPODT_TC structure 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 | ||||
SEL | General Flag | FLAG | CHAR | 1 | FLAG | ||||
DELTA | Royalty 2.0 - TX GLO/TAMU - Royalty Due Net Barrels | OIUY3_TX_ROY_DUE_NET_BARRELS | DEC | 15(6) | OIUY3_SIGNED_DEC_15_6 |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIUY3_TX_RPODT_TC using ABAP code?
As ROIUY3_TX_RPODT_TC is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ROIUY3_TX_RPODT_TC as there is no data to select.How to access SAP table ROIUY3_TX_RPODT_TC
Within an ECC or HANA version of SAP you can also view further information about ROIUY3_TX_RPODT_TC 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