SAP ABAP Table ROIUREP_MMS_2014_LOGICAL_KEY (MMS 2014 Logical Key Definition)
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_LOGICAL_KEY   Table Relationship Diagram
Short Description MMS 2014 Logical Key Definition    
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 PAYOR_NO OIUREP_MMS_2014_PAYOR   CHAR 5   0   Production: MMS-2014 - Payor  
2 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  
3 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
4 API_WELL_NO OIU_WLAPI OIU_WLAPI CHAR 12   0   API well number  
5 API_WELL_CM_NO OIU_API_WC_NO OIU_API_WC_NO CHAR 3   0   API well completion number  
6 LEASE_NO OIUREP_MMS_2014_LEASE_NO   CHAR 11   0   MMS-2014 - Lease Number OIUREP_FEDINDIAN
7 AGREEMENT_NO OIUREP_MMS_2014_AGREEMENT_NO   CHAR 11   0   Production: MMS-2014 - Agreement Number OIUREP_LEASE
8 MMS_PROD_CD OIUREP_MMS_PRODUCT_CODE OIUREP_MMS_PRODUCT_CODE CHAR 2   0   Production: MMS Product Code  
9 SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_MMS_2014_SALES_TYPE_CD CHAR 4   0   Production: MMS-2014 - Sales Type Code OIUREP_SALESTY
10 SALES_DATE OIU_SALE_DT DATUM DATS 8   0   Sales Date / Month  
11 TRANS_CD OIUREP_MMS_2014_TRANS_CD OIUREP_MMS_2014_TRANS_CD CHAR 2   0   Production: MMS-2014 - Transaction Code  
12 PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1   0   Production: MMS-2014 - Payment Method Code  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIUREP_MMS_2014_LOGICAL_KEY AGREEMENT_NO OIUREP_LEASE FED_INDIAN_CD    
2 ROIUREP_MMS_2014_LOGICAL_KEY INDIAN_TRIBE_NO OIUREP_INDIAN_TR INDIAN_TRIBE_NO    
3 ROIUREP_MMS_2014_LOGICAL_KEY LEASE_NO OIUREP_FEDINDIAN LEASE_NO    
4 ROIUREP_MMS_2014_LOGICAL_KEY SALES_TYPE_CD OIUREP_SALESTY SALES_TYPE_CD    
History
Last changed by/on SAP  20050224 
SAP Release Created in 46C