SAP ABAP Table ROIUY3_TX_MASTER_KEY (Royalty 2.0 - TX GLO/TAMU - Master Data Key Fields)
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 INTTAB    Structure 
Structure ROIUY3_TX_MASTER_KEY   Table Relationship Diagram
Short Description Royalty 2.0 - TX GLO/TAMU - Master Data Key Fields    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Royalty 2.0 - TX GLO/TAMU - Master Data Main Key Fields  
2 RPT_ID OIUX3_RPT_ID OIUX3_RPT_ID CHAR 10   0   Tax Reporting - Report ID OIUX3_RPT
3 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
4 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
5 MP_NO OIU_MP_NO OIU_MP_NO CHAR 20   0   Measurement point number OIU_PR_MP
6 BUKRS BUKRS BUKRS CHAR 4   0   Company Code OIU_CM_COMPC
7 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture OIU_DO_JV
8 DOI_NO OIU_DOI_NO OIU_DOI_NO CHAR 5   0   Division of interest (DOI) OIU_DO_DI
9 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
10 .INCLUDE       0   0   Royalty 2,.0 - TX GLO/TAMU - Master Sub Key  
11 GLO_LEASE OIUY3_TX_GLO_LEASE OIUY3_TX_GLO_LEASE NUMC 6   0   Royalty 2.0 - TX GLO/TAMU Lease OIUY3_TX_LEASE
12 GLO_UNIT_NO OIUY3_TX_GLO_UNIT_NO   CHAR 4   0   Royalty 2.0 - Texas GLO/TAMU - Unit Number OIUY3_TX_UNIT
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUY3_TX_MASTER_KEY BUKRS OIU_CM_COMPC BUKRS KEY    
2 ROIUY3_TX_MASTER_KEY DOI_NO OIU_DO_DI DOI_NO KEY    
3 ROIUY3_TX_MASTER_KEY GLO_LEASE OIUY3_TX_LEASE GLO_LEASE    
4 ROIUY3_TX_MASTER_KEY GLO_UNIT_NO OIUY3_TX_UNIT GLO_UNIT_NO KEY    
5 ROIUY3_TX_MASTER_KEY MP_NO OIU_PR_MP MP_NO KEY    
6 ROIUY3_TX_MASTER_KEY RPT_ID OIUX3_RPT RPT_ID KEY    
7 ROIUY3_TX_MASTER_KEY VNAME OIU_DO_JV VNAME KEY    
8 ROIUY3_TX_MASTER_KEY WC_NO OIU_PR_WC WC_NO KEY    
9 ROIUY3_TX_MASTER_KEY WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100