SAP ABAP Table OIUREP_RT_HIST (MMS-2014 - Royalty Transaction (Pending) History)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUREP_RT_HIST	Table Relationship Diagram
Short Description	MMS-2014 - Royalty Transaction (Pending) 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	.INCLUDE	☑				0	0	Production: MMS-2014 - Royalty Transactions Key Fields
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SALES_YEAR	☑	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
5	SALES_MONTH	☑	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
6	RTP_LINE_NUM	☑	OIUREP_MMS_2014_LINE_NO	NUMC10	NUMC	10	0	MMS-2014 - Line Number
7	.INCLUDE	☐				0	0	Production: MMS-2014 - Royalty Transactions Non-Key Fields
8	PAYOR_NO	☐	OIUREP_MMS_2014_PAYOR		CHAR	5	0	Production: MMS-2014 - Payor
9	FED_INDIAN_CD	☐	OIUREP_MMS_2014_FED_INDIAN_CD	OIUREP_MMS_2014_FED_INDIAN_CD	CHAR	1	0	Production: MMS-2014 - Federal or Indian Code
10	INDIAN_TRIBE_NO	☐	OIUREP_MMS_2014_INDN_TRIBE_NO	OIUREP_MMS_2014_INDN_TRIBE_NO	CHAR	2	0	Production: MMS-2014 - Indian Tribe Number	OIUREP_INDIAN_TR
11	API_WELL_NO	☐	OIU_WLAPI	OIU_WLAPI	CHAR	12	0	API well number
12	API_WELL_CM_NO	☐	OIU_API_WC_NO	OIU_API_WC_NO	CHAR	3	0	API well completion number
13	LEASE_NO	☐	OIUREP_MMS_2014_LEASE_NO		CHAR	11	0	MMS-2014 - Lease Number	OIUREP_FEDINDIAN
14	AGREEMENT_NO	☐	OIUREP_MMS_2014_AGREEMENT_NO		CHAR	11	0	Production: MMS-2014 - Agreement Number	OIUREP_LEASE
15	MMS_PROD_CD	☐	OIUREP_MMS_PRODUCT_CODE	OIUREP_MMS_PRODUCT_CODE	CHAR	2	0	Production: MMS Product Code
16	SALES_TYPE_CD	☐	OIUREP_MMS_2014_SALES_TYPE_CD	OIUREP_MMS_2014_SALES_TYPE_CD	CHAR	4	0	Production: MMS-2014 - Sales Type Code	OIUREP_SALESTY
17	SALES_DATE	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
18	TRANS_CD	☐	OIUREP_MMS_2014_TRANS_CD	OIUREP_MMS_2014_TRANS_CD	CHAR	2	0	Production: MMS-2014 - Transaction Code
19	PAY_METHOD_CD	☐	OIUREP_MMS_2014_PAY_METHOD_CD	OIUREP_MMS_2014_PAY_METHOD_CD	CHAR	1	0	Production: MMS-2014 - Payment Method Code
20	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
21	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
22	VNAME	☐	OIUREP_MMS_2014_PROPERTY	JV_NAME	CHAR	6	0	MMS-2014 - Venture	OIU_DO_JV
23	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
24	PU_NO	☐	OIU_PU_NO	KUNNR	CHAR	10	0	Purchaser	*
25	PU_SEQ_NO	☐	OIU_PU_REP_ISQ_NO	OIU_PU_REP_ISQ_NO	CHAR	2	0	Purchasing Representative Interest Sequence No
26	PU_AFFIL_FL	☐	OIUREP_MMS_2014_PU_AFFIL_FL	YESNO	CHAR	1	0	Production: MMS-2014 - Purchaser Affiliation Flag
27	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
28	OWN_NO	☐	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
29	OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
30	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIUCM_CONTRACT
31	GL_ACCTID_NO	☐	OIUH_ACCTID	CHAR10	CHAR	10	0	Account ID
32	NWK_NO	☐	OIUREP_MMS_2014_NWK_NO	OIUREP_MMS_2014_NWK_NO	CHAR	4	0	Network Number
33	SUB_NWK_NO	☐	OIUREP_MMS_2014_SUB_NWK_NO	OIUREP_MMS_2014_SUB_NWK_NO	CHAR	4	0	Sub Network Number
34	INT_TYPE_CD	☐	OIUREP_MMS_2014_INT_TYPE_CD	OIUREP_MMS_2014_INT_TYPE_CD	CHAR	2	0	Interest Type Code
35	INT_SEQ_NO	☐	OIUREP_MMS_2014_INT_SEQ_NO	OIUREP_MMS_2014_INT_SEQ_NO	CHAR	2	0	Interest Sequence Number
36	SALES_QY	☐	OIUREP_MMS_2014_SALES_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Sales Quantity
37	SALES_QY_U	☐	OIUREP_MMS_2014_SALES_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Sales Qty Unit	T006
38	SALES_GV_QY	☐	OIUREP_MMS_2014_SALES_GV_QY		QUAN	4	1	Production: MMS-2014 - Sales Gravity Qty
39	SALES_GV_QY_U	☐	OIUREP_MMS_2014_SALES_GV_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Sales Gravity Qty Unit	T006
40	SALES_BTU_QY	☐	OIUREP_MMS_2014_SALES_BTU_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Sales BTU Quantity
41	SALES_BTU_QY_U	☐	OIUREP_MMS_2014_SALES_BTU_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Sales BTU Qty Unit	T006
42	SALES_PS_BASE_QY	☐	OIU_PS_BASE	MENGE	QUAN	13	3	Pressure Base
43	SALES_PS_BASE_U	☐	OIU_PS_BASE_U	MEINS	UNIT	3	0	Pressure Base Unit	T006
44	SALES_AMT	☐	OIUREP_MMS_2014_SALES_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Sales Amount
45	SALES_CUR	☐	OIUREP_MMS_2014_SALES_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Sales Currency	TCURC
46	ROY_PR_ALW_AMT	☐	OIUREP_MMS_2014_ROY_PR_ALW_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Royalty Value Prior to Allows. Amt
47	ROY_PR_ALW_CUR	☐	OIUREP_MMS_2014_ROY_PR_ALW_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Royalty Value Prior to Allows. Curr	TCURC
48	TRNSP_ALW_DE_AMT	☐	OIUREP_MMS_2014_TRNSP_ALLW_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Transportation Allowance Amount
49	TRNSP_ALW_DE_CUR	☐	OIUREP_MMS_2014_TRNSP_ALLW_CUR	WAERS	CUKY	5	0	MMS-2014 - Transportation Allowance Currency	TCURC
50	PROC_ALW_DE_AMT	☐	OIUREP_MMS_2014_MFRING_UOM_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Manufacturing UOM Amount
51	PROC_ALW_DE_CUR	☐	OIUREP_MMS_2014_MFRING_UOM_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Manufacturing UOM Currency	TCURC
52	ROY_LS_ALLOW_AMT	☐	OIUREP_MMS_2014_ROY_LS_ALW_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Royalty Value Less Allows. Amt
53	ROY_LS_ALLOW_CUR	☐	OIUREP_MMS_2014_ROY_LS_ALW_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Royalty Value Less Allows Curr	TCURC
54	ROY_QY	☐	OIUREP_MMS_2014_ROY_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Royalty Quantity
55	ROY_QY_U	☐	OIUREP_MMS_2014_ROY_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Royalty Quantity Unit	T006
56	DED_REMB_AMT	☐	OIUREP_MMS_2014_DED_REMB_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Deduction Reimbursement Amount
57	DED_REMB_CUR	☐	OIUREP_MMS_2014_DED_REMB_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Deduction Reimbursement Currency	TCURC
58	TAX_AMT	☐	OIUREP_MMS_2014_TAX_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Tax Amount
59	TAX_CUR	☐	OIUREP_MMS_2014_TAX_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Tax Currency	TCURC
60	TAX_REMB_AMT	☐	OIUREP_MMS_2014_TAX_REMB_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Tax Reimbursement Amount
61	TAX_REMB_CUR	☐	OIUREP_MMS_2014_TAX_REMB_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Tax Reimbursement Currency	TCURC
62	MMS_ROY_QY	☐	OIUREP_MMS_2014_MMS_ROY_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - MMS Royalty Quantity
63	MMS_ROY_QY_U	☐	OIUREP_MMS_2014_MMS_ROY_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - MMS Royalty Quantity Unit	T006
64	MMS_PS_BASE_QY	☐	OIU_PS_BASE	MENGE	QUAN	13	3	Pressure Base
65	MMS_PS_BASE_QY_U	☐	OIU_PS_BASE_U	MEINS	UNIT	3	0	Pressure Base Unit	T006
66	MMS_ROY_AMT	☐	OIUREP_MMS_2014_MMS_ROY_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	MMS-2014 - JE Offset Amount
67	MMS_ROY_CUR	☐	OIUREP_MMS_2014_MMS_ROY_CUR	WAERS	CUKY	5	0	MMS-2014 - JE Offset Currency	TCURC
68	MMS_SA_QY	☐	OIUREP_MMS_2014_MMS_SA_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - MMS Sales Quantity
69	MMS_SA_QY_U	☐	OIUREP_MMS_2014_MMS_SA_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - MMS Sales Quantity Unit	T006
70	MMS_SA_AMT	☐	OIUREP_MMS_2014_MMS_SA_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - MMS Sales Amount
71	MMS_SA_CUR	☐	OIUREP_MMS_2014_MMS_SA_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - MMS Sales Currency	TCURC
72	SUSPEND_RSN_CD	☐	OIU_SUSP_CD	OIU_SUSP_CD	CHAR	3	0	Suspense Reason Code	OIU_CM_SUSP
73	ADJ_CD	☐	OIUREP_MMS_2014_ADJ_CD	OIUREP_MMS_2014_ADJ_CD	NUMC	2	0	Production: MMS-2014 - Adjustment Reason Code
74	ADJ_SA_QY	☐	OIUREP_MMS_2014_ADJ_SA_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Adjusted Sales Quantity
75	ADJ_SA_QY_U	☐	OIUREP_MMS_2014_ADJ_SA_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Adjusted Sales Quantity Unit	T006
76	ADJ_ROY_QY	☐	OIUREP_MMS_2014_ADJ_ROY_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Adjusted Royalty Quantity
77	ADJ_ROY_QY_U	☐	OIUREP_MMS_2014_ADJ_ROY_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Adjusted Royalty Quantity Unit	T006
78	ADJ_BTU_QY	☐	OIUREP_MMS_2014_ADJ_BTU_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Adjusted BTU Quantity
79	ADJ_BTU_QY_U	☐	OIUREP_MMS_2014_ADJ_BTU_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Adjusted BTU Quantity Unit	T006
80	GAS_MMBTU_QY	☐	OIUREP_MMS_2014_GAS_MMBTU_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Gas MMBTU Qty
81	GAS_MMBTU_QY_U	☐	OIUREP_MMS_2014_GAS_MMBTU_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Gas MMBTU Qty Unit	T006
82	HISTORY_FL	☐	OIUREP_MMS_2014_HISTORY_FL	YESNO	CHAR	1	0	Production: MMS-2014 - History Flag
83	REPORT_PART_FAC	☐	OIUREP_MMS_2014_RPT_PART_FAC		DEC	9	8	Production: MMS-2014 - Report Participation Factor
84	TRIBAL_ALLOT_CD	☐	OIUREP_MMS_2014_TRIB_ALLOT_CD	OIUREP_MMS_2014_TRIB_ALLOT_CD	CHAR	1	0	Production: MMS-2014 - Tribal/Allottee Code
85	COMP_ROY_FL	☐	OIUREP_MMS_2014_COMP_ROY_FL	YESNO	CHAR	1	0	Production: MMS-2014 - Compensatory Royalty Flag
86	ROY_IN_KIND_FL	☐	OIUREP_MMS_2014_ROY_IN_KIND_FL	YESNO	CHAR	1	0	Production: MMS-2014 - Royalty In Kind Flag
87	PAY_CD	☐	OIUREP_MMS_2014_PAY_CD		CHAR	2	0	Production: MMS-2014 - Payment Code
88	EXTRACTED_FL	☐	OIUREP_MMS_2014_EXTRACTED_FL	YESNO	CHAR	1	0	MMS-2014: Extracted
89	EXTRACT_RUN_TYPE	☐	OIUREP_MMS_2014_RUN_TYPE	OIUREP_RUN_TYPE	CHAR	1	0	Defines whether the run is direct pay or not
90	MANUAL_CREATE_FL	☐			CHAR	1	0
91	.INCLUDE	☐				0	0	Creator and date/time created
92	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
93	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
94	.INCLUDE	☐				0	0	Change Username & Timestamp
95	CHANGE_USER	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
96	CHANGE_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_RT_HIST	ADJ_BTU_QY_U	T006	MSEHI
2	OIUREP_RT_HIST	ADJ_ROY_QY_U	T006	MSEHI
3	OIUREP_RT_HIST	ADJ_SA_QY_U	T006	MSEHI
4	OIUREP_RT_HIST	AGREEMENT_NO	OIUREP_LEASE	FED_INDIAN_CD
5	OIUREP_RT_HIST	BUKRS	T001	BUKRS
6	OIUREP_RT_HIST	CT_NO	OIUCM_CONTRACT	VBELN	KEY
7	OIUREP_RT_HIST	DED_REMB_CUR	TCURC	WAERS
8	OIUREP_RT_HIST	DOI_NO	OIU_DO_DI	DOI_NO
9	OIUREP_RT_HIST	GAS_MMBTU_QY_U	T006	MSEHI
10	OIUREP_RT_HIST	INDIAN_TRIBE_NO	OIUREP_INDIAN_TR	INDIAN_TRIBE_NO	KEY
11	OIUREP_RT_HIST	LEASE_NO	OIUREP_FEDINDIAN	LEASE_NO	KEY
12	OIUREP_RT_HIST	MANDT	T000	MANDT
13	OIUREP_RT_HIST	MATNR	OIU_CM_MAT_PRCD	MATNR	KEY
14	OIUREP_RT_HIST	MMS_PS_BASE_QY_U	T006	MSEHI
15	OIUREP_RT_HIST	MMS_ROY_CUR	TCURC	WAERS
16	OIUREP_RT_HIST	MMS_ROY_QY_U	T006	MSEHI
17	OIUREP_RT_HIST	MMS_SA_CUR	TCURC	WAERS
18	OIUREP_RT_HIST	MMS_SA_QY_U	T006	MSEHI
19	OIUREP_RT_HIST	OWN_NO	LFA1	LIFNR	KEY
20	OIUREP_RT_HIST	PROC_ALW_DE_CUR	TCURC	WAERS
21	OIUREP_RT_HIST	ROY_LS_ALLOW_CUR	TCURC	WAERS
22	OIUREP_RT_HIST	ROY_PR_ALW_CUR	TCURC	WAERS
23	OIUREP_RT_HIST	ROY_QY_U	T006	MSEHI
24	OIUREP_RT_HIST	SALES_BTU_QY_U	T006	MSEHI
25	OIUREP_RT_HIST	SALES_CUR	TCURC	WAERS
26	OIUREP_RT_HIST	SALES_GV_QY_U	T006	MSEHI
27	OIUREP_RT_HIST	SALES_PS_BASE_U	T006	MSEHI
28	OIUREP_RT_HIST	SALES_QY_U	T006	MSEHI
29	OIUREP_RT_HIST	SALES_TYPE_CD	OIUREP_SALESTY	SALES_TYPE_CD
30	OIUREP_RT_HIST	SUSPEND_RSN_CD	OIU_CM_SUSP	SUSP_CD	KEY
31	OIUREP_RT_HIST	TAX_CUR	TCURC	WAERS
32	OIUREP_RT_HIST	TAX_REMB_CUR	TCURC	WAERS
33	OIUREP_RT_HIST	TRNSP_ALW_DE_CUR	TCURC	WAERS
34	OIUREP_RT_HIST	VNAME	OIU_DO_JV	VNAME
35	OIUREP_RT_HIST	WC_NO	OIU_PR_WC	WC_NO	KEY
36	OIUREP_RT_HIST	WL_NO	OIU_PR_WELL	WL_NO	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C