ROIUREP_ROY_LEASE_LASTCURR SAP (Reported Royalty Data by Lease (last and current)) Structure details

Dictionary Type: Structure
Description: Reported Royalty Data by Lease (last and current)




ABAP Code to SELECT data from ROIUREP_ROY_LEASE_LASTCURR
Related tables to ROIUREP_ROY_LEASE_LASTCURR
Access table ROIUREP_ROY_LEASE_LASTCURR




Structure field list including key, data, relationships and ABAP select examples

ROIUREP_ROY_LEASE_LASTCURR 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 "Reported Royalty Data by Lease (last and current)" 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_ROIUREP_ROY_LEASE_LASTCURR TYPE ROIUREP_ROY_LEASE_LASTCURR.

The ROIUREP_ROY_LEASE_LASTCURR table consists of various fields, each holding specific information or linking keys about Reported Royalty Data by Lease (last and current) data available in SAP. These include MANDT (Client), YEAR_MONTH (Reporting Year and Month), ORG_LEVEL1_NO (Company Code), AGENCY (Agency for Reporting).. 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 ROIUREP_ROY_LEASE_LASTCURR 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
MANDTClient MANDTCLNT3T000MANDT
YEAR_MONTHReporting Year and Month OIUREP_RPT_YYYYMMNUMC6OIUREP_RPT_YYYYMM
ORG_LEVEL1_NOCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3OIUREP_ROY_AGYCHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
OIL_GAS_INDOil and Gas Indicator OIUREP_OIL_GAS_INDCHAR1OIUREP_OIL_GAS_INDOIUREP_OIL_GAS_IND
YEAR_MONTH_AMNDYear and Month for Amended Reports OIUREP_AMND_YYYYMMNUMC6OIUREP_RPT_YYYYMM
PROPERTY_NOJoint Venture JV_NAMECHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5OIU_DO_DIALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
WL_NOWell ID number OIU_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5OIU_PR_WCALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
MP_NOMeasurement point number OIU_MP_NOCHAR20OIU_PR_MPALPHAOIU_MP_NOOIU_MPH_OIU_PR_MP
AGENCY_PROD_CODEAgency defined product code OIUREP_AGENCY_PDCDCHAR3OIUREP_AGY_PDCDOIUREP_AGENCY_PDCD
AGENCY_VOL_TYPEAgency defined Volume type OIUREP_AGENCY_VOL_TYPECHAR2OIUREP_AGY_VLTPCHAR2
GRAVITY_QTYGravity Quantity OIUREP_GRV_QY_NUMC4NUMC4NUMC4
UNIT_PROPERTY_NOJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
GROSS_VOLUMEGross Volume OIUREP_GROSS_VOLUMEQUAN13(3) MENGE
NGL_VOLUMENGL Volume OIUY1_NGL_VOLUMEQUAN13(3) MENGE
NET_VOLUMENet Volume OIUREP_NET_VOLUMEQUAN13(3) MENGE
STD_VOL_UStandard volume unit OIU_STD_VOL_UUNIT3Assigned to domainCUNITMEINS
GROSS_VALUEGross Value From a Contract/Well OIUREP_GROSS_VALUECURR13(2) OIUREP_VALUE
NET_VALUENet Value From a Contract/Well OIUREP_NET_VALUECURR13(2) OIUREP_VALUE
TRANSPORT_COSTTransportation Cost OIUREP_TRANSPORT_COSTCURR13(2) OIUREP_VALUE
TAX_AMTTax Amount OIUREP_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
MARKETING_TOTMarketing Amount OIUREP_MKT_AMOUNTCURR11(2) OIUH_CURR11_2
DEDUCTION_AMT1Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
DEDUCTION_AMT2Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
DEDUCTION_AMT3Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
DEDUCTION_AMT4Deduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
ROYALTY_DUERoyalty Amount due to the State Agency OIUREP_ROYALTY_DUECURR13(2) OIUREP_VALUE
CURRENCYCurrency OIUREP_CURRENCYCUKY5Assigned to domainWAERS
ENERGYenergy OIUREP_ENERGYQUAN21(8) OIUH_DEC21_8
ENERGY_UEnergy quantity unit OIU_ENERGY_UUNIT3Assigned to domainCUNITMEINS
TRACT_PFTract Participation Factor Decimal OIU_TR_PART_FACT_PCDEC9(8) OIU_PERCENT98
API_GRVOil/gas density at standard/base conditions OIB_BDICHFLTP16(16) OIB_DICHT
UPLOAD_FLAGSingle-Character Indicator CHAR1CHAR1CHAR1
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
LAST_CURR_INDLast/Current indicator OIUREP_LAST_CURR_INDCHAR1OIUREP_LAST_CURR_IND
AGENCY_LEASEAgency assigned Lease No. OIUREP_AGENCY_LEASECHAR15OIUREP_AGENCY_LEASE
LSE_ALLOC_FACLease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
PAYOR_FRACTIONPayor's fraction of Royalty payment OIUREP_PAYOR_FRACTIONDEC9(8) OIUREP_PAYOR_FRACTION
ENTL_FLAGEntitlement Flag OIUY1_ENTL_FLAGCHAR1OIUY1_FLAG
ROY_OBLIGATIONRoyalty Obligation (Y/N) OIUY1_ROY_OBLGCHAR1OIUY1_FLAG
ROYALTY_DUE_PREVRoyalty Amount due to the State Agency OIUREP_ROYALTY_DUECURR13(2) OIUREP_VALUE
NET_ROYALTY_DUERoyalty Amount due to the State Agency OIUREP_ROYALTY_DUECURR13(2) OIUREP_VALUE

Key field Non-key field



How do I retrieve data from SAP structure ROIUREP_ROY_LEASE_LASTCURR using ABAP code?

As ROIUREP_ROY_LEASE_LASTCURR 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 ROIUREP_ROY_LEASE_LASTCURR as there is no data to select.

How to access SAP table ROIUREP_ROY_LEASE_LASTCURR

Within an ECC or HANA version of SAP you can also view further information about ROIUREP_ROY_LEASE_LASTCURR 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!