SAP ABAP Table OIUY6_WY_MASTER (Royalty 2.0 - WY - Master Data)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y6 (Package) Royalty 2.0 - WY
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUY6_WY_MASTER   Table Relationship Diagram
Short Description Royalty 2.0 - WY - 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 - WY - Master Data Key Fields  
3 .INCLUDE       0   0   Royalty 2.0 - WY - 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 - WY - Master Sub Key  
13 STATE_LEASE_NO OIUY6_WY_STATE_LEASE_NO   CHAR 15   0   Royalty 2.0 - Wyoming - State Lease Number  
14 UNIQUE_ID OIUY6_WY_UNIQUE_IDENTIFIER   CHAR 20   0   Royalty 2.0 - Wyoming - PSA  
15 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
16 .INCLUDE       0   0   Royalty 2.0 - Wyoming Master Non-Key Fields  
17 REPORT_ONLY OIUY6_WY_REPORT_ONLY_FL YESNO CHAR 1   0   Royalty 2.0 - WY - Report Only Flag  
18 OVERRIDE_FL OIUY6_WY_OVERRIDE_OPERATED_FL OIUY6_WY_OVERRIDE_OPERATED_FL CHAR 1   0   Royalty 2.0 - WY - Override Operated Flag  
19 TRACT_ALLOC_LSE OIUY6_WY_TRACT_ALLOC_TO_LEASE OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Wyoming - Tract Allocation to Lease  
20 ROYALTY_RATE OIUY6_WY_ROYALTY_RATE OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Wyoming - Royalty Rate  
21 ALLOC_PERCENT OIUY6_WY_ALLOCATION_PERCENT OIU_PERCENT98 DEC 9   8   Royalty 2.0 - Wyoming - Allocation Percent  
22 REFERENCE_FIELD OIUY6_WY_REFERENCE_FIELD   CHAR 20   0   Royalty 2.0 - WY - Reference Field  
23 ALTERNATE_PSA OIUY6_WY_ALTERNATE_PSA   CHAR 20   0   Royalty 2.0 - Wyoming - Alternate PSA  
24 LEASE_TEXT OIUY6_WY_LEASE_TEXT   CHAR 15   0   Royalty 2.0 - WY - Lease Text  
25 LEGACY_LEASE OIUY6_WY_LEGACY_LEASE   CHAR 15   0   Royalty 2.0 - WY - Legacy Lease  
26 .INCLUDE       0   0   Tax Reporting - Last Changed Structure  
27 CHANGE_USER OIUX3_LAST_CHANGED_USER USNAM CHAR 12   0   Tax Reporting - Last Changed User  
28 CHANGE_DATE OIUX3_LAST_CHANGED_DATE   DATS 8   0   Tax Reporting - Last Changed Date  
29 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 OIUY6_WY_MASTER BUKRS OIU_CM_COMPC BUKRS KEY    
2 OIUY6_WY_MASTER DOI_NO OIU_DO_DI DOI_NO KEY    
3 OIUY6_WY_MASTER MANDT T000 MANDT KEY    
4 OIUY6_WY_MASTER MP_NO OIU_PR_MP MP_NO KEY    
5 OIUY6_WY_MASTER RPT_ID OIUX3_RPT RPT_ID KEY    
6 OIUY6_WY_MASTER VNAME OIU_DO_JV VNAME KEY    
7 OIUY6_WY_MASTER WC_NO OIU_PR_WC WC_NO KEY    
8 OIUY6_WY_MASTER WL_NO OIU_PR_WELL WL_NO KEY    
History
Last changed by/on SAP  20130529 
SAP Release Created in 100