ROIUY3_DISP_TX_VARIANCE_RPODT SAP (Royalty 2.0 - Display TX GLO Oil Report Detail Variance) Structure details
Description: Royalty 2.0 - Display TX GLO Oil Report Detail Variance
Related tables to ROIUY3_DISP_TX_VARIANCE_RPODT
Access table ROIUY3_DISP_TX_VARIANCE_RPODT
Structure field list including key, data, relationships and ABAP select examples
ROIUY3_DISP_TX_VARIANCE_RPODT 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 - Display TX GLO Oil Report Detail Variance" 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_DISP_TX_VARIANCE_RPODT TYPE ROIUY3_DISP_TX_VARIANCE_RPODT.
The ROIUY3_DISP_TX_VARIANCE_RPODT table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - Display TX GLO Oil Report Detail Variance 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_DISP_TX_VARIANCE_RPODT 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 | ||||
2ND_ROYALTY_DUE | Royalty 2.0 - Texas GLO/TAMU - Royalty Due | OIUY3_TX_ROYALTY_DUE | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
VAR_ROYALTY_DUE | Royalty 2.0 - Texas GLO/TAMU - Royalty Due | OIUY3_TX_ROYALTY_DUE | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
PERCENT | 2 byte integer (signed) | INT2 | INT2 | 5 | INT2 |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIUY3_DISP_TX_VARIANCE_RPODT using ABAP code?
As ROIUY3_DISP_TX_VARIANCE_RPODT 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_DISP_TX_VARIANCE_RPODT as there is no data to select.How to access SAP table ROIUY3_DISP_TX_VARIANCE_RPODT
Within an ECC or HANA version of SAP you can also view further information about ROIUY3_DISP_TX_VARIANCE_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