SAP ABAP Table OIUREP_MRT_PEND (MMS-2014 MMS Royalty Transaction Processed - Pending)

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_MRT_PEND	Table Relationship Diagram
Short Description	MMS-2014 MMS Royalty Transaction Processed - Pending

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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 - Report Detail Processing Key
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	DOC_ID	☑	OIUREP_MMS_2014_DOC_ID		CHAR	8	0	Production: MMS-2104 - Document ID
4	DET_LINE_NO	☑	OIU_LIN_NO	NUMC5	NUMC	5	0	Line Number
5	.INCLUDE	☐				0	0	Production: MMS-2014 - Report Detail Processing NON Key
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	PAYOR_NO	☐	OIUREP_MMS_2014_PAYOR		CHAR	5	0	Production: MMS-2014 - Payor
8	SALES_YEAR	☐	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
9	SALES_MONTH	☐	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
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	RESERV_SPACE	☐	OIUREP_MMS_2014_RESERV_SPACE		CHAR	20	0	Production: MMS-2104 - Reserve Space
12	LEASE_NO	☐	OIUREP_MMS_2014_LEASE_NO		CHAR	11	0	MMS-2014 - Lease Number	OIUREP_FEDINDIAN
13	AGREEMENT_NO	☐	OIUREP_MMS_2014_AGREEMENT_NO		CHAR	11	0	Production: MMS-2014 - Agreement Number	OIUREP_LEASE
14	API_WELL_NO	☐	OIU_WLAPI	OIU_WLAPI	CHAR	12	0	API well number
15	API_WELL_CM_NO	☐	OIU_API_WC_NO	OIU_API_WC_NO	CHAR	3	0	API well completion number
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	TRANS_CD	☐	OIUREP_MMS_2014_TRANS_CD	OIUREP_MMS_2014_TRANS_CD	CHAR	2	0	Production: MMS-2014 - Transaction Code
19	ADJ_CD	☐	OIUREP_MMS_2014_ADJ_CD	OIUREP_MMS_2014_ADJ_CD	NUMC	2	0	Production: MMS-2014 - Adjustment Reason Code
20	MMS_SA_QY	☐	OIUREP_MMS_2014_MMS_SA_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - MMS Sales Quantity
21	MMS_SA_QY_U	☐	OIUREP_MMS_2014_MMS_SA_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - MMS Sales Quantity Unit	T006
22	GAS_MMBTU_QY	☐	OIUREP_MMS_2014_GAS_MMBTU_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Gas MMBTU Qty
23	GAS_MMBTU_QY_U	☐	OIUREP_MMS_2014_GAS_MMBTU_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Gas MMBTU Qty Unit	T006
24	MMS_SA_AMT	☐	OIUREP_MMS_2014_MMS_SA_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - MMS Sales Amount
25	MMS_SA_CUR	☐	OIUREP_MMS_2014_MMS_SA_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - MMS Sales Currency	TCURC
26	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
27	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
28	TRNSP_ALW_DE_AMT	☐	OIUREP_MMS_2014_TRNSP_ALLW_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Transportation Allowance Amount
29	TRNSP_ALW_DE_CUR	☐	OIUREP_MMS_2014_TRNSP_ALLW_CUR	WAERS	CUKY	5	0	MMS-2014 - Transportation Allowance Currency	TCURC
30	PROC_ALW_DE_AMT	☐	OIUREP_MMS_2014_MFRING_UOM_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Manufacturing UOM Amount
31	PROC_ALW_DE_CUR	☐	OIUREP_MMS_2014_MFRING_UOM_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Manufacturing UOM Currency	TCURC
32	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
33	ROY_LS_ALLOW_CUR	☐	OIUREP_MMS_2014_ROY_LS_ALW_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Royalty Value Less Allows Curr	TCURC
34	PAY_METHOD_CD	☐	OIUREP_MMS_2014_PAY_METHOD_CD	OIUREP_MMS_2014_PAY_METHOD_CD	CHAR	1	0	Production: MMS-2014 - Payment Method Code
35	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
36	REVERSAL_FL	☐	OIUREP_MMS_2014_REVERSAL_FL	YESNO	CHAR	1	0	Production: MMS-2014 - Reversal History Flag
37	REVERSAL_YEAR	☐	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
38	REVERSAL_MONTH	☐	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
39	SALES_DATE	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
40	.INCLUDE	☐				0	0	Creator and date/time created
41	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
42	OIU_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_MRT_PEND	AGREEMENT_NO	OIUREP_LEASE	FED_INDIAN_CD
2	OIUREP_MRT_PEND	BUKRS	T001	BUKRS
3	OIUREP_MRT_PEND	GAS_MMBTU_QY_U	T006	MSEHI
4	OIUREP_MRT_PEND	INDIAN_TRIBE_NO	OIUREP_INDIAN_TR	INDIAN_TRIBE_NO
5	OIUREP_MRT_PEND	LEASE_NO	OIUREP_FEDINDIAN	LEASE_NO
6	OIUREP_MRT_PEND	MANDT	T000	MANDT
7	OIUREP_MRT_PEND	MMS_SA_CUR	TCURC	WAERS
8	OIUREP_MRT_PEND	MMS_SA_QY_U	T006	MSEHI
9	OIUREP_MRT_PEND	PROC_ALW_DE_CUR	TCURC	WAERS
10	OIUREP_MRT_PEND	ROY_LS_ALLOW_CUR	TCURC	WAERS
11	OIUREP_MRT_PEND	ROY_PR_ALW_CUR	TCURC	WAERS
12	OIUREP_MRT_PEND	SALES_TYPE_CD	OIUREP_SALESTY	SALES_TYPE_CD
13	OIUREP_MRT_PEND	TRNSP_ALW_DE_CUR	TCURC	WAERS

History

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