OIUH_RV_ROYH SAP (New Mexico Royalty History) Table details

Dictionary Type: Table
Description: New Mexico Royalty History




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




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

OIUH_RV_ROYH is a standard SAP Table which is used to store New Mexico Royalty History data and is available within R/3 SAP systems depending on the version and release level.

The OIUH_RV_ROYH table consists of various fields, each holding specific information or linking keys about New Mexico Royalty History data available in SAP. These include DUMMY_SEQ_FIELD (OIUH_CHAR10), ROYH_SYS_NO (OIUH_DEC18), OYH_OR_LVL_1_NO (OIUH_CHAR3), ROYH_MP_NO9 (OIUH_CHAR1).. 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: Cannot Be Enhanced


SAP OIUH_RV_ROYH 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 MANDTCLNT3Assigned to domainMANDT
DUMMY_SEQ_FIELDOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
ROYH_SYS_NOOIUH_DEC18 OIUH_DEC18DEC18DEC18
OYH_OR_LVL_1_NOOIUH_CHAR3 OIUH_CHAR3CHAR3CHAR3
ROYH_MP_NO9OIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_MP_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
ROYH_WL_NO9OIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_WL_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
ROYH_WC_NO9OIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_WC_NOOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
ROYH_PR_NO9OIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_PR_NOOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
ROYH_DOI_NO9OIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_DOI_NOOIUH_CHAR5 OIUH_CHAR5CHAR5CHAR5
ROYH_MAJ_PD_CDOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_PD_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
ROYH_NM_PD_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
ROYH_SA_DTOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14
ROYH_CT_NOContract ID OIUH_CONTRACT_IDCHAR6CHAR6
ROYH_ST_RPT_NOOIUH_CHAR13 OIUH_CHAR13CHAR13CHAR13
OYH_NM_OGRID_NOOIUH_CHAR6 OIUH_CHAR6CHAR6CHAR6
ROYH_TXN_CDOIUH_CHAR2 OIUH_CHAR2CHAR2CHAR2
ROYH_NO_PU_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_PPA_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_RVRS_FLOIUH_CHAR1 OIUH_CHAR1CHAR1CHAR1
ROYH_TRANS_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
ROYH_GRVA_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
ROYH_NGL_GR_QYOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
ROYH_MCF_GR_QYOIUH_DEC11_2 OIUH_DEC11_2DEC11(2) OIUH_DEC11_2
YH_TRANS_DED_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
OYH_PRCS_DED_AMLocal amount OIUH_CURR11_2CURR11(2) OIUH_CURR11_2
ROYH_AVG_BTU_QYOIUH_DEC7_3 OIUH_DEC7_3DEC7(3) OIUH_DEC7_3
ROYH_BTU_QYOIUH_DEC7_3 OIUH_DEC7_3DEC7(3) OIUH_DEC7_3
YH_OBAL_DECM_QYOIUH_DEC9_8 OIUH_DEC9_8DEC9(8) OIUH_DEC9_8
ROYH_VER_NOOIUH_DEC5 OIUH_DEC5DEC5DEC5
ROYH_USER_IDOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
ROYH_TIMESTAMPOIUH_CHAR14 OIUH_CHAR14CHAR14CHAR14

Key field Non-key field



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

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

SELECT SINGLE *
FROM OIUH_RV_ROYH
INTO CORRESPONDING FIELDS OF WA_OIUH_RV_ROYH
WHERE...

How to access SAP table OIUH_RV_ROYH

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