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   Table Relationship Diagram
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 MANDT CLNT 3   0   Client T000
2 .INCLUDE       0   0   Tax Reporting - Texas Master Data Key Fields  
3 RPT_ID OIUX3_RPT_ID OIUX3_RPT_ID CHAR 10   0   Tax Reporting - Report ID *
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 Reporting - Texas Master Data Nonkey Fields  
13 API_WELL_NUMBER OIUX3_TX_API_WELL_NUMBER CHAR8 CHAR 8   0   Tax Reporting - Texas API Well Number  
14 COUNTY OIUX3_TX_COUNTY NUMC3 NUMC 3   0   Tax Reporting - Texas County OIUX3_TX_CNTXRF
15 LEASE_NUMBER OIUX3_TX_LEASE_NUMBER CHAR7 CHAR 7   0   Tax Reporting - Texas Lease OIUX3_TX_LEASE
16 OFF_LEASE_CD OIUX3_TX_OFF_LEASE_CODE OIUX3_TX_OFF_LEASE_CODE CHAR 1   0   Tax Reporting - Texas On/Off Lease Code  
17 OVERRIDE_EXISTS OIUX3_OVERRIDE_EXISTS YESNO CHAR 1   0   Tax Reporting - Override Exists?  
18 .INCLUDE       0   0   Tax Reporting - Last Changed Structure  
19 CHANGE_USER OIUX3_LAST_CHANGED_USER USNAM CHAR 12   0   Tax Reporting - Last Changed User  
20 CHANGE_DATE OIUX3_LAST_CHANGED_DATE   DATS 8   0   Tax Reporting - Last Changed Date  
21 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 OIUX3_TX_MASTER BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUX3_TX_MASTER COUNTY OIUX3_TX_CNTXRF COUNTY REF    
3 OIUX3_TX_MASTER DOI_NO OIU_DO_DI DOI_NO KEY    
4 OIUX3_TX_MASTER LEASE_NUMBER OIUX3_TX_LEASE LEASE_NUMBER REF    
5 OIUX3_TX_MASTER MANDT T000 MANDT KEY    
6 OIUX3_TX_MASTER MP_NO OIU_PR_MP MP_NO KEY    
7 OIUX3_TX_MASTER VNAME OIU_DO_JV VNAME KEY    
8 OIUX3_TX_MASTER WC_NO OIU_PR_WC WC_NO KEY    
9 OIUX3_TX_MASTER WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20080505 
SAP Release Created in 46C