SAP ABAP Table ROIUX1_ADJ_UPLOAD (Structure for uploading adjustments data)
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
⤷ 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_ADJ_UPLOAD | Table Relationship Diagram |
Short Description | Structure for uploading adjustments data |
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 combinations for Tax Reporting | |||||
2 | RSG | OIUX1_RSG | OIUX1_RSG | CHAR | 4 | 0 | Report Submission Group | OIUX1_RPT_SGRP | |
3 | AGENCY | OIUX1_TAX_AGENCY | CHAR3 | CHAR | 3 | 0 | Agency for Reporting | ||
4 | OGIND | OIUREP_OIL_GAS_IND | OIUREP_OIL_GAS_IND | CHAR | 1 | 0 | Oil and Gas Indicator | ||
5 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
6 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
7 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | * | |
8 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | * | |
9 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | * | |
10 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | * | |
11 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | * | |
12 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | * | |
13 | VL_TYPE_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | * | |
14 | SALES_YYYYMM | OIUREP_SALES_YYYYMM | OIUREP_SALES_YYYYMM | NUMC | 6 | 0 | Sales YYYYMM | ||
15 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
16 | GRV_AM | OIB_BDICH | OIB_DICHT | FLTP | 16 | 16 | Oil/gas density at standard/base conditions | ||
17 | ADJ_TYPE | OIUX1_ADJ_TYPE | OIUX1_ADJ_TYPE | CHAR | 2 | 0 | Adjustment type for Tax reporting | ||
18 | TAX_TYPE | OIU_SEVT_TAX_TY | OIU_SEVT_TAX_TY | CHAR | 2 | 0 | Severance Tax Type | * | |
19 | SCHOOL_DIST_CD | OIU_SCHOOL_DIST_CD | OIU_SCHOOL_DIST_CD | CHAR | 3 | 0 | School district code | * | |
20 | TAX_CLS | OIU_TAX_CLS | OIU_TAX_CLS | CHAR | 4 | 0 | Tax Class | * | |
21 | TIER_TAX_IND | OIUX1_TIER_TAX_IND | OIUX1_TIER_TAX_IND | CHAR | 1 | 0 | Tier tax indicator | ||
22 | PDIND | OIUX1_PDIND | OIUX1_PDIND | CHAR | 1 | 0 | Purchaser/Producer Indicator | ||
23 | AFFL_COMP | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
24 | ACTL_GR_VL | OIU_ACTL_GR_VL_AM | MENGE | QUAN | 13 | 3 | Actual Gross Volume Amount | ||
25 | ACTL_ENERGY | OIU_ACTL_ENERGY | MENGE | QUAN | 13 | 3 | Actual Energy | ||
26 | ACTL_GR_VAL_AM | OIU_ACTL_GR_VAL_AM | WERT7 | CURR | 13 | 2 | Actual Gross Value Amount | ||
27 | ACTL_ST_TAX_AM | OIUVL_ACTL_ST_TAX_AM | WERT8 | CURR | 15 | 2 | Actual state tax amount | ||
28 | ACTL_ST_TAX_RMB | OIUVL_ACTL_ST_TAX_REIMB | WERT8 | CURR | 15 | 2 | Actual state tax reimbursement | ||
29 | .INCLUDE | 0 | 0 | Linear structure for marketing costs and exemptions | |||||
30 | MTA_MKCT_INT01 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
31 | MTA_MKCT_INT02 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
32 | MTA_MKCT_INT03 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
33 | MTA_MKCT_INT04 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
34 | MTA_MKCT_INT05 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
35 | MTA_MKCT_INT06 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
36 | MTA_MKCT_INT07 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
37 | MTA_MKCT_INT08 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
38 | MTA_MKCT_INT09 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
39 | MTA_MKCT_INT10 | OIUVL_ACTL_MKCT_INT | WERT8 | CURR | 15 | 2 | Actual marketing cost internal | ||
40 | MTA_MKCT_EXT01 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
41 | MTA_MKCT_EXT02 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
42 | MTA_MKCT_EXT03 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
43 | MTA_MKCT_EXT04 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
44 | MTA_MKCT_EXT05 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
45 | MTA_MKCT_EXT06 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
46 | MTA_MKCT_EXT07 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
47 | MTA_MKCT_EXT08 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
48 | MTA_MKCT_EXT09 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
49 | MTA_MKCT_EXT10 | OIUVL_ACTL_MKCT_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost external | ||
50 | MTA_MCR_EXT01 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
51 | MTA_MCR_EXT02 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
52 | MTA_MCR_EXT03 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
53 | MTA_MCR_EXT04 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
54 | MTA_MCR_EXT05 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
55 | MTA_MCR_EXT06 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
56 | MTA_MCR_EXT07 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
57 | MTA_MCR_EXT08 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
58 | MTA_MCR_EXT09 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
59 | MTA_MCR_EXT10 | OIUVL_ACTL_MCR_EXT | WERT8 | CURR | 15 | 2 | Actual marketing cost reimbursement external | ||
60 | EXMP_VL01 | OIUVL_EXMP_VL | MENGE | QUAN | 13 | 3 | Exempt volume | ||
61 | EXMP_VL02 | OIUVL_EXMP_VL | MENGE | QUAN | 13 | 3 | Exempt volume | ||
62 | EXMP_VL03 | OIUVL_EXMP_VL | MENGE | QUAN | 13 | 3 | Exempt volume | ||
63 | EXMP_VL04 | OIUVL_EXMP_VL | MENGE | QUAN | 13 | 3 | Exempt volume | ||
64 | EXMP_VL05 | OIUVL_EXMP_VL | MENGE | QUAN | 13 | 3 | Exempt volume | ||
65 | EXMP_VAL01 | OIUVL_EXMP_VAL | WERT8 | CURR | 15 | 2 | Exempt value | ||
66 | EXMP_VAL02 | OIUVL_EXMP_VAL | WERT8 | CURR | 15 | 2 | Exempt value | ||
67 | EXMP_VAL03 | OIUVL_EXMP_VAL | WERT8 | CURR | 15 | 2 | Exempt value | ||
68 | EXMP_VAL04 | OIUVL_EXMP_VAL | WERT8 | CURR | 15 | 2 | Exempt value | ||
69 | EXMP_VAL05 | OIUVL_EXMP_VAL | WERT8 | CURR | 15 | 2 | Exempt value | ||
70 | ERROR | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIUX1_ADJ_UPLOAD | RSG | OIUX1_RPT_SGRP | RSG |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in | 46C |