SAP ABAP Table ROIUREP_MMS_2014_REP_DTL_NON (Production: MMS-2014 - Report Detail Processing NON Key)

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_REP_DTL_NON	Table Relationship Diagram
Short Description	Production: MMS-2014 - Report Detail Processing NON Key

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	PAYOR_NO	☐	OIUREP_MMS_2014_PAYOR		CHAR	5	0	Production: MMS-2014 - Payor
3	SALES_YEAR	☐	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
4	SALES_MONTH	☐	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
5	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
6	RESERV_SPACE	☐	OIUREP_MMS_2014_RESERV_SPACE		CHAR	20	0	Production: MMS-2104 - Reserve Space
7	LEASE_NO	☐	OIUREP_MMS_2014_LEASE_NO		CHAR	11	0	MMS-2014 - Lease Number	OIUREP_FEDINDIAN
8	AGREEMENT_NO	☐	OIUREP_MMS_2014_AGREEMENT_NO		CHAR	11	0	Production: MMS-2014 - Agreement Number	OIUREP_LEASE
9	API_WELL_NO	☐	OIU_WLAPI	OIU_WLAPI	CHAR	12	0	API well number
10	API_WELL_CM_NO	☐	OIU_API_WC_NO	OIU_API_WC_NO	CHAR	3	0	API well completion number
11	MMS_PROD_CD	☐	OIUREP_MMS_PRODUCT_CODE	OIUREP_MMS_PRODUCT_CODE	CHAR	2	0	Production: MMS Product Code
12	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
13	TRANS_CD	☐	OIUREP_MMS_2014_TRANS_CD	OIUREP_MMS_2014_TRANS_CD	CHAR	2	0	Production: MMS-2014 - Transaction Code
14	ADJ_CD	☐	OIUREP_MMS_2014_ADJ_CD	OIUREP_MMS_2014_ADJ_CD	NUMC	2	0	Production: MMS-2014 - Adjustment Reason Code
15	MMS_SA_QY	☐	OIUREP_MMS_2014_MMS_SA_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - MMS Sales Quantity
16	MMS_SA_QY_U	☐	OIUREP_MMS_2014_MMS_SA_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - MMS Sales Quantity Unit	T006
17	GAS_MMBTU_QY	☐	OIUREP_MMS_2014_GAS_MMBTU_QY	OIUCM_QUANTITY_13_DECIMAL_3	QUAN	13	3	Production: MMS-2014 - Gas MMBTU Qty
18	GAS_MMBTU_QY_U	☐	OIUREP_MMS_2014_GAS_MMBTU_QY_U	MEINS	UNIT	3	0	Production: MMS-2014 - Gas MMBTU Qty Unit	T006
19	MMS_SA_AMT	☐	OIUREP_MMS_2014_MMS_SA_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - MMS Sales Amount
20	MMS_SA_CUR	☐	OIUREP_MMS_2014_MMS_SA_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - MMS Sales Currency	TCURC
21	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
22	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
23	TRNSP_ALW_DE_AMT	☐	OIUREP_MMS_2014_TRNSP_ALLW_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Transportation Allowance Amount
24	TRNSP_ALW_DE_CUR	☐	OIUREP_MMS_2014_TRNSP_ALLW_CUR	WAERS	CUKY	5	0	MMS-2014 - Transportation Allowance Currency	TCURC
25	PROC_ALW_DE_AMT	☐	OIUREP_MMS_2014_MFRING_UOM_AMT	OIUCM_CURRENCY_15_DECIMAL_2	CURR	15	2	Production: MMS-2014 - Manufacturing UOM Amount
26	PROC_ALW_DE_CUR	☐	OIUREP_MMS_2014_MFRING_UOM_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Manufacturing UOM Currency	TCURC
27	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
28	ROY_LS_ALLOW_CUR	☐	OIUREP_MMS_2014_ROY_LS_ALW_CUR	WAERS	CUKY	5	0	Production: MMS-2014 - Royalty Value Less Allows Curr	TCURC
29	PAY_METHOD_CD	☐	OIUREP_MMS_2014_PAY_METHOD_CD	OIUREP_MMS_2014_PAY_METHOD_CD	CHAR	1	0	Production: MMS-2014 - Payment Method Code
30	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
31	REVERSAL_FL	☐	OIUREP_MMS_2014_REVERSAL_FL	YESNO	CHAR	1	0	Production: MMS-2014 - Reversal History Flag
32	REVERSAL_YEAR	☐	OIUREP_MMS_2014_YEAR		NUMC	4	0	MMS-2014 - Year
33	REVERSAL_MONTH	☐	OIUREP_MMS_2014_MONTH	AM_MONAT	NUMC	2	0	MMS-2014 - Month
34	SALES_DATE	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
35	.INCLUDE	☐				0	0	Creator and date/time created
36	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
37	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	ROIUREP_MMS_2014_REP_DTL_NON	AGREEMENT_NO	OIUREP_LEASE	FED_INDIAN_CD
2	ROIUREP_MMS_2014_REP_DTL_NON	BUKRS	T001	BUKRS
3	ROIUREP_MMS_2014_REP_DTL_NON	GAS_MMBTU_QY_U	T006	MSEHI
4	ROIUREP_MMS_2014_REP_DTL_NON	INDIAN_TRIBE_NO	OIUREP_INDIAN_TR	INDIAN_TRIBE_NO
5	ROIUREP_MMS_2014_REP_DTL_NON	LEASE_NO	OIUREP_FEDINDIAN	LEASE_NO
6	ROIUREP_MMS_2014_REP_DTL_NON	MMS_SA_CUR	TCURC	WAERS
7	ROIUREP_MMS_2014_REP_DTL_NON	MMS_SA_QY_U	T006	MSEHI
8	ROIUREP_MMS_2014_REP_DTL_NON	PROC_ALW_DE_CUR	TCURC	WAERS
9	ROIUREP_MMS_2014_REP_DTL_NON	ROY_LS_ALLOW_CUR	TCURC	WAERS
10	ROIUREP_MMS_2014_REP_DTL_NON	ROY_PR_ALW_CUR	TCURC	WAERS
11	ROIUREP_MMS_2014_REP_DTL_NON	SALES_TYPE_CD	OIUREP_SALESTY	SALES_TYPE_CD
12	ROIUREP_MMS_2014_REP_DTL_NON	TRNSP_ALW_DE_CUR	TCURC	WAERS

History

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