SAP ABAP Table OIUY3_TX_MASTER (Royalty 2.0 - TX GLO/TAMU - Master Data)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y3 (Package) Royalty 2.0 - Texas GLO/TAMU
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUY3_TX_MASTER   Table Relationship Diagram
Short Description Royalty 2.0 - TX GLO/TAMU - 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   Royalty 2.0 - TX GLO/TAMU - Master Data Key Fields  
3 .INCLUDE       0   0   Royalty 2.0 - TX GLO/TAMU - Master Data Main Key Fields  
4 RPT_ID OIUX3_RPT_ID OIUX3_RPT_ID CHAR 10   0   Tax Reporting - Report ID OIUX3_RPT
5 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
6 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
7 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
8 BUKRS BUKRS BUKRS CHAR 4   0   Company Code OIU_CM_COMPC
9 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
10 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
11 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
12 .INCLUDE       0   0   Royalty 2,.0 - TX GLO/TAMU - Master Sub Key  
13 GLO_LEASE OIUY3_TX_GLO_LEASE OIUY3_TX_GLO_LEASE NUMC 6   0   Royalty 2.0 - TX GLO/TAMU Lease OIUY3_TX_LEASE
14 GLO_UNIT_NO OIUY3_TX_GLO_UNIT_NO   CHAR 4   0   Royalty 2.0 - Texas GLO/TAMU - Unit Number OIUY3_TX_UNIT
15 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
16 UNIT_VNAME_FLAG OIUY3_TX_UNIT_VNAME YESNO CHAR 1   0   Roy 2.0 - Texas GLO/TAMU - Unit Venture  
17 .INCLUDE       0   0   Royalty 2.0 - TX GLO/TAMU - Master Non-Key Fields  
18 ALLOC_PERCENT OIUY3_TX_ALLOCATION_PERCENT OIU_PERCENT98 DEC 9   8   Royalty 2.0 - TX GLO/TAMU - Allocation Percent  
19 TRACT_PART_FACT OIUY3_TX_TRACT_PART_FACTOR OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Texas GLO - Tract Participation Factor  
20 .INCLUDE       0   0   Tax Reporting - Last Changed Structure  
21 CHANGE_USER OIUX3_LAST_CHANGED_USER USNAM CHAR 12   0   Tax Reporting - Last Changed User  
22 CHANGE_DATE OIUX3_LAST_CHANGED_DATE   DATS 8   0   Tax Reporting - Last Changed Date  
23 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 OIUY3_TX_MASTER BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUY3_TX_MASTER DOI_NO OIU_DO_DI DOI_NO KEY    
3 OIUY3_TX_MASTER GLO_LEASE OIUY3_TX_LEASE GLO_LEASE    
4 OIUY3_TX_MASTER GLO_UNIT_NO OIUY3_TX_UNIT GLO_UNIT_NO KEY    
5 OIUY3_TX_MASTER MANDT T000 MANDT KEY    
6 OIUY3_TX_MASTER MP_NO OIU_PR_MP MP_NO KEY    
7 OIUY3_TX_MASTER RPT_ID OIUX3_RPT RPT_ID KEY    
8 OIUY3_TX_MASTER VNAME OIU_DO_JV VNAME KEY    
9 OIUY3_TX_MASTER WC_NO OIU_PR_WC WC_NO KEY    
10 OIUY3_TX_MASTER WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100