SAP ABAP Table ROIUREP_MMS_2014_RT_NON (Production: MMS-2014 - Royalty Transactions Non-Key Fields)

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	INTTAB	Structure
Structure	ROIUREP_MMS_2014_RT_NON	Table Relationship Diagram
Short Description	Production: MMS-2014 - Royalty Transactions Non-Key Fields

Delivery and Maintenance

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

History

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