SAP ABAP Table ROIUREP_MMS_2014_FE_WCLEASE (MMS-2014: WC / Lease fast entry structure - Single Owner)
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 INTTAB    Structure 
Structure ROIUREP_MMS_2014_FE_WCLEASE   Table Relationship Diagram
Short Description MMS-2014: WC / Lease fast entry structure - Single Owner    
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 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
2 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
3 .INCLUDE       0   0   MMS-2014 - Lease  
4 .INCLUDE       0   0   Production: MMS-2014 - Lease Key Fields  
5 MANDT MANDT MANDT CLNT 3   0   Client T000
6 PAYORXREF_REC_NO OIUREP_MMS_2014_PAYOR_REC_NO   NUMC 20   0   Production: MMS-2014 - Payor XRef Record Number  
7 LEASE_NO OIUREP_MMS_2014_LEASE_NO   CHAR 11   0   MMS-2014 - Lease Number OIUREP_FEDINDIAN
8 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  
9 AGREEMENT_NO OIUREP_MMS_2014_AGREEMENT_NO   CHAR 11   0   Production: MMS-2014 - Agreement Number  
10 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
11 .INCLUDE       0   0   Production: MMS-2014 - Lease Non Key Fields  
12 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
13 LEASE_RECORD_NO OIUREP_MMS_2014_LEASE_REC_NO   NUMC 20   0   Production: MMS-2014 - Lease Record Number  
14 ALLOCATION_FAC OIUREP_MMS_2014_ALLOCATION_FAC   DEC 9   8   Production: MMS-2014 - Lease/Agreement Allocation Factor  
15 REPORT_PART_FAC OIUREP_MMS_2014_RPT_PART_FAC   DEC 9   8   Production: MMS-2014 - Report Participation Factor  
16 PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
17 COMP_ROYALTY_FL OIUREP_MMS_2014_COMP_ROY_FL YESNO CHAR 1   0   Production: MMS-2014 - Compensatory Royalty Flag  
18 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
19 TRIBAL_ALLOT_CD OIUREP_MMS_2014_TRIB_ALLOT_CD OIUREP_MMS_2014_TRIB_ALLOT_CD CHAR 1   0   Production: MMS-2014 - Tribal/Allottee Code  
20 REPORT_API_WELL OIUREP_MMS_2014_REPORT_API_NO YESNO CHAR 1   0   MMS-2014: Report API Well Number  
21 .INCLUDE       0   0   Creator and date/time created  
22 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
23 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
24 .INCLUDE       0   0   Change Username & Timestamp  
25 CHANGE_USER AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
26 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 ROIUREP_MMS_2014_FE_WCLEASE INDIAN_TRIBE_NO OIUREP_INDIAN_TR INDIAN_TRIBE_NO    
2 ROIUREP_MMS_2014_FE_WCLEASE LEASE_NO OIUREP_FEDINDIAN LEASE_NO KEY    
3 ROIUREP_MMS_2014_FE_WCLEASE MANDT T000 MANDT    
4 ROIUREP_MMS_2014_FE_WCLEASE WC_NO OIU_PR_WC WC_NO    
5 ROIUREP_MMS_2014_FE_WCLEASE WL_NO OIU_PR_WELL WL_NO    
History
Last changed by/on SAP  20050301 
SAP Release Created in 46C