OIUREP_ARCROYHIS SAP (Archived Reported Royalty and Volume Data) Table details

Dictionary Type: Table
Description: Archived Reported Royalty and Volume Data




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




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

OIUREP_ARCROYHIS is a standard SAP Table which is used to store Archived Reported Royalty and Volume Data data and is available within R/3 SAP systems depending on the version and release level.

The OIUREP_ARCROYHIS table consists of various fields, each holding specific information or linking keys about Archived Reported Royalty and Volume Data data available in SAP. These include YEAR_MONTH (Reporting Year and Month), ORG_LEVEL1_NO (Company Code), AGENCY (Agency for Reporting), OIL_GAS_IND (Oil and Gas Indicator).. 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 OIUREP_ARCROYHIS 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
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
AGENCY_LEASEAgency assigned Lease No. OIUREP_AGENCY_LEASECHAR15OIUREP_AGENCY_LEASE
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
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
NGL_VOLUMENGL Volume OIUY1_NGL_VOLUMEQUAN13(3) MENGE
NET_VALUENet Value From a Contract/Well OIUREP_NET_VALUECURR13(2) OIUREP_VALUE
TRANSPORT_COSTTransportation Cost OIUREP_TRANSPORT_COSTCURR13(2) OIUREP_VALUE
TAX_AMTDeduction Amount OIUREP_DED_AMOUNTCURR11(2) OIUH_CURR11_2
MARKETING_TOTDeduction Amount OIUREP_DED_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

Key field Non-key field



How do I retrieve data from SAP table OIUREP_ARCROYHIS using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIUREP_ARCROYHIS to SELECT all data from the table
DATA: WA_OIUREP_ARCROYHIS TYPE OIUREP_ARCROYHIS.

SELECT SINGLE *
FROM OIUREP_ARCROYHIS
INTO CORRESPONDING FIELDS OF WA_OIUREP_ARCROYHIS
WHERE...

How to access SAP table OIUREP_ARCROYHIS

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