OIUREP_AGY_LSE SAP table for – Agency assigned Leases

Here we would like to draw your attention to OIUREP_AGY_LSE table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUREP_AGY_LSE is a SAP standard transp table used for storing Agency assigned Leases related data in SAP. It comes under the package OIU_REP.

SAP OIUREP_AGY_LSE table

Table OIUREP_AGY_LSE technical data

TableOIUREP_AGY_LSE
Data storingAgency assigned Leases
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-ROY
SAP PackageOIU_REP
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUREP_AGY_LSE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUREP_AGY_LSE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • AGENCY_LEASE : Agency assigned Lease No.
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • RRC_LEASE_NO : RRC Oil Lease
    Its data type is CHAR (Character String) with field length 7
  • RRC_WL_LSE_NO : Gas Well Number (RRC)
    Its data type is CHAR (Character String) with field length 9
  • RRC_DIST_CD : RRC District ID
    Its data type is CHAR (Character String) with field length 3
  • FIELD_ID : Field ID
    Its data type is CHAR (Character String) with field length 10
  • OPERATOR_NO : Business Associate
    Its data type is CHAR (Character String) with field length 6
  • SEQ_NO : Transaction code for Royalty reporting
    Its data type is CHAR (Character String) with field length 2
  • TRANSP_ORG_CD : Transport Org Cd
    Its data type is CHAR (Character String) with field length 4
  • LEASE_SHR_PCNT : Lease Share Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • WELL_IND : Well Indicator
    Its data type is CHAR (Character String) with field length 1
  • SW_SWEET_FL : Sweet or Sour Flag(Y/N)
    Its data type is CHAR (Character String) with field length 1
  • REPORT_NO : Plant Org Id
    Its data type is CHAR (Character String) with field length 4
  • UNIT_NO : Unit Number
    Its data type is CHAR (Character String) with field length 6
  • SEC : Section Number
    Its data type is CHAR (Character String) with field length 6
  • TWP : Township number
    Its data type is CHAR (Character String) with field length 3
  • RGE : RGE
    Its data type is CHAR (Character String) with field length 3
  • ROYALTY_DEC : Royalty Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OPERATOR : Operator
    Its data type is CHAR (Character String) with field length 10
  • PUR_TAXID : Purchaser Tax ID
    Its data type is CHAR (Character String) with field length 13
  • OPER_TAXID : Operator TAX ID
    Its data type is CHAR (Character String) with field length 13
  • TRACT_NO : Tract Number
    Its data type is CHAR (Character String) with field length 18
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • LEASE_SHR_PCNTO : Lease Share Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TXN_CD_O : Transaction code for Royalty reporting
    Its data type is CHAR (Character String) with field length 2
  • TYPE_IND : RRC Type
    Its data type is CHAR (Character String) with field length 1