SAP ABAP Table OIUREP_MMS_REJS (MMS-2014 - Extraction Rejects)

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_MMS_REJS	Table Relationship Diagram
Short Description	MMS-2014 - Extraction Rejects

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

History

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