SAP ABAP Table OIUH_RV_ROYH (New Mexico Royalty History)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV (Application Component) Revenue
     ⤷ OIU_H (Package) PRA Hybrid Solution

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUH_RV_ROYH	Table Relationship Diagram
Short Description	New Mexico Royalty History

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DUMMY_SEQ_FIELD	☑	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
3	ROYH_SYS_NO	☐	OIUH_DEC18	DEC18	DEC	18	0	OIUH_DEC18
4	OYH_OR_LVL_1_NO	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
5	ROYH_MP_NO9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
6	ROYH_MP_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
7	ROYH_WL_NO9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
8	ROYH_WL_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
9	ROYH_WC_NO9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
10	ROYH_WC_NO	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
11	ROYH_PR_NO9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
12	ROYH_PR_NO	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
13	ROYH_DOI_NO9	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
14	ROYH_DOI_NO	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
15	ROYH_MAJ_PD_CD	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
16	ROYH_PD_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
17	ROYH_NM_PD_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
18	ROYH_SA_DT	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14
19	ROYH_CT_NO	☐	OIUH_CONTRACT_ID	CHAR6	CHAR	6	0	Contract ID
20	ROYH_ST_RPT_NO	☐	OIUH_CHAR13	CHAR13	CHAR	13	0	OIUH_CHAR13
21	OYH_NM_OGRID_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
22	ROYH_TXN_CD	☐	OIUH_CHAR2	CHAR2	CHAR	2	0	OIUH_CHAR2
23	ROYH_NO_PU_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
24	ROYH_PPA_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
25	ROYH_RVRS_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
26	ROYH_TRANS_AM	☐	OIUH_CURR11_2	OIUH_CURR11_2	CURR	11	2	Local amount
27	ROYH_GRVA_AM	☐	OIUH_CURR11_2	OIUH_CURR11_2	CURR	11	2	Local amount
28	ROYH_NGL_GR_QY	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
29	ROYH_MCF_GR_QY	☐	OIUH_DEC11_2	OIUH_DEC11_2	DEC	11	2	OIUH_DEC11_2
30	YH_TRANS_DED_AM	☐	OIUH_CURR11_2	OIUH_CURR11_2	CURR	11	2	Local amount
31	OYH_PRCS_DED_AM	☐	OIUH_CURR11_2	OIUH_CURR11_2	CURR	11	2	Local amount
32	ROYH_AVG_BTU_QY	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
33	ROYH_BTU_QY	☐	OIUH_DEC7_3	OIUH_DEC7_3	DEC	7	3	OIUH_DEC7_3
34	YH_OBAL_DECM_QY	☐	OIUH_DEC9_8	OIUH_DEC9_8	DEC	9	8	OIUH_DEC9_8
35	ROYH_VER_NO	☐	OIUH_DEC5	DEC5	DEC	5	0	OIUH_DEC5
36	ROYH_USER_ID	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
37	ROYH_TIMESTAMP	☐	OIUH_CHAR14	CHAR14	CHAR	14	0	OIUH_CHAR14

History

Last changed by/on	SAP	20130529
SAP Release Created in