OIUY3_TX_RRC SAP (Royalty 2.0 - TX GLO/TAMU - RRC Master) Table details
Dictionary Type: Table
Description: Royalty 2.0 - TX GLO/TAMU - RRC Master
Description: Royalty 2.0 - TX GLO/TAMU - RRC Master
Table field list including key, data, relationships and ABAP select examples
OIUY3_TX_RRC is a standard SAP Table which is used to store Royalty 2.0 - TX GLO/TAMU - RRC Master data and is available within R/3 SAP systems depending on the version and release level.
The OIUY3_TX_RRC table consists of various fields, each holding specific information or linking keys about Royalty 2.0 - TX GLO/TAMU - RRC Master data available in SAP. These include RPT_ID (Report ID), WL_NO (Well ID number), WC_NO (Well Completion Number), MP_NO (Measurement point 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_RRC 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 | |||
RPT_ID | Report ID | OIUX3_RPT_ID | CHAR | 10 | OIUX3_RPT | OIUX3_RPT_ID | |||
WL_NO | Well ID number | OIU_WL_NO | CHAR | 15 | OIU_PR_WELL | ALPHA | OIU_WL_NO | OIU_WELL | H_OIU_PR_WELL |
WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 5 | OIU_PR_WC | ALPHA | OIU_WC_NO | OIU_WC | H_OIU_PR_WC |
MP_NO | Measurement point number | OIU_MP_NO | CHAR | 20 | OIU_PR_MP | ALPHA | OIU_MP_NO | OIU_MP | H_OIU_PR_MP |
BUKRS | Company Code | BUKRS | CHAR | 4 | OIU_CM_COMPC | BUKRS | BUK | C_T001 | |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | OIU_DO_JV | ALPHA | JV_NAME | JVV | |
DOI_NO | Division of interest (DOI) | OIU_DOI_NO | CHAR | 5 | OIU_DO_DI | ALPHA | OIU_DOI_NO | OIU_DOI | H_OIU_DO_DI |
EFF_FROM_DT | Effective from date | OIU_EFF_FROM_DT | DATS | 8 | DATUM | OIU_EFD | |||
EFF_TO_DT | Effective To Date | OIU_EFF_TO_DT | DATS | 8 | DATUM | OIU_ETD | |||
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 | |||||
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 | |||||
OPERATOR_NO | Royalty 2.0 - TX GLO/TAMU - Operator Number | OIUY3_OPERATOR_NUMBER | CHAR | 6 | OIUH_CM_BA | ALPHA | OIUCM_BUS_ASSOC | ||
OPERATOR_SEQ_NO | Royalty 2.0 - TX GLO - Operator Sequence Number | OIUY3_OPERATOR_SEQUENCE_NUMBER | CHAR | 2 | ALPHA | OIUCM_SEQ_NO | |||
PROD_DISP_RPT | Royalty 2.0 - TX GLO/TAMU - Production Disp Report Indicator | OIUY3_TX_PROD_DISP_RPT_IND | CHAR | 1 | YESNO | ||||
CHANGE_USER | Last Changed By | OIUX3_LAST_CHANGED_USER | CHAR | 12 | USNAM | ||||
CHANGE_DATE | Date of Last Change | OIUX3_LAST_CHANGED_DATE | DATS | 8 | |||||
CHANGE_TIME | Time of Last Change | OIUX3_LAST_CHANGED_TIME | TIMS | 6 |
Key field | Non-key field |
How do I retrieve data from SAP table OIUY3_TX_RRC using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUY3_TX_RRC to SELECT all data from the tableDATA: WA_OIUY3_TX_RRC TYPE OIUY3_TX_RRC.
SELECT SINGLE *
FROM OIUY3_TX_RRC
INTO CORRESPONDING FIELDS OF WA_OIUY3_TX_RRC
WHERE...
How to access SAP table OIUY3_TX_RRC
Within an ECC or HANA version of SAP you can also view further information about OIUY3_TX_RRC 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