SAP ABAP Table ROIUREP_MMS_2014_FORM_DETAIL (Detail Information for MMS 2014 FORM)
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_FORM_DETAIL   Table Relationship Diagram
Short Description Detail Information for MMS 2014 FORM    
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 API_WELL_NO_1 CHAR15 CHAR15 CHAR 15   0   Char 15  
2 MMS_LEASE_SUB1_1 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
3 MMS_LEASE_SUB2_1 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
4 MMS_LEASE_SUB3_1 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
5 MMS_AGREEMNT_SUB1_1 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
6 MMS_AGREEMNT_SUB2_1 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
7 MMS_AGREEMNT_SUB3_1 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
8 PRODUCT_CD_1 OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
9 SALES_TYPE_CD_1 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_MONTH_YR_1 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
11 TRANS_CD_1 OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
12 ADJ_CD_1 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
13 SALES_VOLUME_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
14 ROY_PRIOR_ALLOW_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
15 GAS_MMBTU_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
16 TRANSP_ALLOW_DED_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
17 SALES_VALUE_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
18 PROC_ALLOW_DED_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
19 ROY_LESS_ALLOW_1 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
20 PAY_METHOD_CD_1 OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
21 RESERV_SPACE_1 OIUREP_MMS_2014_RESERV_SPACE   CHAR 20   0   Production: MMS-2104 - Reserve Space  
22 API_WELL_NO_2 CHAR15 CHAR15 CHAR 15   0   Char 15  
23 MMS_LEASE_SUB1_2 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
24 MMS_LEASE_SUB2_2 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
25 MMS_LEASE_SUB3_2 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
26 MMS_AGREEMNT_SUB1_2 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
27 MMS_AGREEMNT_SUB2_2 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
28 MMS_AGREEMNT_SUB3_2 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
29 PRODUCT_CD_2 OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
30 SALES_TYPE_CD_2 OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD CHAR 4   0   Production: MMS-2014 - Sales Type Code OIUREP_SALESTY
31 SALES_MONTH_YR_2 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
32 TRANS_CD_2 OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
33 ADJ_CD_2 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
34 SALES_VOLUME_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
35 ROY_PRIOR_ALLOW_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
36 GAS_MMBTU_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
37 TRANSP_ALLOW_DED_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
38 SALES_VALUE_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
39 PROC_ALLOW_DED_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
40 ROY_LESS_ALLOW_2 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
41 PAY_METHOD_CD_2 OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
42 RESERV_SPACE_2 OIUREP_MMS_2014_RESERV_SPACE   CHAR 20   0   Production: MMS-2104 - Reserve Space  
43 API_WELL_NO_3 CHAR15 CHAR15 CHAR 15   0   Char 15  
44 MMS_LEASE_SUB1_3 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
45 MMS_LEASE_SUB2_3 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
46 MMS_LEASE_SUB3_3 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
47 MMS_AGREEMNT_SUB1_3 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
48 MMS_AGREEMNT_SUB2_3 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
49 MMS_AGREEMNT_SUB3_3 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
50 PRODUCT_CD_3 OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
51 SALES_TYPE_CD_3 OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD CHAR 4   0   Production: MMS-2014 - Sales Type Code OIUREP_SALESTY
52 SALES_MONTH_YR_3 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
53 TRANS_CD_3 OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
54 ADJ_CD_3 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
55 SALES_VOLUME_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
56 ROY_PRIOR_ALLOW_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
57 GAS_MMBTU_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
58 TRANSP_ALLOW_DED_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
59 SALES_VALUE_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
60 PROC_ALLOW_DED_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
61 ROY_LESS_ALLOW_3 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
62 PAY_METHOD_CD_3 OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
63 RESERV_SPACE_3 OIUREP_MMS_2014_RESERV_SPACE   CHAR 20   0   Production: MMS-2104 - Reserve Space  
64 API_WELL_NO_4 CHAR15 CHAR15 CHAR 15   0   Char 15  
65 MMS_LEASE_SUB1_4 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
66 MMS_LEASE_SUB2_4 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
67 MMS_LEASE_SUB3_4 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
68 MMS_AGREEMNT_SUB1_4 CHAR3 CHAR3 CHAR 3   0   3-Byte field  
69 MMS_AGREEMNT_SUB2_4 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
70 MMS_AGREEMNT_SUB3_4 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
71 PRODUCT_CD_4 OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
72 SALES_TYPE_CD_4 OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD CHAR 4   0   Production: MMS-2014 - Sales Type Code OIUREP_SALESTY
73 SALES_MONTH_YR_4 CHAR6 CHAR6 CHAR 6   0   Character field of length 6  
74 TRANS_CD_4 OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
75 ADJ_CD_4 CHAR2 CHAR2 CHAR 2   0   Version Number Component  
76 SALES_VOLUME_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
77 ROY_PRIOR_ALLOW_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
78 GAS_MMBTU_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
79 TRANSP_ALLOW_DED_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
80 SALES_VALUE_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
81 PROC_ALLOW_DED_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
82 ROY_LESS_ALLOW_4 CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
83 PAY_METHOD_CD_4 OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
84 RESERV_SPACE_4 OIUREP_MMS_2014_RESERV_SPACE   CHAR 20   0   Production: MMS-2104 - Reserve Space  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUREP_MMS_2014_FORM_DETAIL SALES_TYPE_CD_1 OIUREP_SALESTY SALES_TYPE_CD    
2 ROIUREP_MMS_2014_FORM_DETAIL SALES_TYPE_CD_2 OIUREP_SALESTY SALES_TYPE_CD    
3 ROIUREP_MMS_2014_FORM_DETAIL SALES_TYPE_CD_3 OIUREP_SALESTY SALES_TYPE_CD    
4 ROIUREP_MMS_2014_FORM_DETAIL SALES_TYPE_CD_4 OIUREP_SALESTY SALES_TYPE_CD    
History
Last changed by/on SAP  20050301 
SAP Release Created in 46C