SAP ABAP Table ROIUREP_MRT_HIST (Change Document Structure; Generated by RSSCD000)

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_MRT_HIST	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

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	.INCLUDE	☐				0	0	MMS-2014 MMS Royalty Transaction Processed History
2	.INCLUDE	☐				0	0	Production: MMS-2014 - Report Detail Processing Key
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	DOC_ID	☐	OIUREP_MMS_2014_DOC_ID		CHAR	8	0	Production: MMS-2104 - Document ID
5	DET_LINE_NO	☐	OIU_LIN_NO	NUMC5	NUMC	5	0	Line Number
6	.INCLUDE	☐				0	0	Production: MMS-2014 - Report Detail Processing NON Key
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	PAYOR_NO	☐	OIUREP_MMS_2014_PAYOR		CHAR	5	0	Production: MMS-2014 - Payor
9	SALES_YEAR	☐	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
10	SALES_MONTH	☐	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
11	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
12	RESERV_SPACE	☐	OIUREP_MMS_2014_RESERV_SPACE		CHAR	20	0	Production: MMS-2104 - Reserve Space
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	API_WELL_NO	☐	OIU_WLAPI	OIU_WLAPI	CHAR	12	0	API well number
16	API_WELL_CM_NO	☐	OIU_API_WC_NO	OIU_API_WC_NO	CHAR	3	0	API well completion number
17	MMS_PROD_CD	☐	OIUREP_MMS_PRODUCT_CODE	OIUREP_MMS_PRODUCT_CODE	CHAR	2	0	Production: MMS Product Code
18	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
19	TRANS_CD	☐	OIUREP_MMS_2014_TRANS_CD	OIUREP_MMS_2014_TRANS_CD	CHAR	2	0	Production: MMS-2014 - Transaction Code
20	ADJ_CD	☐	OIUREP_MMS_2014_ADJ_CD	OIUREP_MMS_2014_ADJ_CD	NUMC	2	0	Production: MMS-2014 - Adjustment Reason Code
21	MMS_SA_QY	☐	OIUREP_MMS_2014_MMS_SA_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - MMS Sales Quantity
22	MMS_SA_QY_U	☐	OIUREP_MMS_2014_MMS_SA_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - MMS Sales Quantity Unit	T006
23	GAS_MMBTU_QY	☐	OIUREP_MMS_2014_GAS_MMBTU_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Gas MMBTU Qty
24	GAS_MMBTU_QY_U	☐	OIUREP_MMS_2014_GAS_MMBTU_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Gas MMBTU Qty Unit	T006
25	MMS_SA_AMT	☐	OIUREP_MMS_2014_MMS_SA_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - MMS Sales Amount
26	MMS_SA_CUR	☐	OIUREP_MMS_2014_MMS_SA_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - MMS Sales Currency	TCURC
27	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
28	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
29	TRNSP_ALW_DE_AMT	☐	OIUREP_MMS_2014_TRNSP_ALLW_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Transportation Allowance Amount
30	TRNSP_ALW_DE_CUR	☐	OIUREP_MMS_2014_TRNSP_ALLW_CUR	WAERS	CUKY	5	0	MMS-2014 - Transportation Allowance Currency	TCURC
31	PROC_ALW_DE_AMT	☐	OIUREP_MMS_2014_MFRING_UOM_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Manufacturing UOM Amount
32	PROC_ALW_DE_CUR	☐	OIUREP_MMS_2014_MFRING_UOM_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Manufacturing UOM Currency	TCURC
33	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
34	ROY_LS_ALLOW_CUR	☐	OIUREP_MMS_2014_ROY_LS_ALW_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Royalty Value Less Allows Curr	TCURC
35	PAY_METHOD_CD	☐	OIUREP_MMS_2014_PAY_METHOD_CD	OIUREP_MMS_2014_PAY_METHOD_CD	CHAR	1	0	Production: MMS-2014 - Payment Method Code
36	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
37	REVERSAL_FL	☐	OIUREP_MMS_2014_REVERSAL_FL	YESNO	CHAR	1	0	Production: MMS-2014 - Reversal History Flag
38	REVERSAL_YEAR	☐	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
39	REVERSAL_MONTH	☐	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
40	SALES_DATE	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
41	.INCLUDE	☐				0	0	Creator and date/time created
42	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
43	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
44	.INCLUDE	☐				0	0	Structures for generating change document update programs
45	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUREP_MRT_HIST	AGREEMENT_NO	OIUREP_LEASE	FED_INDIAN_CD
2	ROIUREP_MRT_HIST	BUKRS	T001	BUKRS
3	ROIUREP_MRT_HIST	GAS_MMBTU_QY_U	T006	MSEHI
4	ROIUREP_MRT_HIST	INDIAN_TRIBE_NO	OIUREP_INDIAN_TR	INDIAN_TRIBE_NO
5	ROIUREP_MRT_HIST	LEASE_NO	OIUREP_FEDINDIAN	LEASE_NO
6	ROIUREP_MRT_HIST	MANDT	T000	MANDT
7	ROIUREP_MRT_HIST	MMS_SA_CUR	TCURC	WAERS
8	ROIUREP_MRT_HIST	MMS_SA_QY_U	T006	MSEHI
9	ROIUREP_MRT_HIST	PROC_ALW_DE_CUR	TCURC	WAERS
10	ROIUREP_MRT_HIST	ROY_LS_ALLOW_CUR	TCURC	WAERS
11	ROIUREP_MRT_HIST	ROY_PR_ALW_CUR	TCURC	WAERS
12	ROIUREP_MRT_HIST	SALES_TYPE_CD	OIUREP_SALESTY	SALES_TYPE_CD
13	ROIUREP_MRT_HIST	TRNSP_ALW_DE_CUR	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in