SAP ABAP Table OIUREP_LEASE (MMS-2014 - Lease)
Hierarchy
☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting
Basic Data
Table Category TRANSP    Transparent table 
Transparent table OIUREP_LEASE   Table Relationship Diagram
Short Description MMS-2014 - Lease    
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 .INCLUDE       0   0   Production: MMS-2014 - Lease Key Fields  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 PAYORXREF_REC_NO OIUREP_MMS_2014_PAYOR_REC_NO   NUMC 20   0   Production: MMS-2014 - Payor XRef Record Number  
4 LEASE_NO OIUREP_MMS_2014_LEASE_NO   CHAR 11   0   MMS-2014 - Lease Number OIUREP_FEDINDIAN
5 FED_INDIAN_CD OIUREP_MMS_2014_FED_INDIAN_CD OIUREP_MMS_2014_FED_INDIAN_CD CHAR 1   0   Production: MMS-2014 - Federal or Indian Code  
6 AGREEMENT_NO OIUREP_MMS_2014_AGREEMENT_NO   CHAR 11   0   Production: MMS-2014 - Agreement Number  
7 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
8 .INCLUDE       0   0   Production: MMS-2014 - Lease Non Key Fields  
9 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
10 LEASE_RECORD_NO OIUREP_MMS_2014_LEASE_REC_NO   NUMC 20   0   Production: MMS-2014 - Lease Record Number  
11 ALLOCATION_FAC OIUREP_MMS_2014_ALLOCATION_FAC   DEC 9   8   Production: MMS-2014 - Lease/Agreement Allocation Factor  
12 REPORT_PART_FAC OIUREP_MMS_2014_RPT_PART_FAC   DEC 9   8   Production: MMS-2014 - Report Participation Factor  
13 PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
14 COMP_ROYALTY_FL OIUREP_MMS_2014_COMP_ROY_FL YESNO CHAR 1   0   Production: MMS-2014 - Compensatory Royalty Flag  
15 INDIAN_TRIBE_NO OIUREP_MMS_2014_INDN_TRIBE_NO OIUREP_MMS_2014_INDN_TRIBE_NO CHAR 2   0   Production: MMS-2014 - Indian Tribe Number OIUREP_INDIAN_TR
16 TRIBAL_ALLOT_CD OIUREP_MMS_2014_TRIB_ALLOT_CD OIUREP_MMS_2014_TRIB_ALLOT_CD CHAR 1   0   Production: MMS-2014 - Tribal/Allottee Code  
17 REPORT_API_WELL OIUREP_MMS_2014_REPORT_API_NO YESNO CHAR 1   0   MMS-2014: Report API Well Number  
18 .INCLUDE       0   0   Creator and date/time created  
19 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
20 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
21 .INCLUDE       0   0   Change Username & Timestamp  
22 CHANGE_USER AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
23 CHANGE_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIUREP_LEASE INDIAN_TRIBE_NO OIUREP_INDIAN_TR INDIAN_TRIBE_NO    
2 OIUREP_LEASE LEASE_NO OIUREP_FEDINDIAN LEASE_NO KEY    
3 OIUREP_LEASE MANDT T000 MANDT    
History
Last changed by/on SAP  20050301 
SAP Release Created in 46C