SAP ABAP Table ROIUX1_PUID_TAX_UPLOAD (Structure for uploading lease tax data from flat files)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X1 (Package) PRA Tax Reporting - Tax Reporting Framework
Basic Data
Table Category INTTAB    Structure 
Structure ROIUX1_PUID_TAX_UPLOAD   Table Relationship Diagram
Short Description Structure for uploading lease tax data from flat files    
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   Execution Parameters for Tax Reporting  
2 RPT_YYYYMM OIUREP_RPT_YYYYMM OIUREP_RPT_YYYYMM NUMC 6   0   Reporting Year and Month  
3 RSG OIUX1_RSG OIUX1_RSG CHAR 4   0   Report Submission Group OIUX1_RPT_SGRP
4 AGENCY OIUX1_TAX_AGENCY CHAR3 CHAR 3   0   Agency for Reporting  
5 OGIND OIUREP_OIL_GAS_IND OIUREP_OIL_GAS_IND CHAR 1   0   Oil and Gas Indicator  
6 SALES_YYYYMM OIUREP_SALES_YYYYMM OIUREP_SALES_YYYYMM NUMC 6   0   Sales YYYYMM  
7 PUID OIUX1_PUID OIUX1_PUID CHAR 20   0   Production Unit ID for tax reporting  
8 AGENCY_VOL_TYPE OIUREP_AGENCY_VOL_TYPE CHAR2 CHAR 2   0   Agency defined Volume type  
9 AGENCY_TAX_CODE OIUX1_AGENCY_TAX_CODE OIUX1_AGENCY_TAX_CODE CHAR 4   0   Agency defined Tax Code for Reporting  
10 PDIND OIUX1_PDIND OIUX1_PDIND CHAR 1   0   Purchaser/Producer Indicator  
11 AFFL_COMP BUKRS BUKRS CHAR 4   0   Company Code *
12 UNIT_VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture *
13 SEC_GEO_LOC OIU_SEC_GEO_LOC OIU_SEC_GEO_LOC CHAR 3   0   Secondary geographic location *
14 GRV_AM OIB_BDICH OIB_DICHT FLTP 16   16   Oil/gas density at standard/base conditions  
15 ACTL_TXVL OIUVL_ACTL_TXVL MENGE QUAN 13   3   Actual taxable volume  
16 ACTL_OVRD_TAXVL OIUVL_ACTL_OVRD_TAX_VL MENGE QUAN 13   3   Actual override taxable volume  
17 ACTL_GR_VL OIU_ACTL_GR_VL_AM MENGE QUAN 13   3   Actual Gross Volume Amount  
18 TAX_FREE_05_VL OIUVL_TAX_FREE_VL MENGE QUAN 13   3   Tax free 05 volume  
19 BLPS_GR_VL OIUVL_BLPS_GR_VL MENGE QUAN 13   3   Before lease plant split gross volume  
20 ACTL_GR_VL_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
21 ACTL_WLR_VL_AM OIU_ACTL_WLR_VL_AM MENGE QUAN 13   3   Act. Wet-less-Residue Vol. Amount  
22 TAX_FREE_05_WLR OIUVL_TAX_FREE_WLR MENGE QUAN 13   3   Tax free 05 wet-less-residue  
23 ACTL_WLR_VL_AM_U OIU_MEAS_U MEINS UNIT 3   0   Measurement unit *
24 ACTL_ENERGY OIU_ACTL_ENERGY MENGE QUAN 13   3   Actual Energy  
25 ACTL_ENERGY_U OIU_ACTL_ENERGY_U MEINS UNIT 3   0   Actual Energy Unit *
26 FX_MCD OIUVL_FX_MCD WERT8 CURR 15   2   Fixed marketing cost deduction  
27 ACTL_GR_VAL_AM OIU_ACTL_GR_VAL_AM WERT7 CURR 13   2   Actual Gross Value Amount  
28 TAX_FREE_05_VAL OIUVL_TAX_FREE_VAL WERT8 CURR 15   2   Tax free 05 value  
29 BLPS_GR_VAL OIUVL_BLPS_GR_VAL WERT8 CURR 15   2   Before lease plant split gross value  
30 ACTL_TXVAL OIUVL_ACTL_TXVAL WERT8 CURR 15   2   Actual taxable value  
31 ACTL_OVRD_TAXVAL OIUVL_ACTL_OVRD_TAX_VAL WERT8 CURR 15   2   Actual override taxable value  
32 ACTL_ST_TAX_AM OIUVL_ACTL_ST_TAX_AM WERT8 CURR 15   2   Actual state tax amount  
33 ACTL_ST_TAX_RMB OIUVL_ACTL_ST_TAX_REIMB WERT8 CURR 15   2   Actual state tax reimbursement  
34 GR_VAL_CURR WAERS WAERS CUKY 5   0   Currency Key *
35 .INCLUDE       0   0   Linear structure for marketing costs and exemptions  
36 MTA_MKCT_INT01 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
37 MTA_MKCT_INT02 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
38 MTA_MKCT_INT03 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
39 MTA_MKCT_INT04 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
40 MTA_MKCT_INT05 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
41 MTA_MKCT_INT06 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
42 MTA_MKCT_INT07 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
43 MTA_MKCT_INT08 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
44 MTA_MKCT_INT09 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
45 MTA_MKCT_INT10 OIUVL_ACTL_MKCT_INT WERT8 CURR 15   2   Actual marketing cost internal  
46 MTA_MKCT_EXT01 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
47 MTA_MKCT_EXT02 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
48 MTA_MKCT_EXT03 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
49 MTA_MKCT_EXT04 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
50 MTA_MKCT_EXT05 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
51 MTA_MKCT_EXT06 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
52 MTA_MKCT_EXT07 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
53 MTA_MKCT_EXT08 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
54 MTA_MKCT_EXT09 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
55 MTA_MKCT_EXT10 OIUVL_ACTL_MKCT_EXT WERT8 CURR 15   2   Actual marketing cost external  
56 MTA_MCR_EXT01 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
57 MTA_MCR_EXT02 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
58 MTA_MCR_EXT03 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
59 MTA_MCR_EXT04 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
60 MTA_MCR_EXT05 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
61 MTA_MCR_EXT06 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
62 MTA_MCR_EXT07 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
63 MTA_MCR_EXT08 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
64 MTA_MCR_EXT09 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
65 MTA_MCR_EXT10 OIUVL_ACTL_MCR_EXT WERT8 CURR 15   2   Actual marketing cost reimbursement external  
66 EXMP_VL01 OIUVL_EXMP_VL MENGE QUAN 13   3   Exempt volume  
67 EXMP_VL02 OIUVL_EXMP_VL MENGE QUAN 13   3   Exempt volume  
68 EXMP_VL03 OIUVL_EXMP_VL MENGE QUAN 13   3   Exempt volume  
69 EXMP_VL04 OIUVL_EXMP_VL MENGE QUAN 13   3   Exempt volume  
70 EXMP_VL05 OIUVL_EXMP_VL MENGE QUAN 13   3   Exempt volume  
71 EXMP_VAL01 OIUVL_EXMP_VAL WERT8 CURR 15   2   Exempt value  
72 EXMP_VAL02 OIUVL_EXMP_VAL WERT8 CURR 15   2   Exempt value  
73 EXMP_VAL03 OIUVL_EXMP_VAL WERT8 CURR 15   2   Exempt value  
74 EXMP_VAL04 OIUVL_EXMP_VAL WERT8 CURR 15   2   Exempt value  
75 EXMP_VAL05 OIUVL_EXMP_VAL WERT8 CURR 15   2   Exempt value  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUX1_PUID_TAX_UPLOAD RSG OIUX1_RPT_SGRP RSG    
History
Last changed by/on SAP  20050301 
SAP Release Created in 46C