SAP ABAP Table OIUX3_TX_MASTER (Tax Reporting - Texas Master Data)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷
IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
⤷
OIU_X3 (Package) Tax 2.0
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | OIUX3_TX_MASTER |
|
| Short Description | Tax Reporting - Texas 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
0 | 0 | Tax Reporting - Texas Master Data Key Fields | |||||
| 3 | |
OIUX3_RPT_ID | OIUX3_RPT_ID | CHAR | 10 | 0 | Tax Reporting - Report ID | * | |
| 4 | |
OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
| 5 | |
OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
| 6 | |
OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
| 7 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | OIU_CM_COMPC | |
| 8 | |
JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
| 9 | |
OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | OIU_DO_DI | |
| 10 | |
OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
| 11 | |
OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
| 12 | |
0 | 0 | Tax Reporting - Texas Master Data Nonkey Fields | |||||
| 13 | |
OIUX3_TX_API_WELL_NUMBER | CHAR8 | CHAR | 8 | 0 | Tax Reporting - Texas API Well Number | ||
| 14 | |
OIUX3_TX_COUNTY | NUMC3 | NUMC | 3 | 0 | Tax Reporting - Texas County | OIUX3_TX_CNTXRF | |
| 15 | |
OIUX3_TX_LEASE_NUMBER | CHAR7 | CHAR | 7 | 0 | Tax Reporting - Texas Lease | OIUX3_TX_LEASE | |
| 16 | |
OIUX3_TX_OFF_LEASE_CODE | OIUX3_TX_OFF_LEASE_CODE | CHAR | 1 | 0 | Tax Reporting - Texas On/Off Lease Code | ||
| 17 | |
OIUX3_OVERRIDE_EXISTS | YESNO | CHAR | 1 | 0 | Tax Reporting - Override Exists? | ||
| 18 | |
0 | 0 | Tax Reporting - Last Changed Structure | |||||
| 19 | |
OIUX3_LAST_CHANGED_USER | USNAM | CHAR | 12 | 0 | Tax Reporting - Last Changed User | ||
| 20 | |
OIUX3_LAST_CHANGED_DATE | DATS | 8 | 0 | Tax Reporting - Last Changed Date | |||
| 21 | |
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 | OIUX3_TX_MASTER | BUKRS | |
|
KEY | ||
| 2 | OIUX3_TX_MASTER | COUNTY | |
|
REF | ||
| 3 | OIUX3_TX_MASTER | DOI_NO | |
|
KEY | ||
| 4 | OIUX3_TX_MASTER | LEASE_NUMBER | |
|
REF | ||
| 5 | OIUX3_TX_MASTER | MANDT | |
|
KEY | ||
| 6 | OIUX3_TX_MASTER | MP_NO | |
|
KEY | ||
| 7 | OIUX3_TX_MASTER | VNAME | |
|
KEY | ||
| 8 | OIUX3_TX_MASTER | WC_NO | |
|
KEY | ||
| 9 | OIUX3_TX_MASTER | WL_NO | |
|
KEY |
History
| Last changed by/on | SAP | 20080505 |
| SAP Release Created in | 46C |