SAP ABAP Table OIUX6_WY_MASTER (Tax 2.0 - Wyoming Master Data)
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 | TRANSP | Transparent table |
Transparent table | OIUX6_WY_MASTER | Table Relationship Diagram |
Short Description | Tax 2.0 - Wyoming Master Data |
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 | .INCLUDE | 0 | 0 | Tax 2.0 - Wyoming Master Data Key Fields | |||||
3 | OGIND | OIUREP_OIL_GAS_IND | OIUREP_OIL_GAS_IND | CHAR | 1 | 0 | Oil and Gas Indicator | ||
4 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
5 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
6 | MP_NO | OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
7 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | OIU_CM_COMPC | |
8 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
9 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | OIU_DO_DI | |
10 | EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
11 | EFF_TO_DT | OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
12 | .INCLUDE | 0 | 0 | Tax 2.0 - Wyoming Master Data Nonkey Fields | |||||
13 | COUNTY | OIUX6_WY_COUNTY | OIU_SEC_GEO_LOC | CHAR | 3 | 0 | Tax 2.0 - Wyoming County Identifier | OIU_CM_LXSGL | |
14 | API_WELL_NUMBER | OIUX6_WY_API_WELL_NUMBER | CHAR | 5 | 0 | Tax 2.0 - Wyoming API Well Number | |||
15 | SIDE_TRACK_NO | OIUX6_WY_SIDE_TRACK_NUMBER | CHAR | 2 | 0 | Tax 2.0 - Wyoming Side Track Number | |||
16 | RESERVOIR | OIUX6_WY_RESERVOIR | CHAR | 3 | 0 | Tax 2.0 - Wyoming Reservoir | |||
17 | RPT_GRP_NO | OIUX6_WY_REPORT_GROUP_NUMBER | OIUX6_WY_REPORT_GROUP_NUMBER | CHAR | 5 | 0 | Tax 2.0 - Wyoming Report Group Number | ||
18 | FIELD_NAME | OIUX6_WY_FIELD_NAME | CHAR | 35 | 0 | Tax 2.0 - Wyoming Field Name | |||
19 | LEASE_UNIT_NAME | OIUX6_WY_LEASE_UNIT_NAME | CHAR35 | CHAR | 35 | 0 | Tax 2.0 - Wyoming Lease Unit Name / API | ||
20 | OPERATED_FLAG | OIUX6_OPERATED_FLAG | YESNO | CHAR | 1 | 0 | Tax 2.0 - Operated Flag | ||
21 | TAX_DISTRICT | OIUX6_WY_TAX_DISTRICT | NUMC4 | NUMC | 4 | 0 | Tax 2.0 - Wyoming Tax District | ||
22 | .INCLUDE | 0 | 0 | Tax Reporting - Last Changed Structure | |||||
23 | CHANGE_USER | OIUX3_LAST_CHANGED_USER | USNAM | CHAR | 12 | 0 | Tax Reporting - Last Changed User | ||
24 | CHANGE_DATE | OIUX3_LAST_CHANGED_DATE | DATS | 8 | 0 | Tax Reporting - Last Changed Date | |||
25 | CHANGE_TIME | OIUX3_LAST_CHANGED_TIME | TIMS | 6 | 0 | Tax Reporting - Last Changed Time |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIUX6_WY_MASTER | BUKRS | OIU_CM_COMPC | BUKRS | KEY | ||
2 | OIUX6_WY_MASTER | COUNTY | OIU_CM_LXSGL | SEC_GEO_LOC | REF | ||
3 | OIUX6_WY_MASTER | DOI_NO | OIU_DO_DI | DOI_NO | KEY | ||
4 | OIUX6_WY_MASTER | MANDT | T000 | MANDT | KEY | ||
5 | OIUX6_WY_MASTER | MP_NO | OIU_PR_MP | MP_NO | KEY | ||
6 | OIUX6_WY_MASTER | VNAME | OIU_DO_JV | VNAME | KEY | ||
7 | OIUX6_WY_MASTER | WC_NO | OIU_PR_WC | WC_NO | KEY | ||
8 | OIUX6_WY_MASTER | WL_NO | OIU_PR_WELL | WL_NO | KEY |
History
Last changed by/on | SAP | 20110810 |
SAP Release Created in | 100 |