SAP ABAP Table ROIUX6_WY_CTAXTXN_ALV_0200 (Tax 2.0 - WY Con User Tax Trans Screen 0200 ALV Structure)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
⤷ OIU_X6 (Package) Tax 2.0 - WY
⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
⤷ OIU_X6 (Package) Tax 2.0 - WY
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIUX6_WY_CTAXTXN_ALV_0200 | Table Relationship Diagram |
Short Description | Tax 2.0 - WY Con User Tax Trans Screen 0200 ALV Structure |
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 | Tax 2.0 - Wyoming Conservation Tax Transactions | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | .INCLUDE | 0 | 0 | Tax 2.0 - Wyoming Conservation Tax Transactions Key Fields | |||||
4 | .INCLUDE | 0 | 0 | Tax 2.0 - Wyoming Conservation Tax Reversal Key Fields | |||||
5 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
6 | SALES_DT | OIU_SALE_DT | DATUM | DATS | 8 | 0 | Sales Date / Month | ||
7 | PDCD | OIU_FULL_PD_CD | OIU_FULL_PD_CD | CHAR | 3 | 0 | Full three char. product code (Major and Detail Products) | OIUX3_PDCD | |
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 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | * | |
12 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | * | |
13 | DN_NO | OIU_DN_NO | OIU_DN_NO | CHAR | 20 | 0 | Delivery network number | * | |
14 | CT_NO | OIU_CT_NO | OIUCM_CONTRACT_NUMBER | CHAR | 10 | 0 | Contract Number | * | |
15 | VL_TYPE_CD | OIU_VT_CD | OIU_VL_TYPE_CD | CHAR | 2 | 0 | Volume type code | OIU_PR_VLTYP | |
16 | TAX_CLS | OIU_TAX_CLS | OIU_TAX_CLS | CHAR | 4 | 0 | Tax Class | OIU_CM_TAXCLS | |
17 | REV_BOOK_ADJ_IND | OIUX6_REV_BOOK_REVADJ_ADJ_IND | OIUX6_REV_BOOK_REVADJ_ADJ_IND | CHAR | 1 | 0 | Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment | ||
18 | .INCLUDE | 0 | 0 | Tax 2.0 - Wyoming Conservation Tax Trans Non-Key Fields | |||||
19 | PROD_PURC_IND | OIUX3_PRODUCER_PURCHASER_IND | OIUX3_PRODUCER_PURCHASER_IND | CHAR | 1 | 0 | Tax Reporting - Producer/Purchaser Indicator | ||
20 | UNIT_VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
21 | PAY_FL | OIU_SEVT_PAY_FL | OIU_SEVT_PAY_FL | CHAR | 1 | 0 | Tax Severance Tax Calculation Payment Obligations Types | ||
22 | RPT_FL | OIU_SEVT_RPT_FL | CHAR1 | CHAR | 1 | 0 | State Severance Tax Reporting Indicators | ||
23 | UOM | OIU_MEAS_U | MEINS | UNIT | 3 | 0 | Measurement unit | T006 | |
24 | GROSS_VOL | OIUX3_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Gross Volume | ||
25 | TAX_VOL | OIUX3_TAXABLE_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Taxable Volume | ||
26 | TAX_VAL | OIUX3_TAXABLE_VALUE | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Taxable Value | ||
27 | EXEMPT_VOL | OIUX3_EXEMPT_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax Reporting - Exempt Volume | ||
28 | TAX_AMT | OIUX3_TAX_AMOUNT | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Tax Amount | ||
29 | TAX_REIMB | OIUX3_TAX_REIMBURSEMENT | OIUX3_SIGNED_CURR_11_2 | CURR | 11 | 2 | Tax Reporting - Tax Reimbursement | ||
30 | WET_LESS_RES | OIUX6_WET_LESS_RES_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax 2.0 - Wet Less Residue Volume (MCF) | ||
31 | BLPS_GROSS_VOL | OIUX6_WY_BLPS_GROSS_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax 2.0 - Wyoming Before Lease Plant Split Gross Volume | ||
32 | RET_LSE_PC | OIUCA_RET_LSE_PC | OIU_PERCENT63 | DEC | 6 | 3 | Percent Returned to Lease | ||
33 | PLANT_PROC_VOL | OIUX6_WY_PLANT_PROC_VOLUME | OIUX3_SIGNED_DEC_11_2 | DEC | 11 | 2 | Tax 2.0 - Wyoming Plant Processing Volume | ||
34 | .INCLUDE | 0 | 0 | Tax 2.0 - Wyoming Master Data Nonkey Fields | |||||
35 | COUNTY | OIUX6_WY_COUNTY | OIU_SEC_GEO_LOC | CHAR | 3 | 0 | Tax 2.0 - Wyoming County Identifier | OIU_CM_LXSGL | |
36 | API_WELL_NUMBER | OIUX6_WY_API_WELL_NUMBER | CHAR | 5 | 0 | Tax 2.0 - Wyoming API Well Number | |||
37 | SIDE_TRACK_NO | OIUX6_WY_SIDE_TRACK_NUMBER | CHAR | 2 | 0 | Tax 2.0 - Wyoming Side Track Number | |||
38 | RESERVOIR | OIUX6_WY_RESERVOIR | CHAR | 3 | 0 | Tax 2.0 - Wyoming Reservoir | |||
39 | RPT_GRP_NO | OIUX6_WY_REPORT_GROUP_NUMBER | OIUX6_WY_REPORT_GROUP_NUMBER | CHAR | 5 | 0 | Tax 2.0 - Wyoming Report Group Number | ||
40 | FIELD_NAME | OIUX6_WY_FIELD_NAME | CHAR | 35 | 0 | Tax 2.0 - Wyoming Field Name | |||
41 | LEASE_UNIT_NAME | OIUX6_WY_LEASE_UNIT_NAME | CHAR35 | CHAR | 35 | 0 | Tax 2.0 - Wyoming Lease Unit Name / API | ||
42 | OPERATED_FLAG | OIUX6_OPERATED_FLAG | YESNO | CHAR | 1 | 0 | Tax 2.0 - Operated Flag | ||
43 | TAX_DISTRICT | OIUX6_WY_TAX_DISTRICT | NUMC4 | NUMC | 4 | 0 | Tax 2.0 - Wyoming Tax District | ||
44 | MASTER_LEVEL | OIUX3_TX_MASTER_LEVEL | OIUX3_TX_MASTER_LEVEL | CHAR | 1 | 0 | Tax Reporting - Texas Master Level | ||
45 | OPERATOR_ID | OIUX6_WY_OPERATOR_ID | OIUX6_WY_OPERATOR_ID | CHAR | 4 | 0 | Tax 2.0 - Wyoming Operator ID | ||
46 | OPERATOR_NO | OIUCM_BUS_ASSOC | OIUCM_BUS_ASSOC | CHAR | 6 | 0 | Business Associate | OIUCM_BA_LINK | |
47 | OPERATOR_SEQ_NO | OIUCM_SEQ_NO | OIUCM_SEQ_NO | CHAR | 2 | 0 | Sequence Number | OIUCM_BA_LINK | |
48 | OPERATOR_NAME | OIUX6_OPERATOR_NAME | CHAR38 | CHAR | 38 | 0 | Tax 2.0 - Operator Name | ||
49 | PURCHASER_NO | OIUCM_BUS_ASSOC | OIUCM_BUS_ASSOC | CHAR | 6 | 0 | Business Associate | OIUCM_BA_LINK | |
50 | PURCHASER_SEQ_NO | OIUCM_SEQ_NO | OIUCM_SEQ_NO | CHAR | 2 | 0 | Sequence Number | OIUCM_BA_LINK | |
51 | PURCHASER_NAME | OIUX6_PURCHASER_NAME | CHAR38 | CHAR | 38 | 0 | Tax 2.0 - Purchaser Name | ||
52 | OGIND | OIUREP_OIL_GAS_IND | OIUREP_OIL_GAS_IND | CHAR | 1 | 0 | Oil and Gas Indicator | ||
53 | DOC_NO | OIURV_DOCNR | OIU_MP_NO | CHAR | 20 | 0 | Val. document number | * | |
54 | DOC_YEAR | OIU_DOC_YEAR | GJAHR | NUMC | 4 | 0 | Document year | ||
55 | OPTION1 | CHAR | 1 | 0 | |||||
56 | OPTION2 | CHAR | 1 | 0 | |||||
57 | OPTION3 | OIUX6_EXT_UPDATE | OIUX6_EXT_UPDATE | CHAR | 1 | 0 | Tax 2.0 - Indicator to identify external data update | ||
58 | REJ_SUSP_IND | OIUX3_REJECT_SUSPEND_IND | OIUX3_REJECT_SUSPEND_IND | CHAR | 1 | 0 | Tax Reporting - Reject/Suspend Indicator | ||
59 | REJ_CD | OIUX3_REJECT_CODE | OIUX3_REJECT_CODE | CHAR | 2 | 0 | Tax Reporting - Reject Code | OIUX6_WY_REJ | |
60 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
61 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
62 | 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 | ROIUX6_WY_CTAXTXN_ALV_0200 | COUNTY | OIU_CM_LXSGL | SEC_GEO_LOC | REF | ||
2 | ROIUX6_WY_CTAXTXN_ALV_0200 | OPERATOR_NO | OIUCM_BA_LINK | BA_NO | |||
3 | ROIUX6_WY_CTAXTXN_ALV_0200 | OPERATOR_SEQ_NO | OIUCM_BA_LINK | BA_SEQ | |||
4 | ROIUX6_WY_CTAXTXN_ALV_0200 | PDCD | OIUX3_PDCD | PDCD | KEY | ||
5 | ROIUX6_WY_CTAXTXN_ALV_0200 | PURCHASER_NO | OIUCM_BA_LINK | BA_NO | |||
6 | ROIUX6_WY_CTAXTXN_ALV_0200 | PURCHASER_SEQ_NO | OIUCM_BA_LINK | BA_SEQ | |||
7 | ROIUX6_WY_CTAXTXN_ALV_0200 | REJ_CD | OIUX6_WY_REJ | REJ_CD | REF | ||
8 | ROIUX6_WY_CTAXTXN_ALV_0200 | TAX_CLS | OIU_CM_TAXCLS | TAX_CLS | KEY | ||
9 | ROIUX6_WY_CTAXTXN_ALV_0200 | UNIT_VNAME | OIU_DO_JV | VNAME | REF | ||
10 | ROIUX6_WY_CTAXTXN_ALV_0200 | UOM | T006 | MSEHI | REF | ||
11 | ROIUX6_WY_CTAXTXN_ALV_0200 | VL_TYPE_CD | OIU_PR_VLTYP | VL_TYPE_CD |
History
Last changed by/on | SAP | 20110810 |
SAP Release Created in | 100 |