SAP ABAP Table OIUX3Y_TX_MASTER (Tax Reporting - Texas Master Data PPN)
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 | OIUX3Y_TX_MASTER |
|
| Short Description | Tax Reporting - Texas Master Data PPN |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| 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 | |
CHAR | 1 | 0 | |||||
| 12 | |
OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
| 13 | |
0 | 0 | Tax Reporting - Texas Master Data Nonkey Fields | |||||
| 14 | |
OIUX3_TX_API_WELL_NUMBER | CHAR8 | CHAR | 8 | 0 | Tax Reporting - Texas API Well Number | ||
| 15 | |
OIUX3_TX_COUNTY | NUMC3 | NUMC | 3 | 0 | Tax Reporting - Texas County | OIUX3_TX_CNTXRF | |
| 16 | |
OIUX3_TX_LEASE_NUMBER | CHAR7 | CHAR | 7 | 0 | Tax Reporting - Texas Lease | OIUX3_TX_LEASE | |
| 17 | |
OIUX3_TX_OFF_LEASE_CODE | OIUX3_TX_OFF_LEASE_CODE | CHAR | 1 | 0 | Tax Reporting - Texas On/Off Lease Code | ||
| 18 | |
OIUX3_OVERRIDE_EXISTS | YESNO | CHAR | 1 | 0 | Tax Reporting - Override Exists? | ||
| 19 | |
CHAR | 1 | 0 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | OIUX3Y_TX_MASTER | BUKRS | |
|
KEY | ||
| 2 | OIUX3Y_TX_MASTER | COUNTY | |
|
REF | ||
| 3 | OIUX3Y_TX_MASTER | DOI_NO | |
|
KEY | ||
| 4 | OIUX3Y_TX_MASTER | LEASE_NUMBER | |
|
REF | ||
| 5 | OIUX3Y_TX_MASTER | MANDT | |
|
KEY | ||
| 6 | OIUX3Y_TX_MASTER | MP_NO | |
|
KEY | ||
| 7 | OIUX3Y_TX_MASTER | VNAME | |
|
KEY | ||
| 8 | OIUX3Y_TX_MASTER | WC_NO | |
|
KEY | ||
| 9 | OIUX3Y_TX_MASTER | WL_NO | |
|
KEY |
History
| Last changed by/on | SAP | 20080505 |
| SAP Release Created in | 46C |