SAP ABAP Table OIUREP_XTRCT_ROY (Extract Royaty Data for the current reporting period)
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_XTRCT_ROY   Table Relationship Diagram
Short Description Extract Royaty Data for the current reporting period    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 YEAR_MONTH OIUREP_RPT_YYYYMM OIUREP_RPT_YYYYMM NUMC 6   0   Reporting Year and Month  
3 AGENCY OIUREP_ROY_AGENCY CHAR3 CHAR 3   0   Agency for Reporting  
4 OIL_GAS_IND OIUREP_OIL_GAS_IND OIUREP_OIL_GAS_IND CHAR 1   0   Oil and Gas Indicator  
5 GL_OR_LVL_1_NO BUKRS BUKRS CHAR 4   0   Company Code *
6 OPSL_GL_SYS_NO OIUH_NUMC18 OIUH_NUMC18 NUMC 18   0   OIUH_NUMC18  
7 GL_ACCT_PERD_DT OIUREP_ACCT_PERD_DT CHAR14 CHAR 14   0   Accounting Period Date  
8 GL_ACCT_NO OIUREP_GL_ACCT_NO CHAR10 CHAR 10   0   GL Account No.  
9 BTCH_TYPE_CODE OIUREP_BTCH_TYPE_CODE CHAR2 CHAR 2   0   Batch Type  
10 GL_TRANS_AM OIUREP_GL_TRANS_AM OIUH_CURR11_2 CURR 11   2   GL Transaction Amount  
11 GL_TRANS_QY OIUREP_GL_TRANS_QY OIUH_DEC11_2 DEC 11   2   GL Transaction Quantity  
12 GL_GR_AM OIUREP_GL_GR_AM OIUH_CURR11_2 CURR 11   2   GL Gross Amount  
13 GL_GR_QY OIUREP_GL_GR_QY OIUH_DEC11_2 DEC 11   2   GL Gross Quantity  
14 GL_PD_CD MATNR MATNR CHAR 18   0   Material Number *
15 GL_VL_TYPE_CD OIUREP_GL_VL_TYPE_CD CHAR2 CHAR 2   0   GL Volume Type Code  
16 GL_PU_NO OIUH_CHAR6 CHAR6 CHAR 6   0   OIUH_CHAR6  
17 GL_PU_SEQ_NO OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
18 GL_CT_NO OIUREP_GL_CT_NO CHAR6 CHAR 6   0   Contract No.  
19 GL_CT_TYPE_CD OIUREP_GL_CT_TYPE_CD CHAR2 CHAR 2   0   GL Contract Type Code  
20 GL_PR_NO JV_NAME JV_NAME CHAR 6   0   Joint venture *
21 GL_DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) *
22 GL_WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number *
23 GL_WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number *
24 GL_SA_MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number *
25 GL_SA_DT OIUREP_GL_SA_DT CHAR14 CHAR 14   0   GL Sales Date  
26 GL_DN_NO OIUH_CHAR4 CHAR4 CHAR 4   0   OIUH_CHAR4  
27 GL_SUB_NWK_NO OIUH_CHAR4 CHAR4 CHAR 4   0   OIUH_CHAR4  
28 GL_CHV_RPT_CD OIUREP_GL_CHV_RPT_CD CHAR10 CHAR 10   0   GL Cost Center  
29 OPSL_BTU_QY OIUREP_OPSL_BTU_QY OIUH_DEC7_3 DEC 7   3   OPSL BTU Quantity  
30 OPSL_PS_BASE_QY OIUREP_OPSL_PS_BASE_QY OIUH_DEC6_3 DEC 6   3   OPSL Pressure Base Quantity  
31 OPSL_GRV_QY OIUREP_GRV_QY_NUMC4 NUMC4 NUMC 4   0   Gravity Quantity  
32 OPSL_OWN_NO OIUCM_MASTER OIUCM_MASTER CHAR 10   0   Master Record  
33 OPSL_PRDR_NO OIUREP_OPSL_PRDR_NO CHAR6 CHAR 6   0   OPSL Producer No.  
34 PSL_PRDR_SEQ_NO OIUREP_PSL_PRDR_SEQ_NO CHAR2 CHAR 2   0   OPSL Producer Sequence No.  
35 OWN_INT_DECM_QY OIUH_DEC9_8 OIUH_DEC9_8 DEC 9   8   OIUH_DEC9_8  
36 OWN_INT_TYPE_CD OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
37 OWN_INT_SEQ_NO OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
38 PSL_RVRS_RSN_CD OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
39 UNIT_OF_MEAS_CD OIUH_CHAR3 CHAR3 CHAR 3   0   OIUH_CHAR3  
40 OPSL_SUS_RSN_CD OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
41 OPSL_ORIG_MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number *
42 OPSL_DED_RMB_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
43 L_DED_GR_RMB_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
44 OPSL_TAX_RMB_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
45 L_TAX_GR_RMB_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
46 OPSL_PAY_CD OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
47 OPSL_ST_CD OIUREP_OPSL_ST_CD CHAR2 CHAR 2   0   OPSL State Code  
48 OWN_BAL_DECM_QY OIUH_DEC9_8 OIUH_DEC9_8 DEC 9   8   OIUH_DEC9_8  
49 OPSL_UNIT_PR_NO JV_NAME JV_NAME CHAR 6   0   Joint venture *
50 L_NET_TRANSP_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
51 L_NET_OTH_MK_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
52 SL_GR_TRANSP_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
53 SL_GR_OTH_MK_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
54 OPSL_AES_FL OIUH_CHAR1 CHAR1 CHAR 1   0   OIUH_CHAR1  
55 OPSL_TXN_VAL_AM OIUH_CURR11_2 OIUH_CURR11_2 CURR 11   2   Local amount  
56 OPSL_GR_PVR_AM OIUH_DEC11_2 OIUH_DEC11_2 DEC 11   2   OIUH_DEC11_2  
57 OPSL_OWN_PVR_AM OIUH_DEC11_2 OIUH_DEC11_2 DEC 11   2   OIUH_DEC11_2  
58 MMBTU_OWN_VL_AM OIUH_DEC11_2 OIUH_DEC11_2 DEC 11   2   OIUH_DEC11_2  
59 PSL_SPC_PYMT_CD OIUH_CHAR1 CHAR1 CHAR 1   0   OIUH_CHAR1  
60 OPSL_LGND_CD OIUH_CHAR2 CHAR2 CHAR 2   0   OIUH_CHAR2  
61 OPSL_ESCH_FL OIUH_CHAR1 CHAR1 CHAR 1   0   OIUH_CHAR1  
62 OPSL_CMT_SYS_NO OIUH_DEC18 DEC18 DEC 18   0   OIUH_DEC18  
63 PSL_INT_PAID_FL OIUH_CHAR1 CHAR1 CHAR 1   0   OIUH_CHAR1  
64 SL_OP_NON_OP_FL OIUH_CHAR1 CHAR1 CHAR 1   0   OIUH_CHAR1  
65 OTAX_TAX_AM1 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
66 OTAX_TAX_AM2 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
67 OTAX_TAX_AM3 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
68 OTAX_TAX_AM4 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
69 OTAX_TAX_AM5 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
70 OTAX_TAX_AM6 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
71 OTAX_TAX_AM7 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
72 OTAX_TAX_AM8 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
73 OTAX_TAX_AM9 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
74 OTAX_TAX_AM10 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
75 GTAX_TAX_AM1 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
76 GTAX_TAX_AM2 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
77 GTAX_TAX_AM3 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
78 GTAX_TAX_AM4 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
79 GTAX_TAX_AM5 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
80 GTAX_TAX_AM6 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
81 GTAX_TAX_AM7 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
82 GTAX_TAX_AM8 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
83 GTAX_TAX_AM9 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
84 GTAX_TAX_AM10 OIUREP_TAX_AMOUNT OIUH_CURR11_2 CURR 11   2   Tax Amount  
85 ODED_DED_AM1 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
86 ODED_DED_AM2 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
87 ODED_DED_AM3 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
88 ODED_DED_AM4 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
89 ODED_DED_AM5 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
90 ODED_DED_AM6 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
91 ODED_DED_AM7 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
92 ODED_DED_AM8 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
93 ODED_DED_AM9 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
94 ODED_DED_AM10 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
95 ODED_DED_AM11 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
96 ODED_DED_AM12 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
97 ODED_DED_AM13 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
98 ODED_DED_AM14 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
99 ODED_DED_AM15 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
100 ODED_DED_AM16 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
101 ODED_DED_AM17 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
102 ODED_DED_AM18 OIUREP_DED_AMOUNT OIUH_CURR11_2 CURR 11   2   Deduction Amount  
103 REJECT_FLAG OIUREP_REJECT_FLAG OIUREP_REJECT_FLAG CHAR 1   0   Reject flag  
104 GL_TIMESTAMP OIUH_CHAR14 CHAR14 CHAR 14   0   OIUH_CHAR14  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUREP_XTRCT_ROY MANDT T000 MANDT    
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C