OIUREP_AGY_LSE SAP (Agency assigned Leases) Table details

Dictionary Type: Table
Description: Agency assigned Leases




ABAP Code to SELECT data from 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
MANDTClient MANDTCLNT3T000MANDT
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3OIUREP_ROY_AGYCHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
AGENCY_LEASEAgency assigned Lease No. OIUREP_AGENCY_LEASECHAR15OIUREP_AGENCY_LEASE
RRC_LEASE_NORRC Oil Lease OIUH_RRC_OIL_LEASECHAR7CHAR7
RRC_WL_LSE_NOGas Well Number (RRC) OIUH_GAS_WELL_NO_RRCCHAR9CHAR9
RRC_DIST_CDRRC District ID OIUH_RRC_DISTRICT_IDCHAR3CHAR3
FIELD_IDField ID OIU_FIELDIDCHAR10Assigned to domainALPHAOIU_FIELDIDOIU_FIELD
OPERATOR_NOBusiness Associate OIUCM_BUS_ASSOCCHAR6ALPHAOIUCM_BUS_ASSOCOIUCM_BUS_ASSOC
SEQ_NOTransaction code for Royalty reporting OIUREP_TXN_CDCHAR2ALPHAOIUCM_SEQ_NO
TRANSP_ORG_CDTransport Org Cd OIUY1_TRNSP_ORG_CDCHAR4CHAR4
LEASE_SHR_PCNTLease Share Percentage OIUY1_LSE_SHR_PCNTDEC11(8) OIUY1_LSE_SHR_PCNT
WELL_INDWell Indicator OIUY1_WELL_INDCHAR1CHAR1
SW_SWEET_FLSweet or Sour Flag(Y/N) OIUY1_SW_FLAGCHAR1OIUY1_SR
REPORT_NOPlant Org Id OIUY1_RPT_NOCHAR4CHAR4
UNIT_NOUnit Number OIUY1_UNIT_NOCHAR6CHAR6
SECSection Number OIUY1_SECTION_NOCHAR6CHAR6
TWPTownship number OIU_TWP_NOCHAR3CHAR3
RGERGE OIUY1_RGECHAR3CHAR3
ROYALTY_DECRoyalty Decimal OIUY1_ROY_DECDEC9(8) OIUY1_ROYALTY_DEC
OPERATOROperator OIUY1_OPERATORCHAR10Assigned to domainALPHALIFNR
PUR_TAXIDPurchaser Tax ID OIUY1_PURTAXIDCHAR13CHAR13
OPER_TAXIDOperator TAX ID OIUY1_OPERTAXIDCHAR13CHAR13
TRACT_NOTract Number OIUY1_TRACT_NOCHAR18CHAR18
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
LEASE_SHR_PCNTOLease Share Percentage OIUY1_LSE_SHR_PCNTDEC11(8) OIUY1_LSE_SHR_PCNT
TXN_CD_OTransaction code for Royalty reporting OIUREP_TXN_CDCHAR2ALPHAOIUCM_SEQ_NO
TYPE_INDRRC Type OIUY1_TYPE_INDCHAR1CHAR1

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!