OIUREP_AGY_LSE SAP (Agency assigned Leases) Table details
Dictionary Type: Table
Description: Agency assigned Leases
Description: Agency assigned Leases
ABAP Code to SELECT data from OIUREP_AGY_LSE
Related tables to OIUREP_AGY_LSE
Access table OIUREP_AGY_LSE
Related tables to OIUREP_AGY_LSE
Access table OIUREP_AGY_LSE
Table field list including key, data, relationships and ABAP select examples
OIUREP_AGY_LSE is a standard SAP Table which is used to store Agency assigned Leases data and is available within R/3 SAP systems depending on the version and release level.
The OIUREP_AGY_LSE table consists of various fields, each holding specific information or linking keys about Agency assigned Leases data available in SAP. These include AGENCY (Agency for Reporting), AGENCY_LEASE (Agency assigned Lease No.), RRC_LEASE_NO (RRC Oil Lease), RRC_WL_LSE_NO (Gas Well Number (RRC)).. 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)
Text table = OIUREP_AGY_LSETX
SAP OIUREP_AGY_LSE 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 | |||
AGENCY | Agency for Reporting | OIUREP_ROY_AGENCY | CHAR | 3 | OIUREP_ROY_AGY | CHAR3 | OIUREP_AGENCY | OIUREP_SH_ROY_AGY | |
AGENCY_LEASE | Agency assigned Lease No. | OIUREP_AGENCY_LEASE | CHAR | 15 | OIUREP_AGENCY_LEASE | ||||
RRC_LEASE_NO | RRC Oil Lease | OIUH_RRC_OIL_LEASE | CHAR | 7 | CHAR7 | ||||
RRC_WL_LSE_NO | Gas Well Number (RRC) | OIUH_GAS_WELL_NO_RRC | CHAR | 9 | CHAR9 | ||||
RRC_DIST_CD | RRC District ID | OIUH_RRC_DISTRICT_ID | CHAR | 3 | CHAR3 | ||||
FIELD_ID | Field ID | OIU_FIELDID | CHAR | 10 | Assigned to domain | ALPHA | OIU_FIELDID | OIU_FIELD | |
OPERATOR_NO | Business Associate | OIUCM_BUS_ASSOC | CHAR | 6 | ALPHA | OIUCM_BUS_ASSOC | OIUCM_BUS_ASSOC | ||
SEQ_NO | Transaction code for Royalty reporting | OIUREP_TXN_CD | CHAR | 2 | ALPHA | OIUCM_SEQ_NO | |||
TRANSP_ORG_CD | Transport Org Cd | OIUY1_TRNSP_ORG_CD | CHAR | 4 | CHAR4 | ||||
LEASE_SHR_PCNT | Lease Share Percentage | OIUY1_LSE_SHR_PCNT | DEC | 11(8) | OIUY1_LSE_SHR_PCNT | ||||
WELL_IND | Well Indicator | OIUY1_WELL_IND | CHAR | 1 | CHAR1 | ||||
SW_SWEET_FL | Sweet or Sour Flag(Y/N) | OIUY1_SW_FLAG | CHAR | 1 | OIUY1_SR | ||||
REPORT_NO | Plant Org Id | OIUY1_RPT_NO | CHAR | 4 | CHAR4 | ||||
UNIT_NO | Unit Number | OIUY1_UNIT_NO | CHAR | 6 | CHAR6 | ||||
SEC | Section Number | OIUY1_SECTION_NO | CHAR | 6 | CHAR6 | ||||
TWP | Township number | OIU_TWP_NO | CHAR | 3 | CHAR3 | ||||
RGE | RGE | OIUY1_RGE | CHAR | 3 | CHAR3 | ||||
ROYALTY_DEC | Royalty Decimal | OIUY1_ROY_DEC | DEC | 9(8) | OIUY1_ROYALTY_DEC | ||||
OPERATOR | Operator | OIUY1_OPERATOR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PUR_TAXID | Purchaser Tax ID | OIUY1_PURTAXID | CHAR | 13 | CHAR13 | ||||
OPER_TAXID | Operator TAX ID | OIUY1_OPERTAXID | CHAR | 13 | CHAR13 | ||||
TRACT_NO | Tract Number | OIUY1_TRACT_NO | CHAR | 18 | CHAR18 | ||||
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 | ||||
LEASE_SHR_PCNTO | Lease Share Percentage | OIUY1_LSE_SHR_PCNT | DEC | 11(8) | OIUY1_LSE_SHR_PCNT | ||||
TXN_CD_O | Transaction code for Royalty reporting | OIUREP_TXN_CD | CHAR | 2 | ALPHA | OIUCM_SEQ_NO | |||
TYPE_IND | RRC Type | OIUY1_TYPE_IND | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP table OIUREP_AGY_LSE using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUREP_AGY_LSE to SELECT all data from the tableDATA: WA_OIUREP_AGY_LSE TYPE OIUREP_AGY_LSE.
SELECT SINGLE *
FROM OIUREP_AGY_LSE
INTO CORRESPONDING FIELDS OF WA_OIUREP_AGY_LSE
WHERE...
How to access SAP table OIUREP_AGY_LSE
Within an ECC or HANA version of SAP you can also view further information about OIUREP_AGY_LSE 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